[ClickHouse Compatibility] +/-Infinity values parsing

[MaceWindu]

ClickHouse supports NaN, Infinity and -Infinity values for float/double types, which cannot be parsed by MySqlConnector here:

• NaN value sent as"nan" and parsed successfully
• Infinity and -Infinity sent as "inf" and "-inf" and result in FormatException

Describe the solution you'd like

Would be nice to support those two values (always or using some ClickHouse compatibility switch/connection string parameter).

I cannot find any information on float/double encoding in spec, probably looking at wrong place as I'm not familiar with it at all (https://dev.mysql.com/doc/internals/en/string.html)

[bgrainger]

double.Parse("∞") returns double.PositiveInfinity; doesn't seem unreasonable to add hard-coded support for inf and -inf.

[bgrainger]

I didn't actually test with ClickHouse, but added support for -inf and inf as described in the case.

[bgrainger]

Implemented in 2.1.11.

[MaceWindu]

Thanks, it works!