tursodatabase / libsql-client-py

Python SDK for libSQL
https://libsql.org/libsql-client-py/
MIT License
44 stars 10 forks source link

RANDOM ROWID unsupported #23

Open raulvc opened 7 months ago

raulvc commented 7 months ago

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()