Re: [HACKERS] SELECT BUG

Sorry for the confusion:

Here an example...

create table master(mcode char(11), mcode1 char(16));
create table detail(dcode char(16));
insert into master values ('a','a');
insert into master values ('a1','a1');
insert into master values ('a13','a13');
insert into detail values ('a13');
insert into detail values ('a1');
insert into detail values ('a13');

--in the following example mcode is long 11 and mcode1 is long 16
--but mcode=mcode1 is true:

select * from master where mcode=mcode1;
mcode |mcode1
-----------+----------------
a |a
a1 |a1
a13 |a13
(3 rows)

--in the following example mcode is long 11 and dcode1 is long 16
--but mcode=dcode1 is false:

select mcode, dcode from master m, detail d where mcode=dcode;
mcode|dcode
-----+-----
(0 rows)

the same example in informix-SE gives me this:
----------------------------------------------
code code

a1 a1
a13 a13

José