ORACLE Where的条件自动删除右侧空格


--  FALSE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '1' = ' ';
--  TRUE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' ' = ' ';
--  TRUE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '  ' = ' ';

--  TRUE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '1  ' = '1 ';
--  FLASE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE '1  ' = ' 1';
--  TRUE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' 1  ' = ' 1';
--  FALSE
SELECT CURRENT_TIMESTAMP FROM DUAL WHERE ' 1  ' = '  1';
DB