Bug report #2407
Quick search behaviour in attributes tables has changed
|Affected QGIS version:||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||12467|
When i start a search within attribute tables with Mimas (1.0.3), searches return results as if it was a SQL request -> SELECT * FROM table WHERE column like '%word_to_search%'
When i start a search within attribute tables with Enceladus (1.0.4), searches return results as if it was an exact match SQL request -> SELECT * FROM table WHERE column = 'word_to_search'
I don't know if it's referenced as bug but I prefer the previous behaviour. The new one is too rigid...
#3 Updated by marisn - over 10 years ago
Unfortunately "Quick search" is not an "find" anymore. Wildcards are not accepted, unescaped SQL also gives errors.
I.e. try to find "ab'c" ->
syntax error, unexpected Unknown_CHARACTER, expecting $end
Also it allows to inject SQL. I.e. select all records:
text' or 1=1 or COLUMN like 'text
Tested on QGIS trunk r12951M with Shapefile (DBF).