Bug #8484 Traditional: STRICT_TRANS_TABLES and STRICT_ALL_TABLES don't work
| Submitted: | 13 Feb 2005 0:24 | Modified: | 14 Mar 2005 15:15 |
|---|---|---|---|
| Reporter: | Trudy Pelzer | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.3-alpha-debug | OS: | Linux (SuSE 9.1) |
| Assigned to: | Ramil Kalimullin | CPU Architecture: | Any |
[13 Feb 2005 0:24]
Trudy Pelzer
[13 Feb 2005 2:16]
MySQL Verification Team
Thank you for the bug report.
[14 Mar 2005 12:38]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/22995
[14 Mar 2005 15:15]
Sergei Golubchik
I don't think it's a bug.
The manual says that in the strict mode "Invalid data values are rejected."
But unless ERROR_FOR_DIVISION_BY_ZERO mode is used
5/0 is not an invalid value - it's NULL. The manual specifies:
`ERROR_FOR_DIVISION_BY_ZERO'
Produce an error in strict mode (otherwise a warning) when we
encounter a division by zero (or `MOD(X,0)') during an `INSERT'/
`UPDATE'. If this mode is not given, MySQL instead returns `NULL'
for divisions by zero.
To summarize: STRICT mode defines whether invalid data should be rejected or auto-converted. ERROR_FOR_DIVISION_BY_ZERO specifies whether 5/0 is invalid data or not.
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.