[MCOL-4676] ColumnStore MTR tests: missing have_innodb.inc and unpredictable default_storage_engine Created: 2021-04-15  Updated: 2021-05-27  Resolved: 2021-04-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: mtr
Affects Version/s: 5.6.1, 6.1.1
Fix Version/s: 5.6.1, 6.1.1

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MCOL-4659 Server MTR failures on ColumnStore tests Open
Relates
relates to MCOL-4736 Fix cross-engine mtr tests to run wit... Closed

 Description   

This is a subtask for MCOL-4659. Under terms of this MCOL let's fix the wrong ENGINE related failures.

If I run mtr from a build dir:

cd mysql-test
 
./mtr --suite=columnstore/basic

some tests fail.

Missing InnoDB plugin

Some tests miss have_innodb.inc and fail with

Unknown storage engine 'INNODB'

Unpredictable default storage engine

Some tests miss:

set @@default_storage_engine=InnoDB

and fail with this symptom:

-) ENGINE=InnoDB DEFAULT CHARSET=koi8r
 
+) ENGINE=MyISAM DEFAULT CHARSET=koi8r

We should:

  • add 

    --source have_innodb.inc

  • and fix the engine to be predictable
    either add this command into the beginning of all affected tests 

    set @@default_storage_engine=InnoDB

    or add explicit ENGINE clause into all CREATE TABLE statements in these tests

    ENGINE=InnoDB



 Comments   
Comment by Alexander Barkov [ 2021-04-15 ]

The proposed change fixes the following tests:

./mtr --force --max-test-fail=0  \
 
columnstore/basic.mcol_2000  \
 
columnstore/basic.mcs18_create_drop_users \
 
columnstore/basic.mcs19_grant_revoke \
 
columnstore/basic.mcol_4222  \
 
columnstore/basic.mcs10_drop_db_table \
 
columnstore/basic.mcs11_show_db_table \
 
columnstore/basic.mcs12_alter_table \
 
columnstore/basic.mcs14_truncate_table \
 
columnstore/basic.mcs24_insert_from_another_table \
 
columnstore/basic.mcs5_create_table_from_other_tables \

Generated at Thu Feb 08 02:52:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.