diff options
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index ac874f9943c..b306965034b 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2611,7 +2611,11 @@ explain select a from t1 where c=2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where drop table t1; +connect root,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK; +connection root; set @got_val= (SELECT 1 FROM (SELECT 'A' as my_col) as T1 ) ; +disconnect root; +connection default; create table t1 (a int, b int); create table t2 (a int, b int); insert into t1 values (1,1),(1,2),(1,3),(2,4),(2,5); |