pgsql: Fix incorrect handling of lookahead constraints in pg_regprefix(
От | Tom Lane |
---|---|
Тема | pgsql: Fix incorrect handling of lookahead constraints in pg_regprefix( |
Дата | |
Msg-id | E1ZoHSc-0006Nr-4h@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix incorrect handling of lookahead constraints in pg_regprefix(). pg_regprefix was doing nothing with lookahead constraints, which would be fine if it were the right kind of nothing, but it isn't: we have to terminate our search for a fixed prefix, not just pretend the LACON arc isn't there. Otherwise, if the current state has both a LACON outarc and a single plain-color outarc, we'd falsely conclude that the color represents an addition to the fixed prefix, and generate an extracted index condition that restricts the indexscan too much. (See added regression test case.) Terminating the search is conservative: we could traverse the LACON arc (thus assuming that the constraint can be satisfied at runtime) and then examine the outarcs of the linked-to state. But that would be a lot more work than it seems worth, because writing a LACON followed by a single plain character is a pretty silly thing to do. This makes a difference only in rather contrived cases, but it's a bug, so back-patch to all supported branches. Branch ------ REL9_4_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/52f21c5882ebad18d4cfcd67d99d31b90397ce29 Modified Files -------------- src/backend/regex/regprefix.c | 10 ++++------ src/test/regress/expected/regex.out | 8 ++++++++ src/test/regress/sql/regex.sql | 1 + 3 files changed, 13 insertions(+), 6 deletions(-)
В списке pgsql-committers по дате отправления: