-- Starting on windows
rmdir data /s
bin\mysqld --initialize-insecure --basedir=%cd% --datadir=%cd%\data --log-error-verbosity=3
bin\mysqld --no-defaults --basedir=%cd% --datadir=%cd%\data  --ft_min_word_len=1 --ft_max_word_len=10

-- extract mysql-bug-data-93455.zip, copy bug93455.* under datadir/test  

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.24 MySQL Community Server (GPL)

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> use test
Database changed
mysql> repair table bug93455 quick;
+---------------+--------+----------+----------+
| Table         | Op     | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| test.bug93455 | repair | status   | OK       |
+---------------+--------+----------+----------+
1 row in set (44.98 sec)

mysql> show variables like 'ft%';
+--------------------------+----------------+
| Variable_name            | Value          |
+--------------------------+----------------+
| ft_boolean_syntax        | + -><()~*:""&| |
| ft_max_word_len          | 10             |
| ft_min_word_len          | 1              |
| ft_query_expansion_limit | 20             |
| ft_stopword_file         | (built-in)     |
+--------------------------+----------------+
5 rows in set (0.00 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
Empty set (0.33 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
Empty set (0.34 sec)

mysql>
mysql> insert into bug93455 select * from bug93455;
Query OK, 18713 rows affected (49.21 sec)
Records: 18713  Duplicates: 0  Warnings: 0

mysql> insert into bug93455 select * from bug93455;
Query OK, 37426 rows affected (1 min 46.83 sec)
Records: 37426  Duplicates: 0  Warnings: 0

mysql> repair table bug93455 quick;
+---------------+--------+----------+----------+
| Table         | Op     | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| test.bug93455 | repair | status   | OK       |
+---------------+--------+----------+----------+
1 row in set (5 min 59.18 sec)

mysql> select count(*) from bug93455;
+----------+
| count(*) |
+----------+
|    74852 |
+----------+
1 row in set (0.24 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
Empty set (1.33 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
Empty set (1.49 sec)

## 2nd attempt

D:\MySQL\mysql-8.0.13-winx64>cd ..

D:\MySQL>cd mysql-5.7.24-winx64

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.24 MySQL Community Server (GPL)

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> create database test;
Query OK, 1 row affected (0.03 sec)

mysql> use test
Database changed
mysql> \q
Bye

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.24 MySQL Community Server (GPL)

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> use test
Database changed
mysql> repair table bug93455 quick;
+---------------+--------+----------+----------+
| Table         | Op     | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| test.bug93455 | repair | status   | OK       |
+---------------+--------+----------+----------+
1 row in set (46.48 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
Empty set (0.32 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
Empty set (0.36 sec)

mysql> insert into bug93455 select * from bug93455;
Query OK, 18713 rows affected (48.76 sec)
Records: 18713  Duplicates: 0  Warnings: 0

mysql> insert into bug93455 select * from bug93455;
Query OK, 37426 rows affected (1 min 54.14 sec)
Records: 37426  Duplicates: 0  Warnings: 0

mysql> repair table bug93455 quick;
+---------------+--------+----------+----------+
| Table         | Op     | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| test.bug93455 | repair | status   | OK       |
+---------------+--------+----------+----------+
1 row in set (5 min 46.34 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
Empty set (1.25 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
Empty set (1.41 sec)

mysql>

###
D:\MySQL\mysql-5.7.24-winx64>bin\mysqldump -uroot --databases test > test.sql

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.24 MySQL Community Server (GPL)

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> drop database test;
Query OK, 1 row affected (0.16 sec)

mysql> create database test;
Query OK, 1 row affected (0.03 sec)

mysql> \q
Bye

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot test < test.sql

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.24 MySQL Community Server (GPL)

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> use test
Database changed
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
Empty set (1.26 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
Empty set (1.48 sec)

mysql>


-- converted table to Innodb, even set --innodb_ft_min_token_size=1 --- no issues noted

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot < ./test.sql

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.24 MySQL Community Server (GPL)

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> use test
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| bug93455       |
+----------------+
1 row in set (0.00 sec)

mysql> alter table bug93455 engine=innodb;
Query OK, 74852 rows affected (1 min 15.34 sec)
Records: 74852  Duplicates: 0  Warnings: 0

mysql> show create table bug93455\G
*************************** 1. row ***************************
       Table: bug93455
Create Table: CREATE TABLE `bug93455` (
  `words` text COLLATE utf8_unicode_ci,
  FULLTEXT KEY `synonyms` (`words`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
1 row in set (0.00 sec)

D:\MySQL\mysql-5.7.24-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.24 MySQL Community Server (GPL)

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> use test
Database changed
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql>


### 8.0.13 - not seeing any issues

rmdir data /s
bin\mysqld --initialize-insecure --basedir=%cd% --datadir=%cd%\data --log-error-verbosity=3
bin\mysqld --no-defaults --basedir=%cd% --datadir=%cd%\data  --ft_min_word_len=1 --ft_max_word_len=10

D:\MySQL\mysql-8.0.13-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.13 MySQL Community Server - GPL

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> create database test;
Query OK, 1 row affected (0.11 sec)

mysql> \q
Bye

D:\MySQL\mysql-8.0.13-winx64>bin\mysql.exe -uroot test < ..\mysql-5.7.24-winx64\test.sql

D:\MySQL\mysql-8.0.13-winx64>bin\mysql.exe -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.13 MySQL Community Server - GPL

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> use test
Database changed
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a"' IN BOOLEAN MODE);
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> show variables like 'ft%';
+--------------------------+----------------+
| Variable_name            | Value          |
+--------------------------+----------------+
| ft_boolean_syntax        | + -><()~*:""&| |
| ft_max_word_len          | 10             |
| ft_min_word_len          | 1              |
| ft_query_expansion_limit | 20             |
| ft_stopword_file         | (built-in)     |
+--------------------------+----------------+
5 rows in set (0.00 sec)

mysql> repair table bug93455 quick;
+---------------+--------+----------+----------+
| Table         | Op     | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| test.bug93455 | repair | status   | OK       |
+---------------+--------+----------+----------+
1 row in set (2 min 57.93 sec)

mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"');
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql> SELECT /*+MAX_EXECUTION_TIME(1) */ * FROM bug93455 WHERE MATCH(words) AGAINST ('"a a a a a a a a a a a a a a"' IN BOOLEAN MODE);
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
mysql>
mysql>