Re: 9th's bug

Posted in 2005

Serge Rielau — Sun, 03 Apr 2005 23:23:13 -0400 — source: Usenet: comp.databases.informix

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