Klaus Berkling wrote:
> I am having an issue with a JOIN on two tables that are in a two node
> cluster.
>
> What happens is that the columns in the joined table are all null.
>
> students left outer join members on students.student_key =
> members.student_key
>
> I should get something like this:
>
> +----------------------+-----------------------+-------------------
> +---------------------+
> | students.student_key | students.student_name | members.class_key |
> members.student_key |
> +----------------------+-----------------------+-------------------
> +---------------------+
> | 5 | Grace | NULL |
> NULL |
> | 3 | Susie | NULL |
> NULL |
> | 1 | Bill | 3 |
> 1 |
> | 1 | Bill | 1 |
> 1 |
> | 4 | Jean | 3 |
> 4 |
> | 2 | John | 3 |
> 2 |
> | 2 | John | 2 |
> 2 |
> | 2 | John | 1 |
> 2 |
> +----------------------+-----------------------+-------------------
> +---------------------+
>
> But I get something like this:
> +----------------------+-----------------------+-------------------
> +---------------------+
> | students.student_key | students.student_name | members.class_key |
> members.student_key |
> +----------------------+-----------------------+-------------------
> +---------------------+
> | 5 | Grace | NULL |
> NULL |
> | 3 | Susie | NULL |
> NULL |
> | 1 | Bill | NULL |
> NULL |
> | 1 | Bill | NULL |
> NULL |
> | 4 | Jean | NULL |
> NULL |
> | 2 | John | NULL |
> NULL |
> | 2 | John | NULL |
> NULL |
> | 2 | John | NULL |
> NULL |
> +----------------------+-----------------------+-------------------
> +---------------------+
>
> These are not the real tables, the real tables are around 2000 rows
>
> I don't have this problem on a much smaller scale (see above) or in a
> InnoDB database with 2000 rows. I only see the issue with an ndb
> cluster with 2000 rows, both tables are in the cluster. The columns are
> set to NOT NULL. I am using mysql 4.1.7.
>
> Anyone seen this?
>
> Thanks
>
> kib
>
Hi,
My guess is that this is a bug.
Please file a bugreport with a reproducable test case, and I'm sure it
will be fixed quickly...
If you don't like to upload test data then you can make it available by
ftp, or mail it directly to me.
/Jonas
--
Jonas Oreland, Software Engineer
MySQL AB, www.mysql.com
