Bugs item #1605200, was opened at 2006-11-29 13:05
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1605200&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: Pathfinder CVS Head
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: Triggers- Insert action
Initial Comment:
Dear developers,
I am using SQL cvs head and M5.
To see me problem run the following queries:
create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
create trigger test_0 after insert on t1
update t1 set id = 1, name = 'monetdb', age = 24 where id =1;
insert into t1 values(1, 'mo', 25);
select * from t1;
select * from t2;
create trigger test_1 after insert on t1
insert into t2 select id,age from t1;
insert into t1 values(2, 'mo', 26);
select * from t1;
select * from t2;
create trigger test_2 after insert on t1
insert into t2 values(1,23);
insert into t1 values(3, 'mo', 27);
select * from t1;
select * from t2;
If you check the result of the selection over t2 it does not contains the row:
[1, 23 ]
it only contains:
[ 1, 25 ]
[ 1, 24 ]
[ 2, 26 ]
Which should had been inserted by action body of trigger test_2.
Regards,
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2007-01-17 22:20
Message:
Logged In: YES
user_id=1498628
Originator: YES
This BUG was correct and it is coverd by a SQL test.
Regards,
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1605200&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
