diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2023-03-11 12:15:41 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2023-03-11 12:15:41 -0500 |
commit | bc436e4a917a7185847e05797249ea889214bffe (patch) | |
tree | f15b13d8401b6ccbc71f05aed49303217dd831fb /src/backend/executor/nodeWindowAgg.c | |
parent | 866fd004d9f94b87d453642c0c854d38884d3d3d (diff) | |
download | postgresql-bc436e4a917a7185847e05797249ea889214bffe.tar.gz postgresql-bc436e4a917a7185847e05797249ea889214bffe.zip |
Fix misbehavior in contrib/pg_trgm with an unsatisfiable regex.
If the regex compiler can see that a regex is unsatisfiable
(for example, '$foo') then it may emit an NFA having no arcs.
pg_trgm's packGraph function did the wrong thing in this case;
it would access off the end of a work array, and with bad luck
could produce a corrupted output data structure causing more
problems later. This could end with wrong answers or crashes
in queries using a pg_trgm GIN or GiST index with such a regex.
Fix by not trying to de-duplicate if there aren't at least 2 arcs.
Per bug #17830 from Alexander Lakhin. Back-patch to all supported
branches.
Discussion: https://postgr.es/m/17830-57ff5f89bdb02b09@postgresql.org
Diffstat (limited to 'src/backend/executor/nodeWindowAgg.c')
0 files changed, 0 insertions, 0 deletions