Bug #51020 add more "sorted_result" to tests

• Submitted: 9 Feb 2010 9:32
• Modified: 1 Jul 2016 10:20
• Reporter: Guilhem Bichot
• Status: Won't fix
• Category: Tests: Server
• Severity: S4 (Feature request)
• Version: 6.0-codebase-bugfixing
• OS: Any
• Assigned to: Roy Lyseng
• CPU Architecture: Any

[9 Feb 2010 9:32] Guilhem Bichot

Description:
When running the testsuite with different optimizer options, like
--mysqld=--optimizer_join_cache_level=8, many SELECTs return their rows in a new order, which is fine but makes a lot of "false alarms": one has to look into the diff to see whether rows are just reordered (ok) or some row is added or missing (bug).
It would be better if the SELECTs which have no expected ordering (no ORDER BY) had a --sorted_result command in the test (this command exists, see in join_cache.test) so that we have less false alarms.
Roy asked that I assign this to him as he has some partial patch around.

How to repeat:
run mtr tests with --mysqld=--optimizer_join_cache_level=8

[24 Jun 2016 9:27] Ole John Aske

Posted by developer:
 
This patch has been un-reviewed for so long that it has
probably lost its relevance. I give up on this an close the bug.