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: 

  1. Insert a record: REPLACE INTO user_profile (id, phone, create_time, user_status, occupation) VALUES (10001, '+1234567890', NOW(), 1, 'engineer');
  2. Search for 'engineer' – works: SELECT id, occupation FROM user_profile WHERE MATCH('@occupation engineer'); -> returns (10001, 'engineer')
  3. Update occupation to 'doctor': REPLACE INTO user_profile (id, phone, create_time, user_status, occupation) VALUES (10001, '+1234567890', NOW(), 1, 'doctor');
  4. Query by ID – shows 'doctor': SELECT id, occupation FROM user_profile WHERE id = 10001; -> returns (10001, 'doctor')
  5. Search for 'doctor' – fails (returns empty): SELECT id, occupation FROM user_profile WHERE MATCH('@occupation doctor'); -> empty
  6. 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')
  7. 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