Alexey Gaidukov wrote:
>
> Can somebody help me?
>
> select getQuant('155') from dbadmin.dual
> returns correct value without exception
>
> The statement
>
> SELECT *
> FROM invest
> WHERE cartnum=6280 and i.dateres='2006-05-25'
>
>
> returns one record
>
> but why
>
> SELECT getQuant('155')
> FROM invest
> WHERE cartnum=6280 and i.dateres='2006-05-25'
>
> returns no records in MaxDB 7.6.00.27?
>
> In MaxDB 7.6.00.16 absolutly the same tests returns correct
> result. In
> attachement there is a vtrace of a statement where should be
> one record
> but it returns "100 No Result".
>
For those following this subject:
getQuant is a user-defined function with a select without cursorname in.
So one has an unnamed query-result IN the user-defined function and one,
meaning that one sent by the client.
These two resultsets collide in some way causing this unexpected result.
We will try to solve the problem.
As workaround a
DECLARE <some name> CURSOR FOR in front of the select and FETCH <same
name>
IN the UDF will help.
Elke
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
