MySQL Bugs: #13170: select error... (mysql cluster)

Bug #13170	select error... (mysql cluster)
Submitted:	14 Sep 2005 9:06	Modified:	14 Nov 2005 15:35
Reporter:	SeungJun Lee	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.0.12-beta	OS:	Linux (fedora core 2)
Assigned to:	Pekka Nousiainen	CPU Architecture:	Any

Description:
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...? 

How to repeat:
cluster restart(with ndb --initial) and restore(ndb_restore).

--table schema and data---(dump file, euckr)

CREATE TABLE `tbl_myboard` (
  `b_index` int(11) unsigned NOT NULL auto_increment,
  `myzean_code` int(11) unsigned NOT NULL default '0',
  `category_code` int(10) unsigned NOT NULL default '0',
  `b_gn` int(11) NOT NULL default '0',
  `b_thread` varchar(255) NOT NULL default '',
  `b_title` varchar(255) NOT NULL default '',
  `b_content` text NOT NULL,
  `user_reqno` int(11) unsigned default NULL,
  `user_id` varchar(12) NOT NULL default '',
  `myzean_nickname` varchar(50) NOT NULL default '',
  `b_hit` int(11) unsigned NOT NULL default '0',
  `b_regdt` datetime default NULL,
  `b_updt` datetime default NULL,
  `b_ip` varchar(30) NOT NULL default '',
  `b_comment_cnt` smallint(5) unsigned NOT NULL default '0',
  `write_id` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`b_index`),
  KEY `myzean_code_idx` (`myzean_code`),
  KEY `category_code_idx` (`category_code`)
) ENGINE=ndbcluster DEFAULT CHARSET=euckr AUTO_INCREMENT=62 ;

-- 
-- 테이블의 덤프 데이터 `tbl_myboard`
-- 

