|
I see the NPE with 10.3.2.1 with this script:
connect 'jdbc:derby:wombat;create=true'; drop table customer_table; CREATE TABLE CUSTOMER_TABLE ( ID VARCHAR(255) PRIMARY KEY NOT NULL, NAME VARCHAR(255) , CODE VARCHAR(255)); insert into CUSTOMER_TABLE VALUES('1234','Customer 1', 'GBR'); insert into CUSTOMER_TABLE VALUES('1235','Customer 2', 'CHA'); select count(customer0_.ID) as col_0_0_ from CUSTOMER_TABLE customer0_ group by customer0_.code having customer0_.code in ('GBR' , 'CHA') ; but I do not see it with the latest on the 10.3 branch. I'm not sure what fixed it. I'll backtrack and see. Building the latest trunk, Apache Derby Network Server - 10.4.0.0 alpha - (631277), the query no longer fails which is consistent with your results above.
Hibernate: select count(customer0_.ID) as col_0_0_ from CUSTOMER_TABLE customer0_ group by customer0_.code having customer0_.code in ('GBR' , 'CHA') Check result received . . . Check result received . . . Expected results received. STATUS:Passed. So, this should get closed as fixed in 10.4, or maybe a duplicate?
This is fixed in 10.4 but would be interesting to know the "duplicate" or related issue to the resolution as Kathey notes above.
The Subversion repository is down, so I can't verify it, but I would guess that it was fixed in
Knut Anders> The Subversion repository is down, so I can't verify it,
Knut Anders> but I would guess that it was fixed in Verified that Kathey's script error is fixed on 10.3 by svn 606277 ( You OK with closing issue this, Shelly? I'll verify against 10.3 and update.
I wonder if we can go ahead and close this out as a dup? Unless I hear back. I will close it Monday.
Kathey, I have verified this is resolved with 10.3 and 10.4.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
|
Bug
Closed
Major
NPE is seemingly simple query
Do you have a simple reproduction case for this issue? I looked at the query above and was able to generate an NPE against 10.3.1.4 with the following:
connect 'testdb;create=true';
create table t1 (i int, c char(3));
insert into t1 values (1, 'ONE'), (2, 'TWO'), (3, 'CHA');
select count(a.i) as col0_0_ from t1 a group by a.c having a.c in ('GBR', 'CHA');
If you run those simple statements do you see an NPE, and if so, does it look like the same problem you are seeing? Without having any further information, I'm wondering if you are seeing
DERBY-3253, which was also filed against 10.3.1.4 but has since been fixed in the 10.3 codeline. At least, the above example query, which fails with 10.3.1.4, now runs without error on the latest 10.3 branch.Is it possible for you to build a set of jars from the 10.3 codeline and see if your query still fails?