[Firebird-devel] [ firebird-Bugs-409769 ] UDF argument can't be query-parameter

[<no...@so...>]

Bugs item #409769, was opened at 2001-03-19 09:03
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=409769&group_id=9028

Category: DSQL
>Group: Fixed v1.0
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Claudio Valderrama C. (robocop)
Summary: UDF argument can't be query-parameter

Initial Comment:
Query kind of:

  SELECT 
     Field1, Field2, ... ,
     UDF1(Field1, ?Param1)
  FROM 
     TABLE1 

don't work - message is "unknown data type"  
         

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

>Comment By: Claudio Valderrama C. (robocop)
Date: 2001-12-09 22:22

Message:
Logged In: YES 
user_id=62823

Now it works. For this, the DSQL layer has to load 
information about UDF arguments that previously it didn't 
have available.
With udfs that use descriptors, the recognized parameter 
type is always the formal parameter; the engine cannot 
guess the actual parameter wanted by the user. Either 
redeclare that udf with a different SQL name and use the 
desired formal parameter or try adjusting the scale of the 
input query parameter when the format argument is int and 
the current parameter is numeric(9,4), for example. If a 
UDF is declared to receive INT by descriptor, the engine 
can pass it happily a numeric(p,s) quantity, then it's to 
the udf to test the scale.


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

Comment By: Claudio Valderrama C. (robocop)
Date: 2001-12-03 00:14

Message:
Logged In: YES 
user_id=62823

Our syntax allows that. However, the DSQL layer doesn't 
retrieve information about parameters to know what their 
type is. A fix is being tested, but the interaction with 
descriptor-based UDFs will surprise developers.


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

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=409769&group_id=9028