On Wed, Sep 2, 2009 at 3:54 PM, Rod Dav4is<dav...@yahoo.com> wrote: > Whether _you_ consider them problems or not, they were certainly > problems for me, migrating a working application to version 3 and having > it fall over in subtle ways because of these undocumented two vs three > differences. They cost me several hours of unnecessary analysis time.
You should bill DRH for this. Or, ask for your money back. Seriously, esp. since the product is still under warranty. > > D. Richard Hipp 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 >> >> >> > > -- > Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 / USA > Genealogy, et Cetera: http://freepages.rootsweb.ancestry.com/~dav4is/ > 538 ancestral & collateral families, mostly 17°-19° century > New England & European roots. Total population: 136,000+ > Annex: http://www.gencircles.com/users/dav4is/ > email: dav...@yahoo.com > A Democrat, a Republican and a giraffe walk into a bar. The > bartender looks up from his want ads and says, "What is this, a joke?" > -unknown > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
