diff options
| author | timour/tkatchaounov@lamia.home <> | 2006-07-26 01:21:35 +0300 |
|---|---|---|
| committer | timour/tkatchaounov@lamia.home <> | 2006-07-26 01:21:35 +0300 |
| commit | dd7ae38de4dd9bfa23f5ef7db4805bb0e520d79d (patch) | |
| tree | 781490658362d595b930c82d130114a79ebe8b15 /mysql-test/r/subselect.result | |
| parent | 59dc5e883821cc03f7e9cd6c8338b0f126fccca6 (diff) | |
| parent | 86ae2f3b067ccd5383d06195d3be22a01d42d51c (diff) | |
| download | mariadb-git-dd7ae38de4dd9bfa23f5ef7db4805bb0e520d79d.tar.gz | |
Merge tkatchaounov@bk-internal.mysql.com:/home/bk/mysql-4.1-opt
into lamia.home:/home/tkatchaounov/autopush/4.1-bug-20954
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index a2a88be8c42..983ad628425 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -539,7 +539,7 @@ EXPLAIN EXTENDED SELECT MAX(numreponse) FROM t1 WHERE numeropost='1'; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away Warnings: -Note 1003 select max(test.t1.numreponse) AS `MAX(numreponse)` from test.t1 where (test.t1.numeropost = _latin1'1') +Note 1003 select max(test.t1.numreponse) AS `MAX(numreponse)` from test.t1 EXPLAIN EXTENDED SELECT numreponse FROM t1 WHERE numeropost='1' AND numreponse=(SELECT MAX(numreponse) FROM t1 WHERE numeropost='1'); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 const PRIMARY,numreponse PRIMARY 7 const,const 1 Using index |