Bug #38445 select Result abnormal when two table join and using normal index .
Submitted: 30 Jul 2008 8:16 Modified: 20 Nov 2008 14:11
Reporter: wang xiaolin Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.0.45,5.0.51(GA),5.1.26 OS:Linux (CentOS 4)
Assigned to: CPU Architecture:Any
Tags: abnormal, cluster, join, normal index, SELECT, Two tables

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:

[30 Jul 2008 8:20] wang xiaolin
table testMM insert SQL .

Attachment: TestMM.SQL (text/plain), 101.63 KiB.

[30 Jul 2008 8:21] wang xiaolin
test Data of table TestB .

Attachment: TestB.sql (text/plain), 34.10 KiB.

[30 Jul 2008 8:23] wang xiaolin
ndb_cluster config

Attachment: ndbconfig.ini (application/octet-stream, text), 1.24 KiB.

[31 Jul 2008 3:25] wang xiaolin
Test again for more easy to read .

Attachment: bug-data-38445.zip.zip (application/x-zip-compressed, text), 5.42 KiB.

[31 Jul 2008 21:32] Hartmut Holzgraefe
test case

Attachment: bug38445.test (application/octet-stream, text), 61.96 KiB.