Re: [sqlite] beginners question

2018-08-30 Thread Jürgen Palm
Jens Alfke wrote: On Aug 30, 2018, at 12:10 PM, Richard Hipp wrote: So, perhaps the solution is for Klaus to compile it himself from sources? What about `sudo apt-get install sqlite3` ? —Jens ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] beginners question

2018-08-30 Thread Jürgen Palm
Richard Hipp wrote: On 8/30/18, Jürgen Palm wrote: Richard Hipp wrote: On 8/30/18, Klaus Maas wrote: Same issues on Xubuntu 16.04 and 18.04 US international keyboard layout Actually 2 questions: 1) The precompiled binary for Linux of sqlite3 does not run, but sqldiff and

Re: [sqlite] beginners question

2018-08-30 Thread Jürgen Palm
Richard Hipp wrote: On 8/30/18, Klaus Maas wrote: Same issues on Xubuntu 16.04 and 18.04 US international keyboard layout Actually 2 questions: 1) The precompiled binary for Linux of sqlite3 does not run, but sqldiff and sqlite3_analyzer do. ./sqlite3: error while loading shared libraries

Re: [sqlite] Bug: Problem with sqlite3_prepare_v2

2018-07-30 Thread Jürgen Palm
Richard Hipp wrote: On 7/29/18, Jürgen Palm wrote: Hi, in an application I encountered a problem, where the changing of the structure of a table by dropping and recreating it via one connection to a db was not directly seen by another connection to the same db. Detecting a schema change

[sqlite] Bug: Problem with sqlite3_prepare_v2

2018-07-29 Thread Jürgen Palm
Hi, in an application I encountered a problem, where the changing of the structure of a table by dropping and recreating it via one connection to a db was not directly seen by another connection to the same db. I could reproduce the problem with the test program below. Inserting a sqlite3_ste

[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