Created by Sergey Petrunia and last modified
Get this branch:
bzr branch lp:~maria-captains/maria/10.0.15-mdev6634-r2
Members of Maria-captains can upload to this branch. Log in for directions.

Branch merges

Related bugs

Related blueprints

Branch information


Recent revisions

4508. By Sergey Petrunia

Better formatting

4507. By Sergey Petrunia

Backport fixes from 10.1 into 10.0:
  MDEV-6634: Wrong estimates for ref(const) and key IS NULL predicate

  IS [NOT] NULL predicate is sargable within an outer join. Range
  analysis only uses predicates from ON expressions, which have
  regular semantics (without null-complemented rows, etc).
  There is no reason not use IS [NOT] NULL predicates.

  MDEV-6634: Wrong estimates for ref(const): Update test result

4506. By Sergei Golubchik

5.5 merge

4505. By Sergei Golubchik


4504. By Sergey Petrunia

MDEV-7118: Anemometer stop working after upgrade to from...

When the optimizer considers an option to use Loose Scan, it should
still consider UNIQUE keys (Previously, MDEV-4120 disabled loose scan
for all kinds of unique indexes. That was wrong)

However, we should not use Loose Scan when trying to satisfy
 "SELECT DISTINCT col1, col2, .. colN"
when using an index defined as UNIQU(col1, col2, ... colN).

4503. By Elena Stepanova

MDEV-7074 multi_source.simple test fails in buildbot

The problem is that the binlog position is updated before
Executed_log_entries and Slave_SQL_State. So, it's possible to hit
the moment when MASTER_POS_WAIT (and hence sync_with_master) already
returned success, but Slave_SQL_State and Executed_log_entries were not
modified yet.
Fixing it by adding a wait on the expected Executed_log_entries value.

4502. By Alexander Barkov

MDEV-6993 Bad results with join comparing DECIMAL and ENUM/SET columns

4501. By Alexander Barkov

MDEV-6978 Bad results with join comparing case insensitive VARCHAR/ENUM/SET
expression to a _bin ENUM column

4500. By Alexander Barkov

MDEV-6991 GROUP_MIN_MAX optimization is erroneously applied in some cases

4499. By Alexander Barkov

MDEV-6950 Bad results with joins comparing DATE/DATETIME and INT/DECIMAL/DOUBLE/ENUM/VARCHAR columns
MDEV-6971 Bad results with joins comparing TIME and DOUBLE/DECIMAL columns
Disallow using indexes on non-temporal columns to optimize
ref access, range access and table elimination when the counterpart's
cmp_type is TIME_RESULT, e.g.:
  SELECT * FROM t1 WHERE indexed_int_column=time_expression;
Only index on a temporal column can be used to optimize temporal comparison

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
This branch contains Public information 
Everyone can see this information.