vember, 2017 13:38
>To: SQLite mailing list
>Subject: Re: [sqlite] Is this error expected?
>
>Now the problem seems to affect implicit column definitions, I tried
>the
>following:
>
>select * from (values(12345)) join (values(54321)) using(column1);
>
>Does not produc
Subject: Re: [sqlite] Is this error expected?
Now the problem seems to affect implicit column definitions, I tried the
following:
select * from (values(12345)) join (values(54321)) using(column1);
Does not produce any output (incorrectly IMO), but it also does not give any
error like the rowid
Now the problem seems to affect implicit column definitions, I tried the
following:
select * from (values(12345)) join (values(54321)) using(column1);
Does not produce any output (incorrectly IMO), but it also does not give any
error like the rowid case (inconsistent -- if we accept the error
It's actually even simpler to show this (without CTE defining a rowid):
create table t1(v); insert into t1 values(12345);
create table t2(v); insert into t2 values(54321);
select * from t1 join t2 using(rowid); -- THIS ONE FAILS
select * from t1 join t2 on t1.rowid = t2.rowid; -- THIS ONE
Not really. Table TAB does not contain a column named rowid. tab.rowid refers
to the non-column representing the row number of a row in the table.
If you declared table TAB to actually have a column called rowid then it would
work just fine, even if that column rowid still contained the row
5 matches
Mail list logo