Hi, On Sat, Apr 14, 2001 at 11:53:52AM +0200, Filip Trojan wrote: > 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". > One of the rows in your dump is this: > 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,''); > Even though it is not equal to what you try to insert here: > 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=''; > You can see from the values in the error message that MySQL does try to insert the same values here: > ERROR 1062 at line 38: Duplicate entry '-2147483648-2147483647' for key 1 > The problem is that your values are outside the valid range for integers. MySQL converts them to the closest value that is allowed. In my opinion it should have given an error message. Anyway, look in the manual for other integer or floating point types to use. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands --------------------------------------------------------------------- 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
