Horton

Remove the wrong assertion from match_orclause_to_indexcol()

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: d4d11940df94ee13166dda70271ff3b97e43bc9b
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2024-11-25T07:07:30Z
Releases: 18.0 
Remove the wrong assertion from match_orclause_to_indexcol()

Obviously, the constant could be zero.  Also, add the relevant check to
regression tests.

Reported-by: Richard Guo
Discussion: https://postgr.es/m/CAMbWs4-siKJdtWhcbqk4Y-xG12do2Ckm1qw672GNsSnDqL9FQg%40mail.gmail.com

Files

PathChange+/−
src/backend/optimizer/path/indxpath.c modified +1 −1
src/test/regress/expected/create_index.out modified +5 −5
src/test/regress/sql/create_index.sql modified +2 −2

Discussion