[sqlite] Is this expected behavoir, or should I open a ticket?

SQL Version: 3.6.10 CREATE TABLE T1(a, b); INSERT INTO T1 VALUES(C1_A, randomblob(1)); SQL error:no such column: C1_A I know that I can quote the value C1_A, but why is that necessary? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged

Re: [sqlite] Is this expected behavoir, or should I open a ticket?

Noah Hart n...@lipmantpa.com wrote: SQL Version: 3.6.10 CREATE TABLE T1(a, b); INSERT INTO T1 VALUES(C1_A, randomblob(1)); SQL error:no such column: C1_A I know that I can quote the value C1_A, but why is that necessary? Why do you believe it shouldn't be necessary? C1_A is an identifier,

Re: [sqlite] Is this expected behavoir, or should I open a ticket?

Never mind, brain glitch. Sorry for the waste of bandwidth. Just too late on a Friday afternoon. Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Friday, February 06, 2009 4:14 PM To: