mercredi 21 octobre 2015

sqlite3 exe shows empty view whereas on mac it is ok

I have a test.db sqlite file that contains some tables and a view (for test). The problem is that when I use sqlite3 exe for windows the view is empty but it contains data if I open it on my mac.

sqlite3.exe version: 3.9.1

sqlite mac version: 3.8.10.2

the view:

CREATE VIEW TEST_VIEW AS SELECT kfeature.ID_KFEATURE, kshaft.ID_KSHAFT, kcompsections.ID_KCOMPSECTIONS, kcompsections.POSITION, kcompsections.KCOMPONENT_ID_KCOMPONENT, ksection_feature.DRAW_ORDER FROM 
(kshaft INNER JOIN kfeature_shaft ON kshaft.ID_KSHAFT = kfeature_shaft.KSHAFT_ID_KSHAFT) INNER JOIN 
(kfeature INNER JOIN (ksection_feature INNER JOIN kcompsections ON ksection_feature.KCOMPSECTION_ID_KCOMPSECTION = kcompsections.ID_KCOMPSECTIONS) ON kfeature.ID_KFEATURE = ksection_feature.KFEATURE_ID_KFEATURE) 
ON kfeature_shaft.KFEATURE_ID_KFEATURE = kfeature.ID_KFEATURE;

I have opened the file even in SQLPro for Sqlite and the view is ok! How is it possible?

Aucun commentaire:

Enregistrer un commentaire