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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2017/08/20 14:25:00 UTC
[jira] [Resolved] (DERBY-6956) Create table as Select cannot copy
Decimal columns
[ https://issues.apache.org/jira/browse/DERBY-6956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-6956.
----------------------------------
Resolution: Fixed
Fix Version/s: 10.14.0.0
> Create table as Select cannot copy Decimal columns
> --------------------------------------------------
>
> 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
> Labels: newbie
> Fix For: 10.14.0.0
>
> Attachments: derby-6956-01-aa-removeSpuriousCheck.diff, withTest.diff
>
>
> 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'
> Everything works perfectly fine if I remove the decimal column.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)