aboutsummaryrefslogtreecommitdiff
path: root/src/backend/regex/regexec.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2012-09-18 12:20:43 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2012-09-18 12:20:43 -0400
commit3cccc6990b66265ad7c4bfbe5789ce571a39d876 (patch)
treea12a0cf126a4667e0c25ff5c3219c8d3209777cd /src/backend/regex/regexec.c
parent66762ce5fa9f2e82003208e4deba465f438e8505 (diff)
downloadpostgresql-3cccc6990b66265ad7c4bfbe5789ce571a39d876.tar.gz
postgresql-3cccc6990b66265ad7c4bfbe5789ce571a39d876.zip
Fix planning of btree index scans using ScalarArrayOpExpr quals.
In commit 9e8da0f75731aaa7605cf4656c21ea09e84d2eb1, I improved btree to handle ScalarArrayOpExpr quals natively, so that constructs like "indexedcol IN (list)" could be supported by index-only scans. Using such a qual results in multiple scans of the index, under-the-hood. I went to some lengths to ensure that this still produces rows in index order ... but I failed to recognize that if a higher-order index column is lacking an equality constraint, rescans can produce out-of-order data from that column. Tweak the planner to not expect sorted output in that case. Per trouble report from Robert McGehee.
Diffstat (limited to 'src/backend/regex/regexec.c')
0 files changed, 0 insertions, 0 deletions