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 <clem...@ladisch.de> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
