NotificationsYou must be signed in to change notification settings
Fork28
Star153

Commit21ea8b5

committed

more tests for RETURNING (add new column)

1 parent6cbe273 commit21ea8b5Copy full SHA for 21ea8b5

File tree

2 files changed

+194

-3

lines changed

expected
- pathman_inserts.out
sql
- pathman_inserts.sql

2 files changed

+194

-3

lines changed

`‎expected/pathman_inserts.out‎`

Lines changed: 172 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -327,7 +327,7 @@ SELECT *, tableoid::regclass FROM test_inserts.storage ORDER BY b, d;`
`327`	`327`	`/* drop data */`
`328`	`328`	`TRUNCATE test_inserts.storage;`
`329`	`329`	`/* one more time! */`
`330`		`-INSERT INTO test_inserts.storage SELECT i, i FROM generate_series(-2, 120) i;`
	`330`	`+INSERT INTO test_inserts.storage(b, d)SELECT i, i FROM generate_series(-2, 120) i;`
`331`	`331`	`SELECT *, tableoid::regclass FROM test_inserts.storage ORDER BY b, d;`
`332`	`332`	`b \| d \| tableoid`
`333`	`333`	`-----+-----+-------------------------`
`@@ -456,6 +456,177 @@ SELECT *, tableoid::regclass FROM test_inserts.storage ORDER BY b, d;`
`456`	`456`	`120 \| 120 \| test_inserts.storage_13`
`457`	`457`	`(123 rows)`
`458`	`458`
	`459`	`+/* drop data */`
	`460`	`+TRUNCATE test_inserts.storage;`
	`461`	`+/* add new column */`
	`462`	`+ALTER TABLE test_inserts.storage ADD COLUMN e INT8 NOT NULL;`
	`463`	`+/* one more time! x2 */`
	`464`	`+INSERT INTO test_inserts.storage (b, d, e) SELECT i, i, i FROM generate_series(-2, 120) i;`
	`465`	`+SELECT *, tableoid::regclass FROM test_inserts.storage ORDER BY b, d;`
	`466`	`+ b \| d \| e \| tableoid`
	`467`	`+-----+-----+-----+-------------------------`
	`468`	`+ -2 \| -2 \| -2 \| test_inserts.storage_11`
	`469`	`+ -1 \| -1 \| -1 \| test_inserts.storage_11`
	`470`	`+ 0 \| 0 \| 0 \| test_inserts.storage_11`
	`471`	`+ 1 \| 1 \| 1 \| test_inserts.storage_1`
	`472`	`+ 2 \| 2 \| 2 \| test_inserts.storage_1`
	`473`	`+ 3 \| 3 \| 3 \| test_inserts.storage_1`
	`474`	`+ 4 \| 4 \| 4 \| test_inserts.storage_1`
	`475`	`+ 5 \| 5 \| 5 \| test_inserts.storage_1`
	`476`	`+ 6 \| 6 \| 6 \| test_inserts.storage_1`
	`477`	`+ 7 \| 7 \| 7 \| test_inserts.storage_1`
	`478`	`+ 8 \| 8 \| 8 \| test_inserts.storage_1`
	`479`	`+ 9 \| 9 \| 9 \| test_inserts.storage_1`
	`480`	`+ 10 \| 10 \| 10 \| test_inserts.storage_1`
	`481`	`+ 11 \| 11 \| 11 \| test_inserts.storage_2`
	`482`	`+ 12 \| 12 \| 12 \| test_inserts.storage_2`
	`483`	`+ 13 \| 13 \| 13 \| test_inserts.storage_2`
	`484`	`+ 14 \| 14 \| 14 \| test_inserts.storage_2`
	`485`	`+ 15 \| 15 \| 15 \| test_inserts.storage_2`
	`486`	`+ 16 \| 16 \| 16 \| test_inserts.storage_2`
	`487`	`+ 17 \| 17 \| 17 \| test_inserts.storage_2`
	`488`	`+ 18 \| 18 \| 18 \| test_inserts.storage_2`
	`489`	`+ 19 \| 19 \| 19 \| test_inserts.storage_2`
	`490`	`+ 20 \| 20 \| 20 \| test_inserts.storage_2`
	`491`	`+ 21 \| 21 \| 21 \| test_inserts.storage_3`
	`492`	`+ 22 \| 22 \| 22 \| test_inserts.storage_3`
	`493`	`+ 23 \| 23 \| 23 \| test_inserts.storage_3`
	`494`	`+ 24 \| 24 \| 24 \| test_inserts.storage_3`
	`495`	`+ 25 \| 25 \| 25 \| test_inserts.storage_3`
	`496`	`+ 26 \| 26 \| 26 \| test_inserts.storage_3`
	`497`	`+ 27 \| 27 \| 27 \| test_inserts.storage_3`
	`498`	`+ 28 \| 28 \| 28 \| test_inserts.storage_3`
	`499`	`+ 29 \| 29 \| 29 \| test_inserts.storage_3`
	`500`	`+ 30 \| 30 \| 30 \| test_inserts.storage_3`
	`501`	`+ 31 \| 31 \| 31 \| test_inserts.storage_4`
	`502`	`+ 32 \| 32 \| 32 \| test_inserts.storage_4`
	`503`	`+ 33 \| 33 \| 33 \| test_inserts.storage_4`
	`504`	`+ 34 \| 34 \| 34 \| test_inserts.storage_4`
	`505`	`+ 35 \| 35 \| 35 \| test_inserts.storage_4`
	`506`	`+ 36 \| 36 \| 36 \| test_inserts.storage_4`
	`507`	`+ 37 \| 37 \| 37 \| test_inserts.storage_4`
	`508`	`+ 38 \| 38 \| 38 \| test_inserts.storage_4`
	`509`	`+ 39 \| 39 \| 39 \| test_inserts.storage_4`
	`510`	`+ 40 \| 40 \| 40 \| test_inserts.storage_4`
	`511`	`+ 41 \| 41 \| 41 \| test_inserts.storage_5`
	`512`	`+ 42 \| 42 \| 42 \| test_inserts.storage_5`
	`513`	`+ 43 \| 43 \| 43 \| test_inserts.storage_5`
	`514`	`+ 44 \| 44 \| 44 \| test_inserts.storage_5`
	`515`	`+ 45 \| 45 \| 45 \| test_inserts.storage_5`
	`516`	`+ 46 \| 46 \| 46 \| test_inserts.storage_5`
	`517`	`+ 47 \| 47 \| 47 \| test_inserts.storage_5`
	`518`	`+ 48 \| 48 \| 48 \| test_inserts.storage_5`
	`519`	`+ 49 \| 49 \| 49 \| test_inserts.storage_5`
	`520`	`+ 50 \| 50 \| 50 \| test_inserts.storage_5`
	`521`	`+ 51 \| 51 \| 51 \| test_inserts.storage_6`
	`522`	`+ 52 \| 52 \| 52 \| test_inserts.storage_6`
	`523`	`+ 53 \| 53 \| 53 \| test_inserts.storage_6`
	`524`	`+ 54 \| 54 \| 54 \| test_inserts.storage_6`
	`525`	`+ 55 \| 55 \| 55 \| test_inserts.storage_6`
	`526`	`+ 56 \| 56 \| 56 \| test_inserts.storage_6`
	`527`	`+ 57 \| 57 \| 57 \| test_inserts.storage_6`
	`528`	`+ 58 \| 58 \| 58 \| test_inserts.storage_6`
	`529`	`+ 59 \| 59 \| 59 \| test_inserts.storage_6`
	`530`	`+ 60 \| 60 \| 60 \| test_inserts.storage_6`
	`531`	`+ 61 \| 61 \| 61 \| test_inserts.storage_7`
	`532`	`+ 62 \| 62 \| 62 \| test_inserts.storage_7`
	`533`	`+ 63 \| 63 \| 63 \| test_inserts.storage_7`
	`534`	`+ 64 \| 64 \| 64 \| test_inserts.storage_7`
	`535`	`+ 65 \| 65 \| 65 \| test_inserts.storage_7`
	`536`	`+ 66 \| 66 \| 66 \| test_inserts.storage_7`
	`537`	`+ 67 \| 67 \| 67 \| test_inserts.storage_7`
	`538`	`+ 68 \| 68 \| 68 \| test_inserts.storage_7`
	`539`	`+ 69 \| 69 \| 69 \| test_inserts.storage_7`
	`540`	`+ 70 \| 70 \| 70 \| test_inserts.storage_7`
	`541`	`+ 71 \| 71 \| 71 \| test_inserts.storage_8`
	`542`	`+ 72 \| 72 \| 72 \| test_inserts.storage_8`
	`543`	`+ 73 \| 73 \| 73 \| test_inserts.storage_8`
	`544`	`+ 74 \| 74 \| 74 \| test_inserts.storage_8`
	`545`	`+ 75 \| 75 \| 75 \| test_inserts.storage_8`
	`546`	`+ 76 \| 76 \| 76 \| test_inserts.storage_8`
	`547`	`+ 77 \| 77 \| 77 \| test_inserts.storage_8`
	`548`	`+ 78 \| 78 \| 78 \| test_inserts.storage_8`
	`549`	`+ 79 \| 79 \| 79 \| test_inserts.storage_8`
	`550`	`+ 80 \| 80 \| 80 \| test_inserts.storage_8`
	`551`	`+ 81 \| 81 \| 81 \| test_inserts.storage_9`
	`552`	`+ 82 \| 82 \| 82 \| test_inserts.storage_9`
	`553`	`+ 83 \| 83 \| 83 \| test_inserts.storage_9`
	`554`	`+ 84 \| 84 \| 84 \| test_inserts.storage_9`
	`555`	`+ 85 \| 85 \| 85 \| test_inserts.storage_9`
	`556`	`+ 86 \| 86 \| 86 \| test_inserts.storage_9`
	`557`	`+ 87 \| 87 \| 87 \| test_inserts.storage_9`
	`558`	`+ 88 \| 88 \| 88 \| test_inserts.storage_9`
	`559`	`+ 89 \| 89 \| 89 \| test_inserts.storage_9`
	`560`	`+ 90 \| 90 \| 90 \| test_inserts.storage_9`
	`561`	`+ 91 \| 91 \| 91 \| test_inserts.storage_10`
	`562`	`+ 92 \| 92 \| 92 \| test_inserts.storage_10`
	`563`	`+ 93 \| 93 \| 93 \| test_inserts.storage_10`
	`564`	`+ 94 \| 94 \| 94 \| test_inserts.storage_10`
	`565`	`+ 95 \| 95 \| 95 \| test_inserts.storage_10`
	`566`	`+ 96 \| 96 \| 96 \| test_inserts.storage_10`
	`567`	`+ 97 \| 97 \| 97 \| test_inserts.storage_10`
	`568`	`+ 98 \| 98 \| 98 \| test_inserts.storage_10`
	`569`	`+ 99 \| 99 \| 99 \| test_inserts.storage_10`
	`570`	`+ 100 \| 100 \| 100 \| test_inserts.storage_10`
	`571`	`+ 101 \| 101 \| 101 \| test_inserts.storage_12`
	`572`	`+ 102 \| 102 \| 102 \| test_inserts.storage_12`
	`573`	`+ 103 \| 103 \| 103 \| test_inserts.storage_12`
	`574`	`+ 104 \| 104 \| 104 \| test_inserts.storage_12`
	`575`	`+ 105 \| 105 \| 105 \| test_inserts.storage_12`
	`576`	`+ 106 \| 106 \| 106 \| test_inserts.storage_12`
	`577`	`+ 107 \| 107 \| 107 \| test_inserts.storage_12`
	`578`	`+ 108 \| 108 \| 108 \| test_inserts.storage_12`
	`579`	`+ 109 \| 109 \| 109 \| test_inserts.storage_12`
	`580`	`+ 110 \| 110 \| 110 \| test_inserts.storage_12`
	`581`	`+ 111 \| 111 \| 111 \| test_inserts.storage_13`
	`582`	`+ 112 \| 112 \| 112 \| test_inserts.storage_13`
	`583`	`+ 113 \| 113 \| 113 \| test_inserts.storage_13`
	`584`	`+ 114 \| 114 \| 114 \| test_inserts.storage_13`
	`585`	`+ 115 \| 115 \| 115 \| test_inserts.storage_13`
	`586`	`+ 116 \| 116 \| 116 \| test_inserts.storage_13`
	`587`	`+ 117 \| 117 \| 117 \| test_inserts.storage_13`
	`588`	`+ 118 \| 118 \| 118 \| test_inserts.storage_13`
	`589`	`+ 119 \| 119 \| 119 \| test_inserts.storage_13`
	`590`	`+ 120 \| 120 \| 120 \| test_inserts.storage_13`
	`591`	`+(123 rows)`
	`592`	`+`
	`593`	`+/* drop data */`
	`594`	`+TRUNCATE test_inserts.storage;`
	`595`	`+/* now test RETURNING list using our new column 'e' */`
	`596`	`+INSERT INTO test_inserts.storage (b, d, e) SELECT i, i, i`
	`597`	`+FROM generate_series(-2, 130, 5) i`
	`598`	`+RETURNING e * 2, b, tableoid::regclass;`
	`599`	`+ ?column? \| b \| tableoid`
	`600`	`+----------+-----+-------------------------`
	`601`	`+ -4 \| -2 \| test_inserts.storage_11`
	`602`	`+ 6 \| 3 \| test_inserts.storage_1`
	`603`	`+ 16 \| 8 \| test_inserts.storage_1`
	`604`	`+ 26 \| 13 \| test_inserts.storage_2`
	`605`	`+ 36 \| 18 \| test_inserts.storage_2`
	`606`	`+ 46 \| 23 \| test_inserts.storage_3`
	`607`	`+ 56 \| 28 \| test_inserts.storage_3`
	`608`	`+ 66 \| 33 \| test_inserts.storage_4`
	`609`	`+ 76 \| 38 \| test_inserts.storage_4`
	`610`	`+ 86 \| 43 \| test_inserts.storage_5`
	`611`	`+ 96 \| 48 \| test_inserts.storage_5`
	`612`	`+ 106 \| 53 \| test_inserts.storage_6`
	`613`	`+ 116 \| 58 \| test_inserts.storage_6`
	`614`	`+ 126 \| 63 \| test_inserts.storage_7`
	`615`	`+ 136 \| 68 \| test_inserts.storage_7`
	`616`	`+ 146 \| 73 \| test_inserts.storage_8`
	`617`	`+ 156 \| 78 \| test_inserts.storage_8`
	`618`	`+ 166 \| 83 \| test_inserts.storage_9`
	`619`	`+ 176 \| 88 \| test_inserts.storage_9`
	`620`	`+ 186 \| 93 \| test_inserts.storage_10`
	`621`	`+ 196 \| 98 \| test_inserts.storage_10`
	`622`	`+ 206 \| 103 \| test_inserts.storage_12`
	`623`	`+ 216 \| 108 \| test_inserts.storage_12`
	`624`	`+ 226 \| 113 \| test_inserts.storage_13`
	`625`	`+ 236 \| 118 \| test_inserts.storage_13`
	`626`	`+ 246 \| 123 \| test_inserts.storage_14`
	`627`	`+ 256 \| 128 \| test_inserts.storage_14`
	`628`	`+(27 rows)`
	`629`	`+`
`459`	`630`	`DROP SCHEMA test_inserts CASCADE;`
`460`	`631`	`NOTICE: drop cascades to 16 other objects`
`461`	`632`	`DROP EXTENSION pg_pathman CASCADE;`

`‎sql/pathman_inserts.sql‎`

Lines changed: 22 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -89,15 +89,35 @@ ORDER BY range_min::INT4;`
`89`	`89`	`/* check the data*/`
`90`	`90`	`SELECT*, tableoid::regclassFROMtest_inserts.storageORDER BY b, d;`
`91`	`91`
`92`		`-`
`93`	`92`	`/* drop data*/`
`94`	`93`	`TRUNCATEtest_inserts.storage;`
`95`	`94`
`96`	`95`
`97`	`96`	`/* one more time!*/`
`98`		`-INSERT INTOtest_inserts.storageSELECT i, iFROM generate_series(-2,120) i;`
	`97`	`+INSERT INTOtest_inserts.storage (b, d)SELECT i, iFROM generate_series(-2,120) i;`
	`98`	`+SELECT*, tableoid::regclassFROMtest_inserts.storageORDER BY b, d;`
	`99`	`+`
	`100`	`+/* drop data*/`
	`101`	`+TRUNCATEtest_inserts.storage;`
	`102`	`+`
	`103`	`+`
	`104`	`+/* add new column*/`
	`105`	`+ALTERTABLEtest_inserts.storage ADD COLUMN e INT8NOT NULL;`
	`106`	`+`
	`107`	`+`
	`108`	`+/* one more time! x2*/`
	`109`	`+INSERT INTOtest_inserts.storage (b, d, e)SELECT i, i, iFROM generate_series(-2,120) i;`
`99`	`110`	`SELECT*, tableoid::regclassFROMtest_inserts.storageORDER BY b, d;`
`100`	`111`
	`112`	`+/* drop data*/`
	`113`	`+TRUNCATEtest_inserts.storage;`
	`114`	`+`
	`115`	`+`
	`116`	`+/* now test RETURNING list using our new column 'e'*/`
	`117`	`+INSERT INTOtest_inserts.storage (b, d, e)SELECT i, i, i`
	`118`	`+FROM generate_series(-2,130,5) i`
	`119`	`+RETURNING e*2, b, tableoid::regclass;`
	`120`	`+`
`101`	`121`
`102`	`122`
`103`	`123`	`DROPSCHEMA test_inserts CASCADE;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit21ea8b5

File tree

2 files changed

2 files changed

`‎expected/pathman_inserts.out‎`

`‎sql/pathman_inserts.sql‎`

0 commit comments