Re: (no subject)

Your new version of CREATE FUNCTION looks correct.

The bug relates to using a function with CALL. It worked fine with
procedures.

Fred

On Thu, Sep 8, 2016, at 18:48, [email protected] wrote:
> Hello!
> 
> On 2016-09-08T18:27:37 +0100
> Fred Toussi <[email protected]> wrote:
> 
> > I think this has been fixed in SVN /base/trunk
> 
> Ok, thanks.
> 
> > 
> > Please read the Guide for the supported syntax of CREATE PROCEDURE and
> > CREATE FUNCTION.
> > 
> > With CREATE FUNCTION, you need to use RETURN TABLE(SELECT ...)
> 
> I'm not sure if you meant that the syntax I gave is wrong...
> 
>   CREATE FUNCTION getX(IN in_x INTEGER)
>     RETURNS TABLE (x INTEGER)
>       READS SQL DATA RETURN TABLE (SELECT t.x FROM WHERE t.x = in_x
>        LIMIT 1);
> 
> It seems correct. Is the (fixed) bug masking what would have been
> a syntax error?
> 
> M
> ------------------------------------------------------------------------------
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> Email had 1 attachment:
> + Attachment1.2
>   1k (application/pgp-signature)

------------------------------------------------------------------------------