Also worked correctly in 3.8.2. Problem introduced in 3.8.3. Fixed here: http://www.sqlite.org/src/info/221f8f9447
On Mon, Mar 24, 2014 at 4:52 AM, Clemens Ladisch <[email protected]> wrote: > Hi, > > it appears that SQLite thinks it can reuse a register even when > another operation changes it by applying numeric affinity: > > > create table t(x); > > insert into t values('1'); > > select typeof(x) from t where x=x; > text > > select typeof(x) from t where x=x+0; > integer > > (first reported here: <http://stackoverflow.com/questions/22598026>) > > This worked correctly in SQLite 3.7.17. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
