Re: bug - multiple column primary key cannot correctly determine duplicate entry

2001-04-14 Thread René Tegel
the 'integers' you insert as key are too big to fit in the size of a integer. mysql replaces such a big or small integer by the biggest or smallest value possible. if you look closely at your query, you see that the key returned by mysql are not the same values as you inserted. you have to: or cha

Re: bug - multiple column primary key cannot correctly determine duplicate entry

2001-04-14 Thread Fred van Engen
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