[
https://issues.apache.org/jira/browse/DERBY-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-6346:
---------------------------------
Attachment: derby-6346-01-aa-logJavaException.diff
Attaching derby-6346-01-aa-logJavaException.diff. This patch adds some
exception printing code to a utility method which wraps a SQLException around
another Java exception. I will run tests.
Touches the following file:
M java/engine/org/apache/derby/impl/jdbc/Util.java
> NPE in left join whose inner table has a generated column
> ---------------------------------------------------------
>
> Key: DERBY-6346
> URL: https://issues.apache.org/jira/browse/DERBY-6346
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.1
> Reporter: Rick Hillegas
> Attachments: derby-6346-01-aa-logJavaException.diff
>
>
> Derby trips over an NPE while processing a left join whose inner table has a
> generated column. The NPE is not printed to derby.log, indicating another
> problem. The bug goes as far back as 10.5.1.1, the release which introduced
> generated columns. The NPE does NOT crash the connection. The application can
> continue issuing statements on the connection.
> The following script shows this problem:
> connect 'jdbc:derby:memory:db;create=true';
> create table t1( c1 int, c2 int generated always as ( -c1 ) );
> create table t2( c1 int );
> insert into t1( c1 ) values ( 2 ), ( 20 );
> insert into t2( c1 ) values ( 2 ), ( 200 );
> -- raises a SQLException wrapping an NPE
> select * from t2 left join t1 on t1.c1 = t2.c1;
--
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
