You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by am...@apache.org on 2023/01/23 14:43:48 UTC
[ignite-3] 01/02: Unmute tests.
This is an automated email from the ASF dual-hosted git repository.
amashenkov pushed a commit to branch gg-18488
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
commit c3d7d1f22c67d12427b250464c204faa6c024265
Author: amashenkov <an...@gmail.com>
AuthorDate: Mon Jan 23 16:32:57 2023 +0300
Unmute tests.
---
.../{test_avg.test_ignore => test_avg.test} | 1 -
.../sql/aggregate/aggregates/test_scalar_aggr.test | 49 ++++++++++++++++++++++
.../aggregates/test_scalar_aggr.test_ignore | 3 +-
.../{test_nvl.test_ignore => test_nvl.test} | 1 -
...est_truncate.test_ignore => test_truncate.test} | 1 -
...seconvert.test_ignore => test_caseconvert.test} | 1 -
...{test_initcap.test_ignore => test_initcap.test} | 1 -
.../{test_left.test_ignore => test_left.test} | 1 -
.../{test_repeat.test_ignore => test_repeat.test} | 1 -
...{test_replace.test_ignore => test_replace.test} | 1 -
...{test_reverse.test_ignore => test_reverse.test} | 1 -
.../{test_right.test_ignore => test_right.test} | 1 -
...t_substring.test_ignore => test_substring.test} | 1 -
.../{test_trim.test_ignore => test_trim.test} | 1 -
...{test_is_null.test_ignore => test_is_null.test} | 1 -
.../null/{test_null.test_ignore => test_null.test} | 1 -
16 files changed, 51 insertions(+), 15 deletions(-)
diff --git a/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_avg.test_ignore b/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_avg.test
similarity index 89%
rename from modules/runner/src/integrationTest/sql/aggregate/aggregates/test_avg.test_ignore
rename to modules/runner/src/integrationTest/sql/aggregate/aggregates/test_avg.test
index 1d1dad869e..bf2ccc3ece 100644
--- a/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_avg.test_ignore
+++ b/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_avg.test
@@ -1,7 +1,6 @@
# name: test/sql/aggregate/aggregates/test_avg.test
# description: Test AVG operator
# group: [aggregates]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# scalar average
query RR
diff --git a/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test b/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test
new file mode 100644
index 0000000000..16554ebb23
--- /dev/null
+++ b/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test
@@ -0,0 +1,49 @@
+# name: test/sql/aggregate/aggregates/test_scalar_aggr.test
+# description: Test aggregates with scalar inputs
+# group: [aggregates]
+
+# test aggregate on scalar values
+query IIII
+SELECT COUNT(1), MIN(1), MAX(1), SUM(1)
+----
+1
+1
+1
+1
+
+# test aggregate on scalar NULLs
+query IIII
+SELECT COUNT(NULL), MIN(NULL), MAX(NULL), SUM(NULL)
+----
+0
+NULL
+NULL
+NULL
+
+# test aggregates on a set of values with scalar inputs
+statement ok
+CREATE TABLE integers(i INTEGER);
+
+statement ok
+INSERT INTO integers VALUES (1), (2), (NULL)
+
+query IIIII
+SELECT COUNT(1), MIN(1), ANY_VALUE(1), MAX(1), SUM(1) FROM integers
+----
+3
+1
+1
+1
+3
+
+# test aggregates on a set of values with scalar NULL values as inputs
+query IIIII
+SELECT COUNT(NULL), MIN(NULL), ANY_VALUE(NULL), MAX(NULL), SUM(NULL) FROM integers
+----
+0
+NULL
+NULL
+NULL
+NULL
+
+
diff --git a/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test_ignore b/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test_ignore
index 272dc6a7ce..9f2eb6b6bf 100644
--- a/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test_ignore
+++ b/modules/runner/src/integrationTest/sql/aggregate/aggregates/test_scalar_aggr.test_ignore
@@ -1,7 +1,8 @@
# name: test/sql/aggregate/aggregates/test_scalar_aggr.test
# description: Test aggregates with scalar inputs
# group: [aggregates]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14636
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-17437
# test aggregate on scalar values
query IIII
diff --git a/modules/runner/src/integrationTest/sql/function/generic/test_nvl.test_ignore b/modules/runner/src/integrationTest/sql/function/generic/test_nvl.test
similarity index 83%
rename from modules/runner/src/integrationTest/sql/function/generic/test_nvl.test_ignore
rename to modules/runner/src/integrationTest/sql/function/generic/test_nvl.test
index 28c99a3aa4..fa7cd4f55a 100644
--- a/modules/runner/src/integrationTest/sql/function/generic/test_nvl.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/generic/test_nvl.test
@@ -1,7 +1,6 @@
# name: test/sql/function/generic/test_nvl.test
# description: Test NVL function
# group: [generic]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
query I
SELECT NVL(102, 101)
diff --git a/modules/runner/src/integrationTest/sql/function/numeric/test_truncate.test_ignore b/modules/runner/src/integrationTest/sql/function/numeric/test_truncate.test
similarity index 88%
rename from modules/runner/src/integrationTest/sql/function/numeric/test_truncate.test_ignore
rename to modules/runner/src/integrationTest/sql/function/numeric/test_truncate.test
index bce2d84b9c..b9d6266815 100644
--- a/modules/runner/src/integrationTest/sql/function/numeric/test_truncate.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/numeric/test_truncate.test
@@ -1,7 +1,6 @@
# name: test/sql/function/numeric/test_truncate.test
# description: Test TRUNCATE function
# group: [numeric]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
query T
SELECT TRUNCATE(-123.345)
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_caseconvert.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_caseconvert.test
similarity index 96%
rename from modules/runner/src/integrationTest/sql/function/string/test_caseconvert.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_caseconvert.test
index 1b0517e949..695b22da3f 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_caseconvert.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_caseconvert.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_caseconvert.test
# description: UPPER/LOWER test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test NULL constant
query TT
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_initcap.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_initcap.test
similarity index 89%
rename from modules/runner/src/integrationTest/sql/function/string/test_initcap.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_initcap.test
index a7c6b8a306..4d76d1f3dd 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_initcap.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_initcap.test
@@ -1,7 +1,6 @@
# name: test/sql/function/test/test_initcap.test
# description: Just simple test to check support of INITCAP function
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
query T
SELECT initcap('just cHEck how iNItCap function is works! 22')
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_left.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_left.test
similarity index 95%
rename from modules/runner/src/integrationTest/sql/function/string/test_left.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_left.test
index 9c56f1cc09..ff8c83d8d7 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_left.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_left.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_left.test
# description: LEFT test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test LEFT on positive positions
query TTTTT
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_repeat.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_repeat.test
similarity index 95%
rename from modules/runner/src/integrationTest/sql/function/string/test_repeat.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_repeat.test
index 6e482b7e73..39ee277073 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_repeat.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_repeat.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_repeat.test
# description: REPEAT test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test repeat on NULLs
query TTT
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_replace.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_replace.test
similarity index 95%
rename from modules/runner/src/integrationTest/sql/function/string/test_replace.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_replace.test
index 71eae08d59..f03cc743fb 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_replace.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_replace.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_replace.test
# description: REPLACE test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test replace on NULLs
query T
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_reverse.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_reverse.test
similarity index 93%
rename from modules/runner/src/integrationTest/sql/function/string/test_reverse.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_reverse.test
index 18c24eb1f1..de59368175 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_reverse.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_reverse.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_reverse.test
# description: REVERSE test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test reverse on scalars
query TTTT
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_right.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_right.test
similarity index 95%
rename from modules/runner/src/integrationTest/sql/function/string/test_right.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_right.test
index cae7f2e167..bbaf401637 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_right.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_right.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_right.test
# description: RIGHT test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test RIGHT on positive positions
query TTTTT
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_substring.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_substring.test
similarity index 97%
rename from modules/runner/src/integrationTest/sql/function/string/test_substring.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_substring.test
index 996d03fdf0..ebb7c1b055 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_substring.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_substring.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_substring.test
# description: Substring test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
statement ok
CREATE TABLE strings(id INTEGER, s VARCHAR, off INTEGER, length INTEGER);
diff --git a/modules/runner/src/integrationTest/sql/function/string/test_trim.test_ignore b/modules/runner/src/integrationTest/sql/function/string/test_trim.test
similarity index 97%
rename from modules/runner/src/integrationTest/sql/function/string/test_trim.test_ignore
rename to modules/runner/src/integrationTest/sql/function/string/test_trim.test
index 1122222c45..8a78883c01 100644
--- a/modules/runner/src/integrationTest/sql/function/string/test_trim.test_ignore
+++ b/modules/runner/src/integrationTest/sql/function/string/test_trim.test
@@ -1,7 +1,6 @@
# name: test/sql/function/string/test_trim.test
# description: LTRIM/RTRIM/TRIM test
# group: [string]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
# test ltrim on scalars
query TTTTTTT
diff --git a/modules/runner/src/integrationTest/sql/types/null/test_is_null.test_ignore b/modules/runner/src/integrationTest/sql/types/null/test_is_null.test
similarity index 90%
rename from modules/runner/src/integrationTest/sql/types/null/test_is_null.test_ignore
rename to modules/runner/src/integrationTest/sql/types/null/test_is_null.test
index 21c073405e..41bf190e2d 100644
--- a/modules/runner/src/integrationTest/sql/types/null/test_is_null.test_ignore
+++ b/modules/runner/src/integrationTest/sql/types/null/test_is_null.test
@@ -1,7 +1,6 @@
# name: test/sql/types/null/test_is_null.test
# description: Test IS NULL
# group: [null]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
statement ok
CREATE TABLE test (a INTEGER, b INTEGER);
diff --git a/modules/runner/src/integrationTest/sql/types/null/test_null.test_ignore b/modules/runner/src/integrationTest/sql/types/null/test_null.test
similarity index 92%
rename from modules/runner/src/integrationTest/sql/types/null/test_null.test_ignore
rename to modules/runner/src/integrationTest/sql/types/null/test_null.test
index 7e386958b0..b49b5f40ed 100644
--- a/modules/runner/src/integrationTest/sql/types/null/test_null.test_ignore
+++ b/modules/runner/src/integrationTest/sql/types/null/test_null.test
@@ -1,7 +1,6 @@
# name: test/sql/types/null/test_null.test
# description: Test standard NULL handling
# group: [null]
-# Ignored: https://issues.apache.org/jira/browse/IGNITE-17271
statement ok
PRAGMA enable_verification