|
If you were logged in you would be able to see more operations.
|
|
|
| Urgency: |
Normal
|
| Issue & fix info: |
Workaround attached, Repro attached, High Value Fix
|
|
When preparing a "INSERT INTO table SELECT FROM (...)" statement,
Derby in some cases throw a NullPointerException or an
AssertFailure. This happens when a '?' occurs in a VALUES statement in
the from list. If one tries to access the table after the
NullPointerException, this exception is thrown:
ERROR 40XT0: An internal error was identified by RawStore module.
Example:
ij> create table t (text varchar(20), len int);
0 rows inserted/updated/deleted
ij> prepare p as 'insert into t select x, length(x) from (values(?)) as v(x)';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
ij> select * from t;
ERROR 40XT0: An internal error was identified by RawStore module.
Replacing '?' with 'CAST (? AS VARCHAR(20))' fixes the problem, but
there is enough information in the query to determine the type of the
parameter even without the cast.
|
|
Description
|
When preparing a "INSERT INTO table SELECT FROM (...)" statement,
Derby in some cases throw a NullPointerException or an
AssertFailure. This happens when a '?' occurs in a VALUES statement in
the from list. If one tries to access the table after the
NullPointerException, this exception is thrown:
ERROR 40XT0: An internal error was identified by RawStore module.
Example:
ij> create table t (text varchar(20), len int);
0 rows inserted/updated/deleted
ij> prepare p as 'insert into t select x, length(x) from (values(?)) as v(x)';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
ij> select * from t;
ERROR 40XT0: An internal error was identified by RawStore module.
Replacing '?' with 'CAST (? AS VARCHAR(20))' fixes the problem, but
there is enough information in the query to determine the type of the
parameter even without the cast. |
Show » |
| No work has yet been logged on this issue.
|
|
Bug
Open
Major
Preparing "INSERT INTO table SELECT FROM (...)" may cause NullPointerException and subsequent internal errors reported by RawStore module
