(ignite-3) branch ignite-21914 created (now 49f62fe954)

[am...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

amashenkov pushed a change to branch ignite-21914
in repository https://gitbox.apache.org/repos/asf/ignite-3.git


      at 49f62fe954 Add test.

This branch includes the following new commits:

     new 49f62fe954 Add test.

The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.

(ignite-3) 01/01: Add test.

[am...@apache.org]

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 49f62fe954df0047c0bb4ab5f384f6d87b34dcd2
Author: amashenkov <an...@gmail.com>
AuthorDate: Mon Apr 8 15:04:16 2024 +0300

    Add test.
---
 .../sql/filter/test_in_list_of_single_element.test | 31 ++++++++++++++++++++++
 1 file changed, 31 insertions(+)

diff --git a/modules/sql-engine/src/integrationTest/sql/filter/test_in_list_of_single_element.test b/modules/sql-engine/src/integrationTest/sql/filter/test_in_list_of_single_element.test
new file mode 100644
index 0000000000..6c4bc2177e
--- /dev/null
+++ b/modules/sql-engine/src/integrationTest/sql/filter/test_in_list_of_single_element.test
@@ -0,0 +1,31 @@
+# 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 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)
+----
+