NotificationsYou must be signed in to change notification settings
Fork0
Star0

Commit9f22a3f

committed

Reduce recursion depth in recently-added regression test.

Some buildfarm members fail the test with the original depth of 10 levels,apparently because they are running at the minimum max_stack_depth settingof 100kB and using ~ 10k per recursion level. While it might beinteresting to try to figure out why they're eating so much stack, it isn'tlikely that any fix for that would be back-patchable. So just change thetest to recurse only 5 levels. The extra levels don't prove anythingcorrectness-wise anyway.

1 parent2868b0c commit9f22a3fCopy full SHA for 9f22a3f

File tree

2 files changed

-7

lines changed

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

2 files changed

-7

lines changed

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

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -2790,8 +2790,8 @@ DROP FUNCTION nonsimple_expr_test();`
`2790`	`2790`	`create function recurse(float8) returns float8 as`
`2791`	`2791`	`$$`
`2792`	`2792`	`begin`
`2793`		`- if ($1< 10) then`
`2794`		`- return sql_recurse($1+ 1);`
	`2793`	`+ if ($1> 0) then`
	`2794`	`+ return sql_recurse($1- 1);`
`2795`	`2795`	`else`
`2796`	`2796`	`return $1;`
`2797`	`2797`	`end if;`
`@@ -2800,10 +2800,10 @@ $$ language plpgsql;`
`2800`	`2800`	`-- "limit" is to prevent this from being inlined`
`2801`	`2801`	`create function sql_recurse(float8) returns float8 as`
`2802`	`2802`	`$$ select recurse($1) limit 1; $$ language sql;`
`2803`		`-select recurse(0);`
	`2803`	`+select recurse(5);`
`2804`	`2804`	`recurse`
`2805`	`2805`	`---------`
`2806`		`-10`
	`2806`	`+ 0`
`2807`	`2807`	`(1 row)`
`2808`	`2808`
`2809`	`2809`	`create function error1(text) returns text language sql as`

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

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -2345,8 +2345,8 @@ DROP FUNCTION nonsimple_expr_test();`
`2345`	`2345`	`createfunctionrecurse(float8) returns float8as`
`2346`	`2346`	`$$`
`2347`	`2347`	`begin`
`2348`		`- if ($1<10) then`
`2349`		`- return sql_recurse($1+1);`
	`2348`	`+ if ($1>0) then`
	`2349`	`+ return sql_recurse($1-1);`
`2350`	`2350`	`else`
`2351`	`2351`	`return $1;`
`2352`	`2352`	`end if;`
`@@ -2357,7 +2357,7 @@ $$ language plpgsql;`
`2357`	`2357`	`createfunctionsql_recurse(float8) returns float8as`
`2358`	`2358`	`$$select recurse($1)limit1; $$ language sql;`
`2359`	`2359`
`2360`		`-select recurse(0);`
	`2360`	`+select recurse(5);`
`2361`	`2361`
`2362`	`2362`	`createfunctionerror1(text) returnstext language sqlas`
`2363`	`2363`	`$$SELECT relname::textFROM pg_class cWHEREc.oid= $1::regclass $$;`

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!

Commit9f22a3f

File tree

2 files changed

2 files changed

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

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

0 commit comments