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

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.