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

[MDEV-20039] sql_mode="oracle" does not support Combined TRIGGERS events Created: 2019-07-10  Updated: 2019-09-10

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

Type: Technical task Priority: Major
Reporter: Faisal Saeed (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

A trigger in Oracle is generally combined into one for all events (INSERT, UPDATE & DELETE) This is not supported by MariaDB

Here is an example code for a typical trigger in Oracle:

CREATE TRIGGER trg_name AFTER INSERT OR UPDATE OR DELETE ON Table_Name
 
FOR EACH ROW
 
BEGIN
 
  IF INSERTING THEN
 
	Do Something here...
 
  END IF;
 
 
 
  IF UPDATING THEN
 
	Do Something here...
 
  END IF;
 
 
 
  IF DELETING THEN
 
	Do Something here...
 
  END IF;
 
END;

Oracle Doc: https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch15.htm
Generated at Thu Feb 08 08:56:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.