Bugs item #2959974, was opened at 2010-02-27 04:20 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2959974&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: Works For Me Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL; where constant value Initial Comment: I wonder if the following is per spec behavior, every constant value not equal to 0 gets casted to true. Is there a reason to allow arbitrary constants? select * from tables where 12345; ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2010-04-09 12:28 Message: The spec isn't clear on this. Auto-conversions between numbers are indeed always done. From numeric to boolean is just an added bonus. I don't consider this a bug. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2959974&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
