> --- Ursprüngliche Nachricht --- > Von: "Anhaus, Thomas" <[EMAIL PROTECTED]> > An: "Andreas Goldstein" <[EMAIL PROTECTED]> > Kopie: <[email protected]> > Betreff: AW: AW: [FSID] Triggers & 9111 > Datum: Fri, 21 Oct 2005 12:11:15 +0200 > > > > >-----Ursprüngliche Nachricht----- > >Von: Andreas Goldstein [mailto:[EMAIL PROTECTED] > >Gesendet: Donnerstag, 20. Oktober 2005 19:14 > >An: Anhaus, Thomas > >Cc: [email protected] > >Betreff: Re: AW: [FSID] Triggers & 9111 > > > > > >Andreas Goldstein wrote : > >Gesendet: Montag, 17. Oktober 2005 08:06 > >An: * > >Betreff: [FSID] Triggers & 9111 > > > > > >Hi Listmembers, > > > >what is wrong here: > > > >CREATE TABLE WWIND.Kunden ( > >KundenNr FIXED(10) DEFAULT SERIAL PRIMARY KEY, > >Firma VARCHAR(40) NOT NULL, > >Kontaktperson VARCHAR(30), > >Funktion VARCHAR(30), > >Strasse VARCHAR(60) NOT NULL, > >Ort VARCHAR(15) NOT NULL, > >Region VARCHAR(15), > >PLZ VARCHAR(10) NOT NULL, > >Land VARCHAR(15) NOT NULL, > >Telefon VARCHAR(24), > >Telefax VARCHAR(24)) > >// > >CREATE TRIGGER it_kontaktinfo FOR WWIND.KUNDEN AFTER INSERT EXECUTE ( > >IF (KONTAKTPERSON IS NULL OR KONTAKTPERSON = '') AND FUNKTION > >IS NOT NULL > >THEN STOP (30001, 'Funktion ohne Kontaktperson ist nicht erlaubt'); > >) > >// > >CREATE TRIGGER ut_kontaktinfo FOR WWIND.KUNDEN AFTER UPDATE > >EXECUTE ( > >IF (NEW.KONTAKTPERSON IS NULL OR NEW.KONTAKTPERSON = '') AND > >NEW.FUNKTION IS > >NOT NULL > >THEN STOP (30002, 'Funktion ohne Kontaktperson ist nicht erlaubt'); > >) > >// > >INSERT INTO KUNDEN > >(KundenNr, Firma, Kontaktperson, Funktion, Strasse, Ort, > >Region, PLZ, Land, > >Telefon, Telefax) > >VALUES > >(1,'Alfreds Futterkiste','Maria > >Anders','Vertriebsmitarbeiterin','Obere > >Str. 57','Berlin', > >'','12209','Deutschland','030-0074321','030-0076545') > > > > > >Execution of the above statements on MaxDB 7.6.00.12 (Windows > >XP) results in > >the following errormessage: > >---- Error ------------------------------- > >Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > > General error;-9111 > >INSERT INTO KUNDEN (KundenNr, Firma, Kontaktperson, Funktion, > >Strasse, Ort, > >Region, PLZ, Land, Telefon, Telefax) VALUES (1,'Alfreds > >Futterkiste','Maria > >Anders','Vertriebsmitarbeiterin','Obere Str. 57','Berlin', > >'','12209','Deutschland','030-0074321','030-0076545') > > > > > >Marked in red are 'NSERT' of the INSERT-Statement (Yes, the > >'I' is not > >marked!). > > > >The reason for the error seems to be caused by the triggers as > >the error > >will not occur when creating the table and inserting the > >record without > >having defined the triggers. > > > > > >This example demonstrates the problem with showing defined > >triggers I > >mentioned some days before (see '[FSID] DOMAIN.TRIGGERS always > >empty!?'): > >Execute the above statements without the INSERT-Statement. On my > >MaxDB-installations this will not result in an errormessage > >and the table > >will be shown in the catalog-manager of SQL Studio while the > >triggers are > >not shown there. > >SELECT COUNT(*) FROM TRIGGERS resuults in '0', but when I try > >to define a > >INSERT-Trigger on WWIND.KUNDEN the system states a "6006 - > >Duplicate name" > > > > > >Who can explain these phenomenons? > > > > > >THX & Regards > > > > > > > > > > > >--- Ursprüngliche Nachricht --- > >Von: "Anhaus, Thomas" <*> > >An: "Andreas Goldstein" <*>, > ><*> > >Betreff: AW: [FSID] Triggers & 9111 > >Datum: Mon, 17 Oct 2005 17:04:09 +0200 > > > >The error -9111 is a bug which is caused by the combination > >of the default serial and the trigger. We will fix it > >as soon as possible. > > > >Unfortunately I have not been able to reproduce the hidden > >trigger problem yet. > > > >Best Regards, > >Thomas > > > > > > > > > >-----Ursprüngliche Nachricht----- > >Von: Andreas Goldstein [mailto:*] > >Gesendet: Dienstag, 18. Oktober 2005 14:57 > >An: Anhaus, Thomas > >Betreff: Re: AW: [FSID] Triggers & 9111 > > > >Hi Thomas! > >Thanks for your response. > > > >How is sould this information be interpreted? > >Never use triggers on tables that use default serial attributes? > > > >Is there any workaround for this issue? > >This seems to be a serious bug once again, as the > >trigger-routine has been > >changed according to the LENGTH-bug yet and does not work at all. :( > > > > > > > > > > > >--- Ursprüngliche Nachricht --- > >Von: "Anhaus, Thomas" <*> > >An: "Andreas Goldstein" <*> > >Betreff: AW: AW: [FSID] Triggers & 9111 > >Datum: Tue, 18 Oct 2005 15:19:07 +0200 > > > >Hi Andreas, > >the problem actually has nothing to do with the trigger and the code > >inside the trigger is irrelevant. > >The problem is caused by the serial and you will also be able > >to run into > >the problem without any trigger. However, I don't know the exact > >circumstances because I'm not familiar with that part of the code. > >But as far as I understood the problem, the following workaround should > >help : > > > >CREATE TRIGGER it_kontaktinfo FOR WWIND.KUNDEN AFTER INSERT > >EXECUTE ( > >IF (KONTAKTPERSON IS NULL OR KONTAKTPERSON = '') AND FUNKTION > >IS NOT NULL > >THEN STOP (30001, 'Funktion ohne Kontaktperson ist nicht erlaubt'); > >) whenever 1 = 1 > > > >Best Regards, > >Thomas > > > > > > > > > >Hi Listmembers, > > > >by a mistake I did not respond to the list so I fix this > >mistake by this > >mail that contains a workaraound suggested by Thomas. > > > >Best regards > > > > > > > > > > > >Hi again, > > > >I tried to identify the bug in the MaxDB-PTS > >(http://www.sapdb.org/webpts) - > >can someone please state the > >PTS-number of the bug that causes the problem > >mentioned above. > > > >THX & Best regards > > > >-- > >Highspeed-Freiheit. Bei GMX supergünstig, z.B. GMX DSL_Cityflat, > >DSL-Flatrate für nur 4,99 Euro/Monat* http://www.gmx.net/de/go/dsl > > > >-- > >MaxDB Discussion Mailing List > >For list archives: http://lists.mysql.com/maxdb > >To unsubscribe: > >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > > > > > > you will find this bug under > > http://pts:1080/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1138461 > > Best Regards, > Thomas
Thanks again! The given URL does not work and is forwarded to 'Paper Technology Specialists' (http://www.ptspaper.de/) :) But with the errornumber I found the corresponding page in PTS :) THX & Best regards -- Highspeed-Freiheit. Bei GMX supergünstig, z.B. GMX DSL_Cityflat, DSL-Flatrate für nur 4,99 Euro/Monat* http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
