Bugs item #2075135, was opened at 2008-08-26 06:23 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075135&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: MonetDB5 5.6 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Qian Qiao (drizzlerain) Assigned to: Niels Nes (nielsnes) Summary: the view with account row,selected wrong Initial Comment: OS:RedHat Linux AS 4 GCC:3.4.6 1.setup: CREATE TABLE A (TOT_PRICE DECIMAL(12,2), UNITS INTEGER); CREATE TABLE B (DOLLAR_EQUIV NUMERIC(5, 2), POUND_EQUIV NUMERIC(8,2)); CREATE VIEW C (UNIT_PRICE) AS SELECT (TOT_PRICE * DOLLAR_EQUIV) / (UNITS * POUND_EQUIV) FROM A, B; 2.insert: INSERT INTO A VALUES (1411.5, 4000); INSERT INTO B VALUES (1.00, 2.20); 3.result: select * from C; +-----------------------+ | unit_price | +=======================+ | 0.0000 | +-----------------------+ 4.question: The result is wrong. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-09-09 12:50 Message: correct accum function is called now (fixes in the resolution of accumulator functions) ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-08-26 12:58 Message: Logged In: YES user_id=43556 Originator: NO Added test mul_div_bug.SF-2075135.sql. The bug seems to trigger 2 problems. One casting of numerics with multiplication isn't done correctly (we lose some of the scale (2.2)). Second problem is with in the core, ie incorrect CMDbataccumMUL is called. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2008-08-26 06:59 Message: Logged In: YES user_id=572415 Originator: NO What should (have) be(en) the correct/expected result? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075135&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
