Jean-Luc Hainaut wrote: > Python 2.7.6, SQLite v3.8.5 So this is not the standard Python distribution?
> import sqlite3 > conn = sqlite3.connect('ORDERS.db') > c = conn.cursor() > > query = "with CTE1(ID,Name,City)"\ > + " as (select CustID,Name from CUSTOMER where City = 'London')"\ > + " select * from CTE1" Error: table CTE1 has 2 values for 3 columns > c.execute(query) > > print c.description > > > Description of the bug: > - if the result set is not empty, c.description returns the list of column > names, as expected. > - if the result set is empty, c.description returns None. As far as I can see, SQLite returns correct column information even for empty result sets. Report bugs in the Python SQLite module here: <https://github.com/ghaering/pysqlite/issues> Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users