sql - MemSQL - How to cast integer/decimal values to Float in MemSQL? -

i tried convert integer/decimal values float returns syntax error.i used following sample query.

select cast(order_quantity float) t demo limit 10

it returned following error.

error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'float) demo limit 10' @ line 1

so there way cast float in memsql?

thank in advance.

casts float not supported memsql. supported casts listed here:

cast (input {binary | char | date | datetime[(prec)] | decimal[(prec [, scale])] | time[(prec)] | signed [integer] | unsigned [integer]})

will decimal cast work?

MOno