Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26-u2.html
CAST() of FLOAT and DOUBLE values to DECIMAL (Bug #33163625, Bug #33138534, WL #14714) The new hw_data_scanned global status variable tracks the total cumulative megabytes scanned by successfully executed MySQL HeatWave queries. Functionality Added ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
(WL #14608) Functionality Added or Changed DATE_ADD() and DATE_SUB() functions now support precision INTERVAL values (DECIMAL, DOUBLE, and FLOAT). Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-2-0.html
(WL #15637) MySQL HeatWave now enables the internal conversion of values from one data type to another, including all combinations of these different encodings: Numeric values INTEGER, FLOAT, and DECIMAL. Functionality Added or Changed MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). This section describes aggregate functions that operate on sets of values.
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/choosing-types.html
This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
Columns using BLOB, TEXT, SET, ENUM, BIT, or spatial data types are not permitted; columns that use floating-point number types are also not permitted. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
When unix_timestamp is a floating point number, the fractional seconds precision of the datetime is 6. This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a ...