Bug #44821 | select distinct on partitioned table returns wrong results | ||
---|---|---|---|
Submitted: | 12 May 2009 13:10 | Modified: | 24 Jun 2009 11:05 |
Reporter: | Rene Eng | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S1 (Critical) |
Version: | 5.1.33, 5.1, 6.0 bzr | OS: | Any (Linux, Sun Solaris 10) |
Assigned to: | Martin Hansson | CPU Architecture: | Any |
Tags: | distinct, partition, SELECT |
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[13 May 2009 8:38]
Sveta Smirnova
[8 Jun 2009 12:28]
Martin Hansson
Minimal test case
Attachment: bug44821.test (, text), 624 bytes.
[8 Jun 2009 12:29]
Martin Hansson
Corresponding expected result
Attachment: bug44821.result (, text), 1.08 KiB.