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:
None 
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 
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 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.