Re: [HACKERS] SELECT BUG
| От | José Soares |
|---|---|
| Тема | Re: [HACKERS] SELECT BUG |
| Дата | |
| Msg-id | 37CFBF06.F6DACB81@sferacarta.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] SELECT BUG (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: [HACKERS] SELECT BUG
|
| Список | pgsql-hackers |
<tt>And now the other SELECT bug in the same data:</tt><tt></tt><p><tt>select master1.*, detail1.*</tt><br /><tt>from master1m, detail1 d</tt><br /><tt>where trim(m.code)=trim(d.code);</tt><tt></tt><p><tt>(I know there's an error in this syntax,but I don't know why PostgreSQL</tt><br /><tt>finds it good and execute a strange query)</tt><tt></tt><p><tt>code |code1 |code</tt><br /><tt>-----------+----------------+----------------</tt><br/><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br /><tt>a |a |a1</tt><br /><tt>a1 |a1 |a1</tt><br /><tt>a13 |a13 |a1</tt><br /><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br /><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br/><tt>a13 |a13 |a13</tt><br /><tt>a |a |a1</tt><br /><tt>a1 |a1 |a1</tt><br /><tt>a13 |a13 |a1</tt><br /><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br/><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br /><tt>a |a |a1</tt><br /><tt>a1 |a1 |a1</tt><br /><tt>a13 |a13 |a1</tt><br /><tt>a |a |a13</tt><br/><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br /><tt>(27 rows)</tt><p>Anyidea ? <p>José <br />
В списке pgsql-hackers по дате отправления: