CREATE TABLE log (
    ts TIMESTAMP TIME INDEX,
    msg STRING FULLTEXT INDEX,
);

Affected Rows: 0

SHOW CREATE TABLE log;

+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                     |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| log   | CREATE TABLE IF NOT EXISTS "log" (                                                                                                                               |
|       |   "ts" TIMESTAMP(3) NOT NULL,                                                                                                                                    |
|       |   "msg" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'false', false_positive_rate = '0.01', granularity = '10240'), |
|       |   TIME INDEX ("ts")                                                                                                                                              |
|       | )                                                                                                                                                                |
|       |                                                                                                                                                                  |
|       | ENGINE=mito                                                                                                                                                      |
|       |                                                                                                                                                                  |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+

DROP TABLE log;

Affected Rows: 0

CREATE TABLE log_with_opts (
    ts TIMESTAMP TIME INDEX,
    msg TEXT FULLTEXT INDEX WITH (analyzer='English', case_sensitive='true'),
);

Affected Rows: 0

SHOW CREATE TABLE log_with_opts;

+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table         | Create Table                                                                                                                                                    |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| log_with_opts | CREATE TABLE IF NOT EXISTS "log_with_opts" (                                                                                                                    |
|               |   "ts" TIMESTAMP(3) NOT NULL,                                                                                                                                   |
|               |   "msg" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'true', false_positive_rate = '0.01', granularity = '10240'), |
|               |   TIME INDEX ("ts")                                                                                                                                             |
|               | )                                                                                                                                                               |
|               |                                                                                                                                                                 |
|               | ENGINE=mito                                                                                                                                                     |
|               |                                                                                                                                                                 |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+

DROP TABLE log_with_opts;

Affected Rows: 0

CREATE TABLE log_multi_fulltext_cols (
    ts TIMESTAMP TIME INDEX,
    msg TINYTEXT FULLTEXT INDEX,
    msg2 VARCHAR FULLTEXT INDEX,
);

Affected Rows: 0

SHOW CREATE TABLE log_multi_fulltext_cols;

+-------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table                   | Create Table                                                                                                                                                      |
+-------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| log_multi_fulltext_cols | CREATE TABLE IF NOT EXISTS "log_multi_fulltext_cols" (                                                                                                            |
|                         |   "ts" TIMESTAMP(3) NOT NULL,                                                                                                                                     |
|                         |   "msg" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'false', false_positive_rate = '0.01', granularity = '10240'),  |
|                         |   "msg2" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'false', false_positive_rate = '0.01', granularity = '10240'), |
|                         |   TIME INDEX ("ts")                                                                                                                                               |
|                         | )                                                                                                                                                                 |
|                         |                                                                                                                                                                   |
|                         | ENGINE=mito                                                                                                                                                       |
|                         |                                                                                                                                                                   |
+-------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+

DROP TABLE log_multi_fulltext_cols;

Affected Rows: 0

CREATE TABLE log_dup_fulltext_opts (
    ts TIMESTAMP TIME INDEX,
    msg TEXT FULLTEXT FULLTEXT,
);

Error: 1004(InvalidArguments), Invalid column option, column name: msg, error: expect INDEX after FULLTEXT keyword

CREATE TABLE log_with_invalid_type (
    ts TIMESTAMP TIME INDEX,
    msg INT FULLTEXT INDEX,
);

Error: 1004(InvalidArguments), Invalid column option, column name: msg, error: FULLTEXT index only supports string type

CREATE TABLE log_with_invalid_option (
    ts TIMESTAMP TIME INDEX,
    msg TEXT FULLTEXT INDEX WITH (analyzer='English', invalid_option='true'),
);

Error: 1004(InvalidArguments), Invalid column option, column name: msg, error: invalid FULLTEXT INDEX option: invalid_option