← Back to team overview

maria-developers team mailing list archive

Re: INSTEAD OF triggers

 

Opps, meant to send to list too.

On Sat, Sep 25, 2021 at 5:28 PM Daniel Black <daniel@xxxxxxxxxxx> 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
> <alexhguerra@xxxxxxxxx> 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-oracle-standard-edition-part-1/
> >
> > Thanks
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~maria-developers
> > Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~maria-developers
> > More help   : https://help.launchpad.net/ListHelp


References