summaryrefslogtreecommitdiff
path: root/mysql-test/main/join.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/join.result')
-rw-r--r--mysql-test/main/join.result1
1 files changed, 0 insertions, 1 deletions
diff --git a/mysql-test/main/join.result b/mysql-test/main/join.result
index e667eab7eb9..88f67fb8074 100644
--- a/mysql-test/main/join.result
+++ b/mysql-test/main/join.result
@@ -1499,7 +1499,6 @@ EXPLAIN EXTENDED
SELECT * FROM t1 JOIN v2 ON i1 = i2 WHERE a < b;
id select_type table type possible_keys key key_len ref rows filtered Extra
1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
-2 DERIVED t2 ALL NULL NULL NULL NULL 2 100.00 Using where
Warnings:
Note 1003 /* select#1 */ select NULL AS `i1`,`v2`.`i2` AS `i2`,`v2`.`a` AS `a`,`v2`.`b` AS `b` from `test`.`v2` where `v2`.`i2` = NULL and `v2`.`a` < `v2`.`b`
DROP VIEW v2;