Just try this sql-s:
create table test(a int, b int);
insert into test values (1,1);
select d from (select c as d from (select a as c from test));
will return name d.
create table test2 as
select d from (select c as d from (select a as c from test));
will create table test2 with column name a.
with PostgreSQL I get table test2 with name d.
Thank you very much for your time!
Richard Hipp je 22.12.2017 ob 20:06 napisal:
On 12/22/17, Radovan Antloga <[email protected]> wrote:
My point is you do not have to change anything regards
to how select works. SELECT statement is working just
great or OK or fine.
CREATE TABLE AS
SELECT ....
does not give same name as SELECT does.
SELECT give name d
CREATE TABLE AS SELECT
create table with name a instead of d.
Can you provide a simple test case for this behavior?
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
