Bug #105822 Non-standard datatype instead of biult-in is used in Reference Manual
Submitted: 7 Dec 2021 11:03 Modified: 7 Dec 2021 17:15
Reporter: Владислав Сокол Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[7 Dec 2021 11:03] Владислав Сокол
The article "MySQL 8.0 Reference Manual / Functions and Operators / Type Conversion in Expression Evaluation" https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html contains the next words:

In all other cases, the arguments are compared as floating-point (real) numbers. For example, a comparison of string and numeric operands takes place as a comparison of floating-point numbers.

But there are only 2 built-in floating-point datatypes - FLOAT and DOUBLE. And "11.1.4 Floating-Point Types (Approximate Value) - FLOAT, DOUBLE" https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html claims that REAL is non-standard syntax.

I think that "In all other cases, the arguments are compared as floating-point (DOUBLE PRECISION) numbers." is more correct.

How to repeat:
not needed
[7 Dec 2021 13:46] MySQL Verification Team
Hi Mr.  Сокол,

Thank you for your bug report.

This is, indeed, a slightly imprecise definition in our Server Documentation.

Verified as reported.
[7 Dec 2021 17:15] Jon Stephens
Fixed in the 5.6, 5.7, 8.0 versions of the Manual, in mysqldoc rev 71418.

[8 Dec 2021 13:23] MySQL Verification Team
Thank you, Jon.