|
|
|
A query similar to the following was failing with error 20090 even if an alias had been provided for the "upper(tbl)" expression:
create table pippo2 as select tbl,upper(tbl) as up from systables where user='admin';
The logic has been updated to correct this situation.
A situation was addressed in which comments in the select statement in a CREATE TABLE AS SELECT caused an infinite loop that would never return even if the query by itself took only a few seconds.
Additional changes were made to address other errors encountered when using CREATE TABLE AS SELECT.
