[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:3652

From: "MINOHATA Norio" <"MINOHATA Norio" <minohata@xxxxxxxxxx>>
Date: Tue, 22 May 2001 17:55:17 +0900
Subject: [mysql 03652] Re: ÉâÆ°¾®¿ô¤¬¥Ç¥¿¥é¥á¤Ê¿ôÃͤ˲½¤±¤Æ½ÐÎϤµ¤ì¤ë¥Ð¥°

> ¶ñÂÎŪ¤ÊºÆ¸½¼ê½ç¤Ï¡¢Ä󼨤Ǥ­¤Þ¤¹¤«¡©
> ¡ô ɽ·Á¼°¡¢¥Ç¡¼¥¿¡¢¥¢¥¯¥»¥¹ÊýË¡

¤µ¤Ã¤½¤¯ºî¤Ã¤Æ¤ß¤Þ¤·¤¿¡£
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

[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

      3636 2001-05-17 11:05 ["MINOHATA Norio" <mi] ÉâÆ°¾®¿ô¤¬¥Ç¥¿¥é¥á¤Ê¿ôÃͤ˲½¤±¤Æ½ÐÎϤµ¤ì¤ë¥Ð¥°
      3646 2001-05-21 20:45 ¨±["MINOHATA Norio" <mi]                                       
      3650 2001-05-22 15:21 ¡¡¨²[Akihiko Shinohara <s]                                     
->    3652 2001-05-22 17:55 ¡¡¨­¨±["MINOHATA Norio" <mi]                                   
      3654 2001-05-23 03:11 ¡¡¨±[tateyan <tateyan@xxx]                                     
      3658 2001-05-23 11:10 ¡¡¡¡¨±[Yasuhide OMORI / Âç¿]