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
