[ 
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)

Reply via email to