Informix to PostgreSQL: FUNCTION RETURNING unhandled

[strk]

This valid Informix function does not convert correctly to PostgreSQL:

CREATE FUNCTION test_returning()
RETURNING VARCHAR(3), VARCHAR(3) ;
   RETURN '0','1';
END FUNCTION

The output shows some memory issue too, as it has mungled text:

CREATE OR REPLACE FUNCTION test_returning()
RETURNING VARCHAR(3), VARCHAR(3) ; AS $$

BEGIN
   RETURN '0','1';
END; 
$$ LANGUAGE plpgsql;
AGE plpgsql;
GE plpgsql;
   
END CREATE FUNCTION;
LANGUAGE plpgsql;

[strk]

Code to convert RETURNING to OUT parameter do exist, but it is evidently not triggered:

sqlines/sqlparser/statements.cpp

Lines 9038 to 9040 in da5ea50

	// For Informix replace RETURNING values with OUT parameters or table function
	if(_source == SQL_INFORMIX)
	InformixConvertReturning(create, procedure);

[strk]

The InformixConvertReturning function is called, as debugging statements show:

XXX ParseInformixReturns enter, returns are 0x558871e2e230
XXX ParseInformixReturns found return datatype VARCHAR
XXX ParseInformixReturns found return datatype VARCHAR

But for some reason those parsed return values are not used/converted

[strk]

Work in progress fix for this issue is in renesugar#3