Merge InnoDB test cases from MySQL 5.7 (MDEV-13626)

[MDEV-14261] fix innobase_drop_fts_index_table.test Created: 2017-11-02  Updated: 2023-11-08  Resolved: 2023-11-08

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Technical task Priority: Major
Reporter: Alice Sherepa Assignee: Marko Mäkelä
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

https://github.com/MariaDB/server/tree/bb-10.2-alice/mysql-test/suite/innodb_fts/t/innobase_drop_fts_index_table.test

innodb_fts.innobase_drop_fts_index_table 'innodb' [ fail ]
        Test ended at 2017-11-02 14:54:52
 
CURRENT_TEST: innodb_fts.innobase_drop_fts_index_table
mysqltest: At line 15: query 'ALTER TABLE t ADD FULLTEXT INDEX (b(64))' succeeded - should have failed with errno 1105...
 
The result from queries just before the failure was:
CREATE TABLE t (a INT, b TEXT);
SET DEBUG_DBUG='+d,alter_table_rollback_new_index';
ALTER TABLE t ADD FULLTEXT INDEX (b(64));

-- source include/have_innodb.inc
# Must have debug code to use SET SESSION debug
-- source include/have_debug.inc
-- source include/not_embedded.inc
CREATE TABLE t (a INT, b TEXT);
SET DEBUG_DBUG='+d,alter_table_rollback_new_index';
-- error ER_UNKNOWN_ERROR
ALTER TABLE t ADD FULLTEXT INDEX (b(64));
SET DEBUG_DBUG='-d,alter_table_rollback_new_index';
DROP TABLE t;



 Comments   
Comment by Marko Mäkelä [ 2023-11-08 ]

In MySQL 5.7, CREATE TABLE would default to ENGINE=InnoDB, while in MariaDB, it would default to ENGINE=MyISAM. After I added explicit ENGINE=InnoDB, the test worked as expected.

This test is included in our innodb_fts.misc_debug.

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