Int16 column is not displayed with SQLite

cactuaroid

I'm using latest LINQPad 4/5 and "IQ Driver - for MySQL, SQLite, Oracle" to query DB of SQLite.

When I right click on table and select ".Take()" or whatever, the result doesn't contain columns of Int16 type.

I checked the SQL of result pane but the SELECT line doesn't contain those columns. If I add that hidden column on SELECT line and run the SQL, it shows the column correctly. Therefore it looks generating SQL ignores Int16 type column somehow.

How can I resolve this?

cactuaroid

According to schema, the column was created as 'smallint' type. In SQLite, it is treated as 'Integer' type (I checked by 'typeof'). Of course other Integer columns have no problem. Thus I guess this is a issue of IQ Driver's dynamic data context driver.

But I couldn't find the open source project of it, maybe I have to ask Joe?

JoeAlbahari

I've just uploaded a fix. The driver now supports all the integer types listed in https://www.sqlite.org/datatype3.html

Download the IQ driver again and let me know.

cactuaroid

Thank you very much Joe, It looks perfectly working now!