-
Bug
-
Resolution: Done
-
Major
-
None
-
None
Very little validation is performed to ensure that the proper resultset is returned from a procedure.
for example:
create virtual procedure vproc (x integer) returns table (y integer) as begin if (x = 1) select 1; else select 1, 2; end;
will return an incorrect result if anything but 1 is passed in, which will cause downstream errors, such as exceptions during serialization (if mismatched types) or npes if too few columns.