support order by limit optimization for non-sorted columns #17955

Job	Run time
CHECK PR VALID	4s
Matrixone CI / UT Test on Ubuntu/x86	18m 0s
Matrixone CI / SCA Test on Ubuntu/x86	8m 58s
Matrixone CI / UT Test on Darwin/x86	31m 29s
Matrixone Compose CI / multi cn e2e bvt test docker compose(Optimistic/PUSH)	15m 43s
Matrixone Compose CI / multi cn e2e bvt test docker compose(PESSIMISTIC)	22m 4s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH,Optimistic)	26m 8s
Matrixone Standlone CI / Multi-CN e2e BVT Test on Linux/x64(LAUNCH, PROXY)	20m 13s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH, PESSIMISTIC)	18m 44s
Matrixone Upgrade CI / Compatibility Test With Release on Linux/x64(LAUNCH)	42m 29s
Matrixone Upgrade CI / Compatibility Test With Target on Linux/x64(LAUNCH)	42m 14s
Matrixone Utils CI / check_organization_user	3s
Matrixone Utils CI / pr-size-label	3s
Matrixone Utils CI / docu_issue_check	0s
Matrixone Utils CI / PR Unit Test Coverage	22m 46s
	4h 28m 58s

Provide feedback