Richard, Oops, I seem to have stirred up a hornet's nest! (must be a talent of mine). Sorry about the "riga.riga" thing, I couldn't remember your name...
BTW: this apparent accreditation (below) is incorrect/an accident of editing? I didn't say this. It was Doug (he says pointing an accusative finger). Doug whilst I'm (appearing to) round on you, contrary to your comment about lack of evidence, Benjamin Pflugman and I responded to Richard's first msg and BOTH reproduced the original phenomenon. It is true that I tested on a Windows box, but I can't say what Benjamin's is, to know if it has anything to do with M$ particularly - but don't let the mere facts get in the way of a salacious story (M$ don't!) > > On Thu, 28 Feb 2002 12:42:04 -0000, DL Neil wrote: > > > 2. The original inquiry may have been resolved using revised/corrected > > syntax -- specifically, @variable -- and would > > require no 'official' involvement. It would be good to hear back from > > riga.riga about his results. Thank you to Roger for a concise summary of the two issues: the somewhat familiar C-rounding library-inconsistency problem had (to my mind) started to overshadow the original issue with ROUND(). > But regardless of all ways to "get it to work", I still think it's a clear > bug. > select round(cola,colb) should work and would make things a lot easier and > faster. > btw: Benjamin Pflugmann forwarded my first posting to mysql-bugs, but > there's no reply yet. I agree, feeling that it is either a bug in MySQL or a 'bug' in the documentaitno - as I said at the time and was restated/reworded today. All of the manual examples give a constant as the number of significant figures for this and similar functions, but the command templates seem to say that a column value or variable could be used. I had forgotten that Benjamin had announced his firm grasp on the initiative - I guess my less teutonic (but nevertheless tidy, if small) mind felt that I should ensure Richard scooped that particular pool - some people think such things deserve some 'credit', because it is certainly not everyday anyone finds a genuine bug in MySQL! More of interest, I'd like to hear from one of the MySQL AB people, to find out if there is a misunderstanding of how things should really be, or if it is in fact a bug? > I'll go on vacation tomorrow afternoon, a colleague of mine who is working > on the same project, Jan Kirchhoff ([EMAIL PROTECTED]) will monitor the > list (he just subscribed). He has quite a lot of experience with mysql but > also couldn't help me with the "round()"-problem... Have a good break. Welcome Jan. =dn PS after his cogent summary, if anyone out there believes that Roger can hide behind "english is not my first language", please come to see me about a special price on the Brooklyn Bridge (be good chaps and form an orderly queue, if you would, please)! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
