Fork me on GitHub
Subscribe 2

Ticket #1087 (fixed bug)

LIKE and '_'

  • Created: 2016-06-18 04:57:41
  • Reported by: Visman
  • Assigned to: Franz
  • Milestone: 1.5.11
  • Component: database
  • Priority: low

'_' no escape in sql queryes.
Look result in* (0 expected lines)*_87 (1 expected line)


Franz 2016-06-21 13:42:58

  • Milestone set to 1.5.11.

Franz 2018-01-14 22:42:56

  • Owner set to Franz.
  • Status changed from open to fixed.

Commit fc51c39 to fluxbb master

Escape underscore in all LIKE queries

It is more likely that people want to search for the actual
underscore character (e.g. in an username) than for exactly one,
but arbitrary character.

Fixes #1087.

Visman 2019-10-12 14:36:55

For SQLite, underscore escaping does not work correctly, it seems.
Tested on SQLite 3 (on my version). On SQLite 2 did not test.
The reason for the test is here … 225#p65225