Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.3.28
-
None
-
Linux, Windows
Description
Same behavior is on this versions: 10.3.28, 10.4.17, 10.5.12
How to reproduce the crash:
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;
|
|
INSERT INTO `d_fulltext_phrase` (`id`, `phrase`) VALUES
|
(1, 'audi'); |
|
ALTER TABLE `d_fulltext_phrase`
|
ADD PRIMARY KEY (`id`);
|
ALTER TABLE `d_fulltext_phrase` ADD FULLTEXT KEY `IDX_E4E8EE24A24BE60C` (`phrase`);
|
|
ALTER TABLE `d_fulltext_phrase`
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; |
and than run:
SELECT phrase, (MATCH (phrase) AGAINST ('aud*' IN BOOLEAN MODE)) + 0 |
FROM d_fulltext_phrase
|
while this runs ok:
SELECT phrase, (MATCH (phrase) AGAINST ('aud*' IN BOOLEAN MODE)) |
FROM d_fulltext_phrase
|