3644
MariaDBERRORNotableQueryHIGH confidence
JSON_TABLE column missing required PATH
Production Risk
Low — Query fails at parse time.
How to reproduce
trigger — this will error
trigger — this will error
SELECT * FROM JSON_TABLE('[{"a":1}]', '$[*]' COLUMNS (v INT)) jt;expected output
ERROR 3644 (HY000): JSON_TABLE column path not specified.
Fix
Add PATH to JSON_TABLE column
Add PATH to JSON_TABLE column
SELECT * FROM JSON_TABLE('[{"a":1}]', '$[*]' COLUMNS (v INT PATH '$.a')) jt;Why this works
Provides the required PATH expression for the column.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 3644 ER_JSON_TABLE_PATH_NOT_SPECIFIED
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev