Paolo Vernazza <[EMAIL PROTECTED]> wrote:
> 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>
>
>
> Is that a sqlite bug? Am I doing something wrong?
> How should I change my query to have the old behavior?
>
See ticket #2248 and check-in [4656]
http://www.sqlite.org/cvstrac/tktview?tn=2248
http://www.sqlite.org/cvstrac/chngview?cn=3656
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
