PL/SQL parser - Phase 2 (MDEV-10764)

[MDEV-11921] sql_mode=ORACLE: Translate NUMBER, FLOAT and DOUBLE to subtypes of DECIMAL Created: 2017-01-27  Updated: 2021-11-03

Status: Open
Project: MariaDB Server
Component/s: Data types
Affects Version/s: 10.3.23
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 1
Labels: Compatibility


 Description   

Oracle data types NUMBER, FLOAT and DOUBLE are precise data types. They never use scientific notation when converted to string.

When running in sql_mode=ORACLE, MariaDB should probably translate these data types to DECIMAL with reasonable precision and scale.

Jerome B. has investigated compatibility problems:
https://lists.launchpad.net/maria-developers/msg10330.html



 Comments   
Comment by Jérôme Brauge [ 2017-02-23 ]

Hello Alexander,
When you will chose the right precision, do not forget to add NUMBER as a cast target datatype.
Regards.
Jérôme.

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