[MDEV-12783] sql_mode=ORACLE: Functions LENGTH() and LENGTHB() - Jira

XML

Word

Printable

Details

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

Sprint:
10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18
PM Planning:
- delivered_NRE-307517

Description

MariaDB translates function LENGTH() to SQL Standard function OCTET_LENGTH().
Oracle translates function LENGTH() to SQL Standard function CHAR_LENGTH().

We'll change MariaDB so it also translates LENGTH() to CHAR_LENGTH() rather than OCTET_LENGTH() when running with sql_mode=ORACLE.

Additionally, we'll add LENGTHB() as a synonym for OCTET_LENGTH(). This synonym will be available in all sql_mode's.

Attachments

Issue Links

is blocked by

MDEV-12784 Change Item_func_length::print() to display octet_length() rather than length()

Closed

relates to

MDEV-10342 Providing compatibility for basic SQL built-in functions

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2017-05-11 12:25

Updated:: 2018-08-31 17:08

Resolved:: 2017-07-11 11:12

Time Tracking

Estimated:

0.5d

Remaining:

0.25d

Logged:

0.25d

Git Integration

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