Disable FQS for cursors defined with SCROLL
authorTomas Vondra <tomas@2ndquadrant.com>
Thu, 5 Oct 2017 21:05:27 +0000 (23:05 +0200)
committerTomas Vondra <tomas@2ndquadrant.com>
Thu, 5 Oct 2017 21:05:27 +0000 (23:05 +0200)
commita4f830d8fe58d891f76e5335ba1048602be8826b
tree94e75f1618d5adb9573b04f18cf666e62716c772
parentf6d85461ca5d6a9afce2ea87a18e98dbdc0d98c2
Disable FQS for cursors defined with SCROLL

When checking if a query is eligible for FQS (fast-query shipping),
disable the optimization for queries in SCROLL cursors, as FQS does
not support backward scans.

Discussion: <e66932f3-3c35-cab0-af7e-60e8dfa423ba@2ndquadrant.com>
src/backend/commands/portalcmds.c
src/backend/pgxc/plan/planner.c
src/test/regress/expected/limit.out
src/test/regress/sql/limit.sql