summaryrefslogtreecommitdiff
path: root/mysql-test/suite/pbxt/r/ps_11bugs.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/pbxt/r/ps_11bugs.result')
-rw-r--r--mysql-test/suite/pbxt/r/ps_11bugs.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/pbxt/r/ps_11bugs.result b/mysql-test/suite/pbxt/r/ps_11bugs.result
index fad35b97b24..dd09e9d14f3 100644
--- a/mysql-test/suite/pbxt/r/ps_11bugs.result
+++ b/mysql-test/suite/pbxt/r/ps_11bugs.result
@@ -120,9 +120,9 @@ create table t1 (a int primary key);
insert into t1 values (1);
explain select * from t1 where 3 in (select (1+1) union select 1);
id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
-2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL Impossible HAVING
-3 DEPENDENT UNION NULL NULL NULL NULL NULL NULL NULL Impossible HAVING
+1 PRIMARY t1 index NULL PRIMARY 4 NULL 1 Using index
+2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL No tables used
+3 DEPENDENT UNION NULL NULL NULL NULL NULL NULL NULL No tables used
NULL UNION RESULT <union2,3> ALL NULL NULL NULL NULL NULL
select * from t1 where 3 in (select (1+1) union select 1);
a