Bug #38049 incorrect rows estimations with references from preceding table
Submitted: 11 Jul 2008 16:50 Modified: 12 Nov 21:17
Reporter: Ruslan Zakirov
Status: Closed
Category:Server: Optimizer Severity:S5 (Performance)
Version:5.0.60, 5.0.68-bzr, 5.1.28-bzr OS:Any
Assigned to: Guilhem Bichot Target Version:
Tags: rows, ref, preceding table, INDEX, multiple-column index
Triage: Triaged: D4 (Minor)

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-38049.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[11 Jul 2008 16:52] Ruslan Zakirov 
scripts to reproduce the problem

Attachment: ref_scan_with_preceding_table.tar.gz (application/gzip, text), 1.11 KiB.
[14 Jul 2008 23:23] Ruslan Zakirov 
updated create_data.pl

Attachment: create_data.pl (text/x-perl), 1.26 KiB.