[DERBY-5918] CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.10.1.1
• Fix Version/s: 10.7.1.4, 10.8.3.0, 10.9.2.2, 10.10.1.1
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Seen in production
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 06/Sep/12 17:41
• Updated: 14/Jun/13 17:12
• Resolved: 17/Oct/12 15:49

Description

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;

Issue Links

• is duplicated by: DERBY-5953 CREATE TABLE ... AS SELECT fails with error ERROR 42X71: Invalid data type 'BOOLEAN'
• relates to: DERBY-4716 Enable BOOLEAN typed columns