Try this with an old 3.2.x sqlite version
SQLite version 3.2.8
Enter ".help" for instructions
sqlite> CREATE Table test (a, b, c);
sqlite> INSERT into test (a,b,c) VALUES ('1', '2', '3');
sqlite> SELECT * FROM test WHERE a||b||c = '123';
1|2|3
sqlite> SELECT * FROM test WHERE a||b||c IN ('123');
1|2|3
sqlite>
Now try with sqlite 3.3.13
SQLite version 3.3.13
Enter ".help" for instructions
sqlite> CREATE Table test (a, b, c);
sqlite> INSERT into test (a,b,c) VALUES ('1', '2', '3');
sqlite> SELECT * FROM test WHERE a||b||c = '123';
1|2|3
sqlite> SELECT * FROM test WHERE a||b||c IN ('123');
sqlite>
But it works if values are not numbers:
sqlite> INSERT into test (a,b,c) VALUES ('1a', '2b', '3c');
sqlite> SELECT * FROM test WHERE a||b||c = '1a2b3c';
1a|2b|3c
sqlite> SELECT * FROM test WHERE a||b||c IN ('1a2b3c');
1a|2b|3c
sqlite>
Is that a sqlite bug? Am I doing something wrong?
How should I change my query to have the old behavior?
Thanks
Paolo
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
