Bugs item #1892708, was opened at 2008-02-13 13:29 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1892708&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 2.22 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Arjen de Rijke (arjenderijke) Assigned to: Niels Nes (nielsnes) Summary: error in create function Initial Comment: Using the tarball from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./Feb2008/ The following query CREATE FUNCTION CHECK_VIDEO() RETURNS VARCHAR(24) BEGIN RETURN SELECT BESTANDSNAAM FROM VIDEO_PRODUKTIE WHERE IMPALA_GEREED IS NULL LIMIT 1; END; returns an error: !syntax error, unexpected LIMIT, expecting SCOLON in: "create function check_video() This is in my opinion correct sql and it worked in earlier versions. It was tested on and F8 and FC6 machine. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-02-16 12:32 Message: Logged In: YES user_id=43556 Originator: NO The parser had a small bug. Fixed now. Also added a test to src/tests/BugTracker/Tests/orderby_in_function.SF-1892708.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1892708&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
