MariaDB [test]> SELECT JSON_TYPE('1');

+----------------+

| JSON_TYPE('1') |

+----------------+

| NUMBER         |

+----------------+

1 row in set (0.00 sec)

MariaDB [test]> SELECT JSON_TYPE('1.1');

+------------------+

| JSON_TYPE('1.1') |

+------------------+

| NUMBER           |

+------------------+

1 row in set (0.00 sec)

MySQL [test]> SELECT JSON_TYPE('1');

+----------------+

| JSON_TYPE('1') |

+----------------+

| INTEGER        |

+----------------+

1 row in set (0.00 sec)

MySQL [test]> SELECT JSON_TYPE('1.1');

+------------------+

| JSON_TYPE('1.1') |

+------------------+

| DOUBLE           |

+------------------+

1 row in set (0.00 sec)