[#MDEV-8852] Implicit or explicit CAST from MAX(string) to INT,DOUBLE,DECIMAL does not produce warnings

[MDEV-8852] Implicit or explicit CAST from MAX(string) to INT,DOUBLE,DECIMAL does not produce warnings Created: 2015-09-26 Updated: 2015-09-28 Resolved: 2015-09-28
Status:	Closed
Project:	MariaDB Server
Component/s:	OTHER
Affects Version/s:	5.5, 10.0, 10.1
Fix Version/s:	10.1.8

Type:

Bug

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

Labels:

None

Issue Links:

Relates
relates to	~~MDEV-8806~~	Numeric CAST produce different warnin...	Closed

Sprint:

10.1.8-3

Description

This SQL script:

SELECT 'x' << 1, CAST('x' AS DOUBLE), CAST('x' AS DECIMAL);

SHOW WARNINGS;

returns the following warnings:

+---------+------+----------------------------------------+

| Level   | Code | Message                                |

+---------+------+----------------------------------------+

| Warning | 1292 | Truncated incorrect INTEGER value: 'x' |

| Warning | 1292 | Truncated incorrect DOUBLE value: 'x'  |

| Warning | 1292 | Truncated incorrect DECIMAL value: 'x' |

+---------+------+----------------------------------------+

Now if I use MAX:

SELECT MAX('x') << 1, CAST(MAX('x') AS DOUBLE), CAST(MAX('x') AS DECIMAL);

it returns no warnings.

Generated at Thu Feb 08 07:30:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.