From f510752e5d8c3484b9bd562984ace8cdeb24dd7c Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 14 Oct 2002 17:04:12 +0300 Subject: 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 --- mysql-test/r/distinct.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/r/distinct.result') 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 -- cgit v1.2.1