planner: query fails with MySQL compatible FTS search #68153

CREATE TABLE bls_occupations (
      id INT PRIMARY KEY,                                                                                                                                                           
      title VARCHAR(200),                                                                                                                                                           
      description TEXT                                                                                                                                                              
    );                                                                                                                                                                              
                                                                                                                                                                         
INSERT INTO bls_occupations VALUES                                                                                                                                              
(1, 'Software Engineer',       'Designs, develops, and maintains software systems and applications.'),
(2, 'Senior Software Engineer','Leads design and architecture of complex distributed systems.'),                                                                               
(3, 'Database Administrator',  'Maintains relational databases and tunes query performance.'),                                                                                 
(4, 'Data Engineer',            'Builds data pipelines for analytics and machine learning workloads.'),
(5, 'Hardware Engineer',        'Designs printed circuit boards and embedded firmware.'),                                                                                      
(6, 'Civil Engineer',           'Designs roads, bridges, and other public infrastructure.'),                                                                                   
(7, 'Marketing Manager',        'Plans advertising campaigns and brand strategy.'),                                                                                            
(8, 'Technical Writer',         'Writes user manuals, API references, and tutorials.'),                                                                                        
(9, 'Security Analyst',         'Monitors networks for intrusions and audits access controls.'),                                                                               
(10,'Product Manager',          'Defines product roadmap and prioritizes engineering work.');    

tidb>   SELECT id, title FROM bls_occupations   WHERE MATCH(title) AGAINST('Engin*' IN BOOLEAN MODE);
ERROR 1105 (HY000): cannot use 'MATCH ... AGAINST' outside of fulltext index