xufei
xufei
/test mysql-test
/test pull-integration-ddl-test
`RADIANS` in TiKV implements as follow ``` fn radians(arg: &Real) -> Result { Ok(Real::new(**arg * std::f64::consts::PI / 180_f64).ok()) } ``` Since 1E308 is the max float, I guess 1E308 *...
@abisshekk5 seems the query is just a simple single table filter, can you paste the `explain analyze` result of the query reading from tikv and reading from tiflash? And also...
@abisshekk5 it is really weird because the join result's count is right, only `sum(rat.anb_charge), sum(rat.bank_charge)` differs. Can you just select all the result like ``` SELECT pts.TXN_TYPE, rat.anb_charge, rat.bank_charge, count(*),...
@abisshekk5 actually, i want to check the difference of the original joined data, not the aggregated data, so i want to run this query ``` SELECT pts.TXN_TYPE, rat.anb_charge, rat.bank_charge, count(*),...
@abisshekk5 looks like the top left join `HashJoin_102` generate the in-consistency result. Can you please 1. check if there is any rows with `txnid = 1372599817` in rat table(using tiflash...
@abisshekk5 its really weird, and i think i need tiflash log to further investigate this issue, could you please run `explain analyze Select /*+ READ_FROM_STORAGE(TIFLASH[snf_db.rates]) */ count(*) from snf_db.rates;` multiple...