Bugs item #2812729, was opened at 2009-06-26 12:32 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2812729&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: Arjen de Rijke (arjenderijke) Assigned to: Niels Nes (nielsnes) Summary: using null as a value gives syntax error Initial Comment: If you use NULL as a value, the SQL module give a syntax error. For example, start mclient and than do: sql>declare a int; sql>set a = null; The errormessage is: !syntax error, unexpected sqlNULL in: "set a = null" This also happens if you use NULL as the value of a funtion parameter, for example: sql> select call_function(NULL); This was tested on a checkout of CVS current of June, 23. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-08-06 20:39 Message: we now allow for null's in assignments and as arguments of functions ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-08-06 20:34 Message: added test to src/tests/BugTracker=2009/set_and_arg_null.SF-2812729.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2812729&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
