[MDEV-35172] FULLTEXT INDEX works incorrectly with words that are equal in the collation - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.5(EOL), 10.6(EOL), 10.11, 11.4, 11.8, 12.3
Fix Version/s: 10.11, 11.4, 11.8, 12.3
Component/s: Full-text Search, Storage Engine - InnoDB
Labels:
- upstream
- wrong-result

Description

MySQL 8.0.40 includes the following change, which seems to be applicable to MariaDB Server:
Bug#36652127 InnoDB: FTS table optimization not working correctly with collation
No test case is included, but source code comments mention Chinese, Japanese, Korean (CJK) collations.

Attachments

Issue Links

relates to

MDEV-34673 innodb_optimize_fulltext_only=ON may corrupt fulltext indexes

Open

MDEV-35170 Merge applicable changes from InnoDB 8.0.40

Closed

MDEV-41360 OPTIMIZE TABLE crashes with ib_vector_size(optim->words) > 0 on FULLTEXT index with collation-equal words

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-10-16 09:27

Updated:: 2026-09-30 13:21

Time Tracking

Estimated:

Not Specified

Remaining:

0d

Logged:

1d

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.