Re: 9th's bug

Posted in 2005

Jean Sagi — Mon, 04 Apr 2005 06:14:21 -0500 — source: Usenet: comp.databases.informix

Ummm... I see... It seems what he is trying to do doesn't work in the long term... J. Serge Rielau wrote: > Jean Sagi wrote: > >>I find this very interesting : >> >>EXECUTE PROCEDURE p( ( SELECT f FROM t2 ) );>> >>And the argument to p is a nvarchar(10)... >> >>What is "rotor" trying to do? >> >>What about if the select on t2 returns more than one row? >> >>J. > > Should be the same error as when you do: > 1 + (select f from t2) > At the end of the day (select f from t2) is just a (scalar) expression. > I presume if t2 has no rows the result of the scalar subquery is > NULL::NVARCHAR(10)? > > Cheers > Serge > Serge Rielau > DB2 SQL Compiler Development > IBM Toronto Lab > sending to informix-list