Bugs item #1599763, was opened at 2006-11-20 15:46
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1599763&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
Initial Comment:
Dear developers,
I created the following tables and trigger:
create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);
create trigger test_1 after insert on t1
insert into t2 select id,age from t1;
I done the following insertion on t1:
sql>insert into t1 values(2, 'mo', 26);
[ 0 ]
[ 1 ]
And then I checked the status of each table:
sql>select * from t1;
% sys.t1, sys.t1, sys.t1 # table_name
% id, name, age # name
% int, varchar, int # type
% 1, 2, 2 # length
[ 2, "mo", 26 ]
sql>select * from t2;
% sys.t2, sys.t2 # table_name
% id, age # name
% int, int # type
% 1, 1 # length
I done another insertion:
sql>insert into t1 values(2, 'mo', 26);
[ 1 ]
[ 1 ]
and I checked again the status:
sql>select * from t2;
% sys.t2, sys.t2 # table_name
% id, age # name
% int, int # type
% 1, 2 # length
[ 2, 26 ]
another insertion and status checked:
sql>insert into t1 values(2, 'mo', 28);
[ 2 ]
[ 1 ]
sql>select * from t2;
% sys.t2, sys.t2 # table_name
% id, age # name
% int, int # type
% 1, 2 # length
[ 2, 26 ]
[ 2, 26 ]
[ 2, 26 ]
Any idea about the problem?
In my opinion the problem is related with the commit.
Best Regards,
Romulo Goncalves
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2007-01-17 20:12
Message:
Logged In: YES
user_id=1498628
Originator: YES
The bug was fixed and it is covered by a test.
Regards,
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1599763&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
