3643
MySQLERRORNotableQueryHIGH confidence
JSON_TABLE column has multiple path expressions
Production Risk
Low — Query fails at parse time; no data is read.
How to reproduce
trigger — this will error
trigger — this will error
SELECT * FROM JSON_TABLE('[{"a":1}]', '$[*]' COLUMNS (v INT PATH '$.a' PATH '$.b')) jt;expected output
ERROR 3643 (HY000): JSON_TABLE column has multiple path expressions.
Fix
Separate columns for each path
Separate columns for each path
SELECT * FROM JSON_TABLE('[{"a":1,"b":2}]', '$[*]' COLUMNS (va INT PATH '$.a', vb INT PATH '$.b')) jt;Why this works
Assigns one PATH per column in the JSON_TABLE definition.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 3643 ER_JSON_TABLE_MULTIPLE_PATHS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev