This is an automated email from the ASF dual-hosted git repository.
jooger 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 fc35f5ec36 IGNITE-21959: Extend test coverage for SQL
E021-12(Character comparison) (#3907)
fc35f5ec36 is described below
commit fc35f5ec360cb53a77ed7ebef4fc9f24fb4216f5
Author: Max Zhuravkov <[email protected]>
AuthorDate: Thu Jun 13 11:19:06 2024 +0400
IGNITE-21959: Extend test coverage for SQL E021-12(Character comparison)
(#3907)
---
.../sql/types/char/test_char_comparison.test | 68 ++++++++++++++++++++++
.../sql/types/string/test_string_comparison.test | 43 ++++++++++++++
2 files changed, 111 insertions(+)
diff --git
a/modules/sql-engine/src/integrationTest/sql/types/char/test_char_comparison.test
b/modules/sql-engine/src/integrationTest/sql/types/char/test_char_comparison.test
new file mode 100644
index 0000000000..8b48de5a89
--- /dev/null
+++
b/modules/sql-engine/src/integrationTest/sql/types/char/test_char_comparison.test
@@ -0,0 +1,68 @@
+# name: test/sql/types/char/test_char_comparison.test
+# feature: E021-12 (Character comparison)
+# group: [char]
+
+# Literal have type char(n), that's why trailing whitespace is ignored
+
+# https://issues.apache.org/jira/browse/IGNITE-22472
+skipif ignite3
+query T
+SELECT 'a'::char(1) < 'a'::char(2)
+----
+false
+
+# https://issues.apache.org/jira/browse/IGNITE-22472
+skipif ignite3
+query T
+SELECT 'a'::char(2) > 'a'::char(1)
+----
+false
+
+query TT
+SELECT 'a'::char(1) <= 'a'::char(2), 'a'::char(2) >= 'a'::char(1)
+----
+true true
+
+query TT
+SELECT 'a'::char(1) = 'a'::char(2), 'a'::char(1) != 'a'::char(2)
+----
+true false
+
+query TT
+SELECT 'a'::char(2) = 'a'::char(1), 'a'::char(1) != 'a'::char(2)
+----
+true false
+
+query TT
+SELECT 'a'::char(1) <= 'a'::char(2), 'a'::char(2) >= 'a'::char(1)
+----
+true true
+
+query TTTT
+SELECT 'b' > 'a', 'b' >= 'a', 'b' < 'a', 'b' != 'a'
+----
+true true false true
+
+# https://issues.apache.org/jira/browse/IGNITE-22472
+skipif ignite3
+query T
+'a ' > 'a'
+----
+false
+
+# https://issues.apache.org/jira/browse/IGNITE-22472
+skipif ignite3
+query T
+'a ' < 'a'
+----
+false
+
+query TT
+SELECT 'a ' >= 'a', 'a ' != 'a'
+----
+true false
+
+query TTTT
+SELECT ' a' > 'a', ' a' >= 'a', ' a' < 'a', ' a' != 'a'
+----
+false false true true
diff --git
a/modules/sql-engine/src/integrationTest/sql/types/string/test_string_comparison.test
b/modules/sql-engine/src/integrationTest/sql/types/string/test_string_comparison.test
new file mode 100644
index 0000000000..9fdb8b9e53
--- /dev/null
+++
b/modules/sql-engine/src/integrationTest/sql/types/string/test_string_comparison.test
@@ -0,0 +1,43 @@
+# name: test/sql/types/string/test_string_comparison.test
+# feature: E021-12 (Character comparison)
+# group: [string]
+
+query TT
+SELECT 'a'::varchar(1) < 'a'::varchar(2), 'a'::varchar(2) > 'a'::varchar(1)
+----
+false false
+
+query TT
+SELECT 'a'::varchar(1) <= 'a'::varchar(2), 'a'::varchar(2) >= 'a'::varchar(1)
+----
+true true
+
+query TT
+SELECT 'a'::varchar(1) = 'a'::varchar(2), 'a'::varchar(1) != 'a'::varchar(2)
+----
+true false
+
+query TT
+SELECT 'a'::varchar(2) = 'a'::varchar(1), 'a'::varchar(1) != 'a'::varchar(2)
+----
+true false
+
+query TT
+SELECT 'a'::varchar(1) <= 'a'::varchar(2), 'a'::varchar(2) >= 'a'::varchar(1)
+----
+true true
+
+query TTTT
+SELECT 'b'::varchar > 'a'::varchar, 'b'::varchar >= 'a'::varchar, 'b'::varchar
< 'a'::varchar, 'b'::varchar != 'a'::varchar
+----
+true true false true
+
+query TTTT
+SELECT 'a '::varchar > 'a'::varchar, 'a '::varchar >= 'a'::varchar, 'a
'::varchar < 'a'::varchar, 'a '::varchar != 'a'::varchar
+----
+true true false true
+
+query TTTT
+SELECT ' a'::varchar > 'a'::varchar, ' a'::varchar >= 'a'::varchar, '
a'::varchar < 'a'::varchar, ' a'::varchar != 'a'::varchar
+----
+false false true true
