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