REPLACE on text field does not update full-text index until FLUSH RAMCHUNK (v28.4.4)
Author: kongxiangLlongCreated Jul 30, 2026Updated Jul 30, 2026
Labelsbugwaiting
Bug Description:
Environment:
- OS: Windows 11 + WSL2 (Ubuntu)
- Manticore: 28.4.4 f63d06ecb@26071006 (latest)
- Table: RT, with occupation as text indexed attribute
Schema: CREATE TABLE user_profile ( id bigint, phone string, create_time timestamp, user_status int, occupation text indexed attribute ) rt_mem_limit='256M'; Steps to reproduce:
- Insert a record: REPLACE INTO user_profile (id, phone, create_time, user_status, occupation) VALUES (10001, '+1234567890', NOW(), 1, 'engineer');
- Search for 'engineer' – works: SELECT id, occupation FROM user_profile WHERE MATCH('@occupation engineer'); -> returns (10001, 'engineer')
- Update occupation to 'doctor': REPLACE INTO user_profile (id, phone, create_time, user_status, occupation) VALUES (10001, '+1234567890', NOW(), 1, 'doctor');
- Query by ID – shows 'doctor': SELECT id, occupation FROM user_profile WHERE id = 10001; -> returns (10001, 'doctor')
- Search for 'doctor' – fails (returns empty): SELECT id, occupation FROM user_profile WHERE MATCH('@occupation doctor'); -> empty
- Search for old value 'engineer' – incorrectly returns the updated document: SELECT id, occupation FROM user_profile WHERE MATCH('@occupation engineer'); -> returns (10001, 'doctor') (wrong, because value is now 'doctor')
- After FLUSH RAMCHUNK user_profile;, everything becomes correct: FLUSH RAMCHUNK user_profile; Search for 'doctor' -> returns (10001, 'doctor') Search for 'engineer' -> empty
AND:
- Using a complete REPLACE with all fields – no effect
- OPTIMIZE TABLE – no effect
- Manticore Buddy is running (SHOW VERSION shows buddy v4.2.0) – not the cause
Expected behavior: After a REPLACE on a text field, the full-text index should be updated immediately (or within a short time) so that MATCH queries return correct results without requiring FLUSH RAMCHUNK. Please let me know if more details are needed. Thank you.
Manticore Search Version:
28.4.4
Operating System Version:
Windows 11 + WSL2 (Ubuntu)
Have you tried the latest development version?
None
Internal Checklist:
To be completed by the assignee. Check off tasks that have been completed or are not applicable.
- Implementation completed
- Tests developed
- Documentation updated
- Documentation reviewed
Source: manticoresoftware/manticoresearch