[
https://issues.apache.org/jira/browse/DERBY-5918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas closed DERBY-5918.
--------------------------------
> 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.1.1
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Labels: derby_triage10_10
> Fix For: 10.7.1.4, 10.8.3.0, 10.9.2.2, 10.10.1.1
>
> Attachments: derby-5918-01-aa-removeHurdle.diff,
> derby-5918-01-ab-removeHurdle.diff
>
>
> 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
