[jira] Updated: (DERBY-4245) Sorting a table containing a CLOB fails after upgrade to 10.5

by JIRA jira@apache.org :: Rate this Message:

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

Knut Anders Hatlen updated DERBY-4245:
--------------------------------------

Attachment: MixedVersionClob.java

To reproduce:

1) Run the attached class with Derby 10.4.2.0 to create the database

2) Open the database in ij with Derby 10.5.1.1 and issue a select with an ORDER BY:

ij version 10.5
ij> connect 'jdbc:derby:db';
ij> select c from t order by length(c);
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
ij>

> Sorting a table containing a CLOB fails after upgrade to 10.5
> -------------------------------------------------------------
>
> Key: DERBY-4245
> URL: https://issues.apache.org/jira/browse/DERBY-4245
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.5.1.1
> Reporter: Knut Anders Hatlen
> Attachments: MixedVersionClob.java
>
>
> When sorting a table containing a CLOB column in a database that has been soft-upgraded from 10.4.2.0 to 10.5.1.1, the query fails with a NullPointerException.
> Reported on derby-user: http://mail-archives.apache.org/mod_mbox/db-derby-user/200905.mbox/%3ckk5ivy.tcwvy@...%3e

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

« Return to Thread: [jira] Created: (DERBY-4245) Sorting a table containing a CLOB fails after upgrade to 10.5