PL/SQL parser (MDEV-10142)

[MDEV-12783] sql_mode=ORACLE: Functions LENGTH() and LENGTHB() Created: 2017-05-11  Updated: 2018-08-31  Resolved: 2017-07-11

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.3
Fix Version/s: 10.3.1

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: Compatibility

Issue Links:
Blocks
is blocked by MDEV-12784 Change Item_func_length::print() to d... Closed
Relates
relates to MDEV-10342 Providing compatibility for basic SQL... Closed
Sprint: 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

 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.
Generated at Thu Feb 08 08:00:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.