[
https://issues.apache.org/jira/browse/IGNITE-23740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-23740:
--------------------------------------
Description:
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}
----
There is also test_filter_clause.test_ignore file which has some test related
to aggregate functions such STRING_AGG, ARRAY_AGG and COVAR_OP, we can move its
content to tests of aggregate functions.
was:
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}
There is a
> 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
> Priority: Major
> Labels: ignite-3
>
> 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}
> ----
> There is also test_filter_clause.test_ignore file which has some test related
> to aggregate functions such STRING_AGG, ARRAY_AGG and COVAR_OP, we can move
> its content to tests of aggregate functions.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
