Re: [sqlite] Quotation handling bug?

2006-09-19 Thread He Shiming
- Original Message - From: "Robert Simpson" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 19, 2006 2:19 PM Subject: RE: [sqlite] Quotation handling bug? Single quotes are supposed to be used for string literals, and double quotes/brackets for identifiers such as

RE: [sqlite] Quotation handling bug?

2006-09-18 Thread Robert Simpson
> -Original Message- > From: He Shiming [mailto:[EMAIL PROTECTED] > Sent: Monday, September 18, 2006 10:02 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Quotation handling bug? > > Hi, > > I think I found a bug in sqlite version 3.3.7. The steps

[sqlite] Quotation handling bug?

2006-09-18 Thread He Shiming
Hi, I think I found a bug in sqlite version 3.3.7. The steps to reproduce it is as follows. I've tested it on Windows only. C:\Something>sqlite3 newdb.db CREATE TABLE 'MYTABLE' ('ID' INTEGER PRIMARY KEY); INSERT INTO 'MYTABLE' ('ID') VALUES(1); INSERT INTO 'MYTABLE' ('ID') VALUES(2); INSERT IN