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 rh...@apache.org on 2012/10/17 17:34:55 UTC
svn commit: r1399310 - in /db/derby/code/branches/10.9: ./
java/engine/org/apache/derby/iapi/types/
java/testing/org/apache/derbyTesting/functionTests/tests/lang/
Author: rhillegas
Date: Wed Oct 17 15:34:55 2012
New Revision: 1399310
URL: http://svn.apache.org/viewvc?rev=1399310&view=rev
Log:
DERBY-5918: Port 1399306 from trunk to 10.9 branch.
Modified:
db/derby/code/branches/10.9/ (props changed)
db/derby/code/branches/10.9/java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java
db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/BooleanValuesTest.java
db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java
Propchange: db/derby/code/branches/10.9/
------------------------------------------------------------------------------
Merged /db/derby/code/trunk:r1399306
Modified: db/derby/code/branches/10.9/java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.9/java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java?rev=1399310&r1=1399309&r2=1399310&view=diff
==============================================================================
--- db/derby/code/branches/10.9/java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java (original)
+++ db/derby/code/branches/10.9/java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java Wed Oct 17 15:34:55 2012
@@ -1812,9 +1812,6 @@ public final class DataTypeDescriptor im
*
* Three examples are:
*
- * BOOLEAN: A user can select boolean columns from system tables, but
- * s/he is not allowed to create such a column him/herself.
- *
* JAVA_OBJECT: A user can select columns of various java object types
* from system tables, but s/he is not allowed to create such a column
* him/herself.
@@ -1831,8 +1828,6 @@ public final class DataTypeDescriptor im
{
switch (typeId.getJDBCTypeId())
{
- case Types.BOOLEAN:
- return false;
case Types.JAVA_OBJECT:
return getTypeId().getBaseTypeId().isAnsiUDT();
case Types.DECIMAL:
Modified: db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/BooleanValuesTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/BooleanValuesTest.java?rev=1399310&r1=1399309&r2=1399310&view=diff
==============================================================================
--- db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/BooleanValuesTest.java (original)
+++ db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/BooleanValuesTest.java Wed Oct 17 15:34:55 2012
@@ -1893,6 +1893,31 @@ public class BooleanValuesTest extends
rs.close();
}
+ /**
+ * Verify that you can use CREATE TABLE AS SELECT to create
+ * empty tables with BOOLEAN columns.
+ */
+ public void test_5918() throws Exception
+ {
+ setAutoCommit(false);
+
+ Statement s = createStatement();
+ s.execute("create table derby5918_1(b boolean)");
+ s.execute("create table derby5918_2 as select * from derby5918_1 with no data");
+ s.executeUpdate("insert into derby5918_2 values ( true )");
+
+ assertResults
+ (
+ getConnection(),
+ "select * from derby5918_2",
+ new String[][]
+ {
+ { "true" },
+ },
+ false
+ );
+ }
+
///////////////////////////////////////////////////////////////////////////////////
//
// SQL ROUTINES
Modified: db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java?rev=1399310&r1=1399309&r2=1399310&view=diff
==============================================================================
--- db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java (original)
+++ db/derby/code/branches/10.9/java/testing/org/apache/derbyTesting/functionTests/tests/lang/CreateTableFromQueryTest.java Wed Oct 17 15:34:55 2012
@@ -262,10 +262,6 @@ public final class CreateTableFromQueryT
{
Statement stmt = createStatement();
- // BOOLEAN
- assertStatementError("42X71", stmt,
- "create table t as select systemalias from sys.sysaliases with no data");
-
// USER (Java Object)
assertStatementError("42X71", stmt,
"create table t as select aliasinfo from sys.sysaliases with no data");