summaryrefslogtreecommitdiff
path: root/mysql-test/r/distinct.result
diff options
context:
space:
mode:
authorunknown <kostja@oak.local>2003-09-17 14:00:43 +0400
committerunknown <kostja@oak.local>2003-09-17 14:00:43 +0400
commit524fe47d0e8249e82d986eb0a3e30f6d85b2cdd2 (patch)
tree28ffab332b6fd863486aee81f3b96838ab1cab23 /mysql-test/r/distinct.result
parenta3056adeb6991dd7f0987b71a590a41859ce2db8 (diff)
downloadmariadb-git-524fe47d0e8249e82d986eb0a3e30f6d85b2cdd2.tar.gz
fixed test result to be in sync with the optimiser
Diffstat (limited to 'mysql-test/r/distinct.result')
-rw-r--r--mysql-test/r/distinct.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result
index da0c6a5eb72..9fcb001de2c 100644
--- a/mysql-test/r/distinct.result
+++ b/mysql-test/r/distinct.result
@@ -303,9 +303,9 @@ t1 index id id 4 NULL 2 Using index; Using temporary
t2 index id id 8 NULL 1 Using index; Distinct
t3 index id id 8 NULL 1 Using index; Distinct
j_lj_t2 index id id 4 NULL 2 Using where; Using index; Distinct
-t2_lj index id id 8 NULL 1 Using where; Using index; Distinct
+t2_lj ref id id 4 j_lj_t2.id 1 Using where; Using index; Distinct
j_lj_t3 index id id 4 NULL 2 Using where; Using index; Distinct
-t3_lj index id id 8 NULL 1 Using where; Using index; Distinct
+t3_lj ref id id 4 j_lj_t3.id 1 Using where; Using index; Distinct
SELECT DISTINCT
t1.id
from