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)