You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Murat Cengiz (JIRA)" <ji...@apache.org> on 2017/08/14 14:53:00 UTC

[jira] [Created] (DERBY-6956) Create table as Select cannot

Murat Cengiz created DERBY-6956:
-----------------------------------

             Summary: Create table as Select cannot 
                 Key: DERBY-6956
                 URL: https://issues.apache.org/jira/browse/DERBY-6956
             Project: Derby
          Issue Type: Bug
          Components: JDBC, SQL
    Affects Versions: 10.13.1.1
         Environment: Windows 7, DataGrip
            Reporter: Murat Cengiz


I create a test table with the following query:

CREATE TABLE "DERBYTEST" ("STRINGCOLUMN" varchar(255), "INTEGERCOLUMN" integer, "SHORTCOLUMN" varchar(255), "LONGCOLUMN" bigint, "DOUBLECOLUMN" double, "FLOATCOLUMN" double, "DECIMALCOLUMN" decimal(31, 6), "BOOLEANCOLUMN" smallint, "DATECOLUMN" timestamp, "DATETIMECOLUMN" timestamp, "ID" integer, "LASTMODTIME" timestamp, PRIMARY KEY ("ID"))

this query completes successfully

I later try to copy the table with the following query:

CREATE TABLE "DERBYTEST_TEMP" AS SELECT * FROM DERBYTEST WITH NO DATA

This throws the following exception:

[42X71][30000] Invalid data type 'DECIMAL(31, 6)' for column 'DECIMALCOLUMN'



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)