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 <[email protected]> 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
