why the operator "ID=999999999999999999999999" cannot get the result , when query on the numeric(24,0) column ?

[tigerzhangyz]

CentOS Linux release 7.8.2003 (Core)
psql (PostgreSQL) 12.4

this is tidb database origin data:
`
mysql> create table testzyz(ID numeric(24,0) NOT NULL COMMENT '关联ID' ,primary key(id));
Query OK, 0 rows affected (0.52 sec)

mysql> insert into testzyz values(999999999999999999999999);;
Query OK, 1 row affected (0.01 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from testzyz;
+----+
| ID |
+----+
| 999999999999999999999999 |
+----+
1 row in set (0.00 sec)
`

this is FDW data:
`
drop SERVER alchemy_srv cascade;
CREATE SERVER alchemy_srv foreign data wrapper multicorn options (
wrapper 'multicorn.sqlalchemyfdw.SqlAlchemyFdw'
);
drop foreign table MTCTIDBtestzyz;
create foreign table MTCTIDBtestzyz (
id numeric(24,0) NOT NULL
) server alchemy_srv options (
tablename 'testzyz',
primary_key 'id',
db_url 'mysql://root:@xxxx:4000/cloud'
);
CREATE FOREIGN TABLE
fdwzyz=# select * from MTCTIDBtestzyz;
id

999999999999999999999999
(1 row)
fdwzyz=# select * from MTCTIDBtestzyz where id=999999999999999999999999;
id

(0 rows)
`

[rdunklau]

Hello,

Can you log the query as it is executed on the MySQL side ?

[tigerzhangyz]

Hello,

Can you log the query as it is executed on the MySQL side ?

I get it，the SQL change in mysql general log, but why?

2020-09-29T15:23:10.711034+08:00 26 Query SELECT testzyz.id
FROM testzyz
WHERE testzyz.id = 1e+24
2020-09-29T15:23:10.712026+08:00 26 Query commit