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 =3D 'insert';
)
//
CREATE TRIGGER TB_UPDATE FOR TB AFTER UPDATE EXECUTE
(
   INSERT ADMIN.LOG SET TXT =3D 'update';
)
//
CREATE TRIGGER TB_DELETE FOR TB AFTER DELETE EXECUTE
(
   INSERT ADMIN.LOG SET TXT =3D 'delete';
)
//
//
INSERT TB SET ID =3D 1, TXT =3D 'Text' UPDATE DUPLICATES
//
INSERT TB SET ID =3D 1, TXT =3D '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]