[Bug]: internal error: panic runtime error: index out of range [0] with length 0 when running prepared statment [select xxx for update]

[aressu1985]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

1d2305a

Other Environment Information

- Hardware parameters:standlone
- OS type:
- Others:

Actual Behavior

Statement : SELECT * FROM task WHERE id =? ORDER BY task.id LIMIT 1 FOR UPDATE
Parameters : [126]
ErrorCode : 20101
ErrorMessage : internal error: panic runtime error: index out of range [0] with length 0:
runtime.goPanicIndex
/Users/sudong/go/pkg/mod/golang.org/[email protected]/src/runtime/panic.go:115
github.com/matrixorigin/matrixone/pkg/sql/colexec/top.(*container).sort
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/sql/colexec/top/top.go:302
github.com/matrixorigin/matrixone/pkg/sql/colexec/top.(*container).processBatch
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/sql/colexec/top/top.go:253
github.com/matrixorigin/matrixone/pkg/sql/colexec/top.(*container).build
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/sql/colexec/top/top.go:228
github.com/matrixorigin/matrixone/pkg/sql/colexec/top.(*Top).Call
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/sql/colexec/top/top.go:144
github.com/matrixorigin/matrixone/pkg/vm.ChildrenCall
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/vm/types.go:499
github.com/matrixorigin/matrixone/pkg/sql/colexec/projection.(*Projection).Call
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/sql/colexec/projection/projection.go:68
github.com/matrixorigin/matrixone/pkg/vm.ChildrenCall
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/vm/types.go:499
github.com/matrixorigin/matrixone/pkg/sql/colexec/projection.(*Projection).Call
/Users/sudong/Program/MatrixOrigin/mo-2.0/matrixone/pkg/sql/colexec/projection/projection.go:68
github.com/matrixorigin/matrixone/pkg/vm.ChildrenCall

server.log

case:

test.zip

Expected Behavior

No response

Steps to Reproduce

1. git clone mo-load https://github.com/matrixorigin/mo-load.git
2. run mo service
3. create database and table
   create database test;
   uset test;
   CREATE TABLE `task` ( `id` bigint NOT NULL AUTO_INCREMENT, `source_connector_id` bigint NOT NULL, `task_log_id` bigint NOT NULL DEFAULT 0, `name` varchar(255) NOT NULL, `creator` varchar(255) NOT NULL, `uid` varchar(255) NOT NULL, `db_status` tinyint NOT NULL, `interval` bigint DEFAULT NULL, `load_interval_type` tinyint NOT NULL, `task_filter_mode` tinyint NOT NULL, `task_meta` varchar(255) NOT NULL, `folder_id` bigint NOT NULL, `folder_name` varchar(255) NOT NULL, `start_time` bigint DEFAULT NULL, `end_time` bigint DEFAULT NULL, `create_time` bigint NOT NULL, `update_time` bigint NOT NULL, PRIMARY KEY (`id`) );

4. insert some data to this table
5. cd mo-load/cases and unzip test.zip
5. cd mo-load and run
   ./run.sh -c cases/test -t 10 -d 2 -i 2 --mode=1 --psmode=true -b test

Additional information

No response