diff options
| author | monty@hundin.mysql.fi <> | 2002-10-14 17:04:12 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-10-14 17:04:12 +0300 |
| commit | 68963e91b2e7195d82dea2f83a8525f9a69b72f5 (patch) | |
| tree | 52bab9dcb504eb7603d26f7b3c33ec0945d8f248 /mysql-test/r | |
| parent | 00e86fb5ccc46d4801514a7aae3cf636fc2a391b (diff) | |
| download | mariadb-git-68963e91b2e7195d82dea2f83a8525f9a69b72f5.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.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/distinct.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/null_key.result | 6 |
2 files changed, 7 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 diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index ead1dc29326..a0f88b804aa 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -120,3 +120,9 @@ id uniq_id 4 2 7 3 8 4 +order_id product_id product_type +order_id product_id product_type +3d7ce39b5d4b3e3d22aaafe9b633de51 1206029 3 +3d7ce39b5d4b3e3d22aaafe9b633de51 5880836 3 +id id +id id |