diff options
author | Alexander Barkov <bar@mariadb.org> | 2014-11-03 21:45:06 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2014-11-03 21:45:06 +0400 |
commit | 43f185e171eecdce41e71c548ce0bc2bd6969c0f (patch) | |
tree | ef2a7c8ea219bb66aeb1532eedfae9268f9f3ae1 /mysql-test/r/subselect_no_opts.result | |
parent | a245543bc8821b15409b839197d911302fb5bfb0 (diff) | |
download | mariadb-git-43f185e171eecdce41e71c548ce0bc2bd6969c0f.tar.gz |
MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats
Diffstat (limited to 'mysql-test/r/subselect_no_opts.result')
-rw-r--r-- | mysql-test/r/subselect_no_opts.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect_no_opts.result b/mysql-test/r/subselect_no_opts.result index 870d1ebfb84..7ecd40c3863 100644 --- a/mysql-test/r/subselect_no_opts.result +++ b/mysql-test/r/subselect_no_opts.result @@ -3697,8 +3697,8 @@ WHERE t1.t < t2.t AND t1.i2=1 AND t2.i1=t1.i1 ORDER BY t1.t DESC LIMIT 1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 system NULL NULL NULL NULL 1 -1 PRIMARY t1 index NULL PRIMARY 16 NULL 11 Using where; Using index -2 SUBQUERY t1 range PRIMARY PRIMARY 16 NULL 5 Using where; Using index +1 PRIMARY t1 index NULL PRIMARY 13 NULL 11 Using where; Using index +2 SUBQUERY t1 range PRIMARY PRIMARY 13 NULL 5 Using where; Using index SELECT * FROM t1,t2 WHERE t1.t = (SELECT t1.t FROM t1 WHERE t1.t < t2.t AND t1.i2=1 AND t2.i1=t1.i1 |