libsql-client-py icon indicating copy to clipboard operation
libsql-client-py copied to clipboard

RANDOM ROWID unsupported

Open raulvc opened this issue 1 year ago • 0 comments

random rowid is unsupported by this client (tried both dbapi2 and the regular client)

libsql_client.client.LibsqlError: SQL_INPUT_ERROR: SQL input error

here's an example code:

from libsql_client import dbapi2

conn = dbapi2.connect("ws://localhost:8080", uri=True)
conn.executescript('''CREATE TABLE test_fails(stuff CHAR(1)) RANDOM ROWID;''')
conn.close()

raulvc avatar Feb 07 '24 00:02 raulvc