This is an automated email from the ASF dual-hosted git repository.
amashenkov 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 a48cd24ca3 IGNITE-18488 SQL: SUBSTRING function does not support NULL
values (#1566)
a48cd24ca3 is described below
commit a48cd24ca38d0856d9e7f056f5c6c6b14c16929d
Author: Andrew V. Mashenkov <[email protected]>
AuthorDate: Wed Jan 25 11:16:24 2023 +0300
IGNITE-18488 SQL: SUBSTRING function does not support NULL values (#1566)
---
.../internal/jdbc/proto/event/JdbcColumnMeta.java | 5 ++
.../apache/ignite/jdbc/ItJdbcMetadataSelfTest.java | 53 ++++++++++++++++------
.../{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 -
18 files changed, 95 insertions(+), 29 deletions(-)
diff --git
a/modules/client-common/src/main/java/org/apache/ignite/internal/jdbc/proto/event/JdbcColumnMeta.java
b/modules/client-common/src/main/java/org/apache/ignite/internal/jdbc/proto/event/JdbcColumnMeta.java
index ed670ff3df..f20b629e42 100644
---
a/modules/client-common/src/main/java/org/apache/ignite/internal/jdbc/proto/event/JdbcColumnMeta.java
+++
b/modules/client-common/src/main/java/org/apache/ignite/internal/jdbc/proto/event/JdbcColumnMeta.java
@@ -25,6 +25,7 @@ import static java.sql.Types.DECIMAL;
import static java.sql.Types.DOUBLE;
import static java.sql.Types.FLOAT;
import static java.sql.Types.INTEGER;
+import static java.sql.Types.NULL;
import static java.sql.Types.OTHER;
import static java.sql.Types.SMALLINT;
import static java.sql.Types.TIME;
@@ -358,6 +359,8 @@ public class JdbcColumnMeta extends Response {
return DATE;
} else if (BigDecimal.class.getName().equals(cls)) {
return DECIMAL;
+ } else if (Void.class.getName().equals(cls)) {
+ return NULL;
} else {
return OTHER;
}
@@ -396,6 +399,8 @@ public class JdbcColumnMeta extends Response {
return "DATE";
} else if (BigDecimal.class.getName().equals(cls)) {
return "DECIMAL";
+ } else if (Void.class.getName().equals(cls)) {
+ return "NULL";
} else {
return "OTHER";
}
diff --git
a/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcMetadataSelfTest.java
b/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcMetadataSelfTest.java
index b41bda5da2..63966c51f8 100644
---
a/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcMetadataSelfTest.java
+++
b/modules/jdbc/src/integrationTest/java/org/apache/ignite/jdbc/ItJdbcMetadataSelfTest.java
@@ -20,6 +20,7 @@ package org.apache.ignite.jdbc;
import static java.sql.Types.DATE;
import static java.sql.Types.DECIMAL;
import static java.sql.Types.INTEGER;
+import static java.sql.Types.NULL;
import static java.sql.Types.VARCHAR;
import static org.junit.jupiter.api.Assertions.assertEquals;
import static org.junit.jupiter.api.Assertions.assertFalse;
@@ -64,6 +65,30 @@ public class ItJdbcMetadataSelfTest extends
AbstractJdbcSelfTest {
}
}
+ @Test
+ public void testNullValuesMetaData() throws Exception {
+ Statement stmt = DriverManager.getConnection(URL).createStatement();
+
+ ResultSet rs = stmt.executeQuery(
+ "select NULL, substring(null, 1, 2)");
+
+ assertNotNull(rs);
+
+ ResultSetMetaData meta = rs.getMetaData();
+
+ assertNotNull(meta);
+
+ assertEquals(2, meta.getColumnCount());
+
+ assertEquals(NULL, meta.getColumnType(1));
+ assertEquals("NULL", meta.getColumnTypeName(1));
+ assertEquals("java.lang.Void", meta.getColumnClassName(1));
+
+ assertEquals(NULL, meta.getColumnType(2));
+ assertEquals("NULL", meta.getColumnTypeName(2));
+ assertEquals("java.lang.Void", meta.getColumnClassName(2));
+ }
+
@Test
public void testResultSetMetaData() throws Exception {
Statement stmt = DriverManager.getConnection(URL).createStatement();
@@ -83,15 +108,15 @@ public class ItJdbcMetadataSelfTest extends
AbstractJdbcSelfTest {
assertEquals("name".toUpperCase(),
meta.getColumnName(1).toUpperCase());
assertEquals("name".toUpperCase(),
meta.getColumnLabel(1).toUpperCase());
assertEquals(VARCHAR, meta.getColumnType(1));
- assertEquals(meta.getColumnTypeName(1), "VARCHAR");
- assertEquals(meta.getColumnClassName(1), "java.lang.String");
+ assertEquals("VARCHAR", meta.getColumnTypeName(1));
+ assertEquals("java.lang.String", meta.getColumnClassName(1));
assertEquals("Organization".toUpperCase(),
meta.getTableName(2).toUpperCase());
assertEquals("id".toUpperCase(), meta.getColumnName(2).toUpperCase());
assertEquals("orgId".toUpperCase(),
meta.getColumnLabel(2).toUpperCase());
assertEquals(INTEGER, meta.getColumnType(2));
- assertEquals(meta.getColumnTypeName(2), "INTEGER");
- assertEquals(meta.getColumnClassName(2), "java.lang.Integer");
+ assertEquals("INTEGER", meta.getColumnTypeName(2));
+ assertEquals("java.lang.Integer", meta.getColumnClassName(2));
}
@Test
@@ -114,15 +139,15 @@ public class ItJdbcMetadataSelfTest extends
AbstractJdbcSelfTest {
assertEquals("DECIMAL_COL", meta.getColumnName(1).toUpperCase());
assertEquals("DECIMAL_COL", meta.getColumnLabel(1).toUpperCase());
assertEquals(DECIMAL, meta.getColumnType(1));
- assertEquals(meta.getColumnTypeName(1), "DECIMAL");
- assertEquals(meta.getColumnClassName(1), "java.math.BigDecimal");
+ assertEquals("DECIMAL", meta.getColumnTypeName(1));
+ assertEquals("java.math.BigDecimal", meta.getColumnClassName(1));
assertEquals("METATEST", meta.getTableName(2).toUpperCase());
assertEquals("DATE_COL", meta.getColumnName(2).toUpperCase());
assertEquals("DATE_COL", meta.getColumnLabel(2).toUpperCase());
assertEquals(DATE, meta.getColumnType(2));
- assertEquals(meta.getColumnTypeName(2), "DATE");
- assertEquals(meta.getColumnClassName(2), "java.sql.Date");
+ assertEquals("DATE", meta.getColumnTypeName(2));
+ assertEquals("java.sql.Date", meta.getColumnClassName(2));
} finally {
stmt.execute("DROP TABLE METATEST;");
}
@@ -205,15 +230,15 @@ public class ItJdbcMetadataSelfTest extends
AbstractJdbcSelfTest {
if ("ID".equals(name)) {
assertEquals(INTEGER, rs.getInt("DATA_TYPE"));
- assertEquals(rs.getString("TYPE_NAME"), "INTEGER");
+ assertEquals("INTEGER", rs.getString("TYPE_NAME"));
assertEquals(0, rs.getInt("NULLABLE"));
} else if ("NAME".equals(name)) {
assertEquals(VARCHAR, rs.getInt("DATA_TYPE"));
- assertEquals(rs.getString("TYPE_NAME"), "VARCHAR");
+ assertEquals("VARCHAR", rs.getString("TYPE_NAME"));
assertEquals(1, rs.getInt("NULLABLE"));
} else if ("BIGDATA".equals(name)) {
assertEquals(DECIMAL, rs.getInt("DATA_TYPE"));
- assertEquals(rs.getString("TYPE_NAME"), "DECIMAL");
+ assertEquals("DECIMAL", rs.getString("TYPE_NAME"));
assertEquals(1, rs.getInt("NULLABLE"));
assertEquals(10, rs.getInt("DECIMAL_DIGITS"));
assertEquals(20, rs.getInt("COLUMN_SIZE"));
@@ -249,11 +274,11 @@ public class ItJdbcMetadataSelfTest extends
AbstractJdbcSelfTest {
if ("NAME".equals(name)) {
assertEquals(VARCHAR, rs.getInt("DATA_TYPE"));
- assertEquals(rs.getString("TYPE_NAME"), "VARCHAR");
+ assertEquals("VARCHAR", rs.getString("TYPE_NAME"));
assertEquals(1, rs.getInt("NULLABLE"));
} else if ("AGE".equals(name)) {
assertEquals(INTEGER, rs.getInt("DATA_TYPE"));
- assertEquals(rs.getString("TYPE_NAME"), "INTEGER");
+ assertEquals("INTEGER", rs.getString("TYPE_NAME"));
assertEquals(1, rs.getInt("NULLABLE"));
} else if ("ORGID".equals(name)) {
assertEquals(INTEGER, rs.getInt("DATA_TYPE"));
@@ -318,7 +343,7 @@ public class ItJdbcMetadataSelfTest extends
AbstractJdbcSelfTest {
int cnt = 0;
while (rs.next()) {
- assertEquals(rs.getString("COLUMN_NAME"), "ORGID");
+ assertEquals("ORGID", rs.getString("COLUMN_NAME"));
cnt++;
}
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