← 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-02-14 01:56:51 UTC
  • mto: (1273.16.5 fix_is)
  • mto: This revision was merged to the branch mainline in revision 1300.
  • Revision ID: brian@gaz-20100214015651-ror9j0xu7dccz0ct
Two fixes for "make dist"

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
13
12
SELECT SQL_BUFFER_RESULT * from t1;
14
13
update t1 set b="a" where a=1;
15
14
delete from t1 where a=1;
16
15
insert into t1 values(1,"test"),(2,"test2");
17
 
--sorted_result
18
16
SELECT SQL_BUFFER_RESULT * from t1;
19
17
update t1 set b="a" where a=1;
20
18
select 1 from t1,t1 as t2,t1 as t3;
39
37
SET MAX_JOIN_SIZE=2;
40
38
SELECT @@MAX_JOIN_SIZE, @@SQL_BIG_SELECTS;
41
39
insert into t1 values (null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a");
42
 
--error ER_TOO_BIG_SELECT
 
40
--error 1104
43
41
SELECT * from t1 order by a;
44
42
SET SQL_BIG_SELECTS=1;
45
43
SELECT * from t1 order by a;
46
44
SET MAX_JOIN_SIZE=2;
47
 
--error ER_TOO_BIG_SELECT
 
45
--error 1104
48
46
SELECT * from t1;
49
47
SET MAX_JOIN_SIZE=DEFAULT;
50
48
SELECT * from t1;
69
67
insert into t1 select * from t1;
70
68
 
71
69
set local  max_join_size=8;
72
 
--error ER_TOO_BIG_SELECT
 
70
--error 1104
73
71
select * from (select * from t1) x;
74
72
 
75
73
set local  max_join_size=1;
76
 
--error ER_TOO_BIG_SELECT
 
74
--error 1104
77
75
select * from (select a.a as aa, b.a as ba from t1 a, t1 b) x;
78
76
 
79
77
set local  max_join_size=1;
80
 
--error ER_TOO_BIG_SELECT
 
78
--error 1104
81
79
select * from (select 1 union select 2 union select 3) x;
82
80
drop table t1;
83
81