diff options
author | Igor Babaev <igor@askmonty.org> | 2018-08-18 22:57:20 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2018-08-21 12:27:29 -0700 |
commit | a1fd25c22bc27e58b802dd83ee48428913351180 (patch) | |
tree | 3b71e72fb1b2ecdb6f4360a99cf24cd2f6caefca /mysql-test/main/opt_tvc.test | |
parent | 0dadb96e169d3fa94b5cbcadd97b3cc8e3c0e138 (diff) | |
download | mariadb-git-a1fd25c22bc27e58b802dd83ee48428913351180.tar.gz |
MDEV-17017 Explain for query using derived table specified with a table
value constructor shows wrong number of rows
If the specification of a derived table contained a table value constructor
then the optimizer incorrectly estimated the number of rows in the derived
table. This happened because the optimizer did not take into account the
number of rows in the constructor. The wrong estimate could lead to choosing
inefficient execution plans.
Diffstat (limited to 'mysql-test/main/opt_tvc.test')
-rw-r--r-- | mysql-test/main/opt_tvc.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/opt_tvc.test b/mysql-test/main/opt_tvc.test index d5c9a5cbd3d..2d06a0a0b20 100644 --- a/mysql-test/main/opt_tvc.test +++ b/mysql-test/main/opt_tvc.test @@ -255,7 +255,7 @@ deallocate prepare stmt; --echo # use inside out access from tvc rows -let $query= select * from t3 where a in (1,4,10); +let $query= select * from t3 where a in (1,4); set @@in_predicate_conversion_threshold= default; eval $query; eval explain extended $query; |