mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
1e0a72a18b
Created tests for "delete" based on update_use_source.test For the update_use_source.test tests, data recovery in the table has been changed from a rollback transaction to a complete delete and re-insert of the data with optimize table. Cases are now being checked on three engines. Added tests for update/delete with LooseScan and DuplicateWeedout optimization strategies Added tests for engine MEMORY on delete and update Added tests for multi-update with JSON_TABLE Added tests for multi-update and multi-delete for engine Connect
42 lines
1.4 KiB
Text
42 lines
1.4 KiB
Text
--source include/have_innodb.inc
|
|
|
|
set @save_default_engine=@@default_storage_engine;
|
|
|
|
--echo #######################################
|
|
--echo # #
|
|
--echo # Engine InnoDB #
|
|
--echo # #
|
|
--echo #######################################
|
|
set global innodb_stats_persistent=1;
|
|
set default_storage_engine=InnoDB;
|
|
--source include/delete_use_source_innodb.inc
|
|
|
|
--echo #######################################
|
|
--echo # #
|
|
--echo # Engine Aria #
|
|
--echo # #
|
|
--echo #######################################
|
|
set default_storage_engine=Aria;
|
|
--source include/delete_use_source.inc
|
|
|
|
--echo #######################################
|
|
--echo # #
|
|
--echo # Engine MyISAM #
|
|
--echo # #
|
|
--echo #######################################
|
|
set default_storage_engine=MyISAM;
|
|
--source include/delete_use_source.inc
|
|
|
|
--echo #######################################
|
|
--echo # #
|
|
--echo # Engine MEMORY #
|
|
--echo # #
|
|
--echo #######################################
|
|
set default_storage_engine=MEMORY;
|
|
--source include/delete_use_source_memory.inc
|
|
|
|
set @@default_storage_engine=@save_default_engine;
|
|
|
|
--echo #
|
|
--echo # End of 11.0 tests
|
|
--echo #
|