← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select_safe.test

  • Committer: Brian Aker
  • Date: 2010-04-05 23:46:43 UTC
  • Revision ID: brian@gaz-20100405234643-0he3xnj902rc70r8
Fixing tests to work with PBXT.

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;