[jira] Resolved: (DERBY-2530) When character type columns are added by CREATE TABLE and ALTER TABLE, their collation type should be set to the containing schema's collation type.

["Mamta A. Satoor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor resolved DERBY-2530.
------------------------------------

    Resolution: Fixed

> When character type columns are added by CREATE TABLE and ALTER TABLE, their collation type should be set to the containing schema's collation type.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2530
>                 URL: https://issues.apache.org/jira/browse/DERBY-2530
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Mamta A. Satoor
>         Assigned To: Mamta A. Satoor
>         Attachments: DERBY2530_create_alter_table_collation_type_v1_diff.txt, DERBY2530_create_alter_table_collation_type_v1_stat.txt
>
>
> Persistent user defined character columns get added through CREATE TABLE and ALTER TABLE statements, These 2 statements should set the collation type of character columns' to the same value as the collation type of the schema they belong to. This collation type will get saved in SYSCOLUMNS and will also be saved in the metadata maintained by Store.

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