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

@sqlite.org Subject: Re: [sqlite] Is this expected behavoir, or should I open a ticket? Noah Hart 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 val

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

Noah Hart 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, not a str

[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 informa