[MDEV-7295] cast($expression as float) should work Created: 2014-12-09  Updated: 2019-04-17  Resolved: 2019-04-17

Status: Closed
Project: MariaDB Server
Component/s: Data types
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Martin Häcker Assignee: Unassigned
Resolution: Duplicate Votes: 1
Labels: upstream

Issue Links:
Duplicate
duplicates MDEV-16872 Add CAST(expr AS FLOAT) Closed

 Description   

I've just stumbled again about mariadbs inability to cast stuff to float. Decimal is supported, but float is not (while it is available as a type).

To me that is an inconsistency that should be avoided - therefore casting to float should be allowed.



 Comments   
Comment by Elena Stepanova [ 2014-12-09 ]

That's how it is in the upstream MySQL:
http://dev.mysql.com/doc/refman/5.7/en/cast-functions.html#function_cast

Comment by Martin Häcker [ 2014-12-10 ]

Very true - and that should change. It's quite annoying.

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