Package: mysql-server-4.1
Version: 4.1.13a-3
Severity: normal
The following SQL fails on mysql-server 4.1.13a-3 with
ERROR 1062 (23000) at line 28: Duplicate entry 'J/JO/JONO/cpan.html' for
key 1
Needless to say that this worked in 3.x and 4.0 as the column is
declared binary which means that case makes a difference. Here is the
SQL:
-- MySQL dump 9.11
--
-- Host: localhost Database: mod
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-10-log
--
-- Table structure for table `applymod`
--
--
-- Table structure for table `distmtimes`
--
DROP TABLE IF EXISTS distmtimes;
CREATE TABLE distmtimes (
dist char(128) binary NOT NULL default '',
distmtime char(10) default NULL,
distmdatetime datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (dist)
) TYPE=ISAM PACK_KEYS=1;
--
-- Dumping data for table `distmtimes`
--
INSERT INTO distmtimes VALUES ('J/JO/JONO/CPAN.html','966270168','2000-08-14
18:22:48');
INSERT INTO distmtimes VALUES ('J/JO/JONO/cpan.html','1004130109','2001-10-26
23:01:49');
I hope this helps to find the bug. Thanks & Regards,
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (990, 'unstable'), (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages mysql-server-4.1 depends on:
ii adduser 3.67 Add and remove users and groups
ii debconf 1.4.58 Debian configuration management sy
ii libc6 2.3.5-6 GNU C Library: Shared libraries an
ii libdbi-perl 1.48-1 Perl5 database interface by Tim Bu
ii libgcc1 1:4.0.1-6 GCC support library
ii libmysqlclient14 4.1.13a-3 mysql database client library
ii libncurses5 5.4-9 Shared libraries for terminal hand
ii libreadline4 4.3-15 GNU readline and history libraries
ii libstdc++6 4.0.1-6 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.20050715cvs-1 A simple mail user agent
ii mysql-client-4.1 4.1.13a-3 mysql database client binaries
ii mysql-common 5.0.11beta-3 mysql database common files (e.g.
ii passwd 1:4.0.3-39 change and administer password and
ii perl 5.8.7-4 Larry Wall's Practical Extraction
ii psmisc 21.6-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.3-4 compression library - runtime
mysql-server-4.1 recommends no packages.
-- debconf information:
mysql-server-4.1/start_on_boot: true
mysql-server-4.1/postrm_remove_databases: false
mysql-server-4.1/really_downgrade: false
mysql-server-4.1/nis_warning:
* mysql-server-4.1/mysql_install_db_notes:
mysql-server-4.1/mysql_update_hints1:
--
andreas
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
