[jira] [Commented] (DERBY-5953) CREATE TABLE ... AS SELECT fails with error ERROR 42X71: Invalid data type 'BOOLEAN'
[ https://issues.apache.org/jira/browse/DERBY-5953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13477917#comment-13477917 ] Charles Hordis commented on DERBY-5953: --- Oops, apologies for the duplicate. > 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.8.2.2, 10.9.1.0 > Environment: Windows XP and Red Hat Linux tested >Reporter: Charles Hordis >Priority: Minor > Labels: sql > > 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
[jira] [Commented] (DERBY-5953) CREATE TABLE ... AS SELECT fails with error ERROR 42X71: Invalid data type 'BOOLEAN'
[ https://issues.apache.org/jira/browse/DERBY-5953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13477459#comment-13477459 ] Bryan Pendleton commented on DERBY-5953: Resolving as a duplicate of DERBY-5918 > 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.8.2.2, 10.9.1.0 > Environment: Windows XP and Red Hat Linux tested >Reporter: Charles Hordis >Priority: Minor > Labels: sql > > 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
