mysql:3652

> 填蟲讀卅瘋蜇澎賜反﹜羼憎匹五引允井〝
> ↑ 刓溥摯﹜犯□正﹜失弁本旦杅芊

今勻公仁綜勻化心引仄凶﹝
http://www.ipc.co.jp/tmp/freebsd_mysql_float_bug/test/
卞瘋蜇迕及旦弁伉皿玄毛3勾譆中化中引允﹝
perl5及旦弁伉皿玄匹﹜DBI乒斥亙□伙匹mysql卞失弁本旦仄引允﹝
http://www.ipc.co.jp/tmp/freebsd_mysql_float_bug/test.tgz
井日引午戶化母它件伕□玉仄化仁分今中﹝

[瘋蜇澎賜]
旦弁伉皿玄反拑忡據匹允﹝
午中丹井劑卅仁午手颱及FreeBSD棕雁匹反肣陴匹允﹝
撢墊仄凶瑛絆及毚エ反扙中引六氏﹝(ゴ及啃)
備旦弁伉皿玄及庍醒毛棕雁卞寧歹六化贗給庍凳仄化井日撢墊仄化仁分今中﹝

(1)賞ɛ
make_table.pl毛撢墊仄引允﹝
# test犯□正矛□旦卞dummy午中丹氾□皮伙毛綜勻化﹜
# 公及醱卞母立□伊戊□玉毛10坳瘀綜嶽仄引允﹝

(2)MySQL互侹切月仇午及割カ
check_table.pl毛醒皿伕本旦⑺凜撢墊仄化仁分今中﹝
> ./check_table.pl &
> ./check_table.pl &
...
颱及棕雁匹反﹜(2)匹2,3皿伕本旦雖日六月午允什卞MySQL互
侹切化仄引中引允及匹﹜醒襖祭仃及氾旦玄迕及旦弁伉皿玄毛
帎籣迕啦仄引仄凶﹝(3)尺

(3)醒襖互祭仃月仇午及割カ
check_table_slow.pl毛2皿伕本旦幻升田永弁弘仿件玉匹
撢墊今六化中月橇謫匹﹜
   select * from test.dummy into outfile '/tmp/test1.txt';
   select * from test.dummy into outfile '/tmp/test2.txt';
仄化井日﹜
   diff test1.txt test2.txt
匹犒坌毛潸月午域譙仄卅中墊互中仁勾井請化五引允﹝
# check_table_slow.pl 反1卍仍午卞SELECT毛撢墊仄引允及匹﹜
# select ... into outfile 互1卍動〇匹蔽歹月方丹卅棕雁分午
# ＞域譙仄卅中＝唱橘反�戲仄卅中井手仄木引六氏﹝

動曉及方丹卅普元匹﹜午曰丐尹內它民及﹜
’FreeBSD4.1 or 4.2
’MySQL3.23.37 or 38
’ configure --prefix=/usr/local/mysql --with-charset=ujis
卅棕雁匹反唱橘互�戲仄引允﹝


--
怬�霾襠
minohata@xxxxxxxxxx