Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.14 Source distribution BUILD: 2018-OCT-04

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 8.0 > CREATE DATABASE test;
mysql 8.0 > USE test;
Database changed
mysql 8.0 > create TABLE t1(c1 varchar(32),key (c1)) engine=myisam;
Query OK, 0 rows affected (0,40 sec)

mysql 8.0 > ALTER TABLE t1 ADD c2 REAL;
Query OK, 0 rows affected (1,02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql 8.0 > INSERT INTO t1 values(0,0),('2147643648','4294967296');
Query OK, 2 rows affected (0,20 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql 8.0 > CREATE TRIGGER bd BEFORE DELETE ON t1 FOR EACH ROW DELETE FROM t1;
Query OK, 0 rows affected (0,44 sec)

mysql 8.0 > LOCK TABLES t1 LOW_PRIORITY WRITE;
Query OK, 0 rows affected, 1 warning (0,00 sec)

mysql 8.0 > repair TABLE t1;
+---------+--------+----------+----------+
| Table   | Op     | Msg_type | Msg_text |
+---------+--------+----------+----------+
| test.t1 | repair | status   | OK       |
+---------+--------+----------+----------+
1 row in set (0,18 sec)

mysql 8.0 > SELECT * FROM t1 ORDER BY c2 DESC;
ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired
mysql 8.0 >

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.14 Source distribution BUILD: 2018-OCT-04

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 8.0 > CREATE DATABASE test;

mysql 8.0 > USE test;
Database changed
mysql 8.0 > SET default_storage_engine=BLACKHOLE;
Query OK, 0 rows affected (0,00 sec)

mysql 8.0 > CREATE TABLE wp(FTS_DOC_ID INT(1)UNSIGNED,title CHAR (1) DEFAULT'',text TEXT,dummy INT,KEY (FTS_DOC_ID),UNIQUE KEY FTS_DOC_ID_INDEX (FTS_DOC_ID),FULLTEXT KEY idx (title,text)) DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0,30 sec)

mysql 8.0 > SELECT title,MATCH(title,text)AGAINST ('+InnoDB -database' IN BOOLEAN MODE) AS score FROM wp WHERE MATCH(title,text) AGAINST ('InnoDB database' WITH QUERY EXPANSION) ORDER BY score DESC;
ERROR 1031 (HY000): Table storage engine for 'wp' doesn't have this option
mysql 8.0 >
--------------------------------------------------------debug-----------------------------------------
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.14-debug Source distribution BUILD: 2018-OCT-04

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 8.0 > CREATE DATABASE test;

mysql 8.0 > USE test;
Database changed
mysql 8.0 > create TABLE t1(c1 varchar(32),key (c1)) engine=myisam;
Query OK, 0 rows affected (0,36 sec)

mysql 8.0 > ALTER TABLE t1 ADD c2 REAL;
Query OK, 0 rows affected (1,01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql 8.0 > INSERT INTO t1 values(0,0),('2147643648','4294967296');
Query OK, 2 rows affected (0,11 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql 8.0 > CREATE TRIGGER bd BEFORE DELETE ON t1 FOR EACH ROW DELETE FROM t1;
Query OK, 0 rows affected (0,57 sec)

mysql 8.0 > LOCK TABLES t1 LOW_PRIORITY WRITE;
Query OK, 0 rows affected, 1 warning (0,00 sec)

mysql 8.0 > repair TABLE t1;
+---------+--------+----------+----------+
| Table   | Op     | Msg_type | Msg_text |
+---------+--------+----------+----------+
| test.t1 | repair | status   | OK       |
+---------+--------+----------+----------+
1 row in set (0,18 sec)

mysql 8.0 > SELECT * FROM t1 ORDER BY c2 DESC;
ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired
mysql 8.0 >

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.14-debug Source distribution BUILD: 2018-OCT-04

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 8.0 > CREATE DATABASE test;

mysql 8.0 > USE test;
Database changed
mysql 8.0 > SET default_storage_engine=BLACKHOLE;
Query OK, 0 rows affected (0,00 sec)

mysql 8.0 > CREATE TABLE wp(FTS_DOC_ID INT(1)UNSIGNED,title CHAR (1) DEFAULT'',text TEXT,dummy INT,KEY (FTS_DOC_ID),UNIQUE KEY FTS_DOC_ID_INDEX (FTS_DOC_ID),FULLTEXT KEY idx (title,text)) DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0,32 sec)

mysql 8.0 > SELECT title,MATCH(title,text)AGAINST ('+InnoDB -database' IN BOOLEAN MODE) AS score FROM wp WHERE MATCH(title,text) AGAINST ('InnoDB database' WITH QUERY EXPANSION) ORDER BY score DESC;
ERROR 1031 (HY000): Table storage engine for 'wp' doesn't have this option
mysql 8.0 >