Wrong resultset in MaxDB 7.6.0.27 with using UDF

[Alexey Gaidukov]

I have the following UDF

CREATE FUNCTION GetQuant(
   p_cab char(10)) returns smallint AS
VAR
   v_quant smallint;
   v_dateres timestamp;
BEGIN
       SELECT field into :v_quant from table where resid=:p_cab;
       return 1;
END;


The two following statement returns the same resultset

SELECT *
FROM invest
WHERE cartnum=6280  and i.dateres='2006-05-25'

and

SELECT *
FROM invest
WHERE cartnum=6280


the follwoing statement returns correct resultset

SELECT getQuant('155')
FROM invest
WHERE cartnum=6280


but the followoing returns always empty resultset

SELECT getQuant('155')
FROM invest
WHERE cartnum=6280  and dateres='2006-05-25'



If from UDF remove SELECT statement then it will work correctly.


Fields cartnum and dateres in the table invest both have indexes.
CREATE INDEX INVEST_DATERES ON GIS.INVEST(DATERES ASC)
CREATE INDEX INVEST_CARTNUM ON GIS.INVEST(CARTNUM ASC)


7.6.00.16 is not affected.


How can I avoid this problem?

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]