Package: mysql-server
Version: 4.0.24-10
Severity: minor
When inserting a bad time format, eg 24:00 or 24:30, into MySQL the
server happily accepts the bad data "Query OK, 1 row affected", and then
turns the data into garbage "0000-00-00 00:00:00".
I would prefer that it would reject the insert or update with an error
about the value being invalid. Then problems in input data may be caught
sooner.
create table tbl (
-> dt datetime
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> insert into tbl values ('2005-06-03 24:00:00');
Query OK, 1 row affected (0.00 sec)
mysql> select * from tbl;
+---------------------+
| dt |
+---------------------+
| 0000-00-00 00:00:00 |
+---------------------+
1 row in set (0.00 sec)
PostgreSQL says:
ERROR: Bad timestamp external representation '2005-06-03 24:00:00'
--
Jacob Anawalt
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-686
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages mysql-server depends on:
ii adduser 3.63 Add and remove users and groups
ii debconf 1.4.30.13 Debian configuration management sy
ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libgcc1 1:3.4.3-13 GCC support library
ii libmysqlclient12 4.0.24-10 mysql database client library
ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra
ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii mysql-client 4.0.24-10 mysql database client binaries
ii mysql-common 4.0.24-10 mysql database common files (e.g.
ii passwd 1:4.0.3-31sarge5 change and administer password and
ii perl 5.8.4-8 Larry Wall's Practical Extraction
ii psmisc 21.5-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.2-4 compression library - runtime
-- debconf information:
mysql-server/nis_warning:
mysql-server/really_downgrade_from_41: false
mysql-server/mysql_update_hints1:
* mysql-server/start_on_boot: true
mysql-server/postrm_remove_databases: false
* mysql-server/mysql_install_db_notes:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
