[ https://issues.jboss.org/browse/TEIIDDES-3034?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3034: ----------------------------------- Description: 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 {code} 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 {code} was: 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 {code} 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 {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)