testing and debugging for TEIIDDES-2783 exposed an issue when importing a procedure containing a RETURNS data type and no result set.

The transformation resolving framework contains logic that will auto-create a result set containing a generated column.

We need to catch this use-case and prevent the result set from being created using this simple DDL input

CREATE VIRTUAL PROCEDURE ProcedureWithRS (
   stringIN string(4000) OPTIONS(ANNOTATION 'parameter 1 description')
) RETURNS string(255) OPTIONS(ANNOTATION 'Example') AS
BEGIN
	SELECT stringIN AS result;
END