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
commitf510752e5d8c3484b9bd562984ace8cdeb24dd7c (patch)
tree52bab9dcb504eb7603d26f7b3c33ec0945d8f248 /mysql-test/r/distinct.result
parent4f1b06bb519a720723a2d3c22bbf8ccbd636a88b (diff)
downloadmariadb-git-f510752e5d8c3484b9bd562984ace8cdeb24dd7c.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