[EMAIL PROTECTED] writes:
> CREATE TABLE AS ignores explicitly specified column names when the query contains a
>UNION. This is illustrated in the example below.
Good catch! If you need a fix immediately, I think the attached patch
will do the trick. (Line numbers are for current sources, but
Todd Reed ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
CREATE TABLE AS ignores explicit column names with UNION
Long Description
CREATE TABLE AS ignores explicitly specified column names when the query contains a
UNION. Th