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
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1
• OS: Any
• CPU Architecture: Any
• Tags: disabled

[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:[e-mail]-20090517174455-elhpj0j1r63z3aax) (version source revid:[e-mail]-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:[e-mail]-20090517133234-suxu78f7ydqw7eib) (version source revid:[e-mail]-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:[e-mail]-20090517174354-mkye4oq2lrilhqwv) (version source revid:[e-mail]-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