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

2017-08-13 Thread Richard Hipp
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

[sqlite] SQLite used in our network engine (SLikeNet)

2017-08-13 Thread Stefan Hett
Hi, I'd just like to quickly reach out to let you know that we released a new (open source) network engine in which we also utilize SQLite and want to thank you for the work you put into SQLite. SQLite is used as the backend db for the logging mechanism utilized in the network engine. In

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

2017-08-13 Thread Bernd Lehmkuhl
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,