SQLite Forum

Cannot parse `IS TRUE` when connecting with Python library
Login
Sorry for the typo, `TRU` should be `TRUE` in the original query.

The output from the test case is:

````
xxx:$ rm test.db; python3 sqlitetest.py
no such column: TRUE
````

I suspect it is a bug in the connector. After changing to the correct quotes `"`, it still have the same error:

````
cu.execute('SELECT "col_char(20)_signed" FROM table_10_undef_undef WHERE ( "col_float_signed" / 0 ) IS TRUE ;')

xxx:~/remote/randgen$ rm test.db; python3 sqlitetest.py 
no such column: TRUE
````