>Description: I have a table 'spoken_text' with a field 'start_time'. When I do an INSERT (from within 'mysql') with a fractional part in the seconds field, SOMETIMES this inserted values is corrupted.
>How-To-Repeat: tpdmmr% mysql -u vip -p vip Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43994 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> status -------------- mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.7 (sparc) Connection id: 43994 Current database: vip Current user: [EMAIL PROTECTED] Current pager: stdout Using outfile: '' Server version: 3.23.36 Protocol version: 10 Connection: dis.tpd.tno.nl via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 215 days 2 hours 27 min 47 sec Threads: 1 Questions: 3885677 Slow queries: 269 Opens: 534 Flush tables: 1 Open tables: 64 Queries per second avg: 0.209 -------------- mysql> desc spoken_text; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | reference | varchar(50) | | | | | | language | tinyint(3) unsigned | | | 1 | | | xml_text | text | YES | | NULL | | | start_time | time | YES | | NULL | | | end_time | time | YES | | NULL | | | archive | varchar(50) | | MUL | | | | asset_id | varchar(10) | | MUL | | | | segment_id | varchar(10) | | | | | | keyid | varchar(50) | | PRI | | | | time_stamp | timestamp(14) | YES | | NULL | | | classification | varchar(50) | YES | | NULL | | | title | varchar(255) | YES | | NULL | | | issue_date | datetime | YES | | NULL | | +----------------+---------------------+------+-----+---------+-------+ 13 rows in set (0.00 sec) mysql> INSERT INTO spoken_text (keyid, archive, asset_id, segment_id, reference, language, xml_text, start_time, end_time, classification) VALUES ('HWtest.16777602.ocr25','HWtest', '16777602','ocr25','16777602.ocr25','2','oud-CIA-di Wo', '00:11:25.159','00:00:3.68',''); mysql> SELECT segment_id,start_time FROM spoken_text WHERE keyid='HWtest.16777602.ocr25'; +------------+------------+ | segment_id | start_time | +------------+------------+ | ocr25 | 15:09:00 | +------------+------------+ 1 row in set (0.00 sec) >Fix: Insert with '00:11:25' only, no fractional part. >Submitter-Id: [EMAIL PROTECTED] >Originator: >Organization: Harry Wedemeijer TNO Institute of Applied Physics Phone : +31 15 2692274 P.O. Box 155 Fax : +31 15 2692111 2600 AD Delft Email : [EMAIL PROTECTED] The Netherlands > >MySQL support: none >Synopsis: Bug when inserting a time with fraction >Severity: serious >Priority: medium >Category: mysql >Class: >Release: mysql-3.23.33 (Official MySQL binary) >Environment: System: SunOS tpdmmr 5.7 Generic_106541-17 sun4u sparc SUNW,Ultra-2 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1707532 Oct 5 19:09 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 1 2001 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 5 19:09 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1707532 Oct 5 19:09 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 1 2001 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 Oct 5 19:09 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php