В сообщении от 10 ноября 2006 13:44 Олег Петрачёв написал(a):
> I am using mysql 4.1.21 under FreeBSD rel 6.1-p10 > Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.1 (i386) using 5.0 > I noticed Mysql sometimes shows data from columns with DOUBLE type > incorrectly, cutting away the last (right) symbol. Even worse. Five selects right after database creation returned different results: mysql> select * from b; +-------+ | d | +-------+ | 1 | | 0.0 | | 0.00 | | 0.000 | | | +-------+ 5 rows in set (0.49 sec) mysql> select * from b; +----------------+ | d | +----------------+ | 1 | | 0.1 | | 0.01 | | 0.001 | | 0.0007HHKHMLNL | +----------------+ 5 rows in set (0.84 sec) mysql> select * from b; +-------------+ | d | +-------------+ | 1 | | 0.1 | | 0.01 | | 0.001 | | 0.000JKHHGK | +-------------+ 5 rows in set (0.00 sec) mysql> select * from b; +----------------+ | d | +----------------+ | 1 | | 0.1 | | 0.01 | | 0.001 | | 0.0007HHKHMLNL | +----------------+ 5 rows in set (0.38 sec) mysql> select * from b; +-------------+ | d | +-------------+ | 1 | | 0.1 | | 0.01 | | 0.001 | | 0.000JKHHGK | +-------------+ 5 rows in set (0.01 sec) -- Петрачёв Олег Отдел виртуального хостинга PeterHost.ru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]