Error querying database. Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘metersphere.u.create_time’ which is not in SELECT list; this is incompatible with DISTINCT
The error may exist in io/metersphere/system/mapper/ExtUserMapper.xml
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: SELECT DISTINCT u.id, u.NAME, u.email FROM user u LEFT JOIN user_role_relation urr ON u.id = urr.user_id WHERE urr.source_id = ? and u.deleted = false order by u.create_time desc limit 1000
Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘metersphere.u.create_time’ which is not in SELECT list; this is incompatible with DISTINCT
; uncategorized SQLException; SQL state [HY000]; error code [3065]; Expression #1 of ORDER BY clause is not in SELECT list, references column ‘metersphere.u.create_time’ which is not in SELECT list; this is incompatible with DISTINCT