>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
