mybatis sql错误?-灵析社区

select JSON_EXTRACT(all_info, '\$[0].motor_controller_temperature') from data_20230217 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: The 'JSON_EXTRACT(all_info, '$' property of null is not a List or Array. 关键是这个sql select JSON_EXTRACT(all_info, '\$[0].motor_controller_temperature') from data_20230217 用navicat运行没有错误