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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/05/31 18:34:40 UTC
[jira] Created: (DERBY-4683) NPE in parameterized INSERT/SELECT
NPE in parameterized INSERT/SELECT
----------------------------------
Key: DERBY-4683
URL: https://issues.apache.org/jira/browse/DERBY-4683
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.6.1.0
Reporter: Rick Hillegas
Fix For: 10.6.1.1
The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4672.
ij version 10.6
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table t
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> create table s
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
prepare foo as 'insert into t select ?, c from s';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4683) NPE in parameterized INSERT/SELECT
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-4683:
--------------------------------------
Description:
The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4671.
ij version 10.6
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table t
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> create table s
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
prepare foo as 'insert into t select ?, c from s';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
was:
The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4672.
ij version 10.6
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table t
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> create table s
(
a int not null,
c int
);
0 rows inserted/updated/deleted
ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
prepare foo as 'insert into t select ?, c from s';
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> NPE in parameterized INSERT/SELECT
> ----------------------------------
>
> Key: DERBY-4683
> URL: https://issues.apache.org/jira/browse/DERBY-4683
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Fix For: 10.6.1.1
>
>
> The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4671.
> ij version 10.6
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> create table s
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
> prepare foo as 'insert into t select ?, c from s';
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4683) NPE in parameterized INSERT/SELECT
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-4683.
-------------------------------------
Resolution: Duplicate
> NPE in parameterized INSERT/SELECT
> ----------------------------------
>
> Key: DERBY-4683
> URL: https://issues.apache.org/jira/browse/DERBY-4683
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Fix For: 10.6.1.1
>
>
> The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4672.
> ij version 10.6
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> create table s
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
> prepare foo as 'insert into t select ?, c from s';
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-4683) NPE in parameterized INSERT/SELECT
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen reopened DERBY-4683:
---------------------------------------
> NPE in parameterized INSERT/SELECT
> ----------------------------------
>
> Key: DERBY-4683
> URL: https://issues.apache.org/jira/browse/DERBY-4683
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Fix For: 10.6.1.1
>
>
> The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4672.
> ij version 10.6
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> create table s
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
> prepare foo as 'insert into t select ?, c from s';
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4683) NPE in parameterized INSERT/SELECT
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4683:
---------------------------------
Bug behavior facts: [Regression, Seen in production] (was: [Seen in production])
> NPE in parameterized INSERT/SELECT
> ----------------------------------
>
> Key: DERBY-4683
> URL: https://issues.apache.org/jira/browse/DERBY-4683
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Fix For: 10.6.1.1
>
>
> The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4671.
> ij version 10.6
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> create table s
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
> prepare foo as 'insert into t select ?, c from s';
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4683) NPE in parameterized INSERT/SELECT
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-4683.
--------------------------------
Resolution: Fixed
> NPE in parameterized INSERT/SELECT
> ----------------------------------
>
> Key: DERBY-4683
> URL: https://issues.apache.org/jira/browse/DERBY-4683
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.1.0
> Reporter: Rick Hillegas
> Fix For: 10.6.1.1
>
>
> The following script works on 10.5.3.0 but fails on 10.6.1.0. The script succeeds on 10.6.1.1, probably because of the fix for DERBY-4672.
> ij version 10.6
> ij> connect 'jdbc:derby:memory:db;create=true';
> ij> create table t
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> create table s
> (
> a int not null,
> c int
> );
> 0 rows inserted/updated/deleted
> ij> -- fails on 10.6.1.0 but succeeds on 10.5.3.0
> prepare foo as 'insert into t select ?, c from s';
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.