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

[Milhouse <ok...@ok...>]

Thanks for your reply and sorry for posting it in this group.
Thanks again for your detailed answer. I´ll fix this view inmediately

""Dmitry Yemanov"" <di...@us...> escribió en el mensaje
news:ao3ggp$gok$1...@ne......
> 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
>
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>