summaryrefslogtreecommitdiff
path: root/mysql-test/r/select_safe.result
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-08-19 00:08:08 +0300
committermonty@mashka.mysql.fi <>2003-08-19 00:08:08 +0300
commit4f7512160bfd467e5d53c3e133e1842fac2737ce (patch)
treedf4f8c8cf4d399e322333c5516d5c19507b1fda8 /mysql-test/r/select_safe.result
parent2263e3e51faba531a0a7055dbf706a6a8719ad70 (diff)
downloadmariadb-git-4f7512160bfd467e5d53c3e133e1842fac2737ce.tar.gz
After merge fixes
Use server character set if --default-character-set is not used Added convert_string() for more efficient alloc+character-set convert of strings
Diffstat (limited to 'mysql-test/r/select_safe.result')
-rw-r--r--mysql-test/r/select_safe.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/select_safe.result b/mysql-test/r/select_safe.result
index dfb12eacd9c..446dd41e216 100644
--- a/mysql-test/r/select_safe.result
+++ b/mysql-test/r/select_safe.result
@@ -61,21 +61,21 @@ a b
4 a
5 a
SELECT @@MAX_SEEKS_FOR_KEY;
-@@max_seeks_for_key
+@@MAX_SEEKS_FOR_KEY
4294967295
analyze table t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
insert into t1 values (null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a");
explain select * from t1,t1 as t2 where t1.b=t2.b;
-table type possible_keys key key_len ref rows Extra
-t1 ALL b NULL NULL NULL 21
-t2 ALL b NULL NULL NULL 16 Using where
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 ALL b NULL NULL NULL 21
+1 SIMPLE t2 ALL b NULL NULL NULL 16 Using where
set MAX_SEEKS_FOR_KEY=1;
explain select * from t1,t1 as t2 where t1.b=t2.b;
-table type possible_keys key key_len ref rows Extra
-t1 ALL b NULL NULL NULL 21
-t2 ref b b 21 t1.b 6 Using where
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 ALL b NULL NULL NULL 21
+1 SIMPLE t2 ref b b 21 test.t1.b 6 Using where
SET MAX_SEEKS_FOR_KEY=DEFAULT;
drop table t1;
SET SQL_SAFE_UPDATES=0,SQL_SELECT_LIMIT=DEFAULT, SQL_MAX_JOIN_SIZE=DEFAULT;