Hi Dusan, thank you for mailing this bug. We will fix it as soon as possible. As a workaround you could insert via the <insert select statement>, i.e.
INSERT TB SELECT 1, 'Text (updated)' FROM DUAL UPDATE DUPLICATES After that you should have 2 rows in your LOG table. Best Regards, Thomas --- Thomas Anhaus MaxDB&liveCache mailto: [EMAIL PROTECTED] www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher / Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. > -----Original Message----- > From: Dusan Kolesar [mailto:[EMAIL PROTECTED] > Sent: Montag, 27. August 2007 10:36 > To: MaxDB mailing list > Subject: INSERT .. UPDATE DUPLICATES - no trigger is fired > > Hello, > I'm using MaxDb 7.6.00.37 on Linux OS (CentOS). > > when I do INSET statement wiht UPDATE DUPLICATES > database engine works incorrectly. > Only when INSERT is performed trigger is fired. > On UPDATE none triger is fired. > > Here is an example: > CREATE TABLE "ADMIN"."TB" > ( > "ID" Integer DEFAULT SERIAL, > "TXT" Varchar (30) ASCII DEFAULT '', > PRIMARY KEY ("ID") > ) > // > CREATE TABLE "ADMIN"."LOG" > ( > "TXT" Varchar (30) ASCII DEFAULT '' > ) > // > // > CREATE TRIGGER TB_INSERT FOR TB AFTER INSERT EXECUTE > ( > INSERT ADMIN.LOG SET TXT = 'insert'; > ) > // > CREATE TRIGGER TB_UPDATE FOR TB AFTER UPDATE EXECUTE > ( > INSERT ADMIN.LOG SET TXT = 'update'; > ) > // > CREATE TRIGGER TB_DELETE FOR TB AFTER DELETE EXECUTE > ( > INSERT ADMIN.LOG SET TXT = 'delete'; > ) > // > // > INSERT TB SET ID = 1, TXT = 'Text' UPDATE DUPLICATES > // > INSERT TB SET ID = 1, TXT = 'Text (updated)' UPDATE DUPLICATES > // > > after 2nd insert there is only 1 row in the LOG table (with > text insert). > > > Thank you for support. > > Dusan > > -- > Dusan Kolesar > Helsinska 19 > 040 13 Kosice > Slovakia > e-mail primary : [EMAIL PROTECTED] > e-mail alternative : [EMAIL PROTECTED] > ICQ# : 160507424 > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
