MySQL loss precision while converting json string to double

similar problem:
MySQL JSON column loses decimal precision when JSON object inserted as a string literal