NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitd2cc897

committed

PL/pgSQL: Extend test case

This test was supposed to check the interaction of INOUT and defaultparameters in a procedure call, but it only checked the case where theparameter was not supplied. Now it also checks the case where theparameter was supplied. It was already working correctly, so no codechanges required.

1 parentd10f774 commitd2cc897Copy full SHA for d2cc897

File tree

2 files changed

+16

-0

lines changed

src/pl/plpgsql/src
- expected
  - plpgsql_call.out
- sql
  - plpgsql_call.sql

2 files changed

+16

-0

lines changed

`‎src/pl/plpgsql/src/expected/plpgsql_call.out`

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -233,12 +233,22 @@ BEGIN`
`233`	`233`	`_a := 10; _b := 30; _c := 50;`
`234`	`234`	`CALL test_proc8c(_a, b => _b);`
`235`	`235`	`RAISE NOTICE '_a: %, _b: %, _c: %', _a, _b, _c;`
	`236`	`+ _a := 10; _b := 30; _c := 50;`
	`237`	`+ CALL test_proc8c(_a, _b, _c);`
	`238`	`+ RAISE NOTICE '_a: %, _b: %, _c: %', _a, _b, _c;`
	`239`	`+ _a := 10; _b := 30; _c := 50;`
	`240`	`+ CALL test_proc8c(c => _c, b => _b, a => _a);`
	`241`	`+ RAISE NOTICE '_a: %, _b: %, _c: %', _a, _b, _c;`
`236`	`242`	`END`
`237`	`243`	`$$;`
`238`	`244`	`NOTICE: a: 10, b: 30, c: 11`
`239`	`245`	`NOTICE: _a: 100, _b: 40, _c: 50`
`240`	`246`	`NOTICE: a: 10, b: 30, c: 11`
`241`	`247`	`NOTICE: _a: 100, _b: 40, _c: 50`
	`248`	`+NOTICE: a: 10, b: 30, c: 50`
	`249`	`+NOTICE: _a: 100, _b: 40, _c: -500`
	`250`	`+NOTICE: a: 10, b: 30, c: 50`
	`251`	`+NOTICE: _a: 100, _b: 40, _c: -500`
`242`	`252`	`-- transition variable assignment`
`243`	`253`	`TRUNCATE test1;`
`244`	`254`	`CREATE FUNCTION triggerfunc1() RETURNS trigger`

`‎src/pl/plpgsql/src/sql/plpgsql_call.sql`

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -212,6 +212,12 @@ BEGIN`
`212`	`212`	`_a :=10; _b :=30; _c :=50;`
`213`	`213`	`CALL test_proc8c(_a, b=> _b);`
`214`	`214`	`RAISE NOTICE'_a: %, _b: %, _c: %', _a, _b, _c;`
	`215`	`+ _a :=10; _b :=30; _c :=50;`
	`216`	`+ CALL test_proc8c(_a, _b, _c);`
	`217`	`+ RAISE NOTICE'_a: %, _b: %, _c: %', _a, _b, _c;`
	`218`	`+ _a :=10; _b :=30; _c :=50;`
	`219`	`+ CALL test_proc8c(c=> _c, b=> _b, a=> _a);`
	`220`	`+ RAISE NOTICE'_a: %, _b: %, _c: %', _a, _b, _c;`
`215`	`221`	`END`
`216`	`222`	`$$;`
`217`	`223`

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!

Commitd2cc897

File tree

2 files changed

2 files changed

`‎src/pl/plpgsql/src/expected/plpgsql_call.out`

`‎src/pl/plpgsql/src/sql/plpgsql_call.sql`

0 commit comments