[jira] [Closed] (DERBY-6031) NullPointerException when comparing string with result from string function in territory based collation

["Knut Anders Hatlen (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-6031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen closed DERBY-6031.
-------------------------------------

    Resolution: Duplicate

Poor memory... I logged a variant of this bug as DERBY-6026 two weeks ago. Closing as duplicate.
                
> NullPointerException when comparing string with result from string function in territory based collation
> --------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6031
>                 URL: https://issues.apache.org/jira/browse/DERBY-6031
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.9.1.0
>            Reporter: Knut Anders Hatlen
>
> ij> connect 'jdbc:derby:memory:db;territory=en;collation=TERRITORY_BASED;create=true';
> ij> create table t(x varchar(10));
> 0 rows inserted/updated/deleted
> ij> insert into t values 'a';
> 1 row inserted/updated/deleted
> ij> select * from t where x = substr('a',1,1);
> 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