#1567 'duplicate column name in derived table' when using wildcard

[Richard Thomas]

Please create a simple table such as
CREATE TABLE PUBLIC.DEMO(TEXT VARCHAR(1024) PRIMARY KEY);
Then try
SELECT *, LENGTH(TEXT) FROM DEMO;
And there is an error
'duplicate column name in derived table'.

[Fred Toussi]

When you use the unqualified wildcard, you cannot add another column to the SELECT list. Qualified wildcards are allowed multiple times or in addition to other columns.

SELECT DEMO.* , LENGTH(TEXT) FROM DEMO;

[Richard Thomas]

Alright thanks. I thought that was allowed in SQL.