分页查询报以下错误,请问下该如何解决,劳请大佬解答下,谢谢

Blade 未结 1 243
yjw2023
yjw2023 剑童 2023-07-13 18:14

org.springblade.core.tenant.exception.TenantDataSourceException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT

             b.id,

             bd.bl_no,

             bd.second_bl_no,

             b.house_bill_date,

             bd.second_etd AS 'etd',

             bd.second_eta AS 'eta',

             bd.second_destination_port AS 'destination_port',

             bd.second_shipment_port AS 'shipment_port',

             IF(b.verify_by != null || b.verify_by != '',b.verify_date,null) AS 'verify_date',

             IF(b.`status` IN ('1',

                               '2',

                               '3'

             )

             ,true,false) AS 'submit_status',

             b.verify_by,

             b.remark

        FROM

            pu_second_bl_detail bd

        LEFT JOIN pu_second_bl b ON b.id = bd.second_bl_id AND bd.delete_flag = 0

### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT

             b.id,

             bd.bl_no,

             bd.second_bl_no,

             b.house_bill_date,

             bd.second_etd AS 'etd',

             bd.second_eta AS 'eta',

             bd.second_destination_port AS 'destination_port',

             bd.second_shipment_port AS 'shipment_port',

             IF(b.verify_by != null || b.verify_by != '',b.verify_date,null) AS 'verify_date',

             IF(b.`status` IN ('1',

                               '2',

                               '3'

             )

             ,true,false) AS 'submit_status',

             b.verify_by,

             b.remark

        FROM

            pu_second_bl_detail bd

        LEFT JOIN pu_second_bl b ON b.id = bd.second_bl_id AND bd.delete_flag = 0


1条回答
  • 拿sql直接去数据库执行下看报什么错。

    0 讨论(0)
提交回复