Bugs item #2974381, was opened at 2010-03-22 15:11
Message generated for change (Tracker Item Submitted) made by oursql
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2974381&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: Core
Group: MonetDB5 "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: bill xin (oursql)
Assigned to: Nobody/Anonymous (nobody)
Summary: concurrency control bug
Initial Comment:
There is a bug in monetdb, you can run the following script in two
clients(mclient.exe), and before test, please disable autocommit option.
user A: USER
B:
CREATE TABLE TEST(C1 INT PRIMARY KEY, C2 INT);
INSERT INTO TEST VALUES(1,1);
COMMIT;
SELECT C2 FROM TEST WHERE C1=1;
SELECT C2 FROM TEST WHERE C1=1;
UPDATE TEST SET C2=10 WHERE C1=1;
UPDATE TEST SET
C2=30 WHERE C1=1;
COMMIT;
COMMIT;--CONFLICT,
NEED TO ROLLBACK;
ROLLBACK;
UPDATE TEST SET
C2=30 WHERE C1=1;
SELECT C2 FROM
TEST WHERE C1=1;
--THE RESULT IS
10, NOT 30. TOO BAD!
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2974381&group_id=56967
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
