New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
3.5.4 版本不支持 JSON_TABLE #6059
Comments
补充提供完整堆栈日志. |
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT oi.id, oi.stand_name FROM asset_stand_basic_info oi LEFT JOIN asset_basic_info ab ON ab.stand_id = oi.id CROSS JOIN JSON_TABLE(ab.star_connectors, '$[*]' COLUMNS (connector_id VARCHAR(255) PATH '$.connector_id')) AS ss WHERE ss.connector_id = ?Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT oi.id, oi.stand_name FROM asset_stand_basic_info oi LEFT JOIN asset_basic_info ab ON ab.stand_id = oi.id CROSS JOIN JSON_TABLE(ab.star_connectors, '$[*]' COLUMNS (connector_id VARCHAR(255) PATH '$.connector_id')) AS ss WHERE ss.connector_id = ?
Caused by: org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT oi.id, oi.stand_name FROM asset_stand_basic_info oi LEFT JOIN asset_basic_info ab ON ab.stand_id = oi.id CROSS JOIN JSON_TABLE(ab.star_connectors, '$[*]' COLUMNS (connector_id VARCHAR(255) PATH '$.connector_id')) AS ss WHERE ss.connector_id = ?Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT oi.id, oi.stand_name FROM asset_stand_basic_info oi LEFT JOIN asset_basic_info ab ON ab.stand_id = oi.id CROSS JOIN JSON_TABLE(ab.star_connectors, '$[*]' COLUMNS (connector_id VARCHAR(255) PATH '$.connector_id')) AS ss WHERE ss.connector_id = ?
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT oi.id, oi.stand_name FROM asset_stand_basic_info oi LEFT JOIN asset_basic_info ab ON ab.stand_id = oi.id CROSS JOIN JSON_TABLE(ab.star_connectors, '$[*]' COLUMNS (connector_id VARCHAR(255) PATH '$.connector_id')) AS ss WHERE ss.connector_id = ? |
得把这个sql反馈给jsqlparser仓库了. |
意思就是这个和mp没关系 是jsqlparse解析sql的问题是吧 因为现在这个sql我们在mp3.5.3.1版本下是没有影响 是不是3.5.4版本升级导致的 |
框架升级了jsqlpaesr,具体看更新日志,只能跟着他走. |
🆗 感谢 |
当前使用版本(必填,否则不予处理)
3.5.4
该问题是如何引起的?(确定最新版也有问题再提!!!)
3.5.3.1 mysql执行 JSON_TABLE正常 3.5.4版本无法正常执行
重现步骤(如果有就写完整)
报错信息
nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT t.id,t.stand_name FROM asset_stand_basic_info t LEFT JOIN asset_stand_basic_info o ON (o.id = t.stand_id AND o.del_flag='0') WHERE t.del_flag='0' AND (CROSS JOIN JSON_TABLE(ab.star_connectors,'$[]' COLUMNS(connector_id VARCHAR(255) PATH '$.connector_id')) AS ss where ss.connector_id=22)\r\n### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT t.id,t.stand_name FROM asset_stand_basic_info t LEFT JOIN asset_stand_basic_info o ON (o.id = t.stand_id AND o.del_flag='0') WHERE t.del_flag='0' AND (CROSS JOIN JSON_TABLE(ab.star_connectors,'$[]' COLUMNS(connector_id VARCHAR(255) PATH '$.connector_id')) AS ss where ss.connector_id=22)
The text was updated successfully, but these errors were encountered: