← 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: 2009-12-03 21:03:24 UTC
  • mto: (1237.2.7 push) (1238.1.1 push)
  • mto: This revision was merged to the branch mainline in revision 1238.
  • Revision ID: brian@gaz-20091203210324-y5e4a6qw37jajekc
Remove dead bits in parser/whitespace/etc.

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, MAX_JOIN_SIZE=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
12
SELECT SQL_BUFFER_RESULT * from t1;
17
17
update t1 set b="a" where a=1;
18
18
select 1 from t1,t1 as t2,t1 as t3;
19
19
 
20
 
# The following should give errors:
21
 
--error 1175
 
20
# The following should NOT give errors:
22
21
update t1 set b="a";
23
 
--error 1175
24
22
update t1 set b="a" where b="test";
25
 
--error 1175
26
23
delete from t1;
27
 
--error 1175
28
24
delete from t1 where b="test";
29
 
--error 1175
30
25
delete from t1 where a+0=1;
31
 
--error 1104
32
26
select 1 from t1,t1 as t2,t1 as t3,t1 as t4,t1 as t5;
33
27
 
34
28
# The following should be ok:
85
79
select * from (select 1 union select 2 union select 3) x;
86
80
drop table t1;
87
81
 
88
 
SET SQL_SAFE_UPDATES=0,SQL_SELECT_LIMIT=DEFAULT, MAX_JOIN_SIZE=DEFAULT;
 
82
SET SQL_SELECT_LIMIT=DEFAULT, MAX_JOIN_SIZE=DEFAULT;
89
83
 
90
84
# End of 4.1 tests