Sorry for the late reply. That output (--1 etc.) was me manually "formatting" the results. I came across this issue using SQLiteStudio v3.0.7 on Windows. I just create a new DB and run that script: it outputs two rows, with one column each, with the values 1 and 2 respectively, instead of an error.
On Mon, Feb 29, 2016 at 11:18 AM, R Smith <rsmith at rsweb.co.za> wrote: > > > On 2016/02/29 12:49 PM, Jo?o Ramos wrote: > >> Maybe this has been fixed then? This is what I'm getting: >> >> select sqlite_version(); -- 3.8.10 >> >> select sqlite_source_id(); -- 2015-05-04 19:13:25 >> 850c11866686a7b39d7b163fb60898c11283688e >> >> >> WITH >> >> tA(id, name) AS >> >> ( >> >> SELECT 1, "a" UNION ALL SELECT 2, "b" >> >> ), >> >> tB(name) AS >> >> ( >> >> SELECT "a" UNION ALL SELECT "b" >> >> ) >> >> SELECT tB.id FROM tA INNER JOIN tB ON (tA.name = tB.name); >> >> >> -- 1 >> >> -- 2 >> > > This output ( -- 1 etc.) looks like it is produced by some SQLite > interface type thing or perhaps an admin tool, it doesn't look like the > SQLite cli, so maybe there's possibly something wrong there? Many of those > tools substitute the column names a bit in queries. > > Show us the exact tool you use to get it and also the OS version etc. > please. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- *Jo?o Ramos*