MySQL JSON_VALUE fails with a path starting with a number?
SELECT JSON_VALUE(‘{“dateTime”: “2024-07-21 08:11:07 -0600”, “60SecInches”: 0.00, “DailyInches”: 0.01, “TotalInches”: 10.61}’, “$.60SecInches”); MySQL said: #3143 – Invalid JSON path expression. The error is around character position 13. If I remove the “60” from the key, the above SELECT works. But the following works as well. SELECT JSON_KEYS(‘{“dateTime”: “2024-07-21 08:11:07 -0600”, “60SecInches”: 0.00, “DailyInches”: 0.01, “TotalInches”: […]