You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by pp...@apache.org on 2024/08/01 14:16:24 UTC
(ignite-3) branch main updated: IGNITE-22702 Sql. Rewrite CREATE TABLE FROM QUERY RESULT in tests (#4163)
This is an automated email from the ASF dual-hosted git repository.
ppa pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
The following commit(s) were added to refs/heads/main by this push:
new 6b12242727 IGNITE-22702 Sql. Rewrite CREATE TABLE FROM QUERY RESULT in tests (#4163)
6b12242727 is described below
commit 6b12242727e6759e8937e8163f20c1b39c5e6420
Author: Pavel Pereslegin <xx...@gmail.com>
AuthorDate: Thu Aug 1 17:16:18 2024 +0300
IGNITE-22702 Sql. Rewrite CREATE TABLE FROM QUERY RESULT in tests (#4163)
---
..._slow_ignore => test_group_by_many_groups.test} | 10 +-
...e_delete.test_ignore => test_large_delete.test} | 6 +-
...use.test_ignore_old => test_filter_clause.test} | 80 +---------
.../sql/filter/test_filter_clause.test_ignore | 82 ++++++++++-
...rs.test_ignore => test_transitive_filters.test} | 6 +-
...{test_zonemap.test_ignore => test_zonemap.test} | 6 +-
.../{test_insert.test_ignore => test_insert.test} | 8 +-
...nore => test_full_outer_join_many_matches.test} | 15 +-
...cates.test_ignore => test_join_duplicates.test} | 6 +-
...join_types.test_ignore => test_join_types.test} | 46 +++---
...{test_lt_join.test_ignore => test_lt_join.test} | 6 +-
...st_ignore => test_unequal_join_duplicates.test} | 7 +-
...types.test_ignore => test_mark_join_types.test} | 46 +++---
...der_large.test_ignore => test_order_large.test} | 6 +-
...gnore => test_order_variable_size_payload.test} | 161 +++------------------
.../test_order_variable_size_payload.test_ignore | 46 +++---
...regates.test_ignore => decimal_aggregates.test} | 6 +-
17 files changed, 225 insertions(+), 318 deletions(-)
diff --git a/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_group_by_many_groups.test_slow_ignore b/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_group_by_many_groups.test
similarity index 53%
rename from modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_group_by_many_groups.test_slow_ignore
rename to modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_group_by_many_groups.test
index 8304dd7672..506bddfc27 100644
--- a/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_group_by_many_groups.test_slow_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/aggregate/aggregates/test_group_by_many_groups.test
@@ -1,11 +1,15 @@
-# name: test/sql/aggregate/aggregates/test_group_by_many_groups.test_slow
+# name: test/sql/aggregate/aggregates/test_group_by_many_groups.test
# description: Test GROUP BY with many groups
# group: [aggregates]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
-CREATE TABLE integers AS SELECT x AS i, 1 AS j FROM table(system_range(0, 9999, 1)) UNION ALL SELECT x AS i, 2 j FROM table(system_range(0, 9999, 1));
+CREATE TABLE integers(i INT, j INT);
+statement ok
+INSERT INTO integers SELECT x as i, 1 as j FROM table(system_range(0, 9999, 1));
+
+statement ok
+INSERT INTO integers SELECT x as i, 2 as j FROM table(system_range(0, 9999, 1));
query RR
SELECT SUM(i), SUM(sums) FROM (SELECT i, SUM(j) AS sums FROM integers GROUP BY i) tbl1
diff --git a/modules/sql-engine/src/integrationTest/sql/delete/test_large_delete.test_ignore b/modules/sql-engine/src/integrationTest/sql/delete/test_large_delete.test
similarity index 62%
rename from modules/sql-engine/src/integrationTest/sql/delete/test_large_delete.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/delete/test_large_delete.test
index 972fb815d2..84cab553da 100644
--- a/modules/sql-engine/src/integrationTest/sql/delete/test_large_delete.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/delete/test_large_delete.test
@@ -1,10 +1,12 @@
# name: test/sql/delete/test_large_delete.test
# description: Test scan with large deletions
# group: [delete]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
-CREATE TABLE a AS SELECT * FROM table(system_range(1, 10000, 1)) t1(i);
+CREATE TABLE a(i INT);
+
+statement ok
+INSERT INTO a SELECT x FROM table(system_range(1, 10000, 1));
statement ok
DELETE FROM a WHERE i >= 2000 AND i < 5000;
diff --git a/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore_old b/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test
similarity index 74%
rename from modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore_old
rename to modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test
index adbdd7d26b..22eb28be15 100644
--- a/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore_old
+++ b/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test
@@ -1,10 +1,12 @@
# name: test/sql/filter/test_filter_clause.test
# description: Test aggregation with filter clause
# group: [filter]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-15589
statement ok
-create table t as select x i, mod(x,10) j,mod(x,10)*10000000 k from table(system_range(0, 999));
+create table t(i int, j int, k int);
+
+statement ok
+insert into t select x i, mod(x,10) j,mod(x,10)*10000000 k from table(system_range(0, 999));
query I
SELECT count(*) from t;
@@ -427,7 +429,10 @@ where i < 5
#Query with many different filter clauses (e.g. 5 aggregates, 5 different filters)
statement ok
-create table t_2 as select x a, length(x) b, mod(x,100) c, 5 d, 10000 e from table(system_range(0, 999)) t1(x);
+create table t_2(a int, b int, c int, d int, e int);
+
+statement ok
+insert into t_2 select x a, length(x) b, mod(x,100) c, 5 d, 10000 e from table(system_range(0, 999));
query IIIII
select count (a) filter (where a>10 and a < 15), count (b) filter (where b between 1 and 3),
@@ -446,75 +451,6 @@ select count (a) filter (where a>10 and a < 15), count (b) filter (where b betwe
4 90 0 90 0
0 900 90 900 0
-
-#Filter with some more complex aggregates: COVAR_POP (multiple input columns), STRING_AGG (strings) and ARRAY_AGG (lists)
-query II
-select COVAR_POP(a,b) filter (where a < 100), COVAR_POP(a,b) filter (where b <5) from t_2;
-----
-4.5 49.95
-
-query II
-select COVAR_POP(a,c) filter (where a < 100), COVAR_POP(a,c) filter (where c <50)
-from t_2
-group by b;
-----
-8.250000 8.250000
-674.916667 133.250000
-NULL 208.250000
-
-statement ok
-CREATE TABLE films(film_id INTEGER, title VARCHAR)
-
-statement ok
-CREATE TABLE actors(actor_id INTEGER, first_name VARCHAR, last_name VARCHAR)
-
-statement ok
-CREATE TABLE film_actor(film_id INTEGER, actor_id INTEGER)
-
-statement ok
-INSERT INTO films VALUES (1, 'The Martian'), (2, 'Saving Private Ryan'), (3, 'Team America');
-
-statement ok
-INSERT INTO actors VALUES (1, 'Matt', 'Damon'), (2, 'Jessica', 'Chastain'), (3, 'Tom', 'Hanks'), (4, 'Edward', 'Burns'),
- (5, 'Kim', 'Jong Un'), (6, 'Alec', 'Baldwin');
-
-statement ok
-INSERT INTO film_actor VALUES (1, 1), (2, 1), (3, 1), (1, 2), (2, 3), (2, 4), (3, 5), (3, 6);
-
-query II
-SELECT
- title,
- ARRAY_AGG (first_name || ' ' || last_name) filter (where first_name = 'Matt') actors
-FROM films
-JOIN film_actor USING (film_id)
-JOIN actors USING (actor_id)
-GROUP BY
- title
-ORDER BY
- title;
-----
-Saving Private Ryan [Matt Damon]
-Team America [Matt Damon]
-The Martian [Matt Damon]
-
-
-query II
-SELECT
- title,
- STRING_AGG (first_name || ' ' || last_name) filter (where first_name = 'Matt') actors
-FROM films
-JOIN film_actor USING (film_id)
-JOIN actors USING (actor_id)
-GROUP BY
- title
-ORDER BY
- title;
-----
-Saving Private Ryan Matt Damon
-Team America Matt Damon
-The Martian Matt Damon
-
-
#DISTINCT aggregates
statement ok
CREATE TABLE integers(i INTEGER)
diff --git a/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore b/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore
index 40582ad97b..f526e792ba 100644
--- a/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/filter/test_filter_clause.test_ignore
@@ -1,17 +1,19 @@
# name: test/sql/filter/test_filter_clause.test
# description: Test aggregation with filter clause
# group: [filter]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
+# Ignore: https://issues.apache.org/jira/browse/IGNITE-15589
statement ok
-create table t as select x i, mod(x,10) j,mod(x,10)*10000000 k from table(system_range(0, 999));
+create table t(i int, j int, k int);
+
+statement ok
+insert into t select x i, mod(x,10) j,mod(x,10)*10000000 k from table(system_range(0, 999));
query I
SELECT count(*) from t;
----
1000
-
query II
SELECT
COUNT(*) AS unfiltered,
@@ -428,7 +430,10 @@ where i < 5
#Query with many different filter clauses (e.g. 5 aggregates, 5 different filters)
statement ok
-create table t_2 as select x a, length(x) b, mod(x,100) c, 5 d, 10000 e from table(system_range(0, 999)) t1(x);
+create table t_2(a int, b int, c int, d int, e int);
+
+statement ok
+insert into t_2 select x a, length(x) b, mod(x,100) c, 5 d, 10000 e from table(system_range(0, 999));
query IIIII
select count (a) filter (where a>10 and a < 15), count (b) filter (where b between 1 and 3),
@@ -447,6 +452,75 @@ select count (a) filter (where a>10 and a < 15), count (b) filter (where b betwe
4 90 0 90 0
0 900 90 900 0
+
+#Filter with some more complex aggregates: COVAR_POP (multiple input columns), STRING_AGG (strings) and ARRAY_AGG (lists)
+query II
+select COVAR_POP(a,b) filter (where a < 100), COVAR_POP(a,b) filter (where b <5) from t_2;
+----
+4.5 49.95
+
+query II
+select COVAR_POP(a,c) filter (where a < 100), COVAR_POP(a,c) filter (where c <50)
+from t_2
+group by b;
+----
+8.250000 8.250000
+674.916667 133.250000
+NULL 208.250000
+
+statement ok
+CREATE TABLE films(film_id INTEGER, title VARCHAR)
+
+statement ok
+CREATE TABLE actors(actor_id INTEGER, first_name VARCHAR, last_name VARCHAR)
+
+statement ok
+CREATE TABLE film_actor(film_id INTEGER, actor_id INTEGER)
+
+statement ok
+INSERT INTO films VALUES (1, 'The Martian'), (2, 'Saving Private Ryan'), (3, 'Team America');
+
+statement ok
+INSERT INTO actors VALUES (1, 'Matt', 'Damon'), (2, 'Jessica', 'Chastain'), (3, 'Tom', 'Hanks'), (4, 'Edward', 'Burns'),
+ (5, 'Kim', 'Jong Un'), (6, 'Alec', 'Baldwin');
+
+statement ok
+INSERT INTO film_actor VALUES (1, 1), (2, 1), (3, 1), (1, 2), (2, 3), (2, 4), (3, 5), (3, 6);
+
+query II
+SELECT
+ title,
+ ARRAY_AGG (first_name || ' ' || last_name) filter (where first_name = 'Matt') actors
+FROM films
+JOIN film_actor USING (film_id)
+JOIN actors USING (actor_id)
+GROUP BY
+ title
+ORDER BY
+ title;
+----
+Saving Private Ryan [Matt Damon]
+Team America [Matt Damon]
+The Martian [Matt Damon]
+
+
+query II
+SELECT
+ title,
+ STRING_AGG (first_name || ' ' || last_name) filter (where first_name = 'Matt') actors
+FROM films
+JOIN film_actor USING (film_id)
+JOIN actors USING (actor_id)
+GROUP BY
+ title
+ORDER BY
+ title;
+----
+Saving Private Ryan Matt Damon
+Team America Matt Damon
+The Martian Matt Damon
+
+
#DISTINCT aggregates
statement ok
CREATE TABLE integers(i INTEGER)
diff --git a/modules/sql-engine/src/integrationTest/sql/filter/test_transitive_filters.test_ignore b/modules/sql-engine/src/integrationTest/sql/filter/test_transitive_filters.test
similarity index 97%
rename from modules/sql-engine/src/integrationTest/sql/filter/test_transitive_filters.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/filter/test_transitive_filters.test
index d860c6af73..a0f5ee479d 100644
--- a/modules/sql-engine/src/integrationTest/sql/filter/test_transitive_filters.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/filter/test_transitive_filters.test
@@ -1,14 +1,16 @@
# name: test/sql/filter/test_transitive_filters.test
# description: Test expressions with transitive filters
# group: [filter]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
# Test various transitive filters with simple constant comparisons followed by non-scalar comparisons
# The main point here is to check that the optimizer handles all these cases correctly
# Inserting i, j = i
statement ok
-CREATE TABLE vals1 AS SELECT i AS i, i AS j FROM table(system_range(0, 11, 1)) t1(i)
+CREATE TABLE vals1(i INT, j INT);
+
+statement ok
+INSERT INTO vals1 SELECT i AS i, i AS j FROM table(system_range(0, 11, 1)) t1(i)
# Inserting i, j = i+1
statement ok
diff --git a/modules/sql-engine/src/integrationTest/sql/filter/test_zonemap.test_ignore b/modules/sql-engine/src/integrationTest/sql/filter/test_zonemap.test
similarity index 79%
rename from modules/sql-engine/src/integrationTest/sql/filter/test_zonemap.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/filter/test_zonemap.test
index a754e0383c..1db67ccdd1 100644
--- a/modules/sql-engine/src/integrationTest/sql/filter/test_zonemap.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/filter/test_zonemap.test
@@ -1,10 +1,12 @@
# name: test/sql/filter/test_zonemap.test
# description: Test expressions with transitive filters
# group: [filter]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
-create table t as select x a, length(x) b, mod(x,10000) c, 5 d, 10000 e from table(system_range(0,999));
+create table t(a int, b int, c int, d int, e int);
+
+statement ok
+insert into t select x a, length(x) b, mod(x,10000) c, 5 d, 10000 e from table(system_range(0,999));
query I
select count(*) from t where a > 500 or a <= 700
diff --git a/modules/sql-engine/src/integrationTest/sql/insert/test_insert.test_ignore b/modules/sql-engine/src/integrationTest/sql/insert/test_insert.test
similarity index 89%
rename from modules/sql-engine/src/integrationTest/sql/insert/test_insert.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/insert/test_insert.test
index 6a145e0006..c6b8c2155a 100644
--- a/modules/sql-engine/src/integrationTest/sql/insert/test_insert.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/insert/test_insert.test
@@ -1,7 +1,6 @@
# name: test/sql/insert/test_insert.test
# description: Test insert into and updates of constant values
# group: [insert]
-# Ignored https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
CREATE TABLE integers(i INTEGER)
@@ -11,7 +10,10 @@ INSERT INTO integers VALUES (1), (2), (3), (4), (5)
# insert a constant 1 for every uneven value in "integers"
statement ok
-CREATE TABLE i2 AS SELECT 1 AS i FROM integers WHERE i % 2 <> 0
+CREATE TABLE i2(i INTEGER)
+
+statement ok
+INSERT INTO i2 SELECT 1 AS i FROM integers WHERE i % 2 <> 0
query I
SELECT * FROM i2 ORDER BY 1
@@ -34,7 +36,7 @@ NULL
# Test insert with long string constant
# found by Pedro Holanda
statement ok
-CREATE TABLE IF NOT EXISTS presentations(presentation_date Date NOT NULL UNIQUE, author VARCHAR NOT NULL, title VARCHAR NOT NULL, bio VARCHAR, abstract VARCHAR, zoom_link VARCHAR);
+CREATE TABLE IF NOT EXISTS presentations(presentation_date Date NOT NULL, author VARCHAR NOT NULL, title VARCHAR NOT NULL, bio VARCHAR, abstract VARCHAR, zoom_link VARCHAR);
statement ok
insert into presentations values ('2020-05-29', 'Eduardo Pena', 'Analytical Query Processing Based on Continuous Compression of Intermediates', NULL, 'Modern in-memory column-stores are widely accepted as the adequate database architecture for the efficient processing of complex analytical queries over large relational data volumes. These systems keep their entire data in main memory and typically employ lightweight compression to address the bottleneck between main memory and CPU. Numer [...]
diff --git a/modules/sql-engine/src/integrationTest/sql/join/full_outer/test_full_outer_join_many_matches.test_ignore b/modules/sql-engine/src/integrationTest/sql/join/full_outer/test_full_outer_join_many_matches.test
similarity index 53%
rename from modules/sql-engine/src/integrationTest/sql/join/full_outer/test_full_outer_join_many_matches.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/join/full_outer/test_full_outer_join_many_matches.test
index 76a87bc65c..9bf6f927fe 100644
--- a/modules/sql-engine/src/integrationTest/sql/join/full_outer/test_full_outer_join_many_matches.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/join/full_outer/test_full_outer_join_many_matches.test
@@ -1,25 +1,30 @@
# name: test/sql/join/full_outer/test_full_outer_join_many_matches.test
# description: Test FULL OUTER JOIN with many matches
# group: [full_outer]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
PRAGMA null=null
statement ok
-CREATE TABLE integers AS SELECT a i, 1 j FROM table(system_range(0, 1999, 1)) t1(a)
+CREATE TABLE integers(i INT, j INT)
statement ok
-CREATE TABLE integers2 AS SELECT a k, 2 l FROM table(system_range(2000, 3999, 1)) t1(a)
+INSERT INTO integers SELECT a i, 1 j FROM table(system_range(0, 1999, 1)) t1(a)
+
+statement ok
+CREATE TABLE integers2(k INT, l INT)
+
+statement ok
+INSERT INTO integers2 SELECT a k, 2 l FROM table(system_range(2000, 3999, 1)) t1(a)
# equality join
query IIII
-SELECT i, j, k, l FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY 1, 2, 3, 4
+SELECT i, j, k, l FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY 1 NULLS FIRST, 2 NULLS FIRST, 3 NULLS FIRST, 4 NULLS FIRST
----
16000 values hashing to 7f3fd3a1cf91a34b461601ac6420e880
# range join
query IIII
-SELECT i, j, k, l FROM integers FULL OUTER JOIN integers2 ON integers.j>integers2.l ORDER BY 1, 2, 3, 4
+SELECT i, j, k, l FROM integers FULL OUTER JOIN integers2 ON integers.j>integers2.l ORDER BY 1 NULLS FIRST, 2 NULLS FIRST, 3 NULLS FIRST, 4 NULLS FIRST
----
16000 values hashing to 7f3fd3a1cf91a34b461601ac6420e880
diff --git a/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_duplicates.test_ignore b/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_duplicates.test
similarity index 75%
rename from modules/sql-engine/src/integrationTest/sql/join/inner/test_join_duplicates.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/join/inner/test_join_duplicates.test
index 050089bf0f..b1bb9f10ab 100644
--- a/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_duplicates.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_duplicates.test
@@ -1,7 +1,6 @@
# name: test/sql/join/inner/test_join_duplicates.test
# description: Test join with > STANDARD_VECTOR_SIZE duplicates
# group: [inner]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-15567
statement ok
PRAGMA enable_verification
@@ -13,7 +12,10 @@ statement ok
INSERT INTO test VALUES (11, 1), (12, 2), (13, 3)
statement ok
-CREATE TABLE test2 AS SELECT * FROM repeat(1, 10*1024) t1(b), (SELECT 10) t2(c);
+CREATE TABLE test2(b INTEGER, c INTEGER);
+
+statement ok
+INSERT INTO test2 SELECT 1, 10 FROM table(system_range(1, 10*1024));
query I
SELECT COUNT(*) FROM test2;
diff --git a/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_types.test_ignore b/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_types.test
similarity index 90%
rename from modules/sql-engine/src/integrationTest/sql/join/inner/test_join_types.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/join/inner/test_join_types.test
index 53015371b4..bef170d005 100644
--- a/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_types.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/join/inner/test_join_types.test
@@ -1,7 +1,6 @@
# name: test/sql/join/inner/test_join_types.test
# description: Test joins with different types
# group: [inner]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
PRAGMA enable_verification
@@ -10,7 +9,10 @@ PRAGMA enable_verification
# tests for tinyint
statement ok
-create table a as select i::tinyint AS i from range(1, 101, 1) t1(i)
+create table a(i tinyint)
+
+statement ok
+insert into a select x i from table(system_range(1, 100, 1))
# range joins
query IR
@@ -61,12 +63,15 @@ select count(*) from a, (SELECT 1::tinyint AS j) b where i = j AND i>1000
----
0
+statement ok
+drop table a
+
# tests for smallint
statement ok
-begin transaction
+create table a(i smallint)
statement ok
-create table a as select i::smallint AS i from range(1, 101, 1) t1(i)
+insert into a select x i from table(system_range(1, 100, 1))
# range joins
query IR
@@ -118,14 +123,14 @@ select count(*) from a, (SELECT 1::smallint AS j) b where i = j AND i>1000
0
statement ok
-rollback
+drop table a
# tests for integer
statement ok
-begin transaction
+create table a(i integer)
statement ok
-create table a as select i::integer AS i from range(1, 101, 1) t1(i)
+insert into a select x i from table(system_range(1, 100, 1))
# range joins
query IR
@@ -177,14 +182,14 @@ select count(*) from a, (SELECT 1::integer AS j) b where i = j AND i>1000
0
statement ok
-rollback
+drop table a
# tests for bigint
statement ok
-begin transaction
+create table a(i bigint)
statement ok
-create table a as select i::bigint AS i from range(1, 101, 1) t1(i)
+insert into a select x i from table(system_range(1, 100, 1))
# range joins
query IR
@@ -236,14 +241,14 @@ select count(*) from a, (SELECT 1::bigint AS j) b where i = j AND i>1000
0
statement ok
-rollback
+drop table a
# tests for real
statement ok
-begin transaction
+create table a(i real)
statement ok
-create table a as select i::real AS i from range(1, 101, 1) t1(i)
+insert into a select x i from table(system_range(1, 100, 1))
# range joins
query IR
@@ -295,14 +300,14 @@ select count(*) from a, (SELECT 1::real AS j) b where i = j AND i>1000
0
statement ok
-rollback
+drop table a
# tests for double
statement ok
-begin transaction
+create table a(i double)
statement ok
-create table a as select i::double AS i from range(1, 101, 1) t1(i)
+insert into a select x i from table(system_range(1, 100, 1))
# range joins
query IR
@@ -353,12 +358,9 @@ select count(*) from a, (SELECT 1::double AS j) b where i = j AND i>1000
----
0
-statement ok
-rollback
-
# strings
statement ok
-begin transaction
+drop table a
statement ok
create table a (i VARCHAR)
@@ -396,7 +398,3 @@ query I
select count(*) from a, (SELECT 'a' AS j) b where i = j
----
1
-
-statement ok
-rollback
-
diff --git a/modules/sql-engine/src/integrationTest/sql/join/inner/test_lt_join.test_ignore b/modules/sql-engine/src/integrationTest/sql/join/inner/test_lt_join.test
similarity index 79%
rename from modules/sql-engine/src/integrationTest/sql/join/inner/test_lt_join.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/join/inner/test_lt_join.test
index 13fee1e33c..02208ff4c9 100644
--- a/modules/sql-engine/src/integrationTest/sql/join/inner/test_lt_join.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/join/inner/test_lt_join.test
@@ -1,13 +1,15 @@
# name: test/sql/join/inner/test_lt_join.test
# description: Test less than join
# group: [inner]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
PRAGMA enable_verification
statement ok
-create table a AS SELECT i FROM range(1, 2001, 1) t1(i)
+create table a(i int)
+
+statement ok
+INSERT INTO a SELECT * FROM table(system_range(1, 2000))
query I
select count(*) from a, (SELECT 2000 AS j) b where i < j
diff --git a/modules/sql-engine/src/integrationTest/sql/join/inner/test_unequal_join_duplicates.test_ignore b/modules/sql-engine/src/integrationTest/sql/join/inner/test_unequal_join_duplicates.test
similarity index 68%
rename from modules/sql-engine/src/integrationTest/sql/join/inner/test_unequal_join_duplicates.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/join/inner/test_unequal_join_duplicates.test
index 2dc204d94b..f7c3f76163 100644
--- a/modules/sql-engine/src/integrationTest/sql/join/inner/test_unequal_join_duplicates.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/join/inner/test_unequal_join_duplicates.test
@@ -1,8 +1,6 @@
# name: test/sql/join/inner/test_unequal_join_duplicates.test
# description: Test inequality join with > STANDARD_VECTOR_SIZE duplicates
# group: [inner]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-15567
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
CREATE TABLE test (b INTEGER);
@@ -11,7 +9,10 @@ statement ok
INSERT INTO test VALUES (1), (2)
statement ok
-CREATE TABLE test2 AS SELECT * FROM repeat(1, 10*1024) t1(b);
+CREATE TABLE test2(b INTEGER);
+
+statement ok
+INSERT INTO test2 SELECT 1 FROM table(system_range(1, 10240));
query I
SELECT COUNT(*) FROM test2;
diff --git a/modules/sql-engine/src/integrationTest/sql/join/mark/test_mark_join_types.test_ignore b/modules/sql-engine/src/integrationTest/sql/join/mark/test_mark_join_types.test
similarity index 93%
rename from modules/sql-engine/src/integrationTest/sql/join/mark/test_mark_join_types.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/join/mark/test_mark_join_types.test
index ce2f5a9fcd..d658eed04e 100644
--- a/modules/sql-engine/src/integrationTest/sql/join/mark/test_mark_join_types.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/join/mark/test_mark_join_types.test
@@ -1,7 +1,6 @@
# name: test/sql/join/mark/test_mark_join_types.test
# description: Test mark join with different types
# group: [mark]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
PRAGMA enable_verification
@@ -10,7 +9,10 @@ PRAGMA enable_verification
# tests for tinyint
statement ok
-create table a as select i::tinyint AS i from range(1, 101, 1) t1(i) order by random()
+create table a(i tinyint)
+
+statement ok
+insert into a select x from table(system_range(1, 100)) order by rand()
# range joins
query I
@@ -107,12 +109,15 @@ select * from (select * from a where i > 90) a WHERE i <> ANY((SELECT 96::tinyin
99
100
+statement ok
+drop table a
+
# tests for smallint
statement ok
-begin transaction
+create table a(i smallint)
statement ok
-create table a as select i::smallint AS i from range(1, 101, 1) t1(i) order by random()
+insert into a select x from table(system_range(1, 100)) order by rand()
# range joins
query I
@@ -210,14 +215,14 @@ select * from (select * from a where i > 90) a WHERE i <> ANY((SELECT 96::smalli
100
statement ok
-rollback
+drop table a
# tests for integer
statement ok
-begin transaction
+create table a(i integer)
statement ok
-create table a as select i::integer AS i from range(1, 101, 1) t1(i) order by random()
+insert into a select x from table(system_range(1, 100)) order by rand()
# range joins
query I
@@ -315,14 +320,14 @@ select * from (select * from a where i > 90) a WHERE i <> ANY((SELECT 96::intege
100
statement ok
-rollback
+drop table a
# tests for bigint
statement ok
-begin transaction
+create table a(i bigint)
statement ok
-create table a as select i::bigint AS i from range(1, 101, 1) t1(i) order by random()
+insert into a select x from table(system_range(1, 100)) order by rand()
# range joins
query I
@@ -420,14 +425,14 @@ select * from (select * from a where i > 90) a WHERE i <> ANY((SELECT 96::bigint
100
statement ok
-rollback
+drop table a
# tests for real
statement ok
-begin transaction
+create table a(i real)
statement ok
-create table a as select i::real AS i from range(1, 101, 1) t1(i) order by random()
+insert into a select x from table(system_range(1, 100)) order by rand()
# range joins
query I
@@ -525,14 +530,14 @@ select * from (select * from a where i > 90) a WHERE i <> ANY((SELECT 96::real))
100.000000
statement ok
-rollback
+drop table a
# tests for double
statement ok
-begin transaction
+create table a(i double)
statement ok
-create table a as select i::double AS i from range(1, 101, 1) t1(i) order by random()
+insert into a select x from table(system_range(1, 100)) order by rand()
# range joins
query I
@@ -630,12 +635,9 @@ select * from (select * from a where i > 90) a WHERE i <> ANY((SELECT 96::double
100.000000
statement ok
-rollback
+drop table a
# strings
-statement ok
-begin transaction
-
statement ok
create table a (i VARCHAR)
@@ -672,7 +674,3 @@ query I
select count(*) from a WHERE i = ANY((SELECT 'a'))
----
1
-
-statement ok
-rollback
-
diff --git a/modules/sql-engine/src/integrationTest/sql/order/test_order_large.test_ignore b/modules/sql-engine/src/integrationTest/sql/order/test_order_large.test
similarity index 66%
rename from modules/sql-engine/src/integrationTest/sql/order/test_order_large.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/order/test_order_large.test
index 1f0269cfab..f6fb70ace1 100644
--- a/modules/sql-engine/src/integrationTest/sql/order/test_order_large.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/order/test_order_large.test
@@ -1,11 +1,13 @@
# name: test/sql/order/test_order_large.test
# description: Test ORDER BY with large table
# group: [order]
-# Ignore: https://issues.apache.org/jira/browse/IGNITE-17268
# order of a large table, with burgers and fries
statement ok
-CREATE TABLE test AS SELECT a FROM table(system_range(10000, 1, -1)) t1(a)
+CREATE TABLE test(a INT)
+
+statement ok
+INSERT INTO test SELECT x FROM table(system_range(10000, 1, -1))
query I
SELECT * FROM test ORDER BY a
diff --git a/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore b/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test
similarity index 68%
copy from modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore
copy to modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test
index ce2f9b1f73..921692e983 100644
--- a/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test
@@ -1,12 +1,6 @@
# name: test/sql/order/test_order_variable_size_payload.test
# description: Test ORDER BY keyword (variable size sorting/payload columns)
# group: [order]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17437
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17268
-
-# payload string that is longer than the 8MB initial string size - this tests whether RowChunk dynamically increases block capacity
-statement ok
-select x % 2 i, string_agg('thisstringis200characterslong..........................................................................................................................................................................') s from table(system_range(0, 99999)) group by i order by i
# weird one from SQLancer
statement ok
@@ -50,7 +44,7 @@ statement ok
INSERT INTO test1 VALUES ('2'), (NULL), ('355555552'), ('1'), ('35555556'), ('10'), ('355555553'), ('355555551')
query I
-SELECT * FROM test1 ORDER BY s
+SELECT * FROM test1 ORDER BY s NULLS FIRST
----
NULL
1
@@ -63,10 +57,16 @@ NULL
# sort on 10000 strings
statement ok
-CREATE TABLE test2 AS (SELECT CAST(range AS VARCHAR) r, random() rand FROM range(10000))
+CREATE TABLE test2(r VARCHAR, rand DOUBLE)
+
+statement ok
+INSERT INTO test2 SELECT x::VARCHAR r, rand() rand FROM table(system_range(1, 10000))
statement ok
-CREATE TABLE test2_1 AS (SELECT * FROM test2 ORDER BY r)
+CREATE TABLE test2_1(r VARCHAR, rand DOUBLE)
+
+statement ok
+INSERT INTO test2_1 (SELECT * FROM test2 ORDER BY r)
query T
SELECT count(*) FROM test2_1
@@ -75,10 +75,16 @@ SELECT count(*) FROM test2_1
# string payload
statement ok
-CREATE TABLE test3 AS (SELECT CAST(range AS VARCHAR) r, random() rand FROM range(10000))
+CREATE TABLE test3(r VARCHAR, rand DOUBLE)
+
+statement ok
+INSERT INTO test3 SELECT x::VARCHAR r, rand() rand FROM table(system_range(1, 10000))
+
+statement ok
+CREATE TABLE test3_1(r VARCHAR, rand DOUBLE)
statement ok
-CREATE TABLE test3_1 AS (SELECT * FROM test3 ORDER BY rand)
+INSERT INTO test3_1 (SELECT * FROM test3 ORDER BY rand)
query T
SELECT count(*) FROM test3_1
@@ -128,101 +134,15 @@ SELECT * FROM tpch_q1_agg ORDER BY l_returnflag, l_linestatus;
----
A F 3774200 5320753880.69 5054096266.6828 5256751331.449234 25.537587116854997 36002.12382901414 0.05014459706340077 147790
N F 95257 133737795.84 127132372.6512 132286291.229445 25.30066401062417 35521.32691633466 0.04939442231075697 3765
-N O 7459297 10512270008.90 9986238338.3847 10385578376.585467 25.545537671232875 36000.9246880137 0.05009595890410959 292000
+N O 7459297 10512270008.90 9986238338.3847 1.0385578376585466E10 25.545537671232875 36000.9246880137 0.05009595890410959 292000
R F 3785523 5337950526.47 5071818532.9420 5274405503.049367 25.5259438574251 35994.029214030925 0.04998927856184382 148301
-statement ok
-create table test5 (i int, s varchar);
-
-statement ok
-insert into test5 values (3, 'ababa'), (1, 'babab'), (NULL, 'abbab'), (2, NULL);
-
-query TT
-select i, list(string_split(s, 'b')) from test5 group by i order by i;
-----
-NULL [[a, , a, ]]
-1 [[, a, a, ]]
-2 [NULL]
-3 [[a, a, a]]
-
-query TT
-select i, struct_pack(i:=i, s:=s) from test5 order by i;
-----
-NULL <i: NULL, s: abbab>
-1 <i: 1, s: babab>
-2 <i: 2, s: NULL>
-3 <i: 3, s: ababa>
-
-query TT
-select i, struct_pack(i:=i, s:=string_split(s, 'b')) from test5 order by i;
-----
-NULL <i: NULL, s: [a, , a, ]>
-1 <i: 1, s: [, a, a, ]>
-2 <i: 2, s: NULL>
-3 <i: 3, s: [a, a, a]>
-
-query TT
-select i, struct_pack(i:=i, s:=UNNEST(string_split(s, 'b'))) from test5 order by i;
-----
-NULL <i: NULL, s: a>
-NULL <i: NULL, s: >
-NULL <i: NULL, s: a>
-NULL <i: NULL, s: >
-1 <i: 1, s: >
-1 <i: 1, s: a>
-1 <i: 1, s: a>
-1 <i: 1, s: >
-2 <i: 2, s: NULL>
-3 <i: 3, s: a>
-3 <i: 3, s: a>
-3 <i: 3, s: a>
-
-query TT
-select i, struct_pack(i:=i, s:=list(s)) from test5 group by i order by i;
-----
-NULL <i: NULL, s: [abbab]>
-1 <i: 1, s: [babab]>
-2 <i: 2, s: [NULL]>
-3 <i: 3, s: [ababa]>
-
-query TT
-select i, struct_pack(i:=i, s:=s) from test5 order by s;
-----
-2 <i: 2, s: NULL>
-3 <i: 3, s: ababa>
-NULL <i: NULL, s: abbab>
-1 <i: 1, s: babab>
-
-query TT
-select i, struct_pack(i:=i, s:=list(string_split(s, 'b'))) from test5 group by i order by i;
-----
-NULL <i: NULL, s: [[a, , a, ]]>
-1 <i: 1, s: [[, a, a, ]]>
-2 <i: 2, s: [NULL]>
-3 <i: 3, s: [[a, a, a]]>
-
# sorting by a mix of variable size and constant size columns
statement ok
CREATE TABLE test6 (i1 INT, s1 VARCHAR, i2 int, s2 VARCHAR)
statement ok
-INSERT INTO test6 VALUES
-(6, '0reallylongstring1', 3, '1reallylongstring8'),
-(6, '0reallylongstring1', 3, '1reallylongstring7'),
-(6, '0reallylongstring1', 4, '1reallylongstring8'),
-(6, '0reallylongstring1', 4, '1reallylongstring7'),
-(6, '0reallylongstring2', 3, '1reallylongstring8'),
-(6, '0reallylongstring2', 3, '1reallylongstring7'),
-(6, '0reallylongstring2', 4, '1reallylongstring8'),
-(6, '0reallylongstring2', 4, '1reallylongstring7'),
-(5, '0reallylongstring1', 3, '1reallylongstring8'),
-(5, '0reallylongstring1', 3, '1reallylongstring7'),
-(5, '0reallylongstring1', 4, '1reallylongstring8'),
-(5, '0reallylongstring1', 4, '1reallylongstring7'),
-(5, '0reallylongstring2', 3, '1reallylongstring8'),
-(5, '0reallylongstring2', 3, '1reallylongstring7'),
-(5, '0reallylongstring2', 4, '1reallylongstring8'),
-(5, '0reallylongstring2', 4, '1reallylongstring7')
+INSERT INTO test6 VALUES (6, '0reallylongstring1', 3, '1reallylongstring8'), (6, '0reallylongstring1', 3, '1reallylongstring7'),(6, '0reallylongstring1', 4, '1reallylongstring8'),(6, '0reallylongstring1', 4, '1reallylongstring7'),(6, '0reallylongstring2', 3, '1reallylongstring8'),(6, '0reallylongstring2', 3, '1reallylongstring7'),(6, '0reallylongstring2', 4, '1reallylongstring8'),(6, '0reallylongstring2', 4, '1reallylongstring7'),(5, '0reallylongstring1', 3, '1reallylongstring8'),(5, '0r [...]
query IIII
SELECT i1, s1, i2, s2 FROM test6 ORDER BY i1, s1, i2, s2
@@ -363,46 +283,3 @@ Brand#11 ECONOMY BURNISHED COPPER 9 4
Brand#11 ECONOMY BURNISHED COPPER 49 4
Brand#11 ECONOMY BURNISHED NICKEL 14 4
Brand#11 ECONOMY BURNISHED NICKEL 49 4
-
-# simple nested lists (no structs)
-statement ok
-create table test8 (i int, s varchar)
-
-statement ok
-insert into test8 values (3, 'aba'), (1, 'ccbcc'), (NULL, 'dbdbd'), (2, NULL);
-
-query TT
-select i, string_split(s, 'b') from test8 order by i;
-----
-NULL [d, d, d]
-1 [cc, cc]
-2 NULL
-3 [a, a]
-
-query TT
-select i, list(s) from test8 group by i order by i;
-----
-NULL [dbdbd]
-1 [ccbcc]
-2 [NULL]
-3 [aba]
-
-query TT
-select i, list(string_split(s, 'b')) from test8 group by i order by i;
-----
-NULL [[d, d, d]]
-1 [[cc, cc]]
-2 [NULL]
-3 [[a, a]]
-
-# lists longer than STANDARD_VECTOR_SIZE
-statement ok
-CREATE TABLE test9 AS (SELECT range % 4 i, range j FROM range(5000));
-
-statement ok
-INSERT INTO test9 VALUES (0, NULL), (1, NULL), (2, NULL), (3, NULL)
-
-query TT
-SELECT i, list(j) FROM test9 GROUP BY i ORDER BY i;
-----
-8 values hashing to fc909a9ac472ea404c0bceecf7f1f3d6
diff --git a/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore b/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore
index ce2f9b1f73..f6e346fd0e 100644
--- a/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/order/test_order_variable_size_payload.test_ignore
@@ -2,7 +2,6 @@
# description: Test ORDER BY keyword (variable size sorting/payload columns)
# group: [order]
# Ignore https://issues.apache.org/jira/browse/IGNITE-17437
-# Ignore https://issues.apache.org/jira/browse/IGNITE-17268
# payload string that is longer than the 8MB initial string size - this tests whether RowChunk dynamically increases block capacity
statement ok
@@ -50,7 +49,7 @@ statement ok
INSERT INTO test1 VALUES ('2'), (NULL), ('355555552'), ('1'), ('35555556'), ('10'), ('355555553'), ('355555551')
query I
-SELECT * FROM test1 ORDER BY s
+SELECT * FROM test1 ORDER BY s NULLS FIRST
----
NULL
1
@@ -63,10 +62,16 @@ NULL
# sort on 10000 strings
statement ok
-CREATE TABLE test2 AS (SELECT CAST(range AS VARCHAR) r, random() rand FROM range(10000))
+CREATE TABLE test2(r VARCHAR, rand DOUBLE)
statement ok
-CREATE TABLE test2_1 AS (SELECT * FROM test2 ORDER BY r)
+INSERT INTO test2 SELECT x::VARCHAR r, rand() rand FROM table(system_range(1, 10000))
+
+statement ok
+CREATE TABLE test2_1(r VARCHAR, rand DOUBLE)
+
+statement ok
+INSERT INTO test2_1 (SELECT * FROM test2 ORDER BY r)
query T
SELECT count(*) FROM test2_1
@@ -75,10 +80,16 @@ SELECT count(*) FROM test2_1
# string payload
statement ok
-CREATE TABLE test3 AS (SELECT CAST(range AS VARCHAR) r, random() rand FROM range(10000))
+CREATE TABLE test3(r VARCHAR, rand DOUBLE)
+
+statement ok
+INSERT INTO test3 SELECT x::VARCHAR r, rand() rand FROM table(system_range(1, 10000))
+
+statement ok
+CREATE TABLE test3_1(r VARCHAR, rand DOUBLE)
statement ok
-CREATE TABLE test3_1 AS (SELECT * FROM test3 ORDER BY rand)
+INSERT INTO test3_1 (SELECT * FROM test3 ORDER BY rand)
query T
SELECT count(*) FROM test3_1
@@ -206,23 +217,7 @@ statement ok
CREATE TABLE test6 (i1 INT, s1 VARCHAR, i2 int, s2 VARCHAR)
statement ok
-INSERT INTO test6 VALUES
-(6, '0reallylongstring1', 3, '1reallylongstring8'),
-(6, '0reallylongstring1', 3, '1reallylongstring7'),
-(6, '0reallylongstring1', 4, '1reallylongstring8'),
-(6, '0reallylongstring1', 4, '1reallylongstring7'),
-(6, '0reallylongstring2', 3, '1reallylongstring8'),
-(6, '0reallylongstring2', 3, '1reallylongstring7'),
-(6, '0reallylongstring2', 4, '1reallylongstring8'),
-(6, '0reallylongstring2', 4, '1reallylongstring7'),
-(5, '0reallylongstring1', 3, '1reallylongstring8'),
-(5, '0reallylongstring1', 3, '1reallylongstring7'),
-(5, '0reallylongstring1', 4, '1reallylongstring8'),
-(5, '0reallylongstring1', 4, '1reallylongstring7'),
-(5, '0reallylongstring2', 3, '1reallylongstring8'),
-(5, '0reallylongstring2', 3, '1reallylongstring7'),
-(5, '0reallylongstring2', 4, '1reallylongstring8'),
-(5, '0reallylongstring2', 4, '1reallylongstring7')
+INSERT INTO test6 VALUES (6, '0reallylongstring1', 3, '1reallylongstring8'), (6, '0reallylongstring1', 3, '1reallylongstring7'),(6, '0reallylongstring1', 4, '1reallylongstring8'),(6, '0reallylongstring1', 4, '1reallylongstring7'),(6, '0reallylongstring2', 3, '1reallylongstring8'),(6, '0reallylongstring2', 3, '1reallylongstring7'),(6, '0reallylongstring2', 4, '1reallylongstring8'),(6, '0reallylongstring2', 4, '1reallylongstring7'),(5, '0reallylongstring1', 3, '1reallylongstring8'),(5, '0r [...]
query IIII
SELECT i1, s1, i2, s2 FROM test6 ORDER BY i1, s1, i2, s2
@@ -397,7 +392,10 @@ NULL [[d, d, d]]
# lists longer than STANDARD_VECTOR_SIZE
statement ok
-CREATE TABLE test9 AS (SELECT range % 4 i, range j FROM range(5000));
+CREATE TABLE test9(i INT, j INT)
+
+statement ok
+INSERT INTO test9 (SELECT x % 4 i, x j FROM table(system_range(1, 5000)))
statement ok
INSERT INTO test9 VALUES (0, NULL), (1, NULL), (2, NULL), (3, NULL)
diff --git a/modules/sql-engine/src/integrationTest/sql/types/decimal/decimal_aggregates.test_ignore b/modules/sql-engine/src/integrationTest/sql/types/decimal/decimal_aggregates.test
similarity index 88%
rename from modules/sql-engine/src/integrationTest/sql/types/decimal/decimal_aggregates.test_ignore
rename to modules/sql-engine/src/integrationTest/sql/types/decimal/decimal_aggregates.test
index 18f15fb8ba..496eadb2e4 100644
--- a/modules/sql-engine/src/integrationTest/sql/types/decimal/decimal_aggregates.test_ignore
+++ b/modules/sql-engine/src/integrationTest/sql/types/decimal/decimal_aggregates.test
@@ -1,7 +1,6 @@
# name: test/sql/types/decimal/decimal_aggregates.test
# description: Test decimal aggregates
# group: [decimal]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17268
statement ok
PRAGMA enable_verification
@@ -69,7 +68,10 @@ NULL
# decimal aggregates over a table
statement ok
-CREATE TABLE decimals AS SELECT x::DECIMAL(4,1) AS d1, (x * x)::DECIMAL(9,1) AS d2, (x * x * x)::DECIMAL(18,1) AS d3, (x * x * x * x)::DECIMAL(38,1) AS d4 FROM table(system_range(1, 999));
+CREATE TABLE decimals(d1 DECIMAL(4,1), d2 DECIMAL(9,1), d3 DECIMAL(18,1), d4 DECIMAL(38,1));
+
+statement ok
+INSERT INTO decimals SELECT x::DECIMAL(4,1) AS d1, (x * x)::DECIMAL(9,1) AS d2, (x * x * x)::DECIMAL(18,1) AS d3, (x * x * x * x)::DECIMAL(38,1) AS d4 FROM table(system_range(1, 999));
query IIII
SELECT SUM(d1)::VARCHAR, SUM(d2)::VARCHAR, SUM(d3)::VARCHAR, SUM(d4)::VARCHAR FROM decimals;