MyBatis-Plus MybatisPlusException: Error: Method queryTotal execution error of sql

created at 05-18-2022 views: 11

Problem Description

com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :
  SELECT COUNT(1) FROM ( SELECT DISTINCT * FROM sys_user WHERE sys_user.del_flag = 0 ) TOTAL

problem analysis:

Since the test environment has been used before, the uat environment is used later, but some tables are newly added later, and the database of the uat environment does not have this table, resulting in an error.

Solution:

Go to the database of the uat environment to confirm whether the table exists. If it does not exist, copy a table structure from the test environment to the uat environment.

created at:05-18-2022
edited at: 05-18-2022: