PL/SQL parser - Phase 2
(MDEV-10764)
|
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Technical task | Priority: | Major |
| Reporter: | Michael Widenius | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 3 |
| Labels: | Compatibility, trigger | ||
| Attachments: |
|
| Description |
|
Add support for TRIGGER events that can fire for one or many of The current syntax for triggers are:
The task is to replace trigger_event with:
Oracle and PostgreSQL both support this extension to CREATE TRIGGER. PostgreSQL solves the issue witth information schema by duplicating the trigger for as many times as there are events.The primary key of the view triggers is because of this trigger_catalog, trigger_schema, event_object_table, trigger_name, event. To distinguish which event fired the trigger, Oracle supports event flags:
We should also support this. |
| Comments |
| Comment by Sergei Golubchik [ 2016-06-01 ] |
|
how to show that in INFORMATION_SCHEMA.TRIGGERS? |
| Comment by Andrii Nikitin (Inactive) [ 2017-06-19 ] |
|
I've attached PoC in patch.diff which seem to work (still needs to add INSERTING / DELETING / UPDATING) keywords to parser |