You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Kevin Risden (JIRA)" <ji...@apache.org> on 2019/03/12 20:29:00 UTC
[jira] [Updated] (CALCITE-2918) Integration tests against postgres
are broken
[ https://issues.apache.org/jira/browse/CALCITE-2918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Risden updated CALCITE-2918:
----------------------------------
Description:
As part of the release process, integration testing against postgres found a failure.
{code:java}
./mvnw verify -Pit
[INFO] -------------------------------------------------------
[INFO] T E S T S
[INFO] -------------------------------------------------------
[INFO] Running org.apache.calcite.test.JdbcTest
2019-03-11 11:23:41,539 [main] INFO - open start - state modified
2019-03-11 11:23:41,555 [main] INFO - Checkpoint start
2019-03-11 11:23:41,555 [main] INFO - Checkpoint end - txts: 25
[ERROR] Tests run: 290, Failures: 0, Errors: 1, Skipped: 21, Time elapsed: 65.154 s <<< FAILURE! - in org.apache.calcite.test.JdbcTest
[ERROR] testIsNotDistinctInFilter(org.apache.calcite.test.JdbcTest) Time elapsed: 0.041 s <<< ERROR!
java.sql.SQLException:
Error while executing SQL "select *
from "foodmart"."employee" as e1
where e1."last_name" is distinct from e1."last_name"": While executing SQL [SELECT *
FROM "foodmart"."employee"
WHERE ("last_name" IS NOT NULL OR "last_name" IS NOT NULL) AND "last_name" = "last_name" IS NOT TRUE] on JDBC sub-schema
at org.apache.calcite.test.JdbcTest.testIsNotDistinctInFilter(JdbcTest.java:1585)
Caused by: java.lang.RuntimeException:
While executing SQL [SELECT *
FROM "foodmart"."employee"
WHERE ("last_name" IS NOT NULL OR "last_name" IS NOT NULL) AND "last_name" = "last_name" IS NOT TRUE] on JDBC sub-schema
at org.apache.calcite.test.JdbcTest.testIsNotDistinctInFilter(JdbcTest.java:1585)
Caused by: org.postgresql.util.PSQLException:
ERROR: argument of IS NOT TRUE must be type boolean, not type character varying
Position: 114
at org.apache.calcite.test.JdbcTest.testIsNotDistinctInFilter(JdbcTest.java:1585)
{code}
was:As part of the release process, integration testing against postgres found a failure.
> Integration tests against postgres are broken
> ---------------------------------------------
>
> Key: CALCITE-2918
> URL: https://issues.apache.org/jira/browse/CALCITE-2918
> Project: Calcite
> Issue Type: Bug
> Reporter: Kevin Risden
> Priority: Blocker
> Fix For: 1.19.0
>
>
> As part of the release process, integration testing against postgres found a failure.
> {code:java}
> ./mvnw verify -Pit
> [INFO] -------------------------------------------------------
> [INFO] T E S T S
> [INFO] -------------------------------------------------------
> [INFO] Running org.apache.calcite.test.JdbcTest
> 2019-03-11 11:23:41,539 [main] INFO - open start - state modified
> 2019-03-11 11:23:41,555 [main] INFO - Checkpoint start
> 2019-03-11 11:23:41,555 [main] INFO - Checkpoint end - txts: 25
> [ERROR] Tests run: 290, Failures: 0, Errors: 1, Skipped: 21, Time elapsed: 65.154 s <<< FAILURE! - in org.apache.calcite.test.JdbcTest
> [ERROR] testIsNotDistinctInFilter(org.apache.calcite.test.JdbcTest) Time elapsed: 0.041 s <<< ERROR!
> java.sql.SQLException:
> Error while executing SQL "select *
> from "foodmart"."employee" as e1
> where e1."last_name" is distinct from e1."last_name"": While executing SQL [SELECT *
> FROM "foodmart"."employee"
> WHERE ("last_name" IS NOT NULL OR "last_name" IS NOT NULL) AND "last_name" = "last_name" IS NOT TRUE] on JDBC sub-schema
> at org.apache.calcite.test.JdbcTest.testIsNotDistinctInFilter(JdbcTest.java:1585)
> Caused by: java.lang.RuntimeException:
> While executing SQL [SELECT *
> FROM "foodmart"."employee"
> WHERE ("last_name" IS NOT NULL OR "last_name" IS NOT NULL) AND "last_name" = "last_name" IS NOT TRUE] on JDBC sub-schema
> at org.apache.calcite.test.JdbcTest.testIsNotDistinctInFilter(JdbcTest.java:1585)
> Caused by: org.postgresql.util.PSQLException:
> ERROR: argument of IS NOT TRUE must be type boolean, not type character varying
> Position: 114
> at org.apache.calcite.test.JdbcTest.testIsNotDistinctInFilter(JdbcTest.java:1585)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)