Re: [sqlite] Packing integer primary key with field bits

2017-08-12 Thread x
Cheers Ryan. From: R Smith Sent: 11 August 2017 11:14 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Packing integer primary key with field bits On 2017/08/11 10:21 AM, x wrote: > I’m wishing I had kept my m

[sqlite] Bug report: Wrong column name in a table in a certain case

2017-08-12 Thread Jürgen Palm
Hi, please have a look at the following sequence of statements executed on Windows 10 with sqlite3.exe, version 3.19.3 and 3.20.0: CREATE TABLE test("column with space" TEXT); CREATE TABLE test2 AS SELECT "column with space" FROM test; CREATE TABLE test3 AS SELECT "column with space" FROM test