NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit6306d07

committed

Re-enable error for "SELECT ... OFFSET -1".

The executor has thrown errors for negative OFFSET values since 8.4 (seecommitbfce56e), but in a moment of brainfade I taught the planner that OFFSET with a constant negative value was ano-op (commit1a1832e). Reinstate theformer behavior by only discarding OFFSET with a value of exactly 0. Inpassing, adjust a planner comment that referenced the ancient behavior.Back-patch to 9.3 where the mistake was introduced.

1 parentf59c8ef commit6306d07Copy full SHA for 6306d07

File tree

1 file changed

-4

lines changed

src/backend/optimizer/plan
- planner.c

1 file changed

-4

lines changed

`‎src/backend/optimizer/plan/planner.c`

Lines changed: 3 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -2127,7 +2127,7 @@ preprocess_limit(PlannerInfo *root, double tuple_fraction,`
`2127`	`2127`	`{`
`2128`	`2128`	`offset_est=DatumGetInt64(((Const)est)->constvalue);`
`2129`	`2129`	`if (*offset_est<0)`
`2130`		`-offset_est=0;/less than 0 is sameas0 */`
	`2130`	`+offset_est=0;/treatasnot present */`
`2131`	`2131`	`}`
`2132`	`2132`	`}`
`2133`	`2133`	`else`
`@@ -2288,9 +2288,8 @@ limit_needed(Query *parse)`
`2288`	`2288`	`{`
`2289`	`2289`	`int64offset=DatumGetInt64(((Const*)node)->constvalue);`
`2290`	`2290`
`2291`		`-/* Executor would treat less-than-zero same as zero */`
`2292`		`-if (offset>0)`
`2293`		`-return true;/* OFFSET with a positive value */`
	`2291`	`+if (offset!=0)`
	`2292`	`+return true;/* OFFSET with a nonzero value */`
`2294`	`2293`	`}`
`2295`	`2294`	`}`
`2296`	`2295`	`else`

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!

Commit6306d07

File tree

1 file changed

1 file changed

`‎src/backend/optimizer/plan/planner.c`

0 commit comments