[jira] [Updated] (CALCITE-6436) Missing round brackets in WHERE condition which contains calculations

[Ulrich Kramer (Jira)]

     [ 
https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ulrich Kramer updated CALCITE-6436:
-----------------------------------
    Description: 
Running the following unit test in {{JdbcAdapterTest}} fails with 

{code:java}
@Test void testOperatorInWhere() {
    CalciteAssert.model(FoodmartSchema.FOODMART_MODEL)
        .query("select * from \"sales_fact_1997\" "
            + "where (\"product_id\" = 1) = ?")
        .consumesPreparedStatement(p -> p.setBoolean(1, true))
        .runs();
  }
{code}

{noformat}
Caused by: java.lang.RuntimeException: While executing SQL [SELECT "product_id" 
= 1 AS "ABC"
FROM "foodmart"."sales_fact_1997"
WHERE "product_id" = 1 = ?] on JDBC sub-schema
        at 
java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:67)
{noformat}

  was:
Running the following unit test in {{JdbcAdapterTest}} fails with 

{code:java}
@Test void testOperatorInWhere() {
    CalciteAssert.model(FoodmartSchema.FOODMART_MODEL)
        .query("with A as (select (\"product_id\" = 1) AS abc from 
\"sales_fact_1997\") "
            + "select * from A "
            + "where abc = ?")
        .consumesPreparedStatement(p -> p.setBoolean(1, true))
        .runs();
  }
{code}

{noformat}
Caused by: java.lang.RuntimeException: While executing SQL [SELECT "product_id" 
= 1 AS "ABC"
FROM "foodmart"."sales_fact_1997"
WHERE "product_id" = 1 = ?] on JDBC sub-schema
        at 
java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:67)
{noformat}


> Missing round brackets in WHERE condition which contains calculations
> ---------------------------------------------------------------------
>
>                 Key: CALCITE-6436
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6436
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.37.0
>            Reporter: Ulrich Kramer
>            Priority: Major
>
> Running the following unit test in {{JdbcAdapterTest}} fails with 
> {code:java}
> @Test void testOperatorInWhere() {
>     CalciteAssert.model(FoodmartSchema.FOODMART_MODEL)
>         .query("select * from \"sales_fact_1997\" "
>             + "where (\"product_id\" = 1) = ?")
>         .consumesPreparedStatement(p -> p.setBoolean(1, true))
>         .runs();
>   }
> {code}
> {noformat}
> Caused by: java.lang.RuntimeException: While executing SQL [SELECT 
> "product_id" = 1 AS "ABC"
> FROM "foodmart"."sales_fact_1997"
> WHERE "product_id" = 1 = ?] on JDBC sub-schema
>       at 
> java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:67)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)