Re: rollback vs. left join problem ?

[Peter Blokland]

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