From 4c42f9fb4f4b596da9e1fc1b4d15009b6eb035a1 Mon Sep 17 00:00:00 2001 From: wenjing zeng Date: Fri, 21 Jan 2022 17:24:51 +0800 Subject: [PATCH 2/2] Since this feature adds INSERT OVERRIDING SET syntax, it is recommended to add some related testcases. Jan 21 wenjing zeng ( 111) Re: [PATCH] Implement INSERT SET syntax --- src/test/regress/expected/identity.out | 22 ++++++++++++++++++++++ src/test/regress/sql/identity.sql | 15 +++++++++++++++ 2 files changed, 37 insertions(+) diff --git a/src/test/regress/expected/identity.out b/src/test/regress/expected/identity.out index 99811570b7b..5dd211e4563 100644 --- a/src/test/regress/expected/identity.out +++ b/src/test/regress/expected/identity.out @@ -160,6 +160,28 @@ SELECT * FROM itest5; 16 | iii (21 rows) +TRUNCATE TABLE itest5; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET a = -1, b = 'aa'; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET a = DEFAULT, b = 'bb'; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET a = DEFAULT; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET b = 'cc'; +INSERT INTO itest5 OVERRIDING USER VALUE SET a = -1, b = 'aaa'; +INSERT INTO itest5 OVERRIDING USER VALUE SET a = DEFAULT, b = 'bbb'; +INSERT INTO itest5 OVERRIDING USER VALUE SET a = DEFAULT; +INSERT INTO itest5 OVERRIDING USER VALUE SET b = 'ccc'; +SELECT * FROM itest5; + a | b +----+----- + -1 | aa + 17 | bb + 18 | + 19 | cc + 20 | aaa + 21 | bbb + 22 | + 23 | ccc +(8 rows) + DROP TABLE itest5; INSERT INTO itest3 VALUES (DEFAULT, 'a'); INSERT INTO itest3 VALUES (DEFAULT, 'b'), (DEFAULT, 'c'); diff --git a/src/test/regress/sql/identity.sql b/src/test/regress/sql/identity.sql index 52800f265c2..a659d9e9405 100644 --- a/src/test/regress/sql/identity.sql +++ b/src/test/regress/sql/identity.sql @@ -77,6 +77,21 @@ INSERT INTO itest5 OVERRIDING USER VALUE VALUES (-5, 'fff'), (DEFAULT, 'ggg'); INSERT INTO itest5 OVERRIDING USER VALUE VALUES (DEFAULT, 'hhh'), (DEFAULT, 'iii'); SELECT * FROM itest5; + +TRUNCATE TABLE itest5; + +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET a = -1, b = 'aa'; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET a = DEFAULT, b = 'bb'; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET a = DEFAULT; +INSERT INTO itest5 OVERRIDING SYSTEM VALUE SET b = 'cc'; + +INSERT INTO itest5 OVERRIDING USER VALUE SET a = -1, b = 'aaa'; +INSERT INTO itest5 OVERRIDING USER VALUE SET a = DEFAULT, b = 'bbb'; +INSERT INTO itest5 OVERRIDING USER VALUE SET a = DEFAULT; +INSERT INTO itest5 OVERRIDING USER VALUE SET b = 'ccc'; + +SELECT * FROM itest5; + DROP TABLE itest5; INSERT INTO itest3 VALUES (DEFAULT, 'a'); -- 2.17.1