NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit314288f

committed

Avoid using trivial usernames in foreign_data regression test.

Author: Martin Pihlak

1 parentb2734a0 commit314288fCopy full SHA for 314288f

File tree

2 files changed

+12

-12

lines changed

src/test/regress
- expected
  - foreign_data.out
- sql
  - foreign_data.sql

2 files changed

+12

-12

lines changed

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

Lines changed: 8 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -524,8 +524,8 @@ List of user mappings`
`524`	`524`	`(0 rows)`
`525`	`525`
`526`	`526`	`-- CREATE USER MAPPING`
`527`		`-CREATE USER MAPPING FORbaz SERVER s1; -- ERROR`
`528`		`-ERROR: role "baz" does not exist`
	`527`	`+CREATE USER MAPPING FORregress_test_missing_role SERVER s1; -- ERROR`
	`528`	`+ERROR: role "regress_test_missing_role" does not exist`
`529`	`529`	`CREATE USER MAPPING FOR current_user SERVER s1; -- ERROR`
`530`	`530`	`ERROR: server "s1" does not exist`
`531`	`531`	`CREATE USER MAPPING FOR current_user SERVER s4;`
`@@ -565,8 +565,8 @@ RESET ROLE;`
`565`	`565`	`(7 rows)`
`566`	`566`
`567`	`567`	`-- ALTER USER MAPPING`
`568`		`-ALTER USER MAPPING FORbob SERVER s4 OPTIONS (gotcha 'true'); -- ERROR`
`569`		`-ERROR: role "bob" does not exist`
	`568`	`+ALTER USER MAPPING FORregress_test_missing_role SERVER s4 OPTIONS (gotcha 'true'); -- ERROR`
	`569`	`+ERROR: role "regress_test_missing_role" does not exist`
`570`	`570`	`ALTER USER MAPPING FOR user SERVER ss4 OPTIONS (gotcha 'true'); -- ERROR`
`571`	`571`	`ERROR: server "ss4" does not exist`
`572`	`572`	`ALTER USER MAPPING FOR public SERVER s5 OPTIONS (gotcha 'true'); -- ERROR`
`@@ -595,14 +595,14 @@ RESET ROLE;`
`595`	`595`	`(7 rows)`
`596`	`596`
`597`	`597`	`-- DROP USER MAPPING`
`598`		`-DROP USER MAPPING FORbob SERVER s4; -- ERROR`
`599`		`-ERROR: role "bob" does not exist`
	`598`	`+DROP USER MAPPING FORregress_test_missing_role SERVER s4; -- ERROR`
	`599`	`+ERROR: role "regress_test_missing_role" does not exist`
`600`	`600`	`DROP USER MAPPING FOR user SERVER ss4;`
`601`	`601`	`ERROR: server "ss4" does not exist`
`602`	`602`	`DROP USER MAPPING FOR public SERVER s7; -- ERROR`
`603`	`603`	`ERROR: user mapping "public" does not exist for the server`
`604`		`-DROP USER MAPPING IF EXISTS FORbob SERVER s4;`
`605`		`-NOTICE: role "bob" does not exist, skipping`
	`604`	`+DROP USER MAPPING IF EXISTS FORregress_test_missing_role SERVER s4;`
	`605`	`+NOTICE: role "regress_test_missing_role" does not exist, skipping`
`606`	`606`	`DROP USER MAPPING IF EXISTS FOR user SERVER ss4;`
`607`	`607`	`NOTICE: server does not exist, skipping`
`608`	`608`	`DROP USER MAPPING IF EXISTS FOR public SERVER s7;`

`‎src/test/regress/sql/foreign_data.sql`

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -204,7 +204,7 @@ DROP SERVER s3 CASCADE;`
`204`	`204`	`\deu`
`205`	`205`
`206`	`206`	`-- CREATE USER MAPPING`
`207`		`-CREATEUSERMAPPING FORbaz SERVER s1;-- ERROR`
	`207`	`+CREATEUSERMAPPING FORregress_test_missing_role SERVER s1;-- ERROR`
`208`	`208`	`CREATEUSERMAPPING FORcurrent_user SERVER s1;-- ERROR`
`209`	`209`	`CREATEUSERMAPPING FORcurrent_user SERVER s4;`
`210`	`210`	`CREATEUSERMAPPING FOR user SERVER s4;-- ERROR duplicate`
`@@ -228,7 +228,7 @@ RESET ROLE;`
`228`	`228`	`\deu`
`229`	`229`
`230`	`230`	`-- ALTER USER MAPPING`
`231`		`-ALTERUSER MAPPING FORbob SERVER s4 OPTIONS (gotcha'true');-- ERROR`
	`231`	`+ALTERUSER MAPPING FORregress_test_missing_role SERVER s4 OPTIONS (gotcha'true');-- ERROR`
`232`	`232`	`ALTERUSER MAPPING FOR user SERVER ss4 OPTIONS (gotcha'true');-- ERROR`
`233`	`233`	`ALTERUSER MAPPING FOR public SERVER s5 OPTIONS (gotcha'true');-- ERROR`
`234`	`234`	`ALTERUSER MAPPING FORcurrent_user SERVER s8 OPTIONS (username'test');-- ERROR`
`@@ -241,10 +241,10 @@ RESET ROLE;`
`241`	`241`	`\deu+`
`242`	`242`
`243`	`243`	`-- DROP USER MAPPING`
`244`		`-DROPUSER MAPPING FORbob SERVER s4;-- ERROR`
	`244`	`+DROPUSER MAPPING FORregress_test_missing_role SERVER s4;-- ERROR`
`245`	`245`	`DROPUSER MAPPING FOR user SERVER ss4;`
`246`	`246`	`DROPUSER MAPPING FOR public SERVER s7;-- ERROR`
`247`		`-DROPUSER MAPPING IF EXISTS FORbob SERVER s4;`
	`247`	`+DROPUSER MAPPING IF EXISTS FORregress_test_missing_role SERVER s4;`
`248`	`248`	`DROPUSER MAPPING IF EXISTS FOR user SERVER ss4;`
`249`	`249`	`DROPUSER MAPPING IF EXISTS FOR public SERVER s7;`
`250`	`250`	`CREATEUSERMAPPING FOR public SERVER s8;`

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!

Commit314288f

File tree

2 files changed

2 files changed

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

`‎src/test/regress/sql/foreign_data.sql`

0 commit comments