summaryrefslogtreecommitdiff
path: root/mysql-test/r/null_key.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2001-11-27 02:50:20 +0200
committerunknown <monty@hundin.mysql.fi>2001-11-27 02:50:20 +0200
commit312e5e82c0b17983bc3ac43b50fac891cccf0ea2 (patch)
tree390d698047d7a779d20d1f8db12dc8a715816aee /mysql-test/r/null_key.result
parent0c9d051c1624b6c097b6c254b9350f919ad01eb9 (diff)
downloadmariadb-git-312e5e82c0b17983bc3ac43b50fac891cccf0ea2.tar.gz
Fixed bug when joining with caching.
Fixed race condition when using the binary log and INSERT DELAYED which could cause the binary log to have rows that was not yet written to MyISAM tables. Docs/manual.texi: Changelog mysql-test/r/null_key.result: Fix of testcase after changing optimizer to only use range keys if it would use a long part of the SAME key. sql/sql_insert.cc: Fixed race condition with binary log and INSERT DELAYED sql/sql_select.cc: Fixed bug when joining with caching
Diffstat (limited to 'mysql-test/r/null_key.result')
-rw-r--r--mysql-test/r/null_key.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result
index d0d59cdebf8..ead1dc29326 100644
--- a/mysql-test/r/null_key.result
+++ b/mysql-test/r/null_key.result
@@ -11,7 +11,7 @@ t1 index NULL a 9 NULL 12 where used; Using index
table type possible_keys key key_len ref rows Extra
t1 range a,b a 9 NULL 3 where used; Using index
table type possible_keys key key_len ref rows Extra
-t1 range a,b a 9 NULL 2 where used; Using index
+t1 ref a,b b 4 const 2 where used
table type possible_keys key key_len ref rows Extra
t1 ref a,b a 5 const 3 where used; Using index
table type possible_keys key key_len ref rows Extra