On Tue, Oct 13, 2015 at 8:28 AM, Don V Nielsen <donvnielsen at gmail.com> wrote:
> The syntax "WITH p AS (SELECT 1) INSERT INTO t(x) SELECT * FROM p;" throws > the same exception: "[2015-10-13 08:20:22] [1] [SQLITE_ERROR] SQL error or > missing database (near ")": syntax error)" > > On my system, RedHat Linux, Fedora 22, x86_64: SQLite version 3.8.11.1 2015-07-29 20:00:57 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t(x); sqlite> WITH p AS (SELECT 1) INSERT INTO t(x) SELECT * FROM p; sqlite> select * from t; 1 sqlite> ? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown