summaryrefslogtreecommitdiff
path: root/mysql-test/r/distinct.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2002-10-14 17:04:12 +0300
committerunknown <monty@hundin.mysql.fi>2002-10-14 17:04:12 +0300
commita86c172f582570dbc19554e85691c34869def66f (patch)
tree52bab9dcb504eb7603d26f7b3c33ec0945d8f248 /mysql-test/r/distinct.result
parent61632073ac9473e00d5e0c88078880d3af575828 (diff)
downloadmariadb-git-a86c172f582570dbc19554e85691c34869def66f.tar.gz
Fixed a bug in key optimizing handling where the expression
WHERE column_name = key_column_name was calculated as true for NULL values. Docs/manual.texi: Changelog mysql-test/r/distinct.result: Updated results caused by bug fix. mysql-test/r/null_key.result: New tests mysql-test/t/null_key.test: New tests sql/sql_select.cc: Additional change for previous changeset for using BLOB in GROUP BY
Diffstat (limited to 'mysql-test/r/distinct.result')
-rw-r--r--mysql-test/r/distinct.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result
index 1d18fb4c75b..0d2f6c6c59c 100644
--- a/mysql-test/r/distinct.result
+++ b/mysql-test/r/distinct.result
@@ -128,7 +128,7 @@ a
1
table type possible_keys key key_len ref rows Extra
t1 index PRIMARY PRIMARY 4 NULL 2 Using index; Using temporary
-t3 ref a a 5 t1.a 10 Using index; Distinct
+t3 ref a a 5 t1.a 10 where used; Using index; Distinct
a
1
2