search

volentixlabsinc / vdex-clojure

1 stars 1 forks source link

SQLite db doesn't handle returning clause #33

Open mariusz-jachimowicz-83 opened 6 years ago

mariusz-jachimowicz-83 commented 6 years ago

for sql instert statement

insert into tokens (address, name, precision) values (:address, :name, 18) returning *

there is an error

expected: nil
  actual: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "returning": syntax error)
 at org.sqlite.core.DB.newSQLException (DB.java:909)
    org.sqlite.core.DB.newSQLException (DB.java:921)
    org.sqlite.core.DB.throwex (DB.java:886)
    org.sqlite.core.NativeDB.prepare_utf8 (NativeDB.java:-2)
    org.sqlite.core.NativeDB.prepare (NativeDB.java:127)
    org.sqlite.core.DB.prepare (DB.java:227)
    org.sqlite.core.CorePreparedStatement.<init> (CorePreparedStatement.java:41)
    org.sqlite.jdbc3.JDBC3PreparedStatement.<init> (JDBC3PreparedStatement.java:30)
    org.sqlite.jdbc4.JDBC4PreparedStatement.<init> (JDBC4PreparedStatement.java:19)
    org.sqlite.jdbc4.JDBC4Connection.prepareStatement (JDBC4Connection.java:48)
    org.sqlite.jdbc3.JDBC3Connection.prepareStatement (JDBC3Connection.java:263)
    org.sqlite.jdbc3.JDBC3Connection.prepareStatement (JDBC3Connection.java:235)
    com.zaxxer.hikari.pool.ProxyConnection.prepareStatement (ProxyConnection.java:309)
    com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement (HikariProxyConnection.java:-1)
    sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
    sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
    sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke (Method.java:498)
    net.ttddyy.dsproxy.proxy.ConnectionProxyLogic.invoke (ConnectionProxyLogic.java:87)