db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Charles Hordis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5953) CREATE TABLE ... AS SELECT fails with error ERROR 42X71: Invalid data type 'BOOLEAN'
Date Tue, 16 Oct 2012 20:59:03 GMT
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

Mime
View raw message