IgniteDataFrame SparkSQL OR clause return incorrect result

[alexcwyu]

I am using IgniteDataFrame and using Spark SQL to query the dataframe.
    spark: 2.3.2
    ignite: 2.7.0

I found a bug in SparkSQL while using Ignite.

    select count(*) from risk where val_date = '2019-04-26' and portf_id =
27315 
    -- correctly return 11 row

    select count(*) from risk where val_date = '2019-04-26' and portf_id =
27315 or portf_id = 14041
    -- correctly return 494 row

    select count(*) from risk where val_date = '2019-04-26' and (portf_id =
27315 or portf_id = 14041)
    -- expected to return 505 row but it return >7000 row

If I turnoff ignite, the row count with OR clause is correct.

anything I can do to further debug / pinpoint the issue?



--
Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/