Alex Yemelyanov (alex@otdyh.kz) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Duplicate values in field with type primary key.
Long Description
There is a table, which keeps the last user's message on irc:
create table otdyh_last(
nick varchar(100)primary key,
message varchar(200),
end_time integer
);
While user enters on channel, two queries is executed:
1. delete from otdyh_last where nick = 'some_nick'
2. insert into otdyh_last values('some_nick','',time_of_join)
Somehow there is 33 unique values in the table in the field nick(text of value 'Nurlan'), I noticed this when trying to
makevacuum.
I do not use transactions(mode Autocommit in DBI).
Contact me on email please and I'll send all the necessary.
Sample Code
No file was uploaded with this report