db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2973) With collation TERRITORY_BASED, insert into table after changing type of column causes assert failure and loss of connection
Date Fri, 27 Jul 2007 15:55:18 GMT

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


Mime
View raw message