model-writtenrun 6237 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Jason Kim reported that btree_gin indexes returned no rows for "char" comparisons using < and <=, while disabling bitmap scans produced the correct results; the regression expectations had incorrectly accepted the empty results #1.
- Peter Geoghegan emphasized that the wrong query answers raised a potential index-corruption or operator-class consistency problem beyond incorrect test expectations #2.
- Tom Lane traced the failure to disagreement between leftmostvalue_char() and btcharcmp() about signedness, concluding that index construction was unaffected and only search results were wrong #3.
- Tom Lane attached a patch setting the minimum "char" search value to zero and correcting the two regression expectations, resolving the thread's diagnosis without requiring index reconstruction #3.
- The attached fix landed unchanged as a6bd28beb0, crediting Jason Kim's report and backpatched to all supported branches; no further review or follow-up appears after the patch submission #3.