[DERBY-5953] CREATE TABLE ... AS SELECT fails with error ERROR 42X71: Invalid data type 'BOOLEAN'

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 10.8.2.2, 10.9.1.0
• Component/s: SQL
• Labels: sql
• Environment: Windows XP and Red Hat Linux tested
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Charles Hordis
• Created: 16/Oct/12 20:57
• Updated: 15/Nov/13 08:15
• Resolved: 16/Oct/12 23:22

Description

CREATE TABLE ... AS SELECT fails with error ERROR 42X71: Invalid data type 'BOOLEAN'

BDELETEABLE is the first BOOLEAN column in the ASSETS table.

ij> CREATE TABLE TEMP_ROOTLIST_1 AS SELECT * FROM Assets WITH NO DATA;
ERROR 42X71: Invalid data type 'BOOLEAN' for column 'BDELETEABLE'.

Issue Links

• duplicates: DERBY-5918 CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns