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

Now fixed on trunk. On 8/11/17, Jürgen Palm wrote: > 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

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

Most probably not a bug. I asked something similar a while ago. It's as easy as https://sqlite.org/faq.html#q28 . As long as you don't explicitly assign an alias to a column name, sqlite is not guaranteed to return what you might expect. Am 11.08.2017 um 22:52 schrieb Jürgen Palm: Hi,

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

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