[Bug]: can insert a float, but not can insert a float variable.

[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_tabel(pk INTEGER PRIMARY KEY, fl FLOAT, dou DOUBLE);

INSERT INTO test_tabel VALUES(0, 1.2345678, 1.223344556677889900);

set @float1_num=1.2345678; set @double_num1=1.223344556677889900;

INSERT INTO test_tabel VALUES(1, @float1_num, @double_num1); error msg: Data truncation: Incorrect FLOAT value: '@float1_num' for column 'fl' at row 0

Expected Behavior

CREATE TABLE test_tabel(pk INTEGER PRIMARY KEY, fl FLOAT, dou DOUBLE);

set @float1_num=1.2345678; set @double_num1=1.223344556677889900;

INSERT INTO test_tabel VALUES(1, @float1_num, @double_num1);

result: Query OK, 1 rows affected (0.01 sec) Records: 1 Duplicates: 0 Warnings: 0

Steps to Reproduce

No response

Additional information

No response