Re: [HACKERS] SELECT BUG - Mailing list pgsql-hackers

From José Soares
Subject Re: [HACKERS] SELECT BUG
Date
Msg-id 37CEAA2D.9DA0FAD5@sferacarta.com
Whole thread Raw
In response to Re: [HACKERS] SELECT BUG  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] SELECT BUG
List pgsql-hackers
<tt>Sorry for the confusion:</tt><tt></tt><p><tt>Here an example...</tt><tt></tt><p><tt>create table master(mcode
char(11),mcode1 char(16));</tt><br /><tt>create table detail(dcode char(16));</tt><br /><tt>insert into master values
('a','a');</tt><br/><tt>insert into master values ('a1','a1');</tt><br /><tt>insert into master values
('a13','a13');</tt><br/><tt>insert into detail values ('a13');</tt><br /><tt>insert into detail values ('a1');</tt><br
/><tt>insertinto detail values ('a13');</tt><tt></tt><p><tt>--in the following example mcode is long 11 and mcode1 is
long16</tt><br /><tt>--but mcode=mcode1 is true:</tt><tt></tt><p><tt>select  * from master where mcode=mcode1;</tt><br
/><tt>mcode     |mcode1</tt><br /><tt>-----------+----------------</tt><br /><tt>a          |a</tt><br /><tt>a1        
|a1</tt><br/><tt>a13        |a13</tt><br /><tt>(3 rows)</tt><tt></tt><p><tt>--in the following example mcode is long 11
anddcode1 is long 16</tt><br /><tt>--but mcode=dcode1 is false:</tt><tt></tt><p><tt>select  mcode, dcode from master m,
detaild where mcode=dcode;</tt><br /><tt>mcode|dcode</tt><br /><tt>-----+-----</tt><br /><tt>(0 rows)</tt><br
/><tt></tt> <tt></tt><p><tt>thesame example in informix-SE gives me this:</tt><br
/><tt>----------------------------------------------</tt><br/><tt>code code</tt><tt></tt><p><tt>a1   a1</tt><br
/><tt>a13 a13</tt><br /><tt></tt> <tt></tt><p><tt>José</tt> 

pgsql-hackers by date:

Previous
From: "Ricardo Coelho"
Date:
Subject: Re: [HACKERS] Odd problem with pg_class ...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] SELECT BUG