47
42
SELECT * from t1 order by a;
55
50
ERROR 42000: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
56
51
SET MAX_JOIN_SIZE=DEFAULT;
64
59
Table Op Msg_type Msg_text
65
60
test.t1 analyze status OK
66
61
insert into t1 values (null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a");
67
62
explain select STRAIGHT_JOIN * from t1,t1 as t2 where t1.b=t2.b;
68
63
id select_type table type possible_keys key key_len ref rows Extra
72
67
explain select STRAIGHT_JOIN * from t1,t1 as t2 where t1.b=t2.b;
73
68
id select_type table type possible_keys key key_len ref rows Extra
76
71
SET MAX_SEEKS_FOR_KEY=DEFAULT;