Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread drh
Yves Goergen <[EMAIL PROTECTED]> wrote: > On 27.06.2007 01:35 CE(S)T, [EMAIL PROTECTED] wrote: > > http://www.sqlite.org/cvstrac/tktview?tn=2450 > > Wow, I guess from that page that it's already fixed? > > One question regarding the issue tracker: Is there a reference of what > the severity and p

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread Yves Goergen
On 27.06.2007 01:35 CE(S)T, [EMAIL PROTECTED] wrote: > http://www.sqlite.org/cvstrac/tktview?tn=2450 Wow, I guess from that page that it's already fixed? One question regarding the issue tracker: Is there a reference of what the severity and priority values mean? Is a lower value more or less sev

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread Dennis Cote
[EMAIL PROTECTED] wrote: You should file a bug ticket at http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew since these are all valid quoted SQL identifiers. http://www.sqlite.org/cvstrac/tktview?tn=2450 I see I'm late to the party again. :-) I'm glad to see this was fixe

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread drh
Dennis Cote <[EMAIL PROTECTED]> wrote: > Yves Goergen wrote: > > Hi, > > > > I've tested my own SQLite application's identifier quoting capabilities > > now and found that the SQLite engine has serious problems with > > table/column names containing certain special characters. Just try the > > foll

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread Dennis Cote
Yves Goergen wrote: Hi, I've tested my own SQLite application's identifier quoting capabilities now and found that the SQLite engine has serious problems with table/column names containing certain special characters. Just try the following: CREATE TABLE "t a" ("c a", """cb"""); INSERT INTO "t a

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-23 Thread Yves Goergen
On 24.06.2007 00:17 CE(S)T, Yves Goergen wrote: > CREATE TABLE "t a" ("c a", """cb"""); > (...) And this may take forever to still not finish: DROP TABLE "t a"; It then worked in a second try. -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified

[sqlite] Crashes and random wrong results with certain column names

2007-06-23 Thread Yves Goergen
Hi, I've tested my own SQLite application's identifier quoting capabilities now and found that the SQLite engine has serious problems with table/column names containing certain special characters. Just try the following: CREATE TABLE "t a" ("c a", """cb"""); INSERT INTO "t a" ("c a", """cb""") VA