Bug #18175 union with aggregate function over 128 tables returns fail.
Submitted: 13 Mar 2006 2:01 Modified: 22 Jun 2006 17:52
Reporter: dharana ashtanga
Status: Closed
Category:Server: Optimizer Severity:S1 (Critical)
Version:5.0.18 OS:Linux (Debian 3.1r0 Kernel 2.6.8 SMP)
Assigned to: Evgeny Potemkin Target Version:

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-18175.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.

[13 Mar 2006 8:10] Hartmut Holzgraefe
test case with 128 tables, works on both 5.0.17 and 5.0.18

Attachment: t128.sql (text/x-sql), 13.60 KiB.

[13 Mar 2006 8:11] Hartmut Holzgraefe
testcase with 129 tables, works on 5.0.17 and fails on .18

Attachment: t129.sql (text/x-sql), 13.71 KiB.