Bug #8256 checksum table random_name, does not return error
Submitted: 2 Feb 2005 9:11 Modified: 9 Mar 2005 2:58
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.9 OS:FreeBSD (freebsd 4)
Assigned to: Jim Winstead CPU Architecture:Any

[2 Feb 2005 9:11] Martin Friebe
checksum table does not check for table existence. it returns a NULL checksum for non existent tables

How to repeat:
checksum table `I_dont_exist`;
#returns result, instead of error

#same for random database
checksum table no_such_db.xxx;

Suggested fix:
check for table existence, and return error
[9 Mar 2005 0:45] Jim Winstead
A warning is generated for this in MySQL 5.0. That NULL is returned for non-existent tables should be added to the documentation.
[9 Mar 2005 2:58] Paul DuBois
Noted in CHECKSUM TABLE and 5.0.3 changelog.