Skip to content

Commit 7284fe1

Browse files
committed
Tweak text
1 parent c7523fd commit 7284fe1

1 file changed

Lines changed: 4 additions & 5 deletions

File tree

  • docs/source/library-user-guide/upgrading

‎docs/source/library-user-guide/upgrading/54.0.0.md‎

Lines changed: 4 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -408,11 +408,10 @@ This produces two user-visible changes:
408408

409409
### Filter predicate evaluation order may differ from query text
410410

411-
The logical optimizer now reorders the conjuncts of an `AND`-only filter so
412-
that cheap predicates (most binary comparisons, `IS NULL`, `Between`, `InList`,
413-
etc.) evaluate before expensive ones (`LIKE`, regex, scalar function calls,
414-
subqueries). For example, `WHERE col LIKE '%foo%' AND col2 = 5` may evaluate
415-
`col2 = 5` before `col LIKE '%foo%'`.
411+
The logical optimizer now reorders filters so that cheap predicates (most binary
412+
comparisons, `IS NULL`, `Between`, `InList`, etc.) evaluate before expensive
413+
ones (`LIKE`, regex, scalar function calls, subqueries). For example, `WHERE col
414+
LIKE '%foo%' AND col2 = 5` may evaluate `col2 = 5` before `col LIKE '%foo%'`.
416415

417416
**Evaluation order is not guaranteed to match the order written in the query.**
418417
The SQL standard explicitly allows implementations to evaluate operands in any

0 commit comments

Comments
 (0)