[jira] Commented: (DERBY-2973) With collation TERRITORY_BASED, insert into table after changing type of column causes assert failure and loss of connection

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

    [ https://issues.apache.org/jira/browse/DERBY-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12516053 ] 

Mamta A. Satoor commented on DERBY-2973:
----------------------------------------

Committed changes for this jira entry into main using revision 560289. Will merge into 10.3 codeline shortly. The commit comments were as follows


ALTER TABLE MODIFY COLUMN should maintain the collation info when the column being altered is character string type. The changes for this went into as a new method in ModifyColumnNode which gets called during the bind phase.


> With collation TERRITORY_BASED, insert into table after changing type of column causes  assert failure and loss of connection
> -----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2973
>                 URL: https://issues.apache.org/jira/browse/DERBY-2973
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Mamta A. Satoor
>            Priority: Critical
>
> ij(CONNECTION1)> create table d (id int not null, t_bigvarchar varchar(400), unique (id));
> 0 rows inserted/updated/deleted
> ij(CONNECTION1)> create index t_bigvarchar_ind on d ( t_bigvarchar);
> 0 rows inserted/updated/deleted
> ij(CONNECTION1)> alter table d alter t_bigvarchar set data type varchar(4096);
> 0 rows inserted/updated/deleted
> ij(CONNECTION1)> insert into d (id, t_bigvarchar) values (1,'hello');
> ERROR XJ001: Java exception: 'ASSERT FAILED type of inserted column[0] = org.apache.derby.iapi.types.SQLVarchartype of t
> emplate column[0] = org.apache.derby.iapi.types.CollatorSQLVarchar: org.apache.derby.shared.common.sanity.AssertFailure'
> .
> ij(CONNECTION1)>

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