If cross-implementation portability is a stated design goal, Adobe's departure from the "authoritative" behavior is indeed a bug. If cross-implementation portability is not "officially" supported but is simply something that users might expect and attempt, then Adobe's departure from the authoritative behavior is just a pothole on the lonely highway.
I don't know the particulars of how it happened. I think Adobe may not have envisioned SQLite database files created outside of AIR being used in AIR apps. They were probably thinking in terms of "local storage" databases instantiated and defined through the AIR API. No, I am not asking SQLite to "emulate an error" in Adobe's code. Rather I am suggesting this: if SQLite is going to distinguish in any way between INT and INTEGER on primary key definitions, the CREATE TABLE X as SELECT... syntax ought not to produce a table with an INT primary key if the prototype had INTEGER. Regards Tim Romano Swarthmore PA On Wed, Jun 30, 2010 at 9:24 AM, David Bicking <dbic...@yahoo.com> wrote: > > > All things considered, I would say this is clearly and 100% a bug in > Adobe's code. The given SQL nowhere mentioned rowid, yet they are > joining on rowid... that has got to be an error. > > And how is Adobe Air doing this? Did they write there own sql parser? > There own VDBE? (Hopefully I got those initials correct.) Are they > calling Sqlite or did they write their own library claiming it is > compatible with the Sqlite file format? > > While I don't necessarily disagree with what you are saying, in this > example you appear to be asking the Sqlite developers to emulate an > error in someone else's code. > > David > > PS. Probably should remove my opinions from this, because the only > reason I am sending this is because I am curious what the hell Adobe is > doing that is causing this confusion. > > > > _______________________________________________ > 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
