diff options
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 1d643333424..d3c0aae91db 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -206,6 +206,8 @@ x 1 create user mysqltest_1; create table t1 select 1 as a; +connect con1,localhost,mysqltest_1,,*NO-ONE*,$MASTER_MYPORT,$MASTER_MYSOCK; +connection con1; set optimizer_switch='derived_merge=off,derived_with_keys=off'; select 2 as a from (select * from t1) b; ERROR 3D000: No database selected @@ -385,6 +387,9 @@ ID DATA FID select t2.* from (select * from t1) as A inner join t2 on A.ID = t2.FID; ID DATA FID drop table t1, t2; +connection con1; +disconnect con1; +connection default; drop user mysqltest_1; # End of 4.1 tests SELECT 0 FROM |