Commite9d6934

committed

Add a regression test to verify that the stack depth checker actually

works (and max_stack_depth is not set too high for the platform).Inspired by trouble report from Brian Betts.

1 parent49c320b commite9d6934Copy full SHA for e9d6934

File tree

+14

-0

lines changed

+14

-0

lines changed

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -441,3 +441,10 @@ NULL);`
`441`	`441`	`ERROR: syntax error at or near "NUL" at character 190`
`442`	`442`	`LINE 16: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...`
`443`	`443`	`^`
	`444`	`+-- Check that stack depth detection mechanism works and`
	`445`	`+-- max_stack_depth is not set too high`
	`446`	`+create function infinite_recurse() returns int as`
	`447`	`+'select infinite_recurse()' language sql;`
	`448`	`+\set VERBOSITY terse`
	`449`	`+select infinite_recurse();`
	`450`	`+ERROR: stack depth limit exceeded`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -367,3 +367,10 @@ INT4`
`367`	`367`	`UNIQUE`
`368`	`368`	`NOT`
`369`	`369`	`NULL);`
	`370`	`+`
	`371`	`+-- Check that stack depth detection mechanism works and`
	`372`	`+-- max_stack_depth is not set too high`
	`373`	`+createfunctioninfinite_recurse() returnsintas`
	`374`	`+'select infinite_recurse()' language sql;`
	`375`	`+\set VERBOSITY terse`
	`376`	`+select infinite_recurse();`

Comments

(0)