Ariznawlll

decimal的精度问题麻烦同时看下原因： ddl： select sum(abs(col16)) from big_data_test.table_basic_for_load_1B; select sum(ln(col16)) from big_data_test.table_basic_for_load_1B where col16 > 0;

**table schema:** create table if not exists big_data_test.table_basic_for_load_100M( col1 tinyint, col2 smallint, col3 int, col4 bigint, col5 tinyint unsigned, col6 smallint unsigned, col7 int unsigned, col8 bigint unsigned, col9 float,...

testing

testing

[20260226] 大数据测试出现了这个问题； job url（queries 1y -> write 1y test）： https://github.com/matrixorigin/mo-nightly-regression/actions/runs/8029862130/job/21947111382 log:http://175.178.192.213:30088/explore?panes=%7B%22AAL%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22branch-big-data-nightly-ead69b4%5C%22%7D%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%22now-2d%22,%22to%22:%22now%22%7D%7D%7D&schemaVersion=1&orgId=1

20240307大数据测试： {"level":"INFO","time":"2024/03/07 01:47:55.283797 +0000","caller":"logtail/utils.go:2601","msg":"read-all","operation":"read","operand":"checkpoint","size":4355263,"duration":"52.97915ms"} {"level":"INFO","time":"2024/03/07 01:47:55.283833 +0000","caller":"checkpoint/replay.go:218","msg":"replay checkpoint CKP[G][2][ckp 77325, truncate 72325](0-0->1709751811761705892-1)"} gc 9 @1.650s 0%: 0.063+12+0.018 ms clock, 1.0+0.096/50/132+0.29 ms cpu, 243->246->184 MB, 286 MB goal, 0 MB stacks,...

fixed

@nnsgmsone 辛苦帮忙看一下呀.

2024.02.26最新测试结果： commit id：ead69b441080825781ba62c0bc886f4f4b9f9ac5

**结论：** 1. 单并发单表场景下，若k值较大，有次级索引性能较无次级索引性能明显提升；若K值较小，次级索引效果不明显，甚至有下降； 2. 多并发多表场景下，测试sysbench 1000w性能获取qps以及cost，有次级索引性能较无次级索引性能有明显提升。 **测试详情：** 测试commit：b49cc70872b55f58b368c7c4c91b33c2a6f5057b 测试环境：128 单机 It works in the current sql type：select c from sbtest%u where k=? **测试场景：** 1. 单并发单表： 1.1 800w行： k = 100000，无次级索引测试结果为0.04s，有次级索引测试结果为0.02s；...