[#MDEV-16872] Add CAST(expr AS FLOAT)

[MDEV-16872] Add CAST(expr AS FLOAT) Created: 2018-08-01 Updated: 2019-05-16 Resolved: 2019-05-16
Status:	Closed
Project:	MariaDB Server
Component/s:	Data types
Fix Version/s:	10.4.5

Type:

Task

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

Labels:

upstream

Issue Links:

Blocks
blocks	~~MDEV-16248~~	Row based replication to spider with ...	Closed
is blocked by	~~MDEV-19468~~	Hybrid type expressions return wrong ...	Closed
Duplicate
is duplicated by	~~MDEV-7295~~	cast($expression as float) should work	Closed
Relates
relates to	MDEV-16873	Compare two FLOAT expressions as floa...	Open

Description

As of version 10.4, MariaDB has CAST(expr AS DOUBLE), but does not have CAST(expr AS FLOAT) yet.

We'll implement CAST(expr AS FLOAT) under terms of this MDEV.

This query:

SELECT CAST(expr AS FLOAT) AS f1 ... ;

will create a column of the FLOAT data type.

Generated at Thu Feb 08 08:32:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.