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.