[
https://issues.apache.org/jira/browse/DERBY-6026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13537803#comment-13537803
]
Knut Anders Hatlen commented on DERBY-6026:
-------------------------------------------
An assert failure is raised with debug builds:
org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED No support
for collators in base class
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.iapi.types.SQLChar.getCollatorForCollation(SQLChar.java:3088)
at
org.apache.derby.iapi.types.SQLChar.getCollationKey(SQLChar.java:2954)
at
org.apache.derby.iapi.types.WorkHorseForCollatorDatatypes.stringCompare(WorkHorseForCollatorDatatypes.java:89)
at
org.apache.derby.iapi.types.CollatorSQLVarchar.stringCompare(CollatorSQLVarchar.java:171)
at org.apache.derby.iapi.types.SQLChar.compare(SQLChar.java:1392)
at org.apache.derby.iapi.types.DataType.compare(DataType.java:871)
at org.apache.derby.iapi.types.SQLChar.compare(SQLChar.java:1375)
at
org.apache.derby.impl.store.raw.data.StoredPage.qualifyRecordFromSlot(StoredPage.java:5062)
at
org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(StoredPage.java:1489)
at
org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(BasePage.java:440)
at
org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(GenericScanController.java:759)
at
org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(HeapScan.java:322)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(BulkTableScanResultSet.java:353)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(BulkTableScanResultSet.java:308)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:478)
at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:432)
at
org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:376)
at
org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:382)
at
org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:338)
at
org.apache.derby.tools.JDBCDisplayUtil.indent_DisplayResults(JDBCDisplayUtil.java:241)
at
org.apache.derby.tools.JDBCDisplayUtil.DisplayResults(JDBCDisplayUtil.java:229)
at
org.apache.derby.impl.tools.ij.utilMain.displayResult(utilMain.java:454)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:528)
at
org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:372)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:229)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:184)
at org.apache.derby.impl.tools.ij.Main.main(Main.java:75)
at org.apache.derby.tools.ij.main(ij.java:59)
at org.apache.derby.iapi.tools.run.main(run.java:53)
> NullPointerException when calling string function in predicate with territory
> based collation
> ---------------------------------------------------------------------------------------------
>
> Key: DERBY-6026
> URL: https://issues.apache.org/jira/browse/DERBY-6026
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.9.1.0
> Reporter: Knut Anders Hatlen
>
> ij version 10.9
> ij> connect
> 'jdbc:derby:memory:colldb;create=true;territory=en_US;collation=TERRITORY_BASED';
> ij> create table t(x varchar(10));
> 0 rows inserted/updated/deleted
> ij> insert into t values 'abc';
> 1 row inserted/updated/deleted
> ij> select * from t where x = trim('xyz');
> X
> ----------
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
