~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/range.test

  • Committer: Monty Taylor
  • Date: 2010-02-05 08:11:15 UTC
  • mfrom: (1283 build)
  • mto: (1273.13.43 fix_is)
  • mto: This revision was merged to the branch mainline in revision 1300.
  • Revision ID: mordred@inaugust.com-20100205081115-dr82nvrwv4lvw7sd
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
556
556
 'd8c4177d09f8b11f5.52725521');
557
557
 
558
558
--replace_column 3 # 8 # 9 #
559
 
--sorted_result
560
559
EXPLAIN
561
560
SELECT s.oxid FROM t1 v, t1 s 
562
561
  WHERE s.oxrootid = 'd8c4177d09f8b11f5.52725521' AND
804
803
explain select * from t2 where a = 'a' or a='a ';
805
804
 
806
805
update t1 set a='b' where a<>'a';
807
 
--replace_column 3 # 4 # 5 # 6 # 7 # 8 # 9 #
 
806
--replace_column 3 # 8 # 9 #
808
807
explain select * from t1 where a not between 'b' and 'b'; 
809
808
select a, hex(filler) from t1 where a not between 'b' and 'b'; 
810
809