[Closed, answered myself] Cannot select from newly created tables with Python 3 connector
(1.1) By zhangyushao (zhangysh1995) on 2020-06-08 13:32:38 edited from 1.0 [source]
My script reads from the sql files, and executes the query one by one. But I found that it cannot select the correct number of rows from the table.
For the script (
SELECT col3, col1 from t0; Error >>>>>> SELECT col3, col1 from t0; // this means no row returned
However, if I run it in the binary:
SQLite version 3.30.1 2019-10-10 20:19:45 Enter ".help" for usage hints. sqlite> .tables t0 t1 t2 t3 t4 t5 t6 t7 t8 t9 sqlite> select col3, col1 from t0; df6320a9-6c4b-4fe3-972a-382fea3ca440|1970-01-02 00:00:01 sqlite>
This gives the correct result.
I provide the script together with the queries (all included) here.
(2) By zhangyushao (zhangysh1995) on 2020-06-08 13:31:55 in reply to 1.0 [link] [source]
I found that I misunderstood the behavior of the