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

Details

Type: Technical task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL)
Fix Version/s: 10.3.6
Component/s: OTHER
Labels:
- Compatibility

Description

Earlier we made the concatenation operator and functions SUBSTR, TRIM, LTRIM, RTRIM translate empty results to NULL when running with sql_mode=ORACLE.

Under terms of this task we'll change LPAD and RPAD to do the same.

SELECT

  CASE

    WHEN LPAD('a', 0) IS NULL THEN 'IS NULL'

    ELSE 'IS NOT NULL'

  END AS c

FROM DUAL;

-----------

IS NULL

SELECT

  CASE

    WHEN RPAD('a', 0) IS NULL THEN 'IS NULL'

    ELSE 'IS NOT NULL'

  END AS c

FROM DUAL;

-----------

IS NULL

Attachments

Issue Links

relates to

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

Closed

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2018-03-30 07:49

Alexander Barkov made changes - 2018-03-30 07:49

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-15664~~ [ ~~MDEV-15664~~ ]

Alexander Barkov made changes - 2018-04-03 11:17

issue.field.resolutiondate

2018-04-03 11:17:11.0

2018-04-03 11:17:11.312

Alexander Barkov made changes - 2018-04-03 11:17

Fix Version/s		10.3.6 [ 23003 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:47

Workflow

MariaDB v3 [ 86313 ]

MariaDB v4 [ 154066 ]

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-03-30 07:49

Updated:: 2018-04-03 11:17

Resolved:: 2018-04-03 11:17

Git Integration

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

MariaDB Server