[
https://issues.apache.org/jira/browse/CALCITE-553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15145047#comment-15145047
]
Josh Elser commented on CALCITE-553:
------------------------------------
[~julianhyde], I'm just getting some test failures.
{noformat}
Tests in error:
testJoinPlan(org.apache.calcite.test.JdbcAdapterTest): exception while
executing [SELECT T1."brand_name"
FROM "foodmart"."product" AS T1
INNER JOIN "foodmart"."product_class" AS T2
ON T1."product_class_id" = T2."product_class_id"
WHERE T2."product_department" = 'Frozen Foods'
OR T2."product_department" = 'Baking Goods'
AND T1."brand_name" <> 'King']
testUnionPlan(org.apache.calcite.test.JdbcAdapterTest): exception while
executing [explain plan for select * from "sales_fact_1997"
union all
select * from "sales_fact_1998"]
testMetadataTables(org.apache.calcite.test.JdbcAdapterTest):
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (IO Error: The Network Adapter could not establish
the connection)
testInPlan(org.apache.calcite.test.JdbcAdapterTest): exception while
executing [select "store_id", "store_name" from "store"
where "store_name" in ('Store 1', 'Store 10', 'Store 11', 'Store 15', 'Store
16', 'Store 24', 'Store 3', 'Store 7')]
testFilterUnionPlan(org.apache.calcite.test.JdbcAdapterTest): exception while
executing [select * from (
select * from "sales_fact_1997"
union all
select * from "sales_fact_1998")
where "product_id" = 1]
testSubQueryWithSingleValue(org.apache.calcite.test.JdbcAdapterTest):
exception while executing [explain plan for SELECT "full_name" FROM "employee"
WHERE "employee_id" = (SELECT "employee_id" FROM "salary")]
testOrderByOnSortedTable2(org.apache.calcite.test.JdbcTest): exception while
executing [select "time_id", "the_date" from "time_by_day"
where "time_id" < 370
order by "time_id"]
testOrderByFetch(org.apache.calcite.test.JdbcTest): exception while executing
[explain plan for select "store_id", "grocery_sqft" from "store"
where "store_id" < 10
order by 1 fetch first 5 rows only]
testSelfJoinDifferentColumns(org.apache.calcite.test.JdbcTest): exception
while executing [select e1."full_name"
from "foodmart"."employee" as e1
join "foodmart"."employee" as e2 on e1."first_name" = e2."last_name"
order by e1."last_name" limit 3]
testLimitOnQueryableTable(org.apache.calcite.test.JdbcTest): exception while
executing [select * from "days"
limit 2]
testHavingNot2(org.apache.calcite.test.JdbcTest): exception while executing
[select 1
from "store"
group by "store"."store_street_address"
having NOT (sum("store"."grocery_sqft") < 20000)]
testExplain(org.apache.calcite.test.JdbcTest): exception while executing
[explain plan for values (1, 'ab')]
testExtract(org.apache.calcite.test.JdbcTest): exception while executing
[values extract(year from date '2008-2-23')]
testOrderBy(org.apache.calcite.test.JdbcTest): exception while executing
[select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2]
testWhereNot(org.apache.calcite.test.JdbcTest): exception while executing
[select 1
from "store"
where NOT ("store"."grocery_sqft" < 22000)
group by "store"."store_street_address"
]
testOrderOnSortedTable(org.apache.calcite.test.JdbcTest): exception while
executing [select "day"
from "days"
order by "day"]
testGetDateAsString(org.apache.calcite.test.JdbcTest): exception while
executing [select min("date") mindate from "foodmart"."currency"]
testOrderByOffsetFetch(org.apache.calcite.test.JdbcTest): exception while
executing [select "store_id", "grocery_sqft" from "store"
where "store_id" < 10
order by 1 offset 2 rows fetch next 5 rows only]
testVarcharEquals(org.apache.calcite.test.JdbcTest): exception while
executing [select "lname" from "customer" where "lname" = 'Nowmer']
testModel(org.apache.calcite.test.JdbcTest): exception while executing
[select count(*) as c from "foodmart"."time_by_day"]
testHook(org.apache.calcite.test.JdbcTest): exception while executing [SELECT
1]
testTrim(org.apache.calcite.test.JdbcTest): exception while executing [select
trim("lname") as "lname" from "customer" where "lname" = 'Nowmer']
testNullableTimestamp2(org.apache.calcite.test.JdbcTest): exception while
executing [select "hire_date", "end_date", "birth_date" from
"foodmart"."employee" where "employee_id" = 1]
testOrderByNullsFirst(org.apache.calcite.test.JdbcTest): exception while
executing [select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2 nulls first]
testUnicode(org.apache.calcite.test.JdbcTest): exception while executing
[values _UTF16'英国']
testCloneSchema(org.apache.calcite.test.JdbcTest):
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (IO Error: The Network Adapter could not establish
the connection)
testHavingNot(org.apache.calcite.test.JdbcTest): exception while executing
[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]
testGetDate(org.apache.calcite.test.JdbcTest):
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (IO Error: The Network Adapter could not establish
the connection)
testOrderByNullsLast(org.apache.calcite.test.JdbcTest): exception while
executing [select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2 nulls last]
testAggregateFilter(org.apache.calcite.test.JdbcTest): exception while
executing [select "the_month",
count(*) as "c",
count(*) filter (where "day_of_month" > 20) as "c2"
from "time_by_day" as "time_by_day"
where "time_by_day"."the_year" = 1997
group by "time_by_day"."the_month"
order by "time_by_day"."the_month"]
testAlmostBushy(org.apache.calcite.test.JdbcTest): exception while executing
[explain plan including all attributes for select *
from "sales_fact_1997" as s
join "customer" as c using ("customer_id")
join "product" as p using ("product_id")
where c."city" = 'San Francisco'
and p."brand_name" = 'Washington']
testDistinctCountComposite(org.apache.calcite.test.JdbcTest): exception while
executing [select "time_by_day"."the_year" as "c0",
count(distinct "sales_fact_1997"."product_id",
"sales_fact_1997"."customer_id") as "m0"
from "time_by_day" as "time_by_day",
"sales_fact_1997" as "sales_fact_1997"
where "sales_fact_1997"."time_id" = "time_by_day"."time_id"
and "time_by_day"."the_year" = 1997
group by "time_by_day"."the_year"]
testCloneGroupBy(org.apache.calcite.test.JdbcTest): exception while executing
[select "the_year", count(*) as c, min("the_month") as m
from "foodmart2"."time_by_day"
group by "the_year"
order by 1, 2]
testOrderByDescNullsLast(org.apache.calcite.test.JdbcTest): exception while
executing [select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2 desc nulls last]
testOrderByCase(org.apache.calcite.test.JdbcTest): exception while executing
[select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day"
group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year"
IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
testOrderByCast(org.apache.calcite.test.JdbcTest): exception while executing
[select "customer_id", "postal_code" from "customer"
where "customer_id" < 5
order by cast(substring("postal_code" from 3) as integer) desc]
testOrderByDesc(org.apache.calcite.test.JdbcTest): exception while executing
[select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2 desc]
testSelfJoinCount(org.apache.calcite.test.JdbcTest): exception while
executing [select count(*) as c from "foodmart"."store" as p1 join
"foodmart"."store" as p2 using ("store_id")]
testGetTimestampObject(org.apache.calcite.test.JdbcTest):
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (IO Error: The Network Adapter could not establish
the connection)
testModelWithComment(org.apache.calcite.test.JdbcTest): exception while
executing [select count(*) as c from "foodmart"."time_by_day"]
testJdbcTimestamp(org.apache.calcite.test.JdbcTest): exception while
executing [select count(*) as c from (
select 1 from "foodmart"."employee" as e1
where "hire_date" < TIMESTAMP '1996-06-05 00:00:00'
and "gender" = 'F')]
testOrderByVarious(org.apache.calcite.test.JdbcTest): exception while
executing [select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2 ]
testDistinctCount2(org.apache.calcite.test.JdbcTest): exception while
executing [explain plan for select cast("unit_sales" as integer) as "u",
count(distinct "sales_fact_1997"."customer_id") as "m0"
from "sales_fact_1997" as "sales_fact_1997"
group by "unit_sales"]
testOrderSorted(org.apache.calcite.test.JdbcTest): exception while executing
[select "store_id"
from "store"
order by "store_id" limit 3]
testJoinCorrelatedScalarSubquery(org.apache.calcite.test.JdbcTest): exception
while executing [select e.employee_id, d.department_id from employee e,
department d where e.department_id = d.department_id and e.salary > (select
avg(e2.salary) from employee e2 where
e2.store_id = e.store_id)]
testRunSort(org.apache.calcite.test.JdbcTest): Error while executing command
net.hydromatic.quidem.Quidem$CompositeCommand@65465610
testDialect(org.apache.calcite.test.JdbcTest): exception while executing
[select count(*) as c from "foodmart"."employee" as e1
where "first_name" = 'abcde'
and "gender" = 'F']
testOrderByDescNullsFirst(org.apache.calcite.test.JdbcTest): exception while
executing [select "store_id", "grocery_sqft" from "store"
where "store_id" < 3 order by 2 desc nulls first]
testJanino169(org.apache.calcite.test.JdbcTest): exception while executing
[select "time_id" from "foodmart"."time_by_day" as "t"
]
testSimple(org.apache.calcite.test.JdbcTest): exception while executing
[SELECT 1]
testOrderByOnSortedTable(org.apache.calcite.test.JdbcTest): exception while
executing [explain plan for select * from "time_by_day"
order by "time_id"]
testNullableTimestamp(org.apache.calcite.test.JdbcTest): exception while
executing [select "hire_date", "end_date", "birth_date" from
"foodmart"."employee" where "employee_id" = 1]
testSchemaCaching(org.apache.calcite.test.JdbcTest):
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (IO Error: The Network Adapter could not establish
the connection)
testSelfJoin(org.apache.calcite.test.JdbcTest): exception while executing
[select count(*) as c from (
select 1 from "foodmart"."employee" as e1
join "foodmart"."employee" as e2 using ("position_title"))]
testDistinctCountSimple(org.apache.calcite.test.JdbcTest): exception while
executing [explain plan for select count(distinct
"sales_fact_1997"."unit_sales") as "m0"
from "sales_fact_1997" as "sales_fact_1997"]
{noformat}
Can you share the error you ran into?
> "mvn clean install" fails due to missing SqlParserImpl
> ------------------------------------------------------
>
> Key: CALCITE-553
> URL: https://issues.apache.org/jira/browse/CALCITE-553
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Josh Elser
> Fix For: next
>
>
> Every second time I call {mvn -DskipTests clean install} it fails with
> {code}[ERROR] COMPILATION ERROR :
> [INFO] -------------------------------------------------------------
> [ERROR]
> /home/jhyde/open1/calcite.2/core/src/main/java/org/apache/calcite/sql/parser/SqlParser.java:[24,42]
> cannot find symbol
> symbol: class SqlParserImpl
> location: package org.apache.calcite.sql.parser.impl
> [ERROR]
> /home/jhyde/open1/calcite.2/core/src/main/java/org/apache/calcite/sql/parser/SqlParser.java:[201,50]
> cannot find symbol
> symbol: variable SqlParserImpl
> location: class org.apache.calcite.sql.parser.SqlParser.ConfigBuilder
> [INFO] 2 errors{code}
> I think CALCITE-484 broke something; maybe the parser is not generated
> correctly if at the start of the mvn command (before clean) the parser
> already exists.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
