Julian Hyde created OPTIQ-403:
---------------------------------
Summary: Enumerable gives NullPointerException with HAVING on
nullable GROUP BY column
Key: OPTIQ-403
URL: https://issues.apache.org/jira/browse/OPTIQ-403
Project: Optiq
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Foodmart query #6597
{code:sql}
select "store"."store_country" as "c0",
"store"."store_state" as "c1",
"store"."store_city" as "c2",
"store"."store_name" as "c3",
"Store"."store_type" as "c4",
"store"."store_manager" as "c5",
"store"."store_sqft" as "c6",
"store"."grocery_sqft" as "c7",
"store"."frozen_sqft" as "c8",
"store"."meat_sqft" as "c9",
"store"."coffee_bar" as "c10",
"store"."store_street_address" as "c11"
from "store" as "store"
group by "store"."store_country",
"store"."store_state",
"store"."store_city",
"store"."store_name",
"store"."store_type",
"store"."store_manager",
"store"."store_sqft",
"store"."grocery_sqft",
"store"."frozen_sqft",
"store"."meat_sqft",
"store"."coffee_bar",
"store"."store_street_address"
having NOT((((sum("store"."store_sqft") - sum("store"."grocery_sqft")) <
10000)) )
order by "store"."store_country" ASC NULLS LAST,
"store"."store_state" ASC NULLS LAST,
"store"."store_city" ASC NULLS LAST,
"store"."store_name" ASC NULLS LAST
{code}
gives the following stack:
{code}
java.lang.NullPointerException
at Baz$6$1.moveNext(Unknown Source)
at
net.hydromatic.optiq.runtime.ObjectEnumeratorCursor.next(ObjectEnumeratorCursor.java:43)
at
net.hydromatic.avatica.AvaticaResultSet.next(AvaticaResultSet.java:186)
at
net.hydromatic.optiq.test.OptiqAssert.countRows(OptiqAssert.java:493){code}
More minimal test case:
{code}
select 1
from "store"
group by "store_street_address"
having NOT (sum("grocery_sqft") < 10000)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
