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

dump.sql (10.4 KB)
这个是示例，查询SQL为，导入到另外一个6.1.1的集群也是一样报错：

-- 这个查不出来结果
  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';

-- 换成主键，能查出来
  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';