[jira] [Updated] (DERBY-6026) NullPointerException when calling string function in predicate with territory based collation

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

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

Dag H. Wanvik updated DERBY-6026:
---------------------------------

               Urgency: Urgent
     Affects Version/s: 10.6.1.0
                        10.6.2.1
                        10.7.1.1
                        10.8.1.2
                        10.8.2.2
                        10.8.3.0
                        10.10.1.1
    Bug behavior facts: Regression
                Labels: derby_triage10_11  (was: )

Triaged for 10.11. Marking urgent since this is a regression in 10.6: With Derby 10.5.3.0 the query works.


                
> 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.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.8.3.0, 10.9.1.0, 10.10.1.1
>            Reporter: Knut Anders Hatlen
>              Labels: derby_triage10_11
>
> 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