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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
