Last modified: 2012-09-29 20:20:44 UTC
'ORDER BY' => 'foo, bar' works but 'ORDER BY' => array( 'foo', 'bar' ) doesn't. Same for GROUP BY. We also don't have nice array-based condition building for HAVING like we do for WHERE.
Created attachment 7890 [details] GROUP BY/ORDER BY array() support For GROUP and ORDER BY, would something as simple as this work?
(In reply to comment #1) > Created attachment 7890 [details] > GROUP BY/ORDER BY array() support > > For GROUP and ORDER BY, would something as simple as this work? I think so
Comment on attachment 7890 [details] GROUP BY/ORDER BY array() support r81272 applied this patch.
"The SQL standard requires that HAVING must reference only columns in the GROUP BY clause or columns used in aggregate functions. However, MySQL supports an extension to this behavior, and permits HAVING to refer to columns in the SELECT list and columns in outer subqueries as well." Our HAVING doesn't garuntee that ;) Also roan, are you just meaning doing the HAVING more nicely, allowing things not having to put literal text to get it to work, and doing stuff like 'HAVING' => array( 'blah' => 2 ) etc?
*Bulk BZ Change: +Patch to open bugs with patches attached that are missing the keyword*
removed patch keyword - no patch attached anymore
Already fixed