Non deterministic behavior of Mysql Cluster

[jannis breitwieser]

I ran the same query several times - everytime i got different results:

select source,count(*) as number from (select source, target from links limit 10000) as a,pages p1, pages p2 where a.source = p1.id and a.target=p2.id and p1.host_id != p2.host_id group by source;

1825 rows in set (8.61 sec)
1836 rows in set (8.37 sec)
1830 rows in set (8.46 sec)


Probably thats because the results of the fastest node(s) are used to compute the output.
However thats not what one would expect when using a database!