Some times, I need to create a query where there is a 'where (0=0)' . it´s not logic for anyone. But to me, it´s significant because I need to certify that WHERE clausule always exists when populate my query with dinamic filters controlled by my application. In your example, I can espaculate that your intention is not a bug, but there is a reason for that or your value is innocuous. innocuous value is not the same as bug, sometimes is not intentional but happens when generated by automatic selected fields or filters in application. The RDBMS does not know the context situation to raise an exception for ambiguals or innocuous values.
2017-02-08 13:55 GMT-02:00 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] < firebird-support@yahoogroups.com>: > > > CREATE PROCEDURE TEST > RETURNS( > lcName VARCHAR(40)) > AS > BEGIN > FOR SELECT > ALU_NOMBRE, > ALU_APELLD > FROM > ALUMNOS > INTO > :lcName, > :lcName > DO > SUSPEND; > > END; > > In the above stored procedure there are 2 columns in the FOR SELECT but > just 1 variable name. > > It seems a bug for me. Or there are some reasons for allowing to do such > thing? > > Of course, the fault is of the programmer, but it can be detected at > compilation time. > > Firebird version: 2.5.5 > > Greetings. > > Walter. > > >
