This is an automated email from the ASF dual-hosted git repository.
amashenkov pushed a commit to branch ignite-21914
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
commit a7a6348608a6edefe4e45155514cfdff69655dd5
Author: amashenkov <andrey.mashen...@gmail.com>
AuthorDate: Mon Apr 8 15:04:16 2024 +0300
Add test.
---
.../generic/test_in_list_of_single_element.test | 36 ++++++++++++++++++++++
1 file changed, 36 insertions(+)
diff --git
a/modules/sql-engine/src/integrationTest/sql/function/generic/test_in_list_of_single_element.test
b/modules/sql-engine/src/integrationTest/sql/function/generic/test_in_list_of_single_element.test
new file mode 100644
index 0000000000..69d1685b17
--- /dev/null
+++
b/modules/sql-engine/src/integrationTest/sql/function/generic/test_in_list_of_single_element.test
@@ -0,0 +1,36 @@
+# name: test/sql/filter/test_in_list_of_single_element.test
+# description: Test IN predicate with list of single element.
+# feature: T631
+# group: [filter]
+
+
+statement ok
+CREATE TABLE integers(i INTEGER)
+
+statement ok
+INSERT INTO integers VALUES (1), (NULL);
+
+query III
+SELECT 1 IN (1), 1 IN (NULL), NULL IN (NULL)
+----
+TRUE, FALSE, FALSE
+
+query I rowsort
+SELECT * FROM integers WHERE 1 IN (1)
+----
+NULL
+1
+
+query I
+SELECT * FROM integers WHERE i IN (1)
+----
+1
+
+query I
+SELECT * FROM integers WHERE i IN (2)
+----
+
+query I
+SELECT * FROM integers WHERE i IN (NULL)
+----
+
