[firebase-br] bug?

[Carlos H. Cantu (TeamFB)]

Vc já testou com o RC2?

[]s
Cantu (Membro do TeamFB - FireBase)
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br

MF> --------------------------------
MF> -- FB Version: Firebird 2.0 RC1
MF> -- OS: Windows 2000 SP4
MF> -- Tool: IB Expert 2005.09.25
MF> --------------------------------

MF> ------------------------------------
MF> SET SQL DIALECT 3;
MF> SET NAMES ISO8859_1;
MF> CREATE DATABASE 'C:\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey' 
MF> PAGE_SIZE 8192 DEFAULT CHARACTER SET ISO8859_1;

MF> ------------------------------------
MF> CREATE TABLE A (
MF>      CODA  INTEGER NOT NULL,
MF>      DES   VARCHAR(80) CHARACTER SET ISO8859_1
MF> );

MF> CREATE TABLE B (
MF>      CODB  INTEGER NOT NULL,
MF>      CODA  INTEGER,
MF>      DES   VARCHAR(80) CHARACTER SET ISO8859_1
MF> );

MF> INSERT INTO A (CODA, DES) VALUES (1, '1');
MF> INSERT INTO A (CODA, DES) VALUES (2, '2');
MF> INSERT INTO A (CODA, DES) VALUES (3, '3');
MF> INSERT INTO A (CODA, DES) VALUES (4, '4');
MF> INSERT INTO A (CODA, DES) VALUES (5, '5');
MF> INSERT INTO A (CODA, DES) VALUES (6, '6');
MF> INSERT INTO A (CODA, DES) VALUES (7, '7');
MF> INSERT INTO A (CODA, DES) VALUES (8, '8');
MF> INSERT INTO A (CODA, DES) VALUES (9, '9');
MF> COMMIT WORK;

MF> INSERT INTO B (CODB, CODA, DES) VALUES (1, 9, '1 - 9');
MF> COMMIT WORK;

MF> ------------------------------------
MF> ALTER TABLE A ADD PRIMARY KEY (CODA);
MF> ALTER TABLE B ADD PRIMARY KEY (CODB);

MF> ------------------------------------
MF> ALTER TABLE B ADD CONSTRAINT FK_A FOREIGN KEY (CODA) REFERENCES A (CODA);

MF> ------------------------------------
MF> -- Resulta uma linha (resultado certo!)
MF> ------------------------------------
MF> SELECT * FROM A
MF> WHERE
MF> A.CODA = ALL(SELECT 9 FROM B);

MF> ------------------------------------
MF> -- Resulta mais de uma linha (resultado errado!)
MF> ------------------------------------
MF> SELECT * FROM A
MF> WHERE
MF> A.CODA = ALL(SELECT CODA FROM B);

MF> ------------------------------------
MF> -- O resultado das duas sub-consultas são iguais
MF> ------------------------------------
MF> SELECT 9 FROM B;
MF> SELECT CODA FROM B;


MF> ______________________________________________
MF> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
MF> Para editar sua configuração na lista, use o endereço
MF> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
MF> Para consultar mensagens antigas: http://firebase.com.br/pesquisa