NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitca02434

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 parentc2b5d17 commitca02434Copy full SHA for ca02434

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!

Commitca02434

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