Movatterモバイル変換

Skip to content

postgrespro/postgresPublic

forked frompostgres/postgres

NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit6f3de1b

author

Thomas G. Lockhart

committed

Types removed from Postgres: oidint2, oidint4, oidname.

Fix example columns in alter_table.out to use datetime and timespan as a substitute for oidint4 and oidname.

1 parent91178b8 commit6f3de1bCopy full SHA for 6f3de1b

File tree

15 files changed

+12

-738

lines changed

src/test/regress
- expected
- sql

15 files changed

+12

-738

lines changed

`‎src/test/regress/expected/alter_table.out`

Lines changed: 8 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@ QUERY: ALTER TABLE temp ADD COLUMN h abstime;`
`10`	`10`	`QUERY: ALTER TABLE temp ADD COLUMN i char;`
`11`	`11`	`QUERY: ALTER TABLE temp ADD COLUMN j abstime[];`
`12`	`12`	`QUERY: ALTER TABLE temp ADD COLUMN k dt;`
`13`		`-ERROR:type name lookup of dt failed`
	`13`	`+ERROR: type name lookup of dt failed`
`14`	`14`	`QUERY: ALTER TABLE temp ADD COLUMN l tid;`
`15`	`15`	`QUERY: ALTER TABLE temp ADD COLUMN m xid;`
`16`	`16`	`QUERY: ALTER TABLE temp ADD COLUMN n oid8;`
`@@ -20,8 +20,8 @@ QUERY: ALTER TABLE temp ADD COLUMN r lseg;`
`20`	`20`	`QUERY: ALTER TABLE temp ADD COLUMN s path;`
`21`	`21`	`QUERY: ALTER TABLE temp ADD COLUMN t box;`
`22`	`22`	`QUERY: ALTER TABLE temp ADD COLUMN u tinterval;`
`23`		`-QUERY: ALTER TABLE temp ADD COLUMN voidint4;`
`24`		`-QUERY: ALTER TABLE temp ADD COLUMN woidname;`
	`23`	`+QUERY: ALTER TABLE temp ADD COLUMN vdatetime;`
	`24`	`+QUERY: ALTER TABLE temp ADD COLUMN wtimespan;`
`25`	`25`	`QUERY: ALTER TABLE temp ADD COLUMN x float8[];`
`26`	`26`	`QUERY: ALTER TABLE temp ADD COLUMN y float4[];`
`27`	`27`	`QUERY: ALTER TABLE temp ADD COLUMN z int2[];`
`@@ -33,7 +33,7 @@ QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t`
`33`	`33`	`'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',`
`34`	`34`	`'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',`
`35`	`35`	`'1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');`
`36`		`-ERROR:Relation temp does not have attribute k`
	`36`	`+ERROR: Relation temp does not have attribute k`
`37`	`37`	`QUERY: SELECT * FROM temp;`
`38`	`38`	`initial\|a\|b\|c\|d\|e\|f\|g\|h\|i\|j\|l\|m\|n\|p\|q\|r\|s\|t\|u\|v\|w\|x\|y\|z`
`39`	`39`	`-------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-`
`@@ -54,7 +54,7 @@ QUERY: ALTER TABLE temp ADD COLUMN h abstime;`
`54`	`54`	`QUERY: ALTER TABLE temp ADD COLUMN i char;`
`55`	`55`	`QUERY: ALTER TABLE temp ADD COLUMN j abstime[];`
`56`	`56`	`QUERY: ALTER TABLE temp ADD COLUMN k dt;`
`57`		`-ERROR:type name lookup of dt failed`
	`57`	`+ERROR: type name lookup of dt failed`
`58`	`58`	`QUERY: ALTER TABLE temp ADD COLUMN l tid;`
`59`	`59`	`QUERY: ALTER TABLE temp ADD COLUMN m xid;`
`60`	`60`	`QUERY: ALTER TABLE temp ADD COLUMN n oid8;`
`@@ -64,8 +64,8 @@ QUERY: ALTER TABLE temp ADD COLUMN r lseg;`
`64`	`64`	`QUERY: ALTER TABLE temp ADD COLUMN s path;`
`65`	`65`	`QUERY: ALTER TABLE temp ADD COLUMN t box;`
`66`	`66`	`QUERY: ALTER TABLE temp ADD COLUMN u tinterval;`
`67`		`-QUERY: ALTER TABLE temp ADD COLUMN voidint4;`
`68`		`-QUERY: ALTER TABLE temp ADD COLUMN woidname;`
	`67`	`+QUERY: ALTER TABLE temp ADD COLUMN vdatetime;`
	`68`	`+QUERY: ALTER TABLE temp ADD COLUMN wtimespan;`
`69`	`69`	`QUERY: ALTER TABLE temp ADD COLUMN x float8[];`
`70`	`70`	`QUERY: ALTER TABLE temp ADD COLUMN y float4[];`
`71`	`71`	`QUERY: ALTER TABLE temp ADD COLUMN z int2[];`
`@@ -77,7 +77,7 @@ QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t`
`77`	`77`	`'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',`
`78`	`78`	`'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',`
`79`	`79`	`'1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');`
`80`		`-ERROR:Relation temp does not have attribute k`
	`80`	`+ERROR: Relation temp does not have attribute k`
`81`	`81`	`QUERY: SELECT * FROM temp;`
`82`	`82`	`initial\|a\|b\|c\|d\|e\|f\|g\|h\|i\|j\|l\|m\|n\|p\|q\|r\|s\|t\|u\|v\|w\|x\|y\|z`
`83`	`83`	`-------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-`

`‎src/test/regress/expected/oidint2-FreeBSD.out`

Lines changed: 0 additions & 66 deletions

This file was deleted.

`‎src/test/regress/expected/oidint2-NetBSD.out`

Lines changed: 0 additions & 66 deletions

This file was deleted.

`‎src/test/regress/expected/oidint2-SunOS.out`

Lines changed: 0 additions & 66 deletions

This file was deleted.

`‎src/test/regress/expected/oidint2.out`

Lines changed: 0 additions & 66 deletions

This file was deleted.

`‎src/test/regress/expected/oidint4-FreeBSD.out`

Lines changed: 0 additions & 66 deletions

This file was deleted.

0 commit comments

Comments

(0)

[8]ページ先頭

©2009-2025 Movatter.jp