[Bug]: float type, select ... where col=flo; unmatch.

[tianyahui-python]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

CREATE TABLE test_table (pk INT DEFAULT NULL, fl FLOAT DEFAULT NULL,dou DOUBLE DEFAULT NULL, PRIMARY KEY (pk));

INSERT INTO test_table VALUES(0, 1.2345678, 1.223344556677889900), (1, 1.8765432, 1.223344556677889900);

mysql> select * from test_table; +------+-----------+------------------+ | pk | fl | dou | +------+-----------+------------------+ | 0 | 1.2345678 | 1.22334455667789 | | 1 | 1.8765432 | 1.22334455667789 | +------+-----------+------------------+

mysql> select * from test_table where fl=1.2345678; Empty set (0.00 sec)

Expected Behavior

mysql> select * from test_table where fl=1.2345678;

+------+-----------+------------------+ | pk | fl | dou | +------+-----------+------------------+ | 0 | 1.2345678 | 1.22334455667789 | +------+-----------+------------------+

Steps to Reproduce

No response

Additional information

No response