create table from values clause causes error: ERROR 42ZA3: The table will have
collation type UCS_BASIC which is different than the collation of the schema
TERRITORY_BASED
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-2952
URL: https://issues.apache.org/jira/browse/DERBY-2952
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 11.0.0.0
Reporter: Kathey Marsden
To reproduce:
ij> connect
'jdbc:derby:nordb;territory=no_NO;collation=TERRITORY_BASED;create=true';
ij> create table t3 (x,y) as values (1,'name') with no data;
ERROR 42ZA3: The table will have collation type UCS_BASIC which is different
than the collation of the schema TERRITORY_
BASED hence this operation is not supported .
java.sql.SQLException: The table will have collation type UCS_BASIC which is
different than the collation of the schema
TERRITORY_BASED hence this operation is not supported .
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1572)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:585)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:528)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:330)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:522)
at
org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:364)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:262)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:215)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:181)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:56)
at org.apache.derby.tools.ij.main(ij.java:71)
Caused by: ERROR 42ZA3: The table will have collation type UCS_BASIC which is
different than the collation of the schema
TERRITORY_BASED hence this operation is not supported .
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)
at
org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement(CreateTableNode.java:340)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:314)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConne
ctionContext.java:753)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:579)
... 9 more
This can also be seen in the test
CreateTableFromQueryTest.testCreateTableFromValues
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
