Charles Hordis created DERBY-5953:
-------------------------------------
Summary: CREATE TABLE ... AS SELECT fails with error ERROR 42X71:
Invalid data type 'BOOLEAN'
Key: DERBY-5953
URL: https://issues.apache.org/jira/browse/DERBY-5953
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.9.1.0, 10.8.2.2
Environment: Windows XP and Red Hat Linux tested
Reporter: Charles Hordis
Priority: Minor
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'.
--
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
