Bug #36732 many disabled ndb tests in test suite parts

• Submitted: 15 May 2008 9:32
• Modified: 29 Jul 2008 9:57
• Reporter: Mattias Jonsson
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• Assigned to: Mattias Jonsson
• CPU Architecture: Any
• Triage: D3 (Medium)

[15 May 2008 9:32] Mattias Jonsson

Description:
Here is the mysql-test/suite/parts/t/disabled.def:
ndb_blob_partition             : cannot create t1
ndb_dd_backuprestore           : cannot create t1
ndb_partition_error            : cannot create t1
ndb_partition_list             : cannot create t1
ndb_partition_range            : cannot create t1
part_supported_sql_func_ndb    : cannot create t1
partition_alter1_ndb           : timeout. Needs too much time.
partition_alter2_ndb           : cannot create t1
partition_basic_ndb            : cannot create t1
partition_bit_ndb              : cannot create t1
partition_engine_ndb           : cannot create t1
partition_int_ndb              : cannot create t1
partition_sessions             : needs system_3_init.inc
partition_syntax_ndb           : cannot create t1
partition_value_innodb         : Bug#30581 partition_value tests use disallowed CAST() function
partition_value_myisam         : Bug#30581 partition_value tests use disallowed CAST() function
partition_value_ndb            : cannot create t1
rpl_ndb_dd_partitions          : cannot create t1
partition_alter4_myisam        : Bug#20129 / WL#4176
partition_alter4_innodb        : Bug#20129 / WL#4176

All ndb test should be updated to work (most are probably using list/range/hash partitioning which ndb does not support unless option 'new' is given)

Five tests are also duplicated from suite/ndb (where they have been updated):
ndb_blob_partition
ndb_partition_error
ndb_partition_key
ndb_partition_list
ndb_partition_range

How to repeat:
look at mysql-test/suite/parts/t/disabled.def

Suggested fix:
bk rm the five duplicated test files from mysql-test/suite/parts (both test and result files)
update the rest ndb test in suite/parts so they can be enabled
enable all ndb test in suite/parts.

[2 Jul 2008 8:24] Mattias Jonsson

bzr gcommit failed to send commit mail, so here is the 'bzr diff -r -1..' output

Attachment: b36732.diff.gz (application/x-gzip, text), 46.96 KiB.

[2 Jul 2008 8:25] Mattias Jonsson

and here is the comments (including per file comments) taken from 'bzr vis'

Attachment: b36732.comments.gz (application/x-gzip, text), 970 bytes.

[2 Jul 2008 8:27] Mattias Jonsson

I have committed a patch (see above):
Bug#36732: many disabled ndb tests in test suite parts

REORGANIZE TEST parts WHERE ENGINE='NDB' ;)

Updated tests for better matching NDB's limitations.

Removed some duplicate tests.

[8 Jul 2008 10:53] Mattias Jonsson

Pushed into mysql-6.0-bugteam and mysql-5.1-bugteam

[28 Jul 2008 13:44] Georgi Kodinov

Pushed to 5.1.28 and 6.0.7-alpha

[28 Jul 2008 16:47] Bugs System

Pushed into 5.1.28  (revid:[e-mail]-20080714105031-88hmr2baz5di9xej) (version source revid:[e-mail]-20080714105031-88hmr2baz5di9xej) (pib:3)

[28 Jul 2008 17:23] Paul Dubois

Test case changes. No 5.1.x changelog entry needed.

Setting report to Patch Queued pending push of fix into 6.0.x.

[29 Jul 2008 8:52] Georgi Kodinov

Pushed into 6.0.7-alpha

[29 Jul 2008 9:57] Jon Stephens

Closed without further action per comment from Paul.