Bugs item #1892708, was opened at 2008-02-13 14:29 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: Open Resolution: None 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. ---------------------------------------------------------------------- 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
