[#MDEV-27509] sql_mode="oracle" does not support CHAR and VARCHAR data sizes

[MDEV-27509] sql_mode="oracle" does not support CHAR and VARCHAR data sizes Created: 2020-05-14 Updated: 2024-01-12
Status:	Open
Project:	MariaDB Server
Component/s:	None
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Manjot Singh (Inactive)

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

Compatibility, Oracle

Description

in PL/SQL CHAR and VARCHAR can also be defined by data size instead of character limit.

For example:

"CUR_CD" CHAR(2 BYTE) NOT NULL ENABLE

"DSCR_CD" VARCHAR2(9 BYTE) NOT NULL ENABLE

Comments

Comment by Julien Fritsch [ 2020-06-02 ]

manjot We only support the most important subset of PL/SQL so far. This MENT is a features which is outside of the currently supported subset.

Comment by Michael Widenius [ 2020-06-07 ]

This is a new feature that we adding support for

Generated at Thu Feb 08 09:53:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.