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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
