← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select_safe.test

  • Committer: Stewart Smith
  • Date: 2008-12-22 02:20:48 UTC
  • mto: This revision was merged to the branch mainline in revision 728.
  • Revision ID: stewart@flamingspork.com-20081222022048-8gbkwxsdudm12qwo
fix select_safe and http://bugs.mysql.com/bug.php?id=32250 (but for Drizzle)

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/select_safe.test
6
6
drop table if exists t1;
7
7
--enable_warnings
8
8
 
9
 
SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=4, SQL_MAX_JOIN_SIZE=9;
 
9
SET SQL_SAFE_UPDATES=1,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
12
SELECT SQL_BUFFER_RESULT * from t1;
85
85
select * from (select 1 union select 2 union select 3) x;
86
86
drop table t1;
87
87
 
88
 
SET SQL_SAFE_UPDATES=0,SQL_SELECT_LIMIT=DEFAULT, SQL_MAX_JOIN_SIZE=DEFAULT;
 
88
SET SQL_SAFE_UPDATES=0,SQL_SELECT_LIMIT=DEFAULT, MAX_JOIN_SIZE=DEFAULT;
89
89
 
90
90
# End of 4.1 tests