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/subselect2.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/subselect2.result')
| -rw-r--r-- | mysql-test/r/subselect2.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect2.result b/mysql-test/r/subselect2.result index 034cba58c8f..75e8c084026 100644 --- a/mysql-test/r/subselect2.result +++ b/mysql-test/r/subselect2.result @@ -287,7 +287,7 @@ ORDER BY mirror_date ASC ) AS calculated_result; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 -2 DERIVED t1 range date date 9 NULL 2 Using index condition; Using where; Rowid-ordered scan; Using filesort +2 DERIVED t1 range date date 6 NULL 2 Using index condition; Using where; Rowid-ordered scan; Using filesort SELECT * FROM ( SELECT node_uid, date, mirror_date, @result := 0 AS result FROM t1 @@ -310,7 +310,7 @@ ORDER BY mirror_date ASC ) AS calculated_result; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 -2 DERIVED t1 range date date 9 NULL 2 Using index condition; Using where; Using filesort +2 DERIVED t1 range date date 6 NULL 2 Using index condition; Using where; Using filesort SELECT * FROM ( SELECT node_uid, date, mirror_date, @result := 0 AS result FROM t1 |