Maksim Zhuravkov created IGNITE-23740:
-----------------------------------------

             Summary: Sql. Missing rowsort comparison mode in 
test_filter_clause.test 
                 Key: IGNITE-23740
                 URL: https://issues.apache.org/jira/browse/IGNITE-23740
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Maksim Zhuravkov


The following test case from test_filter_clause.test lacks rowsort comparison 
option. This may introduce flakiness into the sql logic test suite if sql 
engine is going to return results in different order. 

{noformat}
query IIIII
select count (a) filter (where a>10 and a < 15), count (b) filter (where b 
between 1 and 3),
    count (c) filter ( where c < 10), count (d) filter (where d =5), count(e) 
filter (where e < 10)
    from t_2
    group by b;
----
0       10      10      10      0
4       90      0       90      0
0       900     90      900     0
{noformat}





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

Reply via email to