aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/basics.source
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2021-08-10 18:10:30 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2021-08-10 18:10:30 -0400
commitcd7d9b6b63f1ed1d60cab3888eb0fc2523de6f0e (patch)
tree0414b501689f9a1c97da212f976e3cfc25f155d4 /src/tutorial/basics.source
parentde835071fda945fb5e40340d3ea8dd2ca13e725c (diff)
downloadpostgresql-cd7d9b6b63f1ed1d60cab3888eb0fc2523de6f0e.tar.gz
postgresql-cd7d9b6b63f1ed1d60cab3888eb0fc2523de6f0e.zip
Fix failure of btree_gin indexscans with "char" type and </<= operators.
As a result of confusion about whether the "char" type is signed or unsigned, scans for index searches like "col < 'x'" or "col <= 'x'" would start at the middle of the index not the left end, thus missing many or all of the entries they should find. Fortunately, this is not a symptom of index corruption. It's only the search logic that is broken, and we can fix it without unpleasant side-effects. Per report from Jason Kim. This has been wrong since btree_gin's beginning, so back-patch to all supported branches. Discussion: https://postgr.es/m/20210810001649.htnltbh7c63re42p@jasonk.me
Diffstat (limited to 'src/tutorial/basics.source')
0 files changed, 0 insertions, 0 deletions