Incorrect default value

[WenyXu]

What type of bug is this?

Unexpected error

What subsystems are affected?

Table Engine

Minimal reproduce step

1. Create a table

CREATE TABLE `ExcePTuRi`(
non TIMESTAMP(6) TIME INDEX,
`iUSTO` DOUBLE DEFAULT 0.047318541668048164
)
ENGINE=mito

2. Check the column default value

SELECT table_name,column_name,column_default FROM information_schema.columns WHERE table_name = 'ExcePTuRi'; 

What did you expect to see?

+------------+-------------+----------------------+
| table_name | column_name | column_default       |
+------------+-------------+----------------------+
| ExcePTuRi  | non         | NULL                 |
| ExcePTuRi  | iUSTO       | 0.047318541668048164 |
+------------+-------------+----------------------+

What did you see instead?

+------------+-------------+---------------------+
| table_name | column_name | column_default      |
+------------+-------------+---------------------+
| ExcePTuRi  | non         | NULL                |
| ExcePTuRi  | iUSTO       | 0.04731854166804816 |
+------------+-------------+---------------------+

What operating system did you use?

doesn't matter

What version of GreptimeDB did you use?

main

Relevant log output and stack trace

No response

[WenyXu]

See also: serde-rs/json#536