>>> 2. *Quotes in SELECT*: Specification of Field='3' failed to find >>> hits; Field=3 (i.e. without quotes) was required. > > This is a feature, not a bug. SQLite 3.x distinguishes between > integers and strings and does not consider them equal to one another. > You might have some rows where Field='3' and different rows where > Field=3 and SQLite will distinguish between them.
BTW, I've re-read documentation about this, felt that something wrong here, tried it out and saw that your (Rod) complaint is wrong in this particular case: sqlite> create table t (n integer, t text); sqlite> insert into t values (1, '3'); sqlite> select * from t; 1|3 sqlite> select * from t where n = 1; 1|3 sqlite> select * from t where n = '1'; 1|3 sqlite> select * from t where t = '3'; 1|3 sqlite> select * from t where t = 3; 1|3 sqlite> select * from t where +n = '1'; sqlite> Pavel On Tue, Sep 1, 2009 at 4:48 PM, D. Richard Hipp<d...@hwaci.com> wrote: > > On Sep 1, 2009, at 4:38 PM, Rod Dav4is wrote: > >> Aren't these problems considered worth fixing ? > > I do not consider them to be problems. > >> >> Rod Dav4is wrote: >>> 1. *OID vs ROWID*: Specification of the OID field name (in >>> SELECT) >>> did not set Rexx variables X.OID.n, but instead set variables >>> x.ROWID.n > > The "name" of a result column is undefined unless you use the "AS" > clause. We try to be reasonably consistent, but there are no > promises. There are especially no promises when moving form 2.8 to 3.6 > > >>> 2. *Quotes in SELECT*: Specification of Field='3' failed to find >>> hits; Field=3 (i.e. without quotes) was required. > > This is a feature, not a bug. SQLite 3.x distinguishes between > integers and strings and does not consider them equal to one another. > You might have some rows where Field='3' and different rows where > Field=3 and SQLite will distinguish between them. > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
