Bugs item #1605209, was opened at 2006-11-29 13:17
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1605209&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: Triggers combine with constraints
Initial Comment:
Dear developers,
I am using SQL cvs head and M5.
If I run the following queires:
create table t1 (id int, name varchar(1024));
create table t2 (id int);
insert into t1 values(10, 'monetdb');
insert into t1 values(20, 'monet');
create trigger test1
after update on t1
delete from t1 where name = 'mo' and id = 10;
create trigger test2
before update on t1
select id into t2 where id = 10;
create trigger test3
after update on t1
insert into t1 values(10, 'update_from_test3');
create trigger test4
after update on t1
insert into t1 values(20, 'update_from_test4');
ALTER TABLE t1 add CONSTRAINT t1_constraint PRIMARY KEY(id);
I get this error:
sql>ALTER TABLE t1 add CONSTRAINT t1_constraint PRIMARY KEY(id);
MAPI = [EMAIL PROTECTED]:50000
QUERY = ALTER TABLE t1 add CONSTRAINT t1_constraint PRIMARY KEY(id);
ERROR = !ERROR: 'aggr.count' undefined in user.s1_1[15] _35:bat[:oid,:int] :=
aggr.count(_31:bat[:void,:oid], _31:bat[:void,:oid], _33:bat[:void,:void])
!ERROR: SQLerror:assert:INSERT INTO: PRIMARY KEY constraint
't1.t1_constraint' violated
sql>
Any idea?
Regards,
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2007-01-17 20:20
Message:
Logged In: YES
user_id=1498628
Originator: YES
This BUG was fixed and it covered by a Test.
Note: One of the triggers in the example is not working. I run the example
without this trigger.
Regards,
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1605209&group_id=56967
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
