OceanBase数据库 mysql可以这么写，oceanbase也支持吗？

"OceanBase数据库 mysql可以这么写，oceanbase也支持吗？ AND (A.AR_CODE is not null OR A.AR_CODE <> '') SELECT DISTINCT A.FUNC_ID ID,A.PARENT_ID,A.FUNC_CODE CODE,A.FUNC_NAME NAME,A.FUNC_URI URL,A.AR_CODE PERMS,A.INNER_CODE,A.DEFAULT_FLAG,A.FUNC_PARAM PARAM
FROM P1SM_FUNC A
JOIN P1SM_FUNCROLE B ON B.SFUNC_ID = A.ROW_ID AND B.SYS_ID = A.SYS_ID
JOIN P1SM_ROLE C ON C.ROW_ID = B.SROLE_ID AND C.SYS_ID = B.SYS_ID AND C.STATUS_FLAG='3'
JOIN P1SM_USERROLE D ON D.SROLE_ID = B.SROLE_ID AND D.SYS_ID = B.SYS_ID
JOIN P1SM_USER E ON E.ROW_ID = D.SUSER_ID AND E.SYS_ID = B.SYS_ID AND E.STATUS_FLAG='3'
WHERE A.DELETED_FLAG = '0'
AND A.END_FLAG = '1'
AND (A.AR_CODE is not null OR A.AR_CODE <> '')
AND B.DELETED_FLAG = '0'
AND C.DELETED_FLAG = '0'
AND D.DELETED_FLAG = '0'
AND E.DELETED_FLAG = '0'
AND E.ROW_ID = #{userId}
ORDER BY A.INNER_CODE "