SQLite Forum

**Test case** (sqlitetest.py ):

````
import sqlite3

ddl = '''
create table table_10_undef_undef (
`pk` int primary key,
`col_bigint_signed` bigint ,
`col_float_signed` float ,
`col_double_signed` double ,
`col_char(20)_signed` char(20) ,
`col_varchar(20)_signed` varchar(20) ,
`col_tinyint_signed` tinyint ,
`col_smallint_signed` smallint
) ;
'''

try:
    cu = sqlite3.connect('test.db')
    cu.execute(ddl)
    cu.commit()
    cu.execute("SELECT `col_char(20)_signed` FROM table_10_undef_undef WHERE ( `col_float_signed` / 0 ) IS TRUE ;")
    cu.close()
except sqlite3.OperationalError as e:
    print(e)
````

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

**However, the query is executable without errors when using the shell:**
````
sqlite> SELECT `col_char(20)_signed` FROM table_10_undef_undef WHERE ( `col_float_signed` / 0 ) IS TRUE ;
````