← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select_safe.test

  • Committer: Jay Pipes
  • Date: 2010-04-08 16:27:25 UTC
  • mfrom: (1405.6.10 replication-pairs)
  • mto: This revision was merged to the branch mainline in revision 1457.
  • Revision ID: jpipes@serialcoder-20100408162725-sugbgn38oxjqclq2
Merge trunk and replication-pairs with conflict resolution

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/select_safe.test
9
9
SET SQL_SELECT_LIMIT=4, MAX_JOIN_SIZE=9;
10
10
create table t1 (a int auto_increment primary key, b char(20));
11
11
insert into t1 values(1,"test");
 
12
--sorted_result
12
13
SELECT SQL_BUFFER_RESULT * from t1;
13
14
update t1 set b="a" where a=1;
14
15
delete from t1 where a=1;
15
16
insert into t1 values(1,"test"),(2,"test2");
 
17
--sorted_result
16
18
SELECT SQL_BUFFER_RESULT * from t1;
17
19
update t1 set b="a" where a=1;
18
20
select 1 from t1,t1 as t2,t1 as t3;