Re: [sqlite] Sqlite accepts invalid column names

On Mon, Jun 24, 2013 at 8:32 AM, Rob Golsteijn wrote: > > I found the issue in SQLite version 3.7.15. Great if it is solved in the > latest version. > Fixed for 3.7.16 by check-in http://www.sqlite.org/src/info/99127a669c -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Sqlite accepts invalid column names

> On Thu, Jun 20, 2013 at 10:26 AM, Rob Golsteijn > wrote: > > > > > SELECT a.col2, > >b.col2, > >a.b.col2,-- invalid column name > >b.a.col2,-- invalid column name > >a.a.col2,-- invalid column name > >

Re: [sqlite] Sqlite accepts invalid column names

On Thu, Jun 20, 2013 at 10:26 AM, Rob Golsteijn wrote: > > SELECT a.col2, >b.col2, >a.b.col2,-- invalid column name >b.a.col2,-- invalid column name >a.a.col2,-- invalid column name >b.b.col2,--

[sqlite] Sqlite accepts invalid column names

Hi List, I made a copy-paste mistake, resulting in something that looked to me as invalid syntax for column names, but sqlite accepted it. The invalid column names are shown by the following example: .header on -- pragma is deprecated, but shows what happens pragma full_column_names=1;