no ORDER BY in views
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
STK-Unit |
Triaged
|
High
|
Federico Razzoli |
Bug Description
Reasons to avoid ORDER BY in views:
* There is a regression bug in My 5.5/5.6: http://
* ORDER BYs in views are somewhat anti-relational, because entities don't have an order.
* information_schema virtual tables dont have an order, even when a natural order is possible (ie SCHEMATA)
However, views with ORDER BY are tester-friendly, so:
* the original view should remain, but without ORDER BY
* a stored procedure which returns an ordered resultset must be added
The following views have an ORDER BY and the following sp must be added:
* last_test_results - show_last_results()
* last_test_
* recent_test_results - show_results()
* recent_
* my_dbug_log - show_dbug_log()
(however stk/dbug will be used in 2.0, hopefully)
Changed in stk-unit: | |
importance: | Undecided → High |