Subject Re: [firebird-support] Is this a bug of Firebird?
Author hamacker
Post date 2017-02-09T15:00:36Z
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' sistemas2000profesional@... [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.