Re: rollback vs. left join problem ?
something new :
in stead of restarting the server, this also works :
mysql> select * from a left join b on (a.id_a=b.id_a);
+------+--------+------+-------+
| id_a | text_a | id_a | int_b |
+------+--------+------+-------+
| 1 | text | NULL | NULL |
| 2 | text2 | NULL | NULL |
mysql> show create table b;
<output snipped>
mysql> select * from a left join b on (a.id_a=b.id_a);
+------+--------+------+-------+
| id_a | text_a | id_a | int_b |
+------+--------+------+-------+
| 1 | text | 1 | 1 |
| 2 | text2 | NULL | NULL |
is this a bug ? i couldn;t find anything like it on the bug-list...
Subject
Views
Written By
Posted
3084
August 09, 2005 04:33AM
Re: rollback vs. left join problem ?
1995
August 10, 2005 02:16AM
1976
August 10, 2005 05:25AM
1968
August 10, 2005 06:07AM
1932
August 10, 2005 06:45AM
1806
August 11, 2005 02:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.