Bug #35835 Cluster: BKA Join Buffer returns extra result rows.
Submitted: 4 Apr 2008 16:51 Modified: 20 Nov 2010 23:33
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:mysql-6.0-bka-preview OS:Linux
Assigned to: Igor Babaev CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

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:

[4 Apr 2008 16:52] Jonathan Miller
Test Case

Attachment: ndb_new.test (application/octet-stream, text), 31.60 KiB.

[4 Apr 2008 16:53] Jonathan Miller
Cluster Results BKA Clone w/ BKA == on

Attachment: ndb_new.result (application/octet-stream, text), 30.09 KiB.

[4 Apr 2008 16:54] Jonathan Miller
Reject file from BKA clone using cluster w/ BKA == off

Attachment: ndb_new.reject (application/octet-stream, text), 29.83 KiB.

[4 Apr 2008 16:55] Jonathan Miller
Cluster 5.0 Reject File

Attachment: ndb_new.5.0.reject (application/octet-stream, text), 33.60 KiB.

[4 Apr 2008 16:55] Jonathan Miller
Cluster 5.1 Reject File

Attachment: ndb_new.5.1.reject (application/octet-stream, text), 33.62 KiB.

[7 Apr 2008 21:57] Jonathan Miller
Updated results of BKA cluster with JCL=6

Attachment: ndb_new-jcl6.result (application/octet-stream, text), 30.18 KiB.

[7 Apr 2008 22:00] Jonathan Miller
Reject file from BKA using cluster JLC = 5

Attachment: ndb_new-jcl5.reject (application/octet-stream, text), 33.76 KiB.

[7 Apr 2008 22:00] Jonathan Miller
Reject file from BKA using cluster JLC = 4

Attachment: ndb_new-jcl4.reject (application/octet-stream, text), 33.50 KiB.

[7 Apr 2008 22:02] Jonathan Miller
Reject file from BKA using cluster JLC = 3

Attachment: ndb_new-jcl3.reject (application/octet-stream, text), 33.74 KiB.

[7 Apr 2008 22:06] Jonathan Miller
Reject file from BKA using cluster JLC = 2

Attachment: ndb_new-jcl2.reject (application/octet-stream, text), 33.74 KiB.

[7 Apr 2008 22:09] Jonathan Miller
Reject file from BKA using cluster JLC = 1

Attachment: ndb_new-jcl1.reject (application/octet-stream, text), 33.74 KiB.

[7 Apr 2008 22:11] Jonathan Miller
Reject file from BKA using cluster JLC = 0

Attachment: ndb_new-jcl0.reject (application/octet-stream, text), 33.74 KiB.

[8 Apr 2008 10:16] Kristian Nielsen
Reduced test case showing extra row returned

Attachment: ndb_new.test (application/octet-stream, text), 3.63 KiB.

[8 Apr 2008 10:18] Kristian Nielsen
Correct result file for reduced test case

Attachment: ndb_new.result (application/octet-stream, text), 2.29 KiB.