同样的查询条件，展示字段不同，得出来结果不一样。

select version();
+--------------------+
| version()          |
+--------------------+
| 5.7.25-TiDB-v6.4.0 |
+--------------------+
1 row in set (0.01 sec)

root@:4000[test]>select
    ->     c.occur_amount
    ->     from capital_history c
    ->     join txn_account_info t
    ->     on c.txt_account_id=t.txn_account_id
    ->     and c.capital_sub_class='CUST'
    ->     and t.account_id='1142927' and t.broker='0009'
    ->     and c.occur_trade_date = '2022-11-17';
+--------------+
| occur_amount |
+--------------+
|        -2.01 |
+--------------+
1 row in set (0.08 sec)

root@:4000[test]> select
    ->     c.serial_id, c.occur_amount
    ->     from capital_history c
    ->     join txn_account_info t
    ->     on c.txt_account_id=t.txn_account_id
    ->     and c.capital_sub_class='CUST'
    ->     and t.account_id='1142927' and t.broker='0009'
    ->     and c.occur_trade_date = '2022-11-17';
+------------------+--------------+
| serial_id        | occur_amount |
+------------------+--------------+
| 2022111700196920 |        -2.01 |
+------------------+--------------+
1 row in set (0.10 sec)

我这测试了下，没问题。
跟在MySQL里面执行的结果一样。