MariaDB [test]> CREATE TABLE `d_fulltext_phrase` (

    ->   `id` int(11) NOT NULL,

    ->   `phrase` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:string)'

    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Query OK, 0 rows affected (0.008 sec)

MariaDB [test]> INSERT INTO `d_fulltext_phrase` (`id`, `phrase`) VALUES

    -> (1, 'audi');

Query OK, 1 row affected (0.001 sec)

MariaDB [test]> ALTER TABLE `d_fulltext_phrase` ADD PRIMARY KEY (`id`);

Query OK, 0 rows affected (0.011 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [test]> ALTER TABLE `d_fulltext_phrase` ADD FULLTEXT KEY `IDX_E4E8EE24A24BE60C` (`phrase`);

Query OK, 0 rows affected (0.043 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [test]> ALTER TABLE `d_fulltext_phrase`

    ->   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

Query OK, 1 row affected (0.058 sec)               

Records: 1  Duplicates: 0  Warnings: 0

MariaDB [test]> SELECT phrase,

    ->        (MATCH (phrase) against ('aud*' IN BOOLEAN MODE)) + 0

    -> FROM d_fulltext_phrase;

ERROR 1690 (22003): DOUBLE value is out of range in '(match `test`.`d_fulltext_phrase`.`phrase` against ('aud*' in boolean mode)) + 0'

MariaDB [test]> select version();

+-----------------+

| version()       |

+-----------------+

| 10.3.28-MariaDB |

+-----------------+

1 row in set (0.000 sec)

MariaDB [test]> SELECT phrase,

    ->        (MATCH (phrase) against ('aud*' IN BOOLEAN MODE)) + 0

    -> FROM d_fulltext_phrase;

ERROR 1690 (22003): DOUBLE value is out of range in '(match `test`.`d_fulltext_phrase`.`phrase` against ('aud*' in boolean mode)) + 0'

SELECT phrase, (MATCH(phrase) AGAINST ('aud*' IN BOOLEAN MODE))+0

FROM d_fulltext_phrase;

phrase	(MATCH(phrase) AGAINST ('aud*' IN BOOLEAN MODE))+0

audi	0.000000001885928302414186

SELECT phrase, (MATCH(phrase) AGAINST ('aud*' IN BOOLEAN MODE))

FROM d_fulltext_phrase;

phrase	(MATCH(phrase) AGAINST ('aud*' IN BOOLEAN MODE))

audi	0.000000001885928302414186