Having upgraded to 6.4.12, I have followed the instructions and run:

ALTER TABLE trends
MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
MODIFY value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
MODIFY value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;

However, I still get

I'm running MariaDB 10.6.14

Tables 'trends' and 'history' look like:

Can't really think of much more to do to get DOUBLE_IEEE754 set in system_info so reckoning it could be a problem with my setup?

Help!