Bugs item #1605193, was opened at 2006-11-29 12:54
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1605193&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: Trigger - Update action
Initial Comment:
Dear developers,
Just run the following queries:
create table t1(id int, name varchar(1024), 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;
How you can see the result in t1 is:
[ 1, "mo", 25 ]
and it should be:
[ 1, "monetdb", 24 ]
Regards,
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2007-01-17 20:16
Message:
Logged In: YES
user_id=1498628
Originator: YES
This BUG was fixed and it is covered by a SQL test.
Regards,
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1605193&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
