Dear MySQL experts In the following example I created simple table with two-column primary key ID,IDT. After some inserts there came insert with ID, IDT values, that are not equal to none of the previous couples, but MySQL still reported error "Duplicate entry". In the lines below there is source code that can by used to reproduce the problem. This example was run under local environment of Microsoft Windows 98 4.10.1998 on MySQL Ver 3.23.32 for Win95/Win98 on i32 with user privileges select, insert, update, delete, create, drop, alter and index. Please feel free to answer that this was my fault. I am just a beginner and it would be the best result. Otherwise it would be serios bug. Filip Trojan, Prague, Czech Republic # MySQL dump 8.12 # # Host: localhost Database: tourservis #-------------------------------------------------------- # Server version 3.23.32-log # # Table structure for table 'pobzajturnus' # CREATE TABLE pobzajturnus ( ID int(11) NOT NULL default '0', IDT int(11) NOT NULL default '0', DZAP datetime NOT NULL default '0000-00-00 00:00:00', DAKT datetime NOT NULL default '0000-00-00 00:00:00', DZAC datetime NOT NULL default '0000-00-00 00:00:00', DKON datetime NOT NULL default '0000-00-00 00:00:00', POCMIST smallint(6) default NULL, POCVOLN smallint(6) default NULL, DOPRAVA varchar(40) default NULL, VEDOUCI int(11) default NULL, POZN blob, PRIMARY KEY (ID,IDT) ) TYPE=MyISAM; # # Dumping data for table 'pobzajturnus' # INSERT INTO pobzajturnus VALUES (-2147483648,1544414423,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-09 00:00:00','2001-06-16 00:00:00',NULL,NULL,'vlastní nebo autobusovou linkou (není za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,44245749,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-16 00:00:00','2001-06-23 00:00:00',NULL,NULL,'vlastní nebo autobusovou linkou (není za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,2147483647,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-23 00:00:00','2001-06-30 00:00:00',NULL,NULL,'vlastní nebo autobusovou linkou (není za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,1338875697,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-30 00:00:00','2001-07-07 00:00:00',NULL,NULL,'vlastní nebo autobusovou linkou (není za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,1969892214,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-07-07 00:00:00','2001-07-14 00:00:00',NULL,NULL,'vlastní nebo autobusovou linkou (není za',0,''); insert into pobzajturnus set id=-2154422840, idt=4764690836, dzap=now(), dakt=now(), dzac='2001-07-14 00:00', dkon='2001-07-21 00:00', doprava='vlastní nebo autobusovou linkou (není zahrnuta v ceně)', vedouci='', pozn=''; ERROR 1062 at line 38: Duplicate entry '-2147483648-2147483647' for key 1
