MySQL Bugs: #105822: Non-standard datatype instead of biult-in is used in Reference Manual

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:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
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

Hi Mr.  Сокол,

Thank you for your bug report.

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

Verified as reported.

Fixed in the 5.6, 5.7, 8.0 versions of the Manual, in mysqldoc rev 71418.

Closed.

Thank you, Jon.