Derby
  1. Derby
  2. DERBY-5918

CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Seen in production

      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

          Activity

          Rick Hillegas created issue -
          David Myers made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-4716 [ DERBY-4716 ]
          Knut Anders Hatlen made changes -
          Labels derby_triage10_10
          Urgency Normal [ 10052 ]
          Issue & fix info Repro attached [ 10424 ]
          Knut Anders Hatlen made changes -
          Link This issue is duplicated by DERBY-5953 [ DERBY-5953 ]
          Rick Hillegas made changes -
          Bug behavior facts Seen in production [ 10421 ]
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Attachment derby-5918-01-aa-removeHurdle.diff [ 12549500 ]
          Rick Hillegas made changes -
          Attachment derby-5918-01-ab-removeHurdle.diff [ 12549519 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.7.1.4 [ 12315902 ]
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Fix Version/s 10.9.1.1 [ 12321551 ]
          Fix Version/s 10.10.0.0 [ 12321550 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Fix Version/s 10.8.3.0 [ 12323456 ]
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Kathey Marsden made changes -
          Fix Version/s 10.9.2.0 [ 12323562 ]
          Fix Version/s 10.9.1.1 [ 12321551 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12724262 ] Default workflow, editable Closed status [ 12802056 ]

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development