[Firebird-test] I found an rare case

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

Hi.

I´m trying to migrate my DB from Interbase 6.0 to Firebird 1.5 Alpha2. I
have encountered this case:

When I try to make:

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

These two tables are:

CREATE TABLE tb_asignaciongruposusuarios
(
          idusuario    INTEGER            NOT NULL,
            idgrupo    INTEGER            NOT NULL,
      activa    SMALLINT DEFAULT 1 NOT NULL,

 PRIMARY KEY (idusuario, idgrupo),
 CHECK(activa IN (0, 1))
);

and

CREATE TABLE tb_usuarios
(
       idusuario    INTEGER         NOT NULL,
          nombre    VARCHAR(    35) CHARACTER SET ISO8859_1 NOT NULL COLLATE
ES_ES,
       apellido1    VARCHAR(    25) CHARACTER SET ISO8859_1       COLLATE
ES_ES,
       apellido2    VARCHAR(    25) CHARACTER SET ISO8859_1        COLLATE
ES_ES,
           login    VARCHAR(    20) CHARACTER SET ISO8859_1 NOT NULL COLLATE
ES_ES,
             dni       CHAR(     9) CHARACTER SET NONE      NOT NULL COLLATE
NONE,
 fechanacimiento       DATE,
       direccion    VARCHAR(    60) CHARACTER SET ISO8859_1          COLLATE
ES_ES,
            sexo   SMALLINT         DEFAULT 0 NOT NULL,
     estadocivil   SMALLINT,
       fechaalta       DATE         NOT NULL,
        horaalta       TIME,
      comentario    VARCHAR(   255) CHARACTER SET ISO8859_1        COLLATE
ES_ES,
       idhorario    INTEGER,
    idrecursodef    INTEGER,
      habilitado   SMALLINT         DEFAULT 1 NOT NULL,
        esagente   SMALLINT     DEFAULT 1 NOT NULL,
          pinacd    VARCHAR(     8) CHARACTER SET NONE COLLATE NONE,
        permisos   SMALLINT     DEFAULT 0 NOT NULL,
         borrado   SMALLINT         DEFAULT 0 NOT NULL,

 PRIMARY KEY (idusuario),
 CHECK (sexo IN (0, 1)),
 CHECK (habilitado IN (0, 1)),
 CHECK (borrado IN (0, 1)),
 CHECK (esagente IN (0, 1)),
 CHECK (UPPER(login) NOT IN (SELECT UPPER(login) FROM tb_usuarios WHERE
idusuario <> NEW.idusuario AND borrado = 0))
);


Whats the error in this view? I don´t explain myself.

TIA