Andrei Koiro created DERBY-6890:
-----------------------------------
Summary: 'ASSERT FAILED type of inserted column[0] =
org.apache.derby.iapi.types.CollatorSQLVarchartype of template column[0] =
org.apache.derby.iapi.types.SQLVarchar:
org.apache.derby.shared.common.sanity.AssertFailure'
Key: DERBY-6890
URL: https://issues.apache.org/jira/browse/DERBY-6890
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.12.1.1
Environment: Mac OS X 10.11.5
JDK: Oracle 1.8.0_92
Reporter: Andrei Koiro
we are trying to merge to derby 10.12.1.1 and want to use 'GENERATED BY DEFAULT
AS IDENTITY'. Now we use
we altered our pk columns, and added 'GENERATED BY DEFAULT AS IDENTITY'. After
that when I try to insert in my table any record, I get this exception:
Caused by: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED
type of inserted column[0] = org.apache.derby.iapi.types.CollatorSQLVarchartype
of template column[0] = org.apache.derby.iapi.types.SQLVarchar
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162)
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147)
at
org.apache.derby.impl.store.access.btree.OpenBTree.isIndexableRowConsistent(OpenBTree.java:519)
at
org.apache.derby.impl.store.access.btree.BTreeController.doIns(BTreeController.java:679)
at
org.apache.derby.impl.store.access.btree.BTreeController.insert(BTreeController.java:1372)
at
org.apache.derby.impl.store.access.btree.index.B2IController.insert(B2IController.java:210)
at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(IndexChanger.java:565)
at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java:393)
at
org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java:713)
at
org.apache.derby.impl.sql.execute.IndexSetChanger.insert(IndexSetChanger.java:268)
at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java:458)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:881)
at
org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:452)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:473)
at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:352)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1340)
... 30 more
I attached Test.groovy class which shows this issue.
I found this workaround:
we need drop indexes and create them again.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
