hi all
i use mysql-3.23.32
my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like
insert into Table
values('9231852172526977164',0,0,52056,0,0,0,0,0,52056,0,0,0,0,0,0,0,11,0,'184000','184000',1),'9231898557453533324',0,0,5532,0,0,0,0,0,5532,0,0,0,0,0,0,0,11,0,'184000','184000',1),'9230422383529723532',147,0,0,0,0,0,0,0,147,0,0,0,0,0,0,0,91,0,'184000','184000',1)
query failed
Duplicate entry '9231898557453533324' for key 1
but actually if i select * from Table where a='9231898557453533324'
it can't find anything.........what's wrong with this, bug?
p.s. unsigned Bigint should be from 0 to 18446744073709551615, so
'9231898557453533324' is included in it, right?
regards
Allen