← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/range.result

updateing test results that need to sorted by adding --sorted_result - bug 622005

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/range.result
694
694
v.oxrootid ='d8c4177d09f8b11f5.52725521' AND
695
695
s.oxleft > v.oxleft AND s.oxleft < v.oxright;
696
696
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
 
697
1       SIMPLE  #       ALL     OXLEFT  NULL    NULL    #       #       Range checked for each record (index map: 0x4)
697
698
1       SIMPLE  #       ALL     OXLEFT,OXRIGHT,OXROOTID NULL    NULL    #       #       Using where
698
 
1       SIMPLE  #       ALL     OXLEFT  NULL    NULL    #       #       Range checked for each record (index map: 0x4)
699
699
SELECT s.oxid FROM t1 v, t1 s 
700
700
WHERE s.oxrootid = 'd8c4177d09f8b11f5.52725521' AND
701
701
v.oxrootid ='d8c4177d09f8b11f5.52725521' AND