Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
25.10.3
-
None
-
None
-
MXS-SPRINT-279
Description
Getting below error with Maxscale 25.10.3 while parsing the query with Common Table Expression (WITH …), MATCH AGAINST and UNION
2026-08-13 05:02:59 info : (36408) [pp_sqlite] (Galera-RW-Service); Parsing the query failed, cannot report query type: WITH filtered_processors AS (SELECT DISTINCT SUBSTR(proc_identifier,1,12) item_prefix, SUBSTR(proc_identifier,14,4) proc_code FROM my_schema.processor_master WHERE MATCH(proc_identifier) AGAINST ('SEARCH_TERM' IN BOOLEAN MODE)) SELECT DISTINCT A.item_id, PB.proc_code FROM my_schema.settlement_records A JOIN filtered_processors PB ON A.item_id = PB.item_prefix WHERE A.run_time = '20:00' AND A.is_active = 'Y' AND A.proc_mode = 'MODE_A' AND A.item_id IN (SELECT DISTINCT item_id FROM my_schema.batch_queue WHERE is_active = 'Y') AND A.item_id NOT IN (SELECT DISTINCT item_id FROM my_schema.job_history WHERE (event_date='2026-08-11' AND exec_status='COMPLETED')) UNION DISTINCT SELECT DISTINCT SUBSTRING(item_id,1,12), PB.proc_code FROM my_schema.job_history JTB JOIN filtered_processors PB ON JTB.item_id = PB.item_prefix WHERE event_date='2026-08-11' AND exec_status='FAILED' AND JTB.proc_mode='MODE_A' AND item_id NOT IN (SELECT item_id FROM my_schema.job_history_retry WHERE event_date='2026-08-11' AND exec_status='COMPLETED') GROUP BY item_id HAVING COUNT(*)<3; |
This is obfuscated version of query with all schemas, tables, columns, and business-specific values replaced with generic placeholders.