diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-06-27 01:00:22 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-06-27 01:00:22 +0400 |
| commit | 99a8bfe68cdd6411ed24b3fa465d5dd4b70be6dc (patch) | |
| tree | ff39d52783dd1e666e33ecfa0fd6a83739e0fe77 /mysql-test | |
| parent | 79392b9383921cb1d48ca0defb8715f7385af0e8 (diff) | |
| download | mariadb-git-99a8bfe68cdd6411ed24b3fa465d5dd4b70be6dc.tar.gz | |
[SHOW] EXPLAIN UPDATE/DELETE, code re-structuring
- Update view.result (old EXPLAIN didn't match the execution)
- Put in a stub code to work around the
SELECT ... UNION SELECT ... ORDER BY (subuqery) problem
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/disabled.def | 2 | ||||
| -rw-r--r-- | mysql-test/r/view.result | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/disabled.def b/mysql-test/disabled.def index 4133eb2a12c..d9f8f15cfff 100644 --- a/mysql-test/disabled.def +++ b/mysql-test/disabled.def @@ -16,4 +16,4 @@ read_many_rows_innodb : Bug#11748886 2010-11-15 mattiasj report already exist archive-big : Bug#11817185 2011-03-10 Anitha Disabled since this leads to timeout on Solaris Sparc log_tables-big : Bug#11756699 2010-11-15 mattiasj report already exists mysql_embedded : Bug#12561297 2011-05-14 Anitha Dependent on PB2 changes - eventum#41836 -show_explain : Psergey: random timeout in range-checked-for-each record query. +#show_explain : Psergey: random timeout in range-checked-for-each record query. diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 7fc2fa72805..bc286c36655 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3584,7 +3584,7 @@ View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` FORCE INDEX (PRIMARY) FORCE INDEX (`b`) order by `t1`.`a` latin1 latin1_swedish_ci EXPLAIN SELECT * FROM v1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index NULL PRIMARY 4 NULL 15 +1 SIMPLE t1 ALL NULL NULL NULL NULL 15 CREATE VIEW v2 AS SELECT * FROM t1 USE KEY () ORDER BY a; SHOW CREATE VIEW v2; View Create View character_set_client collation_connection |