netbox/docs/reference
Jason Novinger 9782be4cd5 Assert the collation reaches the query, and clarify the documented behaviour
The existing tests assert on filter results, which stay correct for ASCII values
even when the collation is never applied. Add a test which asserts on the
lookup's own compiled output, so that the mechanism failing open is caught
rather than passing silently.

Explain why the placeholder is compared literally: a field declaring its own
get_placeholder() compiles to something other than '%s', and splicing a COLLATE
clause into that is not safe, so any other right-hand side is left alone.

The documentation note described the folding as specific to the German
eszett. It is the common example rather than the rule: the collation treats a
character as equivalent to the sequence it expands to in upper case, which also
covers ligatures. Note too that a case-insensitive exact match on a collated
field may now return more than one object.
2026-09-11 03:50:47 -05:00
..
conditions.md Add v4.7 release notes 2026-08-14 13:53:02 -04:00
filtering.md Assert the collation reaches the query, and clarify the documented behaviour 2026-09-11 03:50:47 -05:00
markdown.md