v 10.0.1.3931

This script demonstrates the problem:

create table stuff(SomeStuff char(10) primary key);
insert into stuff(somestuff) values ('a');
insert into stuff(somestuff) values ('b');
insert into stuff(somestuff) values ('c');
insert into stuff(somestuff) values ('d');
insert into stuff(somestuff) values ('e');
insert into stuff(somestuff) values ('f');
insert into stuff(somestuff) values ('g');
insert into stuff(somestuff) values ('h');

create function Needs2Parameters(a int, b int)
returns int
begin
return a+b
end;

When you run this statement in ISQL:

select somestuff, Needs2Parameters(13) from stuff order by somestuff;

You get a dialog box entitled "Interactive SQL" saying: The following error occured while fetching results: Wrong number of parameters to function 'Needs2Parameters' SQLCODE=-154, ODBC 3 State="42000".

Fair enough, except that you also get a result set looking like this:

somestuff  Needs2Parameters(13)
'b'        (NULL)
'c',       (NULL)
'd',       (NULL)
'e',       (NULL)
'f',       (NULL)
'g',       (NULL)
'h',       (NULL)

note that the first line is missing. With an ODBC client it's even odder, you don't get an error, and the first line consists of random data from a buffer (it's often recognisable as something you selected recently), then you get the remainder of the result set seen in ISQL.

If the function is a built in one, eg

select somestuff, greater(13) from stuff order by somestuff

Then you get a different dialog box, enttled "ISQL Error", Could not execute statement. Wrong number of parameters ...... In this case you get no result set.

The same behaviour is seen in v9.0.2