I'm using SQLite 3.8.10.2 and the following query illustrates the problem:
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);
There is no _id_ column in the tB table, y
On 02/27/2016 12:49 AM, Jo?o Ramos wrote:
> I'm using SQLite 3.8.10.2 and the following query illustrates the problem:
>
> 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 O
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 SELEC
On 2/29/16, 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
Compiling with that exact same version of the source code, it works fin
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" UNIO
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.
6 matches
Mail list logo