Produces a result of type REAL . This is actually FLOAT  if the REAL_AS_FLOAT  SQL mode is enabled; otherwise the result is of type DOUBLE . 

• SIGNED [INTEGER] 

Produces a signed integer value. 

• spatial_type 

As of MySQL 8.0.24, CAST()  and CONVERT()  support casting geometry values from one spatial type to another, for certain combinations of spatial types. The following list shows the permitted type 

