diff options
Diffstat (limited to 'mysql-test/r/ps_4heap.result')
| -rw-r--r-- | mysql-test/r/ps_4heap.result | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/r/ps_4heap.result b/mysql-test/r/ps_4heap.result index 4228d95677d..13bb3b26311 100644 --- a/mysql-test/r/ps_4heap.result +++ b/mysql-test/r/ps_4heap.result @@ -396,7 +396,8 @@ set @arg00='ABC'; set @arg01='two'; set @arg02='one'; select first.a, @arg00, second.a FROM t1 first, t1 second -where @arg01 = first.b or first.a = second.a or second.b = @arg02; +where @arg01 = first.b or first.a = second.a or second.b = @arg02 +order by second.a, first.a; a @arg00 a 1 ABC 1 2 ABC 1 @@ -408,7 +409,8 @@ a @arg00 a 2 ABC 4 4 ABC 4 prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second - where ? = first.b or first.a = second.a or second.b = ? '; + where ? = first.b or first.a = second.a or second.b = ? + order by second.a, first.a'; execute stmt1 using @arg00, @arg01, @arg02; a ? a 1 ABC 1 |