Bug #1279
closed
Lists advanced search: Search any of a single-drop-down field but selecting empty line in multi-select field gives invalid SQL query
Added by krileon about 15 years ago.
Updated almost 15 years ago.
Start date:
14 September 2009
Files
- Target version set to CB 1.2.2
- Estimated time set to 3:00 h
- File 1279.patch added
- Status changed from New to Assigned
- Assignee changed from krileon to beat
- % Done changed from 0 to 80
The issue was with the building of the query checking for != '' instead of !== null, as blanks are permitted. This caused it to place an empty AND inside of the query. Function reduceSqlFormula in plugin.class.php.
- File deleted (
1279.patch)
- File deleted (
1279.patch)
- Subject changed from Multi select drop down error to Lists advanced search: Search any of a single-drop-down field but selecting empty line in multi-select field gives invalid SQL query
- Status changed from Assigned to Closed
- % Done changed from 80 to 100
Not agreeing with the patch, as it gives wrong results, allowing selection of the empty row generating '' and wrong results.
Enclosed another patch, which gives expected behavior.
Committed in r848 .
(after 1.2.2 beta 1)
Also available in: Atom
PDF