TYPO3 Core

When selecting Tools / DB check / Record Statistics (shouldn't that be 'Records' i.e. with an ending s?) I'm getting a bunch of

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/typo3_src-4.0/t3lib/class.t3lib_db.php on line 801

errors.

Enabling SQL debug, the ERROR shows as

Lost connection to MySQL server during query

The query is

SELECT uid,pid,title
FROM static_template
WHERE
pid NOT IN (-1,0)

Executing that query in the MySQL Query Browser, I'm also getting the 'Lost connection' message

Replacing (-1,0) with (0,0) or (0,1) the query completes without any errors.

Reading the SQL for the table creation, it seems the column 'pid' has been created as an unsigned int:

`pid` int(11) unsigned NOT NULL default '0',

Changing the column to a signed type:

ALTER TABLE static_template MODIFY pid int(11) NOT NULL default '0'

makes this error go away.

Now, which one is wrong: the query or the table column definition?

MySQL version 5.0.21

The Ubuntu 6.06 LAMP server has been configured from scratch - i.e. the database has never hosted typo3.

(issue imported from #M3661)