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 8737d92818 IGNITE-22060: Enable sql logic tests for NOT NULL
constraint violation (#3618)
8737d92818 is described below
commit 8737d92818b655d0dc9f91ee0659c4041fd8f544
Author: Max Zhuravkov <[email protected]>
AuthorDate: Wed Apr 17 14:23:28 2024 +0300
IGNITE-22060: Enable sql logic tests for NOT NULL constraint violation
(#3618)
---
.../sql/contstraint/test_not_null_contraint.test | 60 ----------------------
1 file changed, 60 deletions(-)
diff --git
a/modules/sql-engine/src/integrationTest/sql/contstraint/test_not_null_contraint.test
b/modules/sql-engine/src/integrationTest/sql/contstraint/test_not_null_contraint.test
index 4eb79f9737..4d722c3723 100644
---
a/modules/sql-engine/src/integrationTest/sql/contstraint/test_not_null_contraint.test
+++
b/modules/sql-engine/src/integrationTest/sql/contstraint/test_not_null_contraint.test
@@ -58,48 +58,30 @@ INSERT INTO t1 VALUES(1, true, 2, 3, 4, 5, 6, 7, 8, '9999',
'1010', x'1111', x'1
# INSERT INTO ... SELECT
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'BOOL_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, NULL, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', x'1111',
x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'TINYINT_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, NULL, 3, 4, 5, 6, 7, 8, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'SMALLINT_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, NULL, 4, 5, 6, 7, 8, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'INT_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, NULL, 5, 6, 7, 8, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'BIGINT_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, NULL, 6, 7, 8, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'REAL_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, NULL, 7, 8, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'DOUBLE_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, NULL, 8, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'DECIMAL_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, NULL, '9999', '1010',
x'1111', x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'CHAR_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, NULL, '1010', x'1111',
x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
@@ -108,28 +90,18 @@ skipif ignite3
statement error: Column 'VARCHAR_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, '9999', NULL, x'1111',
x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'BINARY_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', NULL,
x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'VARBINARY_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', x'1111',
NULL, '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'DATE_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', x'1111',
x'1212', NULL, '12:00'::TIME, '00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'TIME_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', x'1111',
x'1212', '2000-01-01'::DATE, NULL, '00112233-4455-6677-8899-aabbccddeeff'::UUID
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'UUID_COL' does not allow NULLs
INSERT INTO t1 SELECT 1, true, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', x'1111',
x'1212', '2000-01-01'::DATE, '12:00'::TIME, NULL
@@ -143,78 +115,48 @@ UPDATE t1 SET bool_col = NULL
statement ok
INSERT INTO t1 VALUES(1, true, 2, 3, 4, 5, 6, 7, 8, '9999', '1010', x'1111',
x'1212', '2000-01-01'::DATE, '12:00'::TIME,
'00112233-4455-6677-8899-aabbccddeeff'::UUID);
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'BOOL_COL' does not allow NULLs
UPDATE t1 SET bool_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'TINYINT_COL' does not allow NULLs
UPDATE t1 SET tinyint_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'SMALLINT_COL' does not allow NULLs
UPDATE t1 SET smallint_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'INT_COL' does not allow NULLs
UPDATE t1 SET int_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'BIGINT_COL' does not allow NULLs
UPDATE t1 SET bigint_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'REAL_COL' does not allow NULLs
UPDATE t1 SET real_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'DOUBLE_COL' does not allow NULLs
UPDATE t1 SET double_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'DECIMAL_COL' does not allow NULLs
UPDATE t1 SET decimal_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'CHAR_COL' does not allow NULLs
UPDATE t1 SET char_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'VARCHAR_COL' does not allow NULLs
UPDATE t1 SET varchar_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'BINARY_COL' does not allow NULLs
UPDATE t1 SET binary_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'VARBINARY_COL' does not allow NULLs
UPDATE t1 SET varbinary_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'DATE_COL' does not allow NULLs
UPDATE t1 SET date_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'TIME_COL' does not allow NULLs
UPDATE t1 SET time_col = NULL
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'UUID_COL' does not allow NULLs
UPDATE t1 SET uuid_col = NULL
@@ -229,7 +171,5 @@ MERGE INTO t2 dst USING t1 src ON dst.id = src.id WHEN NOT
MATCHED THEN INSERT (
statement ok
INSERT INTO t2 VALUES(1, 42)
-skipif ignite3
-# https://issues.apache.org/jira/browse/IGNITE-22015
statement error: Column 'VAL' does not allow NULLs
MERGE INTO t2 dst USING t1 src ON dst.id = src.id WHEN MATCHED THEN UPDATE SET
val = NULL
