Thread

Re: [HACKERS] SELECT BUG

Jose Soares <jose@sferacarta.com> — 1999-09-02T16:47:41Z

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é