[IGNITE-20128] Sql. Clean up ignored SQL tests

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Iurii Gerzhedovich
• Reporter: Iurii Gerzhedovich
• Created: 01/Aug/23 16:35
• Updated: 04/Sep/24 16:10
• Resolved: 07/Aug/23 07:15

Description

We have buch of muted, but works test, or muted tests which shouldn't work at all.
Let's do our tests are a little bit less messed.

Test require attention:
sql/sqlite/join/join1.test_ignore
sql/sqlite/select2/select2_erroneous_hash_res.test_ignored
sql/sqlite/select2/select2_erroneous_res.test_ignored
sql/sqlite/select3/select3_erroneous_hash_res.test_ignore
sql/sqlite/select3/select3_erroneous_res.test_ignore
sql/subquery/table/test_aliasing.test_ignore
sql/filter/test_constant_comparisons.test_ignore
sql/insert/test_insert_type.test_ignore
sql/filter/test_obsolete_filters.test_ignore
sql/order/test_order_same_value.test_slow_ignore
sql/subquery/table/test_table_subquery.test_ignore
sql/subquery/any_all/test_uncorrelated_all_subquery.test_ignore
sql/subquery/any_all/test_uncorrelated_any_subquery.test_ignored
sql/subquery/scalar/test_uncorrelated_scalar_subquery.test_ignore

Tickets require attention:
https://issues.apache.org/jira/browse/IGNITE-14617
https://issues.apache.org/jira/browse/IGNITE-15561
https://issues.apache.org/jira/browse/IGNITE-15583
https://issues.apache.org/jira/browse/IGNITE-15586
https://issues.apache.org/jira/browse/IGNITE-15605
https://issues.apache.org/jira/browse/IGNITE-17644
https://issues.apache.org/jira/browse/IGNITE-17921
https://issues.apache.org/jira/browse/IGNITE-18365

Issue Links

• links to: GitHub Pull Request #2392