You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Robert Enyedi (JIRA)" <de...@db.apache.org> on 2006/08/29 15:52:22 UTC
[jira] Created: (DERBY-1774) NullPointerException when using
COALESCE
NullPointerException when using COALESCE
----------------------------------------
Key: DERBY-1774
URL: http://issues.apache.org/jira/browse/DERBY-1774
Project: Derby
Issue Type: Bug
Components: Network Server
Affects Versions: 10.1.3.1
Environment: Windows XP SP2, JRE 1.5.0_05
Reporter: Robert Enyedi
Attachments: crtStmt.sql, derby.log
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
[jira] Resolved: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden resolved DERBY-1774.
-----------------------------------
Resolution: Cannot Reproduce
The original problem was resolved and we did not get a reproduction for the followup case. No response to my proposal to close CNR in July, so closing this bug.
> NullPointerException when using COALESCE
> ----------------------------------------
>
> Key: DERBY-1774
> URL: https://issues.apache.org/jira/browse/DERBY-1774
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.1.3.1, 10.2.1.6
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Kristian Waagan (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ]
Kristian Waagan updated DERBY-1774:
-----------------------------------
Component/s: SQL
(was: Network Server)
> 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
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log, derby.log-proper
>
>
> 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
[jira] Updated: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Robert Enyedi (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ]
Robert Enyedi updated DERBY-1774:
---------------------------------
Attachment: selectStatement.sql
This causes a NullPointerException in the bytecode generated for the prepared statement.
> 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.2.1.0, 10.1.3.1
> 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
[jira] Updated: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Kristian Waagan (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ]
Kristian Waagan updated DERBY-1774:
-----------------------------------
Affects Version/s: 10.2.1.0
Note that the error also happens with Derby 10.1.3.1 embedded, and with Derby 10.2.1.1 (alpha snapshot).
However, the bug seems to be fixed in trunk/10.3.
> 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.2.1.0, 10.1.3.1
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log, derby.log-proper
>
>
> 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
[jira] Commented: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Robert Enyedi (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12431243 ]
Robert Enyedi commented on DERBY-1774:
--------------------------------------
Correction: The problem DOES also appear on JRE 1.4.2_06
> NullPointerException when using COALESCE
> ----------------------------------------
>
> Key: DERBY-1774
> URL: http://issues.apache.org/jira/browse/DERBY-1774
> Project: Derby
> Issue Type: Bug
> Components: Network Server
> Affects Versions: 10.1.3.1
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log
>
>
> 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
[jira] Commented: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12516495 ]
Kathey Marsden commented on DERBY-1774:
---------------------------------------
There has not been an update on this issue since Sept 06 and we don't have a reproducible case. I will close it CannotReproduce unless someone objects.
> NullPointerException when using COALESCE
> ----------------------------------------
>
> Key: DERBY-1774
> URL: https://issues.apache.org/jira/browse/DERBY-1774
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.1.3.1, 10.2.1.6
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Dag H. Wanvik (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12431273 ]
Dag H. Wanvik commented on DERBY-1774:
--------------------------------------
As part of fixing DERBY-1574, I added a missing preprocess
implementation for COALESCE to the compiler
(CoalesceFunctionNode.java). It may possibly have solved this issue,
too.
> 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.2.1.0, 10.1.3.1
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log, derby.log-proper
>
>
> 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
[jira] Commented: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Robert Enyedi (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12434139 ]
Robert Enyedi commented on DERBY-1774:
--------------------------------------
Despite the fact that the latest 1.2.1.3 beta solves the initial NullPointerException, I still receive the exception for a more complicated query (see the attached selectStatement.sql). I did not have the time yet to simplify it, but the error log (error.new.log) shows that this time the exception is right from inside the bytecode generated for the prepared statement.
I'm unable to reproduce it when the statement is directly executed.
I know that it's difficult to find the source of this bug (I tried it myself), but maybe the stack trace is of any help.
> 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.2.1.0, 10.1.3.1
> 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
[jira] Commented: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Robert Enyedi (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12434113 ]
Robert Enyedi commented on DERBY-1774:
--------------------------------------
I can confirm that this issue is solved in the 1.2.1.3 beta from September 9.
> 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.2.1.0, 10.1.3.1
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log, derby.log-proper
>
>
> 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
[jira] Updated: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Robert Enyedi (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ]
Robert Enyedi updated DERBY-1774:
---------------------------------
Attachment: derby.new.log
The derby log associated with selectStatement.sql
> 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.2.1.0, 10.1.3.1
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log, derby.log-proper, derby.new.log
>
>
> 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
[jira] Commented: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "A B (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Updated: (DERBY-1774) NullPointerException when using
COALESCE
Posted by "Kristian Waagan (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ]
Kristian Waagan updated DERBY-1774:
-----------------------------------
Attachment: derby.log-proper
Attaching a proper derby.log, generated by using Derby 10.1.3.1 (debug).
I could not see the mentioned error in the original log file.
> NullPointerException when using COALESCE
> ----------------------------------------
>
> Key: DERBY-1774
> URL: http://issues.apache.org/jira/browse/DERBY-1774
> Project: Derby
> Issue Type: Bug
> Components: Network Server
> Affects Versions: 10.1.3.1
> Environment: Windows XP SP2, JRE 1.5.0_05
> Reporter: Robert Enyedi
> Attachments: crtStmt.sql, derby.log, derby.log-proper
>
>
> 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