db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6026) NullPointerException when calling string function in predicate with territory based collation
Date Fri, 21 Dec 2012 11:23:12 GMT

    [ 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

Mime
View raw message