db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1774) NullPointerException when using COALESCE
Date Tue, 12 Sep 2006 20:29:23 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12434260 ] 
            
A B commented on DERBY-1774:
----------------------------

The query shown in derby.new.log is not the same query as that shown in selectStatement.sql.
 Are you seeing the problem for the query in selectStatement.sql as well?

Can you post the DDL for the tables that are referenced in the query that's shown in derby.new.log?
 You can get the DDL by using the dblook utility:

http://db.apache.org/derby/docs/dev/tools/ctoolsdblook.html

Alternatively, if you can post an ij script or program to create a database from scratch that
reproduces the error, that would be wonderful (similar to what you did for crtStmt.sql). 
It's great to have the query and the stack trace (thanks!) but if someone looking at this
issue could actually run the query to reproduce the error, that'd be even better...

> NullPointerException when using COALESCE
> ----------------------------------------
>
>                 Key: DERBY-1774
>                 URL: http://issues.apache.org/jira/browse/DERBY-1774
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.1.3.1, 10.2.1.0
>         Environment: Windows XP SP2, JRE 1.5.0_05
>            Reporter: Robert Enyedi
>         Attachments: crtStmt.sql, derby.log, derby.log-proper, derby.new.log, selectStatement.sql
>
>
> I receive the following error when executing the attached file:
> ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating
an expression. SQLSTATE: XJ001: Java exception: ': java.lang.NullPointerException'.
> I also attached the Derby log with the derby.language.logQueryPlan property set to true.
> The problem does not appear when running on JRE 1.4.2_06.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message