[MDEV-15664] sql_mode=ORACLE: Make TRIM return NULL instead of empty string - Jira

XML

Word

Printable

Earlier we made concatenation operator and SUBSTR translate empty results to NULL when running with sql_mode=ORACLE.

Under terms of this task we'll change TRIM, LTRIM, RTRIM to do the same.

The below scripts demonstrate Oracle's behavior:

SELECT

  CASE

    WHEN TRIM('a' FROM 'aa') IS NULL THEN 'IS NULL'

    ELSE 'IS NOT NULL'

  END AS c

FROM DUAL;

-----------

IS NULL

SELECT

  CASE

    WHEN LTRIM('  ') IS NULL THEN 'IS NULL'

    ELSE 'IS NOT NULL'

  END AS c

FROM DUAL;

-----------

IS NULL

SELECT

  CASE

    WHEN RTRIM('  ') IS NULL THEN 'IS NULL'

    ELSE 'IS NOT NULL'

  END AS c

FROM DUAL;

-----------

IS NULL

relates to

MDEV-15739 sql_mode=ORACLE: Make LPAD and RPLAD return NULL instead of empty string

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.