Commita163c00

committed

Tweak targetlist-SRF tests.

Add a test case showing that we don't support SRFs in window-functionarguments. Remove a duplicate test case for SRFs in aggregate arguments.

1 parent55c3391 commita163c00Copy full SHA for a163c00

File tree

-5

lines changed

-5

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -159,6 +159,9 @@ SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest`
`159`	`159`	`-- SRFs are not allowed in aggregate arguments`
`160`	`160`	`SELECT min(generate_series(1, 3)) FROM few;`
`161`	`161`	`ERROR: set-valued function called in context that cannot accept a set`
	`162`	`+-- SRFs are not allowed in window function arguments, either`
	`163`	`+SELECT min(generate_series(1, 3)) OVER() FROM few;`
	`164`	`+ERROR: set-valued function called in context that cannot accept a set`
`162`	`165`	`-- SRFs are normally computed after window functions`
`163`	`166`	`SELECT id,lag(id) OVER(), count(*) OVER(), generate_series(1,3) FROM few;`
`164`	`167`	`id \| lag \| count \| generate_series`
`@@ -369,9 +372,6 @@ INSERT INTO fewmore VALUES(1) RETURNING generate_series(1,3);`
`369`	`372`	`ERROR: set-returning functions are not allowed in RETURNING`
`370`	`373`	`LINE 1: INSERT INTO fewmore VALUES(1) RETURNING generate_series(1,3)...`
`371`	`374`	`^`
`372`		`--- nor aggregate arguments`
`373`		`-SELECT count(generate_series(1,3)) FROM few;`
`374`		`-ERROR: set-valued function called in context that cannot accept a set`
`375`	`375`	`-- nor standalone VALUES (but surely this is a bug?)`
`376`	`376`	`VALUES(1, generate_series(1,2));`
`377`	`377`	`ERROR: set-valued function called in context that cannot accept a set`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -47,6 +47,9 @@ SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest`
`47`	`47`	`-- SRFs are not allowed in aggregate arguments`
`48`	`48`	`SELECTmin(generate_series(1,3))FROM few;`
`49`	`49`
	`50`	`+-- SRFs are not allowed in window function arguments, either`
	`51`	`+SELECTmin(generate_series(1,3)) OVER()FROM few;`
	`52`	`+`
`50`	`53`	`-- SRFs are normally computed after window functions`
`51`	`54`	`SELECT id,lag(id) OVER(),count(*) OVER(), generate_series(1,3)FROM few;`
`52`	`55`	`-- unless referencing SRFs`
`@@ -73,8 +76,7 @@ UPDATE fewmore SET data = generate_series(4,9);`
`73`	`76`
`74`	`77`	`-- SRFs are not allowed in RETURNING`
`75`	`78`	`INSERT INTO fewmoreVALUES(1) RETURNING generate_series(1,3);`
`76`		`--- nor aggregate arguments`
`77`		`-SELECTcount(generate_series(1,3))FROM few;`
	`79`	`+`
`78`	`80`	`-- nor standalone VALUES (but surely this is a bug?)`
`79`	`81`	`VALUES(1, generate_series(1,2));`
`80`	`82`

Comments

(0)