Bug #8256 checksum table random_name, does not return error

• Submitted: 2 Feb 2005 10:11
• Modified: 9 Mar 2005 3:58
• Reporter: Martin Friebe (Gold Quality Contributor) (SCA)
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 4.1.9
• OS: FreeBSD (freebsd 4)
• Assigned to: Jim Winstead

[2 Feb 2005 10:11] Martin Friebe

Description:
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 1: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 3:58] Paul DuBois

Noted in CHECKSUM TABLE and 5.0.3 changelog.