Create table statement:
create TABLE test_schema.floatTable (floatColumn FLOAT(10));

Insert data:
insert into test_schema.floatTable VALUES(1.234);

CDC message:
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"double","optional":true,"field":"floatColumn"}],"optional":true,"name":"dbserver02.test_schema.floatTable.Value","field":"before"},{"type":"struct","fields":[{"type":"double","optional":true,"field":"floatColumn"}],"optional":true,"name":"dbserver02.test_schema.floatTable.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"version"},{"type":"string","optional":false,"field":"connector"},{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"ts_ms"},{"type":"string","optional":true,"name":"io.debezium.data.Enum","version":1,"parameters":{"allowed":"true,last,false"},"default":"false","field":"snapshot"},{"type":"string","optional":false,"field":"db"},{"type":"string","optional":true,"field":"table"},{"type":"int64","optional":false,"field":"server_id"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"int64","optional":true,"field":"thread"},{"type":"string","optional":true,"field":"query"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"id"},{"type":"int64","optional":false,"field":"total_order"},{"type":"int64","optional":false,"field":"data_collection_order"}],"optional":true,"field":"transaction"}],"optional":false,"name":"dbserver02.test_schema.floatTable.Envelope"},"payload":{"before":null,"after":{"floatColumn":1.2339999675750732},"source":{"version":"1.4.0.Final","connector":"mysql","name":"dbserver02","ts_ms":1619437010000,"snapshot":"false","db":"test_schema","table":"floatTable","server_id":1,"gtid":null,"file":"binlog.000008","pos":1236258,"row":0,"thread":10529,"query":null},"op":"c","ts_ms":1619437010398,"transaction":null}}