Bugs item #2605686, was opened at 2009-02-16 14:08 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2605686&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: Fixed Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: decimals / exec doesn't truncate decimals Initial Comment: create table test(test decimal(4,4)); !scale (4) should be less than precision (4) in: "create table test(test decimal(4,4)" !syntax error, unexpected ')' in: ")" Not known if this is an SQL bug. ---------- create table test(test decimal(5,4)); insert into test values (0.12345); select * from test; ---> 0.1235 (as expected) (restart mclient) PREPARE INSERT INTO test (test) values (?); exec 2(0.12345); !SQLException:sql.prepare:wrong argument for prepared statement (expected decimal instead of decimal) ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-02-16 22:08 Message: fixed handling of decimal2decimal casting in atom_cast, it now truncates. Added a test decimal_needs_truncation.SF-2605686.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2605686&group_id=56967 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
