MySQL Forums
Forum List  »  InnoDB

Re: rollback vs. left join problem ?
Posted by: Peter Blokland
Date: August 10, 2005 02:16AM

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...

Options: ReplyQuote


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
1932
August 10, 2005 06:45AM


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.