Re: [Firebird-test] I found an rare case

[Dmitry Y. <di...@us...>]

Hi,

> CREATE VIEW asignaciongruposagentes (idagente, idgrupo)
> AS SELECT idusuario, idgrupo
> FROM tb_asignaciongruposusuarios agu JOIN tb_usuarios u ON (agu.idusuario
=
> u.idusuario)
> WHERE agu.activa = 1 AND u.esagente = 1;
>
> Firebird answers me:
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -204
> internal gds software consistency check (table
TB_ASIGNACIONGRUPOSUSUARIOS)
> IDUSUARIO

In fact, there should be another error - "Ambiguous column reference",
because you select just "idusuario", but both tables in your statement
contain such a column, so the engine doesn't know which table you want to
get data from. It's a implicitly dangerous situation which IB 6.0 doesn't
care about. Rewrite your SELECT statement to use a table alias in the
selection area (like SELECT agu.idusuario ...). But some bug still exists in
the server, because it returns wrong error message.


Dmitry