List:Cluster« Previous MessageNext Message »
From:Jonas Oreland Date:January 20 2005 4:12pm
Subject:Re: JOIN with a ndbcluster engine
View as plain text  
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
Thread
JOIN with a ndbcluster engineKlaus Berkling20 Jan
  • Re: JOIN with a ndbcluster engineJonas Oreland20 Jan
  • Re: JOIN with a ndbcluster engineJohan Andersson20 Jan
    • Re: JOIN with a ndbcluster engineKlaus Berkling26 Jan