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)
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
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