no ORDER BY in views

Bug #1198446 reported by Federico Razzoli
6
This bug affects 1 person
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://bugs.mysql.com/bug.php?id=69678 Will it regress again? Does Oracle create (and execute) regression bugs? No one knows, I think.
* 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_results_bad - show_last_bad_results()
* recent_test_results - show_results()
* recent_test_results_bad - show_bad_results()
* my_dbug_log - show_dbug_log()

(however stk/dbug will be used in 2.0, hopefully)

Changed in stk-unit:
importance: Undecided → High
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.