~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/range.result

  • Committer: Lee Bieber
  • Date: 2010-08-21 22:42:44 UTC
  • mto: (1727.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1728.
  • Revision ID: lbieber@kalebral-2.local-20100821224244-kh3gmsvi45dlbuu1
For the feature request (https://blueprints.launchpad.net/drizzle/+spec/limit-maximum-sort-size) 
that is requesting the ability to cap various buffers, we first tried setting the join buffer to 
1 to see how that would affect the test results and expose test results that need to 
sorted (by adding --sorted_result). 

Show diffs side-by-side

added added

removed removed

Lines of Context:
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