Horton

Re: [HACKERS] SELECT BUG

Jose Soares <jose@sferacarta.com>

View thread
From: José Soares <jose@sferacarta.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>, hackers <pgsql-hackers@postgresql.org>
Date: 1999-09-03T12:28:54Z
Lists: pgsql-hackers 
And now the other SELECT bug in the same data:

select master1.*, detail1.*
from master1 m, detail1 d
where trim(m.code)=trim(d.code);

(I know there's an error in this syntax, but I don't know why PostgreSQL
finds it good and execute a strange query)

code       |code1           |code
-----------+----------------+----------------
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a1
a1         |a1              |a1
a13        |a13             |a1
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a1
a1         |a1              |a1
a13        |a13             |a1
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a1
a1         |a1              |a1
a13        |a13             |a1
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
(27 rows)

Any idea ?

José