Bugs item #2818176, was opened at 2009-07-07 19:38 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2818176&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 "stable" >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Franck Routier (alci) Assigned to: Niels Nes (nielsnes) Summary: NUMERIC data type not following sql standard Initial Comment: The numeric type in Monetdb has two shortcomings : - numeric is an arbitrary precision number. Imposing a limitation of 18 digits in the implementation is a bit restrictive (it is ok, but most rdbms will have much higher precision) - when defining the type NUMERIC(P,S), P+S must be <= 18. But in fact, P should be the total number of digits, so if the limit is 18, we should have P <= 18 (and of course S<P) ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-08-06 19:33 Message: fixed the numeric type added test to BugTracker-2009 ---------------------------------------------------------------------- Comment By: Franck Routier (alci) Date: 2009-07-21 07:27 Message: simply try this : sql>create table numtest (id integer, val numeric(18,8)); You will see : !decimal(18,8) isn't supported because P=18 + S=8 > 18 in: "create table numtest (id integer, val numeric(18,8)" !syntax error, unexpected ')' in: ")" 0 tuples As you see, you cannot create numeric(18,8), as monetdb checks that P+S <= 18. But in the sql numeric type, P stands for the TOTAL precision of the number, and S the number of digits for the decimal part. So numeric(18,8) should be valid, meaning a number with 10 digits for the floor, and 8 digits for the decimal part... ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-07-20 18:44 Message: could you please add the failing prepare/execute statements (including ddl statements). Its hard to reproduce bugs without test scripts. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2818176&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
