diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-07-17 12:31:45 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2019-07-19 18:00:10 +0200 |
| commit | f90040fd9ccb99cb4541d181a7052c37dc38decb (patch) | |
| tree | 95a9b6d092ba63de4740105c8a2cdfae206e2256 /sql/sql_lex.cc | |
| parent | cc86a0bd11a436dfe4df0622481c571f83b1680a (diff) | |
| download | mariadb-git-f90040fd9ccb99cb4541d181a7052c37dc38decb.tar.gz | |
MDEV-19429: Wrong query result with EXISTS and LIMIT 0bb-5.5-MDEV-19429
Check EXISTS LIMIT before rewriting.
Diffstat (limited to 'sql/sql_lex.cc')
| -rw-r--r-- | sql/sql_lex.cc | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/sql/sql_lex.cc b/sql/sql_lex.cc index 28f56282bad..fe4dcfd1524 100644 --- a/sql/sql_lex.cc +++ b/sql/sql_lex.cc @@ -2456,14 +2456,13 @@ void st_select_lex::print_limit(THD *thd, if (item && unit->global_parameters == this) { Item_subselect::subs_type subs_type= item->substype(); - if (subs_type == Item_subselect::EXISTS_SUBS || - subs_type == Item_subselect::IN_SUBS || + if (subs_type == Item_subselect::IN_SUBS || subs_type == Item_subselect::ALL_SUBS) { return; } } - if (explicit_limit) + if (explicit_limit && select_limit) { str->append(STRING_WITH_LEN(" limit ")); if (offset_limit) |