[Bug]: internal error: panic runtime error: index out of range [10] with length 10 when running sysbench random point case with 1000w data

[aressu1985]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

1.1-dev

Commit ID

40f1df0

Other Environment Information

- Hardware parameters: 64C 128G 
- OS type:
- Others:

Actual Behavior

job link:
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/7741895346/job/21110133785

when running sysbench random point case with 1000w data, all the queries were failed.
FATAL: mysql_store_result() returned error 20101 (internal error: panic runtime error: index out of range [10] with length 10:
runtime.goPanicIndex
/usr/local/go/src/runtime/panic.go:114
github.com/matrixorigin/matrixone/pkg/sql/plan/function.PrefixIn
/data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/plan/function/func_prefix.go:135
github.com/matrixorigin/matrixone/pkg/sql/colexec.(*FunctionExpressionExecutor).Eval
/data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/col)
FATAL: thread_run' function failed: select_random_points.lua:71: SQL error, errno = 20101, state = 'HY000': internal error: panic runtime error: index out of range [10] with length 10: runtime.goPanicIndex /usr/local/go/src/runtime/panic.go:114 github.com/matrixorigin/matrixone/pkg/sql/plan/function.PrefixIn /data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/plan/function/func_prefix.go:135 github.com/matrixorigin/matrixone/pkg/sql/colexec.(*FunctionExpressionExecutor).Eval /data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/col FATAL: mysql_store_result() returned error 20101 (internal error: panic runtime error: index out of range [10] with length 10: runtime.goPanicIndex /usr/local/go/src/runtime/panic.go:114 github.com/matrixorigin/matrixone/pkg/sql/plan/function.PrefixIn /data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/plan/function/func_prefix.go:135 github.com/matrixorigin/matrixone/pkg/sql/colexec.(*FunctionExpressionExecutor).Eval /data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/col) FATAL: thread_run' function failed: select_random_points.lua:71: SQL error, errno = 20101, state = 'HY000': internal error: panic runtime error: index out of range [10] with length 10:
runtime.goPanicIndex
/usr/local/go/src/runtime/panic.go:114
github.com/matrixorigin/matrixone/pkg/sql/plan/function.PrefixIn
/data1/runners/action-runner/_work/mo-nightly-regression/mo-nightly-regression/head/pkg/sql/plan/function/func_prefix.go:135
github.com/matrixorigin/matrixone/pkg/sql/colexec.(*FunctionExpressionExecutor).Eval

Expected Behavior

No response

Steps to Reproduce

1. git clone https://github.com/matrixorigin/mo-sysbench.git
2. prepare data:
   create database sysbench_1000w_auto_index;
   sysbench --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password='111' oltp_common.lua --mysql-db=sysbench_1000w_auto_index --tables=10 cleanup
   sysbench --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password='111' oltp_common.lua --mysql-db=sysbench_1000w_auto_index --tables=10 --table_size=10000000 --threads=10  prepare

3. run test:
   sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 --db-ps-mode=disable select_random_points.lua --mysql-db=sysbench_10w_auto_index --tables=10 --table_size=100000 --threads=100 --time=60 --report-interval=2 run

Additional information

No response

[aunjgr]

fixed by #14511 and #14519

[aressu1985]

fixed