Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7755A1035D for ; Fri, 14 Jun 2013 17:14:23 +0000 (UTC) Received: (qmail 82428 invoked by uid 500); 14 Jun 2013 17:14:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 82410 invoked by uid 500); 14 Jun 2013 17:14:20 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 82385 invoked by uid 99); 14 Jun 2013 17:14:20 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Jun 2013 17:14:20 +0000 Date: Fri, 14 Jun 2013 17:14:20 +0000 (UTC) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (DERBY-5918) CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-5918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas closed DERBY-5918. -------------------------------- > CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns > ------------------------------------------------------------------ > > Key: DERBY-5918 > URL: https://issues.apache.org/jira/browse/DERBY-5918 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.10.1.1 > Reporter: Rick Hillegas > Assignee: Rick Hillegas > Labels: derby_triage10_10 > Fix For: 10.7.1.4, 10.8.3.0, 10.9.2.2, 10.10.1.1 > > Attachments: derby-5918-01-aa-removeHurdle.diff, derby-5918-01-ab-removeHurdle.diff > > > 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; -- 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