[
https://issues.apache.org/jira/browse/DERBY-5918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450645#comment-13450645
]
Rick Hillegas commented on DERBY-5918:
--------------------------------------
Hi David,
I agree that the fix for this bug could be backported all the way back to 10.7,
the release which introduced the BOOLEAN datatype. Thanks.
> 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
>
> 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