INSERT INTO `tbl_myboard` VALUES (60, 6, 32, 3, 'A', '<b>php</b>', '<?php ?>', 347595, 'ovclas', '체리필터', 0, '2005-09-12 14:20:53', NULL, '211.236.169.66', 0, '');
INSERT INTO `tbl_myboard` VALUES (41, 5, 24, 3, 'A', 'dd', 'dd', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:39:59', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (18, 1, 5, 7, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:01', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (53, 4, 27, 3, 'A', 'test', '또 테스트입니다..', 4, 'd8648', '동기', 0, '2005-09-07 16:58:23', NULL, '211.236.169.68', 0, '');
INSERT INTO `tbl_myboard` VALUES (57, 4, 27, 5, 'A', '바보얌', '바보 맞지롱', 4, 'd8648', '동기야', 0, '2005-09-12 11:23:09', NULL, '211.236.169.68', 0, '');
INSERT INTO `tbl_myboard` VALUES (15, 1, 5, 4, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:30:45', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (31, 1, 24, 16, 'A', 'dd', 'dd', 1, 'mingi', '민기', 0, '2005-07-07 14:08:17', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (34, 1, 24, 18, 'A', 'dd', 'dd', 1, 'mingi', '아휘', 0, '2005-07-07 15:02:00', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (36, 1, 24, 20, 'A', 'dd', 'dd', 1, 'mingi', '아휘', 0, '2005-07-07 16:14:48', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (17, 1, 5, 6, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:30:55', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (24, 1, 5, 13, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:37', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (19, 1, 5, 8, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:07', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (22, 1, 5, 11, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:25', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (39, 5, 24, 1, 'AA', '[Re]dd', '\r\nddd\r\n>dd', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:22:50', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (14, 1, 5, 3, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:30:40', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (44, 5, 24, 6, 'A', 'jlkj', 'kl', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:40:21', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (42, 5, 24, 4, 'A', 'gg', 'gg', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:40:05', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (58, 4, 27, 6, 'A', '바보얌', '<? php\r\n aaa()\r\n?>', 4, 'd8648', '동기야', 0, '2005-09-12 11:42:33', NULL, '211.236.169.68', 0, '');
INSERT INTO `tbl_myboard` VALUES (32, 1, 24, 17, 'A', 'dd', 'dd', 1, 'mingi', '민기', 0, '2005-07-07 14:13:13', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (21, 1, 5, 10, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:19', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (11, 1, 7, 1, 'A', 'test', 'testddddddd', 1, 'mingi', '민기', 0, '2005-06-20 12:05:14', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (56, 6, 32, 2, 'A', 'test21', 'test21', 347595, 'ovclas', '체리필터', 0, '2005-09-12 10:21:57', NULL, '211.236.169.66', 0, '');
INSERT INTO `tbl_myboard` VALUES (28, 1, 24, 15, 'A', 'ddd', 'ddd', 1, 'mingi', '아휘', 0, '2005-07-04 19:00:06', NULL, '218.145.148.30', 0, '');
INSERT INTO `tbl_myboard` VALUES (43, 5, 24, 5, 'A', 'hhh', 'hhh', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:40:11', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (26, 1, 5, 14, 'A', 'dd', 'dd', 1, 'mingi', '민기', 0, '2005-06-27 15:24:33', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (55, 6, 32, 1, 'A', 'test', 'zzzz\r\nㅋㅋㅋㅋ', 347595, 'ovclas', '체리필터', 0, '2005-09-09 14:12:40', NULL, '211.236.169.66', 0, '');
INSERT INTO `tbl_myboard` VALUES (16, 1, 5, 5, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:30:50', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (20, 1, 5, 9, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:13', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (23, 1, 5, 12, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:31:31', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (35, 1, 25, 19, 'A', 'dd', 'dd', 1, 'mingi', '아휘', 0, '2005-07-07 16:13:28', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (54, 4, 27, 4, 'A', '잘되시나욤', '잘되시나욤..\r\n아무 이상 없나요..', 4, 'd8648', '동기야', 0, '2005-09-08 17:48:48', NULL, '211.236.169.68', 0, '');
INSERT INTO `tbl_myboard` VALUES (61, 6, 32, 4, 'A', '글쓰기 테스트 ㅋㅋㅋ', '잘 되남?\r\n엔터..\r\n엔터..', 347595, 'ovclas', '체리필터', 0, '2005-09-12 14:29:03', NULL, '211.236.169.66', 0, '');
INSERT INTO `tbl_myboard` VALUES (30, 4, 27, 1, 'A', '에러가 나나요', '에러가 나는건가요...\r\n잘되어야 할텐데', 4, 'd8648', '민기', 0, '2005-07-06 13:52:42', NULL, '218.145.148.30', 0, '');
INSERT INTO `tbl_myboard` VALUES (33, 4, 27, 2, 'A', '테스트입니다', '테스트입니다', 4, 'd8648', '동기', 0, '2005-07-07 14:18:44', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (51, 5, 24, 6, 'AA', '[Re]jlkj', '\r\n\r\n\r\n>ahwi777님이 쓰신 글입니다.\r\n\r\n>kl', 5, 'ahwi777', '아휘', 0, '2005-08-11 19:05:22', NULL, '211.236.169.71', 0, '');
INSERT INTO `tbl_myboard` VALUES (59, 6, 32, 2, 'AA', '[Re]test21', '잘 되나? ㅋ\r\n\r\n\r\n>ovclas님이 쓰신 글입니다.\r\n\r\n>test21', 347595, 'ovclas', '체리필터', 0, '2005-09-12 13:42:41', NULL, '211.236.169.66', 0, '');
INSERT INTO `tbl_myboard` VALUES (13, 1, 5, 2, 'A', 'test입니다.', 'test입니다.', 1, 'mingi', '민기', 0, '2005-06-24 17:30:34', NULL, '218.145.148.49', 0, '');
INSERT INTO `tbl_myboard` VALUES (40, 5, 24, 2, 'A', 'dd', 'dd', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:39:50', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (45, 5, 24, 7, 'A', 'kkk', 'kkk', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:40:29', NULL, '61.74.150.19', 0, '');
INSERT INTO `tbl_myboard` VALUES (38, 5, 24, 1, 'A', 'dd', 'dd', 5, 'ahwi777', '아휘', 0, '2005-07-07 16:22:31', NULL, '61.74.150.19', 0, '');

Can't reproduce in current (pre 5.0.14) on debian linux.

Please attach the SQL as a _file_.  The HTML does not give
exactly same data values.

Yes...
This attatch file is dump(sql) file.

Thank you your kindness.

still cannot repeat (5.0, 5.1, debian linux)