Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
CREATE OR REPLACE TABLE t1 (pk INT AUTO_INCREMENT PRIMARY KEY, c VARCHAR(8)) ENGINE=MyISAM WITH SYSTEM VERSIONING; |
INSERT INTO t1 VALUES (1,'foo'); |
DELETE FROM t1; |
ALTER TABLE t1 ENGINE=MyISAM; |
ERROR 1112 (42000): Table '#sql-17fe_b' uses an extension that doesn't exist in this MariaDB version |
Also reproducible with Aria.
This variation causes the same problem with InnoDB:
CREATE OR REPLACE TABLE t1 (pk INT AUTO_INCREMENT PRIMARY KEY, c VARCHAR(8), FULLTEXT(c)) ENGINE=InnoDB WITH SYSTEM VERSIONING; |
INSERT INTO t1 VALUES (1,'foo'); |
DELETE FROM t1; |
ALTER TABLE t1 ENGINE=InnoDB; |
Attachments
Issue Links
- relates to
-
MDEV-15121 ER_UNSUPPORTED_EXTENSION when using ON DELETE CASCADE
-
- Closed
-
-
MDEV-15136 'delete from user where username = "admin"' failed: 1112: Table 'user' uses an extension that doesn't exist in this MariaDB version
-
- Closed
-
Thread 28 "mysqld" hit Breakpoint 5, handler::update_auto_increment (this=0x61d00020e508) at handler.cc:3070
3070 DBUG_RETURN(HA_ERR_UNSUPPORTED);
#0 handler::update_auto_increment (this=0x61d00020e508) at handler.cc:3070
#1 ha_myisam::write_row (this=0x61d00020e508, buf=0x6190000dc108 "\374\001") at ha_myisam.cc:896
#2 handler::ha_write_row (this=0x61d00020e508, buf=0x6190000dc108 "\374\001") at handler.cc:6113
#3 copy_data_between_tables (thd=0x62a0000ba270, from=0x61f0000524f0, to=0x61f000054ef0, create=List<Create_field> with 4 elements, ignore=false, order_num=0, order=0x0, copied=0x7fffde9527e0, deleted=0x7fffde952800, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7fffde951890) at sql_table.cc:10391
#4 mysql_alter_table (thd=0x62a0000ba270, new_db=0x62b0000009a8 "test", new_name=0x0, create_info=0x7fffde955600, table_list=0x62b000000370, alter_info=0x7fffde9557e0, order_num=0, order=0x0, ignore=false) at sql_table.cc:9795
#5 Sql_cmd_alter_table::execute (this=0x62b0000009b8, thd=0x62a0000ba270) at sql_alter.cc:325
#6 mysql_execute_command (thd=0x62a0000ba270) at sql_parse.cc:6258
#7 mysql_parse (thd=0x62a0000ba270, rawbuf=0x62b000000288 "ALTER TABLE t1 ENGINE=MyISAM", length=28, parser_state=0x7fffde95ca20, is_com_multi=false, is_next_command=false) at sql_parse.cc:7988
#8 dispatch_command (command=COM_QUERY, thd=0x62a0000ba270, packet=0x62900012c271 "ALTER TABLE t1 ENGINE=MyISAM", packet_length=28, is_com_multi=false, is_next_command=false) at sql_parse.cc:1825