Fork me on GitHub

You are not logged in. Please login or register.

Development

Download

Tickets

Milestones

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 https://fluxbb.org/forums/userlist.php?username=Fran_* (0 expected lines)
https://fluxbb.org/forums/userlist.php?username=*_87 (1 expected line)

History

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 https://fluxbb.org/forums/viewtopic.php … 225#p65225