Bug #44919 parts-suite in mtr tries to use features not supported by ndb
Submitted: 17 May 2009 12:07 Modified: 17 May 2009 13:33
Reporter: Jonas Oreland Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: disabled
Triage: Triaged: D4 (Minor) / R6 (Needs Assessment) / E6 (Needs Assessment)

[17 May 2009 12:07] Jonas Oreland
Description:
A number of tests in the parts-suite tries to create table where the
partitioning function is dependent on columns not part of the primary key.

The check for this was ommitted in ha_ndbcluster, but has now been added
(bug#40709), this cause the following testcases to fail, where as they
previously had been running code which had undefined semantics.

partition_mgm_lc1_ndb, part_supported_sql_func_ndb, partition_basic_ndb, partition_engine_ndb

NOTE: I fixed bug#40709 in mysql-5.1-telco-6.2
So modification of the testcases should either be done in
this clone, or in 5.1-main and merged down.

How to repeat:
run any of mentioned testcases in mysql-5.1-telco-6.2
and the testcases will fail with ndb error

Got error 4327 'Distribution key is only supported on part of primary key' from NDB

Suggested fix:
adopt test cases to test things ndb support.
[17 May 2009 12:07] Jonas Oreland
partition_mgm_lc0_ndb should also be part of list...sorry
[17 May 2009 13:33] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/74309

2927 Jonas Oreland	2009-05-17
      bug#44919 - disable invalid testcases
[17 May 2009 17:46] Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090517174455-elhpj0j1r63z3aax) (version source revid:jonas@mysql.com-20090517174455-elhpj0j1r63z3aax) (merge vers: 5.1.34-ndb-7.0.6) (pib:6)
[17 May 2009 17:47] Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090517133234-suxu78f7ydqw7eib) (version source revid:jonas@mysql.com-20090517133234-suxu78f7ydqw7eib) (merge vers: 5.1.34-ndb-6.2.18) (pib:6)
[17 May 2009 17:48] Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090517174354-mkye4oq2lrilhqwv) (version source revid:jonas@mysql.com-20090517174354-mkye4oq2lrilhqwv) (merge vers: 5.1.34-ndb-6.3.25) (pib:6)
[18 May 2009 19:28] Jonas Oreland
comment: the problem is in tests written by QA.
hence I don't think bocklin is a suitable lead.
(and don't think category cluster is applicable either...)
[13 Jul 2009 18:34] Joerg Bruehe
The patch to disable the affected test cases is incomplete:
It should also handle
  partition_mgm_lc2_ndb

(Found during the build of cluster-6.3.25)
[23 Sep 2009 19:10] Alexander Nozdrin
Bug#45710 was marked as a duplicate of this one.
[17 Dec 2009 10:21] Jonas Oreland
FYI: I added partition_mgm_lc2_ndb to disable.def
  as part of merging 5.1.41 into telco-trees.

  Since joerg is correct, that testcase tries to use features
    not supported by ndb