函数替代 Gbase | |
Mysql | Gbase |
IF(sug.org_id IS NULL, 1, sug.org_id) | CASE WHEN sug.org_id IS NULL THEN 1 ELSE sug.org_id END AS userCurrentOrgId |
find_in_set (srm.role_id,#{roleIds}) | ',' || #{roleIds} || ',' LIKE '%' || ',' || srm.role_id || ',' || '%' |
config_key like concat('%', #{configKey}, '%') | config_key like '%' || #{configKey} || '%' |