From: Dusan Kolesar (d.kolesargmail.com)
Date: Mon Aug 27 2007 - 03:36:27 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.kolesargmail.com
e-mail alternative : d.kolesarcentrum.sk
ICQ# : 160507424

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]