There was a bug in sqlite.ijs now fixed. Please get update and test again. Thank you for the detail report.
On Thu, Mar 24, 2022 at 4:08 PM Ulrich Vollert <[email protected]> wrote: > Hi, > > I noticed an issue with SQLite and qualified column names - working with > j903/j64/darwin and data/sqlite 1.0.35. > > When I use two table names in a join as shown below, and the first column > name after the SELECT is qualified, I get no reply?? > > When the qualified name is the second column in the query, there is a > correct reply. > > require'data/sqlite' > > F =: '~temp/error_test.sqlite' > db=: sqlcreate_psqlite_ F > > sqlcmd__db 'create table t1 (a int, b int)' > sqlcmd__db 'create table t2 (a int, c int)' > > sqlinsert__db't1';('a';'b');<1;2 > sqlinsert__db't2';('a';'c');<1;3 > > > sqlreads__db'select t1.a, b, c from t1, t2 where t1.a = t2.a' > > evaluates to > ┌──────┬─┬─┐ > │"t1.a“. │b │c │ > ├──────┼─┼─┤ > └──────┴─┴─┘ > > which is not the correct answer….?? > > sqlreads__db'select b, t1.a, c from t1, t2 where t1.a = t2.a' > > evaluates correctly to > > ┌─┬─┬─┐ > │b │a │c │ > ├─┼─┼─┤ > │2 │1 │3 │ > └─┴─┴─┘ > > > Regards, > Ulrich > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
