Issue Bug Rejected

#16211DB-Check->Records Statistics uses -1 in query while pid is defined unsigned

Bernhard Fischer 06/02/06, 11:41 updated 11/22/11, 14:37

Description

The query to show the record statistics inside the DB check tool uses the value -1 in its query, but pid is defined as unsigned int. So it does not make sense.

As a consequence of this query, MySQL crashes and restarts on my machine. I’m using MySQL 5.0.2 with php 4.4.2. I didn’t check this behavior on other MySQL installations … maybe it’s a simple bug in MySQL 5.x … propably i have to recompile my libs!

snipped from the MySQL logfile:

thd->query at 0×8960e18 = SELECT uid,pid,title
FROM static_template
WHERE
pid NOT IN (-1,0,1,2)

(issue imported from #M3617)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.