diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-10-14 17:04:12 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-10-14 17:04:12 +0300 |
| commit | f510752e5d8c3484b9bd562984ace8cdeb24dd7c (patch) | |
| tree | 52bab9dcb504eb7603d26f7b3c33ec0945d8f248 /mysql-test/r/distinct.result | |
| parent | 4f1b06bb519a720723a2d3c22bbf8ccbd636a88b (diff) | |
| download | mariadb-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.result | 2 |
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 |