select error....in cluster

[SeungJun Lee]

Hi...

I have select error in my mysql cluster system...(ver. 5.0.12-beta)

My system is...

1 mgm node

2 sql node

4 data node

Error is..

When I run "select" in sql node,

first,
mysql> select b_index from tbl_myboard where myzean_code = '4' and category_code='27';
+---------+
| b_index |
+---------+
| 54 |
| 30 |
| 33 |
| 53 |
| 57 |
| 58 |
+---------+
6 rows in set (0.09 sec)

second,
mysql> select b_index from tbl_myboard where myzean_code = '4' and category_code='27';
+---------+
| b_index |
+---------+
| 53 |
| 57 |
| 58 |
+---------+
3 rows in set (0.09 sec)

third,
mysql> select b_index from tbl_myboard where myzean_code = '4' and category_code='27';
+---------+
| b_index |
+---------+
| 54 |
| 30 |
| 33 |
| 58 |
| 53 |
| 57 |
+---------+
6 rows in set (0.09 sec)

fourth,
mysql> select b_index from tbl_myboard where myzean_code = '4' and category_code='27';
+---------+
| b_index |
+---------+
| 58 |
+---------+
1 row in set (0.09 sec)

fifth,
mysql> select b_index from tbl_myboard where myzean_code = '4' and category_code='27';
+---------+
| b_index |
+---------+
| 54 |
| 30 |
| 33 |
| 58 |
| 53 |
| 57 |
+---------+
6 rows in set (0.09 sec)


correct result is...
mysql> select b_index from tbl_myboard where myzean_code = '4' and category_code='27';
+---------+
| b_index |
+---------+
| 54 |
| 30 |
| 33 |
| 58 |
| 53 |
| 57 |
+---------+
6 rows in set (0.09 sec)

How can I solve this problem...?

Have a nice day~~~



Edited 1 time(s). Last edit at 09/12/2005 08:03PM by SeungJun Lee.