[
https://issues.apache.org/jira/browse/DERBY-5918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-5918:
--------------------------------------
Issue & fix info: Repro attached
Urgency: Normal
Labels: derby_triage10_10 (was: )
> CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns
> ------------------------------------------------------------------
>
> Key: DERBY-5918
> URL: https://issues.apache.org/jira/browse/DERBY-5918
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.10.0.0
> Reporter: Rick Hillegas
> Labels: derby_triage10_10
>
> You can't use CREATE TABLE AS SELECT from a table with a BOOLEAN column. This
> limitation was put in when CREATE TABLE AS SELECT was added. At that time you
> could not create user tables with BOOLEAN columns and we did not want people
> to be able to subvert that restriction by using CREATE TABLE AS SELECT from a
> system table with BOOLEAN columns. The following script shows this problem:
> connect 'jdbc:derby:memory:db;create=true';
> create table t1( a int );
> create table t2( a boolean );
> create table t3 as select * from t1 with no data;
> create table t4 as select * from t2 with no data;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
