Bug #13817 ERROR_FOR_DIVISION_BY_ZERO handling and documentation inconsistent
| Submitted: | 6 Oct 2005 20:00 | Modified: | 24 Jan 2014 15:46 |
|---|---|---|---|
| Reporter: | Kristian Koehntopp | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.0.13 | OS: | Linux (Suse Linux 9.3) |
| Assigned to: | Paul DuBois | CPU Architecture: | Any |
[6 Oct 2005 20:00]
Kristian Koehntopp
[20 Oct 2005 19:18]
Paul DuBois
Further information: The test case does not qualify for the conditions described in the manual. SELECT 1/0 is not an INSERT or UPDATE, and it doesn't involve table data. So the documentation does not "promise" an error in this case. However, after further investigation, we also do not throw an error for either of the following cases when col_name is 0, and both cases *do* involve table data: SELECT 1/col_name FROM t; SELECT * FROM t WHERE 1/col_name; So the manual was indeed not correct. I'll amend it to delete "or in any expression (for example, in a select list or WHERE clause) that involves table data and a division by zero." See also Bug#8423, Bug#6105.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 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.