EVOLUTION-MANAGER

Edit File: column_generated_stored_update.result

DROP TABLE IF EXISTS logs; CREATE TABLE logs ( id INT PRIMARY KEY, record JSON, message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`, '$.message')) STORED, FULLTEXT INDEX(message) comment 'tokenizer "TokenBigramSplitSymbolAlphaDigit"' ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COMMENT = 'ENGINE "InnoDB"'; INSERT INTO logs(id, record) VALUES (1, '{"level": "info", "message": "start"}'); INSERT INTO logs(id, record) VALUES (2, '{"level": "info", "message": "restart"}'); INSERT INTO logs(id, record) VALUES (3, '{"level": "warn", "message": "abort"}'); UPDATE logs SET record = '{"level": "info", "message": "shutdown"}' WHERE id = 2; SELECT * FROM logs WHERE MATCH(message) AGAINST("hut" IN BOOLEAN MODE); id record message 2 {"level": "info", "message": "shutdown"} "shutdown" DROP TABLE logs;