SQLite Forum

[Closed, answered myself] Cannot select from newly created tables with Python 3 connector
Login
Hi,


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 (`Python 3.6.9`):

````
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](https://drive.google.com/drive/folders/1DoJ7fmHsfksUk3YcAxxSXRk-gM7UqKin?usp=sharing).