-----Original Message----- From: Gerard Samuel [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 11:41 AM To: Fred Williams; [EMAIL PROTECTED] Subject: Re: [sqlite] Select statements returned column names
On Wednesday 18 February 2004 12:19 pm, Fred Williams wrote: > Just did some testing on the "other" databases I have available. This > "feature" of SQLite does seem to be unique. I am early in the learning > curve on SQLite, and had not found this particular "enhancement" as yet. > Nice to know, and avoid! > > Looks like to me it is time for a new PRAGMA! > > I am not well versed on the SQL '9x specifications, so don't know if SQLite > is breaking spec's or just breaking "convention." Either way I think it > deserves consideration, as it directly impacts cross platform (i.e. > database engines) environments. Something I am painfully familiar with. > Just never got burned by this particular situation in the past, so was > blissfully unaware of the pending potential "all nighters," BUMMER! > > Fred > >In my journey with databases, (mysql, postgresql, sql 2000, ibm db2, and >sqlite), sqlite is the only one that behaves like this. >IMHO, its not a "feature" but more of a "catch all" regardless of whether the >results contain same column names. >Like using an axe to split match sticks!! >Lets hope it gets reverted to how it was, or some kind of switch is >introduced... ... Judging from my very short SLQite exposure, I am very impressed with both the engine and the responsive support it receives (jumped in after the first of the year at 2.8.8 and we are already at 2.8.12!) I just hope Richard has (select one or more): Infinite financial resources, an extremely understanding or stupid boss, way too much "spare" time on his hands, the world's perfect wife, and etc, etc.! AND may his situation never change. I feel there will be a very workable resolution to this issue way earlier than I would expect. Now if I could just get the guy supplying my "free" and super Delphi DBExpress driver to keep up with mister Hipp, my life would be damn near perfect. Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
