"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "mysql-test/r/view.result" between
mariadb-10.2.21.tar.gz and mariadb-10.2.22.tar.gz

About: MariaDB is a relational database management system (a drop-in replacement for MySQL). Stable (GA) release (10.2).

view.result  (mariadb-10.2.21):view.result  (mariadb-10.2.22)
skipping to change at line 4672 skipping to change at line 4672
SELECT * FROM t1, t2 SELECT * FROM t1, t2
WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a) WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a)
WHERE t4.a >= t1.a); WHERE t4.a >= t1.a);
id select_type table type possible_keys key key_len ref r ows filtered Extra id select_type table type possible_keys key key_len ref r ows filtered Extra
1 PRIMARY t2 system NULL NULL NULL NULL 1 100.00 1 PRIMARY t2 system NULL NULL NULL NULL 1 100.00
1 PRIMARY t1 ALL NULL NULL NULL NULL 2 100.00 U sing where 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 100.00 U sing where
2 DEPENDENT SUBQUERY t3 system NULL NULL NULL NULL 0 0.00 const row not found 2 DEPENDENT SUBQUERY t3 system NULL NULL NULL NULL 0 0.00 const row not found
2 DEPENDENT SUBQUERY t4 ALL NULL NULL NULL NULL 2 100.00 Using where 2 DEPENDENT SUBQUERY t4 ALL NULL NULL NULL NULL 2 100.00 Using where
Warnings: Warnings:
Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELEC T #1 Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELEC T #1
Note 1003 select `test`.`t1`.`a` AS `a`,10 AS `a` from `test`.`t1` where !< expr_cache><10,`test`.`t1`.`a`>(<in_optimizer>(10,<exists>(select NULL from `tes t`.`t4` where `test`.`t4`.`a` >= `test`.`t1`.`a` and trigcond(<cache>(10) = NULL or <cache>(NULL is null)) having trigcond(NULL is null)))) Note 1003 select `test`.`t1`.`a` AS `a`,10 AS `a` from `test`.`t1` where !< expr_cache><10,`test`.`t1`.`a`>(<in_optimizer>(10,<exists>(select NULL from `tes t`.`t4` where `test`.`t4`.`a` >= `test`.`t1`.`a` and trigcond(<cache>(10) = NULL or 1) having trigcond(NULL is null))))
SELECT * FROM t1, t2 SELECT * FROM t1, t2
WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a) WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a)
WHERE t4.a >= t1.a); WHERE t4.a >= t1.a);
a a a a
EXPLAIN EXTENDED EXPLAIN EXTENDED
SELECT * FROM v1, t2 SELECT * FROM v1, t2
WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a) WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a)
WHERE t4.a >= v1.a); WHERE t4.a >= v1.a);
id select_type table type possible_keys key key_len ref r ows filtered Extra id select_type table type possible_keys key key_len ref r ows filtered Extra
1 PRIMARY t2 system NULL NULL NULL NULL 1 100.00 1 PRIMARY t2 system NULL NULL NULL NULL 1 100.00
1 PRIMARY t1 ALL NULL NULL NULL NULL 2 100.00 U sing where 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 100.00 U sing where
2 DEPENDENT SUBQUERY t3 system NULL NULL NULL NULL 0 0.00 const row not found 2 DEPENDENT SUBQUERY t3 system NULL NULL NULL NULL 0 0.00 const row not found
2 DEPENDENT SUBQUERY t4 ALL NULL NULL NULL NULL 2 100.00 Using where 2 DEPENDENT SUBQUERY t4 ALL NULL NULL NULL NULL 2 100.00 Using where
Warnings: Warnings:
Note 1276 Field or reference 'v1.a' of SELECT #2 was resolved in SELECT #1 Note 1276 Field or reference 'v1.a' of SELECT #2 was resolved in SELECT #1
Note 1003 select `test`.`t1`.`a` AS `a`,10 AS `a` from `test`.`t1` where !< expr_cache><10,`test`.`t1`.`a`>(<in_optimizer>(10,<exists>(select NULL from `tes t`.`t4` where `test`.`t4`.`a` >= `test`.`t1`.`a` and trigcond(<cache>(10) = NULL or <cache>(NULL is null)) having trigcond(NULL is null)))) Note 1003 select `test`.`t1`.`a` AS `a`,10 AS `a` from `test`.`t1` where !< expr_cache><10,`test`.`t1`.`a`>(<in_optimizer>(10,<exists>(select NULL from `tes t`.`t4` where `test`.`t4`.`a` >= `test`.`t1`.`a` and trigcond(<cache>(10) = NULL or 1) having trigcond(NULL is null))))
SELECT * FROM v1, t2 SELECT * FROM v1, t2
WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a) WHERE t2.a NOT IN (SELECT t3.b FROM t3 RIGHT JOIN t4 ON (t4.a = t3.a)
WHERE t4.a >= v1.a); WHERE t4.a >= v1.a);
a a a a
DROP VIEW v1; DROP VIEW v1;
DROP TABLE t1,t2,t3,t4; DROP TABLE t1,t2,t3,t4;
# #
# LP bug #823237: dependent subquery with LEFT JOIN # LP bug #823237: dependent subquery with LEFT JOIN
# referencing view in WHERE # referencing view in WHERE
# (duplicate of LP bug #823189) # (duplicate of LP bug #823189)
 End of changes. 2 change blocks. 
2 lines changed or deleted 2 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)