[jira] Assigned: (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:all-tabpanel ]

Mamta A. Satoor reassigned DERBY-2973:
--------------------------------------

    Assignee: Mamta A. Satoor

> 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.