maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

DB2 goes even beyond. When you do INSERT/DELETE/UPDATE, you can SELECT from these tables:

OLD - the old rows, unmodified
NEW - the new rows, before any AFTER trigger or foreign key is executed
FINAL - the final rows, after triggers and foreign keys are executed



--------------------------------------------
Ven 12/6/15, Rhys Campbell <Rhys.Campbell@xxxxxxxxxxxxxxxxx> ha scritto:

 Oggetto: RE: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers
 A: "Federico Razzoli" <federico_raz@xxxxxxxx>, "Geoff Montee" <geoff.montee@xxxxxxxxx>, "Roberto Spadim" <roberto@xxxxxxxxxxxxx>
 Cc: "MariaDB discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Venerdì 12 giugno 2015, 10:55
 
 Just to add another one into the mix
 (and I guess it may be related in some sense)...
 
 For ON DELETE triggers it currently fires per row. This
 impacts performance significantly in some situations when a
 lot of rows are processed. MSSQL gets around this by
 creating virtual tables, INSERTED & DELETED (in effect
 similar to the OLD / NEW tags) and the trigger executes only
 once...
 
 https://msdn.microsoft.com/en-us/library/ms191300.aspx
 
 
 
 Cheers,
 
 Rhys
 
 -----Original Message-----
 From: Maria-discuss
 [mailto:maria-discuss-bounces+rhys.campbell=tradingscreen.com@xxxxxxxxxxxxxxxxxxx]
 On Behalf Of Federico Razzoli
 Sent: 12 June 2015 04:02
 To: Geoff Montee; Roberto Spadim
 Cc: MariaDB discuss
 Subject: Re: [Maria-discuss] DELETE FROM RETURNING
 
 In the meanwhile, we can use ON DELETE triggers. But the
 request is a good idea, because it is a common operation
 when we want to move some rows to history tables.
 
 Federico
 
 
 --------------------------------------------
 Gio 11/6/15, Roberto Spadim <roberto@xxxxxxxxxxxxx>
 ha scritto:
 
  Oggetto: Re: [Maria-discuss] DELETE FROM RETURNING
  A: "Geoff Montee" <geoff.montee@xxxxxxxxx>
  Cc: "MariaDB discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
  Data: Giovedì 11 giugno 2015, 21:09
  
  +1, good idea, today
  i execute an insert, and a delete
  2015-06-11 16:07
  GMT-03:00 Geoff Montee <geoff.montee@xxxxxxxxx>:
  Hi
  Rhys,
  
  
  
  On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell
  
  <Rhys.Campbell@xxxxxxxxxxxxxxxxx>
  wrote:
  
  > " This might be better suited as a feature
 request  on the MariaDB JIRA."
  
  >
  
  > I got chastised for doing that before so I'm
 trying  to play nice! ;-)
  
  >
  
  
  
  I don't know why you were chastised in the past,  but
 I've added this
  
  to the JIRA:
  
  
  
  https://mariadb.atlassian.net/browse/MDEV-8307
  
  
  
  It sure sounds like a useful feature to me. Thanks for
 the  suggestion!
  
  
  
  Geoff
  
  
  
  _______________________________________________
  
  Mailing list: https://launchpad.net/~maria-discuss
  
  Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
  
  Unsubscribe : https://launchpad.net/~maria-discuss
  
  More help   : https://help.launchpad.net/ListHelp
  
  
  
  
  --
  Roberto Spadim
  SPAEmpresarial - Software ERPEng. Automação e 
 Controle
  
  -----Segue allegato-----
  
  _______________________________________________
  Mailing list: https://launchpad.net/~maria-discuss
  Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx 
 Unsubscribe : https://launchpad.net/~maria-discuss
  More help   : https://help.launchpad.net/ListHelp
  
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp