mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-01-15 19:42:28 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/atomic/alter_table_aria.result
Sergey Vojtovich d50663198c DDL recovery for high-level indexes
2024-11-05 14:00:52 -08:00

2584 lines
69 KiB
Text
Raw Permalink Blame History

create database test2;
RESET MASTER;
engine: aria
query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
crash point: ddl_log_alter_after_drop_original_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new"
query: ALTER TABLE t1 COMMENT "new"
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new"
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 change column a c int COMMENT "new"
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new"
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_to_backup
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_to_backup_log
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_before_rename_triggers
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_triggers
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_after_delete_backup
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
crash point: ddl_log_alter_after_drop_original_table
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
query: ALTER TABLE t1 disable keys
crash point: ddl_log_alter_after_create_frm
"No crash!"
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
"No crash!"
crash point: ddl_log_alter_after_log
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
crash point: ddl_log_alter_after_drop_original_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, ALGORITHM=copy, COMMENT "new"
query: ALTER TABLE t1 rename t2
crash point: ddl_log_alter_after_create_frm
"No crash!"
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
"No crash!"
crash point: ddl_log_alter_after_log
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_rename_triggers
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 COMMENT "new", rename t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_copy
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
crash point: ddl_log_alter_after_log
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_triggers
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 change column a c int COMMENT "new", rename t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_copy
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
crash point: ddl_log_alter_after_log
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
crash point: ddl_log_alter_after_rename_triggers
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", rename t2
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup_log
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
crash point: ddl_log_alter_after_drop_original_table
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ENGINE=myisam, COMMENT "new"
query: ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
crash point: ddl_log_alter_after_rename_to_backup
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
crash point: ddl_log_alter_after_rename_to_backup_log
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
crash point: ddl_log_alter_after_drop_original_table
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) DEFAULT NULL COMMENT 'new',
`b` int(11) DEFAULT NULL,
KEY `a` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column a c int COMMENT "new", engine=myisam
query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_after_rename_to_backup
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_after_rename_to_backup_log
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_before_rename_triggers
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_after_rename_triggers
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_after_delete_backup
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
crash point: ddl_log_alter_after_drop_original_table
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2, engine=myisam
query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_rename_to_backup
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_rename_to_backup_log
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_before_rename_triggers
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_rename_triggers
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_delete_backup
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_drop_original_table
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename test2.t2
query: ALTER TABLE t1 COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
"No crash!"
crash point: ddl_log_alter_after_prepare_inplace
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_rename_to_backup
"No crash!"
crash point: ddl_log_alter_after_rename_to_backup_log
"No crash!"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
"No crash!"
crash point: ddl_log_alter_before_rename_triggers
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_rename_triggers
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename test2.t2
crash point: ddl_log_alter_after_delete_backup
"No crash!"
crash point: ddl_log_alter_after_drop_original_table
"No crash!"
query: ALTER TABLE t1 ADD key(b), COMMENT "new"
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
crash point: ddl_log_alter_after_rename_to_backup_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
crash point: ddl_log_alter_after_drop_original_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`),
KEY `b` (`b`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='new'
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD key(b), COMMENT "new"
query: ALTER TABLE t1 DROP INDEX a
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
crash point: ddl_log_alter_after_rename_to_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
crash point: ddl_log_alter_after_rename_to_backup_log
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
crash point: ddl_log_alter_after_drop_original_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 DROP INDEX a
query: ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1#i#01.MAD
t1#i#01.MAI
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
crash point: ddl_log_alter_after_rename_to_backup
t1#i#01.MAD
t1#i#01.MAI
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
crash point: ddl_log_alter_after_rename_to_backup_log
t1#i#01.MAD
t1#i#01.MAI
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1#i#01.MAD
t1#i#01.MAI
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1#i#01.MAD
t1#i#01.MAI
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
crash point: ddl_log_alter_after_drop_original_table
t1#i#01.MAD
t1#i#01.MAI
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v)
query: ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_after_rename_to_backup
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_after_rename_to_backup_log
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_before_rename_triggers
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_after_rename_triggers
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_after_delete_backup
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
crash point: ddl_log_alter_after_drop_original_table
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2
query: ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t1#i#01.MYD
t1#i#01.MYI
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
crash point: ddl_log_alter_after_rename_to_backup
t1#i#01.MYD
t1#i#01.MYI
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
crash point: ddl_log_alter_after_rename_to_backup_log
t1#i#01.MYD
t1#i#01.MYI
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t1#i#01.MYD
t1#i#01.MYI
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
crash point: ddl_log_alter_before_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_rename_triggers
"No crash!"
crash point: ddl_log_alter_after_delete_backup
t1#i#01.MYD
t1#i#01.MYI
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
crash point: ddl_log_alter_after_drop_original_table
t1#i#01.MYD
t1#i#01.MYI
t1.MYD
t1.MYI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), ENGINE=myisam
query: ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_after_rename_to_backup
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_after_rename_to_backup_log
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_before_rename_triggers
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_after_rename_triggers
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_after_delete_backup
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
crash point: ddl_log_alter_after_drop_original_table
t2#i#01.MYD
t2#i#01.MYI
t2.MYD
t2.MYI
t2.frm
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME t2, ENGINE=myisam
query: ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_after_create_frm
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_create_table
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_prepare_inplace
"No crash!"
crash point: ddl_log_alter_after_copy
t1.MAD
t1.MAI
t1.frm
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
crash point: ddl_log_alter_after_log
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_after_rename_to_backup
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_after_rename_to_backup_log
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_rename_frm
"No crash!"
crash point: ddl_log_alter_after_rename_to_original
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_before_rename_triggers
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_after_rename_triggers
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_after_delete_backup
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
crash point: ddl_log_alter_after_drop_original_table
t2#i#01.MAD
t2#i#01.MAI
t2.MAD
t2.MAI
t2.frm
"Table is in test2"
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`v` vector(5) NOT NULL,
KEY `a` (`a`),
VECTOR KEY `v` (`v`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
count(*)
2
master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN v VECTOR(5) NOT NULL, ADD VECTOR INDEX(v), RENAME test2.t2
Reference in a new issue View git blame Copy permalink