db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2879) CREATE TABLE AS <subquery> does not maintain the collation for character types.
Date Wed, 27 Jun 2007 14:18:25 GMT
CREATE TABLE AS <subquery> does not maintain the collation for character types.
-------------------------------------------------------------------------------

                 Key: DERBY-2879
                 URL: https://issues.apache.org/jira/browse/DERBY-2879
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.3.1.0, 10.3.1.1, 10.4.0.0
            Reporter: Daniel John Debrunner
            Priority: Critical


create table t as select tablename from sys.systables with no data;

This creates a column TABLENAME with collation based upon the user schema, but the type of
 sys.systables.tablename has collation UCS_BASIC.

The required behaviour should be verified with the SQL standard (11.3 SR6), but since collation
is an attribute of a type it seems logical that the collation is maintained by the create.

Fixing this to keep the collation of the system column will cause problems though as there
would be no way to recreate this table through a regular create table, say if the schema is
dumped and recreated using ddlutils.

I think this is critical as fixing it after a release would lead to a change in behaviour
for applications.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message