SQLITE tables behavior

[Jerry]

Hi, since the change to 4.7 I have some weird behaviour of the DB Nodes (on Mac).

I have an Sqlite table where I have two parameters defined as VARCHAR. One of them is really a text string the other one just looks like a number. Using the new DB connector the mapping seems to be okay and identical in all nodes. However, if I open the DB query reader node it shows the two string fields as Double in the Tables Section Browser. If I execute the node the output is again correct as string. So far this looks strange but it works.

The real problems comes up when I use the Parameterized DB Query Reader. Although it looks as weird as the regular Query Reader node (the mapping is identical) in this case also the output comes out wrong. The one that looks like a number is converted to Double and the actual textstring is also Double and shows only a zero.

I hope the explanation together with the screenshots is clear.

Don’t know if this is a bug or just something I have to tweak in the configuration dialog.

Best regards Jerry

[mlauber71]

@Jerry maybe you could provide a sample workflow that would show the error without spelling any secrets.

[Jerry]

Hi, I recreated it by creating a dummy sqlite database and a workflow. Just took at the two interactive tables.
test.knwf (35.3 KB) unfortunately I does not let me upload the sqlite file.

This did not happen in 4.6 with the previous driver. I think it has something to do with how the database table is created. If I convert all Varchar to just Text everything works.

Thanks Jerry

[mlauber71]

@Jerry you can always place the SQLite file in the /data/ subfolder of the node itself.

knime://knime.workflow/data/test.sqlite

[Jerry]

TestDatabase.knar (17.1 KB)

Okay, didn’t think of that…