 | | | Subject: INSERT .. UPDATE DUPLICATES - no trigger is fired | Subject: INSERT .. UPDATE DUPLICATES - no trigger is fired 2007-08-27 - By Dusan Kolesar
Back
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 : d.kolesar@(protected)
e-mail alternative : d.kolesar@(protected)
ICQ# : 160507424
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
|