Commit3300e87

committed

Schema-qualify references in test_ddl_deparse test script.

This omission seems to be what is causing buildfarm failures on crake.Security:CVE-2018-1058

1 parentadb0718 commit3300e87Copy full SHA for 3300e87

File tree

-6

lines changed

src/test/modules/test_ddl_deparse
- expected
  - test_ddl_deparse.out
- sql
  - test_ddl_deparse.sql

-6

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,13 +12,13 @@ BEGIN`
`12`	`12`	`FOR r IN SELECT * FROM pg_event_trigger_ddl_commands()`
`13`	`13`	`LOOP`
`14`	`14`	`-- verify that tags match`
`15`		`-tag = get_command_tag(r.command);`
	`15`	`+tag =public.get_command_tag(r.command);`
`16`	`16`	`IF tag <> r.command_tag THEN`
`17`	`17`	`RAISE NOTICE 'tag % doesn''t match %', tag, r.command_tag;`
`18`	`18`	`END IF;`
`19`	`19`
`20`	`20`	`-- log the operation`
`21`		`-cmdtype = get_command_type(r.command);`
	`21`	`+cmdtype =public.get_command_type(r.command);`
`22`	`22`	`IF cmdtype <> 'grant' THEN`
`23`	`23`	`RAISE NOTICE 'DDL test: type %, tag %', cmdtype, tag;`
`24`	`24`	`ELSE`
`@@ -28,7 +28,7 @@ BEGIN`
`28`	`28`	`-- if alter table, log more`
`29`	`29`	`IF cmdtype = 'alter table' THEN`
`30`	`30`	`FOR r2 IN SELECT *`
`31`		`-FROM unnest(get_altertable_subcmdtypes(r.command))`
	`31`	`+FROM unnest(public.get_altertable_subcmdtypes(r.command))`
`32`	`32`	`LOOP`
`33`	`33`	`RAISE NOTICE ' subcommand: %', r2.unnest;`
`34`	`34`	`END LOOP;`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,13 +13,13 @@ BEGIN`
`13`	`13`	`FOR rINSELECT*FROM pg_event_trigger_ddl_commands()`
`14`	`14`	`LOOP`
`15`	`15`	`-- verify that tags match`
`16`		`-tag= get_command_tag(r.command);`
	`16`	`+tag=public.get_command_tag(r.command);`
`17`	`17`	`IF tag<>r.command_tag THEN`
`18`	`18`	`RAISE NOTICE'tag % doesn''t match %', tag,r.command_tag;`
`19`	`19`	`END IF;`
`20`	`20`
`21`	`21`	`-- log the operation`
`22`		`-cmdtype= get_command_type(r.command);`
	`22`	`+cmdtype=public.get_command_type(r.command);`
`23`	`23`	`IF cmdtype<>'grant' THEN`
`24`	`24`	`RAISE NOTICE'DDL test: type %, tag %', cmdtype, tag;`
`25`	`25`	`ELSE`
`@@ -29,7 +29,7 @@ BEGIN`
`29`	`29`	`-- if alter table, log more`
`30`	`30`	`IF cmdtype='alter table' THEN`
`31`	`31`	`FOR r2INSELECT*`
`32`		`-FROM unnest(get_altertable_subcmdtypes(r.command))`
	`32`	`+FROM unnest(public.get_altertable_subcmdtypes(r.command))`
`33`	`33`	`LOOP`
`34`	`34`	`RAISE NOTICE' subcommand: %',r2.unnest;`
`35`	`35`	`END LOOP;`

Comments

(0)