Re: [Maria-developers] INSTEAD OF triggers

Opps, meant to send to list too. On Sat, Sep 25, 2021 at 5:28 PM Daniel Black wrote:

Hi Alexandre,

Given the aws blog is written around that Oracle SE doesn't have partitions and EE does, does it still make sense with MariaDB (that includes partitions as standard - https://mariadb.com/kb/en/partitioning-tables/)?

Take a look at the way partitions are implemented, they may offer what you plan to write in a slightly different way.

If you are sure you want to embark on this journey, there is a feature request for this issue https://jira.mariadb.org/browse/MDEV-12151

Recommend starting by describing exactly what you plan to implement in this issue. Reference existing implementations like https://www.postgresql.org/docs/current/sql-createtrigger.html make notes of differences and what you plan to cover (and not cover)

I assume you've come across the generic https://mariadb.org/get-involved/getting-started-for-developers/ . Start with a fork from the 10.7 branch

First bit is sql/sql_yacc.yy trg_action_time that is the parsing syntax.

If you `git grep TRG_ACTION_AFTER` the code you should contain the places that will need a TRG_ACTION_INSTEAD_OF handling.

Also look at the set of tests in $ find mysql-test -name \*trigger\*

Any problems, find us on https://mariadb.zulipchat.com/#narrow/stream/118759-general for some more realtime help.

On Sat, Sep 25, 2021 at 1:44 AM Alexandre hadjinlian guerra wrote:

...

Hello

Im looking forward to implement this feature in MariaDB, and will look after trigger definition code/modules in MariaDB, but any wisdom that could be shared to speed up my efforts would be greatly appreciated.

The idea is to provide the same functionality as describe here https://aws.amazon.com/pt/blogs/database/implementing-table-partitioning-in-...

Thanks

_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp