Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.2.2, 10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2, 11.3(EOL)
-
None
-
Ubuntu
Description
The following query crashes MariaDB (signal 11) when partitioned table is used with UNION+FULLTEXT query. Same doesn't happen when table is not partitioned.
SELECT gb_id |
FROM gen_idx_birth6 |
WHERE MATCH(gb_names_a ) AGAINST ( 'kosk' IN BOOLEAN MODE ) |
AND MATCH(gb_names_b ) AGAINST ( 'kwit' IN BOOLEAN MODE ) |
UNION ALL |
SELECT gb_id |
FROM gen_idx_birth6 |
WHERE MATCH(gb_names_b ) AGAINST ( 'kosk' IN BOOLEAN MODE ) |
AND MATCH(gb_names_a ) AGAINST ( 'kwit' IN BOOLEAN MODE ) |
Table:
CREATE TABLE `gen_idx_birth6` ( |
`region` int(11) NOT NULL, |
`gb_id` bigint(6) NOT NULL, |
`gb_names_a` varchar(100) DEFAULT NULL, |
`gb_names_b` varchar(30) DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_polish_ci |
PARTITION BY LIST (`region`) |
(
|
PARTITION p7 VALUES IN (7) ENGINE=InnoDB |
);
|
 |
ALTER TABLE `gen_idx_birth6` |
ADD PRIMARY KEY (`gb_id`,`region`) USING BTREE; |
ALTER TABLE `gen_idx_birth6` ADD FULLTEXT KEY `ix_names_b` (`gb_names_b`); |
ALTER TABLE `gen_idx_birth6` ADD FULLTEXT KEY `ix_names_a` (`gb_names_a`); |
 |
ALTER TABLE `gen_idx_birth6` |
MODIFY `gb_id` bigint(6) NOT NULL AUTO_INCREMENT; |
COMMIT; |