Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-19145] sql_mode="oracle" does not support bfile data type Created: 2019-04-02  Updated: 2023-10-18

Status: Stalled
Project: MariaDB Server
Component/s: Data types
Affects Version/s: None
Fix Version/s: N/A

Type: Technical task Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description    

MariaDB [test]> CREATE TABLE bfiletest (myfile BFILE);
 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BFILE)' at line 2

Bfile should translate to varchar(255) as a file path.

 Comments   
Comment by Alexander Barkov [ 2019-09-11 ]

The Estimated field includes:

  • Adding a new distinct data type
  • Check constraint to validate that it is a path
  • Multi-OS environment questions
  • Replication
Comment by Alexander Barkov [ 2023-10-18 ]

It seems it was closed in a mistake

Generated at Thu Feb 08 08:49:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.