0001-insert-overriding-set-case.patch
application/octet-stream
Filename: 0001-insert-overriding-set-case.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: unified
Series: patch 0001
| File | + | − |
|---|---|---|
| src/test/regress/expected/identity.out | 22 | 0 |
| src/test/regress/sql/identity.sql | 15 | 0 |
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.32.0 (Apple Git-132)