Actions
Bug #1279
closedLists advanced search: Search any of a single-drop-down field but selecting empty line in multi-select field gives invalid SQL query
Description
Files
Actions
Added by krileon over 15 years ago. Updated about 15 years ago.
Description
Files
1279_unified.patch (737 Bytes) 1279_unified.patch | Unified Patch | krileon, 28 January 2010 00:32 | |
1279-plugin.class.php.patch (648 Bytes) 1279-plugin.class.php.patch | beat, 28 January 2010 01:09 |
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.
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)