You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by bp...@apache.org on 2017/08/18 01:32:24 UTC
svn commit: r1805356 -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java
Author: bpendleton
Date: Fri Aug 18 01:32:24 2017
New Revision: 1805356
URL: http://svn.apache.org/viewvc?rev=1805356&view=rev
Log:
DERBY-6956: CREATE TABLE AS SELECT cannot copy DECIMAL(31,6)
This change adds several test tests to serve as regression tests.
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java?rev=1805356&r1=1805355&r2=1805356&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java Fri Aug 18 01:32:24 2017
@@ -182,6 +182,88 @@ public final class CreateTableFromQueryT
new String[] {"VARCHAR", "INTEGER"});
}
+ public void testDerby6956() throws Exception
+ {
+ Statement stmt = createStatement();
+
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST6956 " +
+ "(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))");
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST_TEMP6956 "+
+ "AS SELECT * FROM DERBYTEST6956 WITH NO DATA");
+
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST6956_A " +
+ "(STRINGCOLUMN varchar(255), "+
+ " INTEGERCOLUMN integer, "+
+ " SHORTCOLUMN varchar(255), "+
+ " LONGCOLUMN bigint, "+
+ " DOUBLECOLUMN double, "+
+ " FLOATCOLUMN double, "+
+ " DECIMALCOLUMN decimal(29, 6), "+
+ " BOOLEANCOLUMN smallint, "+
+ " DATECOLUMN timestamp, "+
+ " DATETIMECOLUMN timestamp, "+
+ " ID integer, "+
+ " LASTMODTIME timestamp, "+
+ " PRIMARY KEY (ID))");
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST_TEMP6956_A "+
+ "AS SELECT * FROM DERBYTEST6956_A WITH NO DATA");
+
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST6956_B " +
+ "(STRINGCOLUMN varchar(255), "+
+ " INTEGERCOLUMN integer, "+
+ " SHORTCOLUMN varchar(255), "+
+ " LONGCOLUMN bigint, "+
+ " DOUBLECOLUMN double, "+
+ " FLOATCOLUMN double, "+
+ " DECIMALCOLUMN decimal(31,31), "+
+ " BOOLEANCOLUMN smallint, "+
+ " DATECOLUMN timestamp, "+
+ " DATETIMECOLUMN timestamp, "+
+ " ID integer, "+
+ " LASTMODTIME timestamp, "+
+ " PRIMARY KEY (ID))");
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST_TEMP6956_B "+
+ "AS SELECT * FROM DERBYTEST6956_B WITH NO DATA");
+
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST6956_C " +
+ "(STRINGCOLUMN varchar(255), "+
+ " INTEGERCOLUMN integer, "+
+ " SHORTCOLUMN varchar(255), "+
+ " LONGCOLUMN bigint, "+
+ " DOUBLECOLUMN double, "+
+ " FLOATCOLUMN double, "+
+ " DECIMALCOLUMN decimal(31,0), "+
+ " BOOLEANCOLUMN smallint, "+
+ " DATECOLUMN timestamp, "+
+ " DATETIMECOLUMN timestamp, "+
+ " ID integer, "+
+ " LASTMODTIME timestamp, "+
+ " PRIMARY KEY (ID))");
+ stmt.executeUpdate(
+ "CREATE TABLE DERBYTEST_TEMP6956_C "+
+ "AS SELECT * FROM DERBYTEST6956_C WITH NO DATA");
+
+ }
+
/**
* Test error when base table does not exist.
* @throws Exception