sql: refactor external table with Process.FileService

init file service on CN and pass to frontend

Co-authored-by: fengttt <fengttt@gmail.com>

* fix some bvt bugs and modify error msg

* log func base 1 should be error

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>

Resolves:

Reference
For more information on update，see[Update Standalone MatrixOne](https://docs.matrixorigin.io/0.5.1/MatrixOne/Get-Started/update-standalone-matrixone/).
For more information on deployment，see[Deployment FAQs](https://docs.matrixorigin.io/0.5.1/MatrixOne/FAQs/deployment-faqs/).

Approved by: @dengn

Revise the check failure bug when the mo boots with previous databases and tables.

Approved by: @yingfeng

1. add serialization methods for struct Compile.Scope for pipeline's remote run.
2. add cn-client and cn-service related methods.

Approved by: @daviszhen, @reusee, @zhangxu19830126, @nnsgmsone

Approved by: @reusee

Approved by: @aressu1985

mo-service: refactor file service initialization

Approved by: @zhangxu19830126

1.  Enable multi tenant in default

- add create account statement.
- add create user statement.
- add create role statement.
- with two internal users -- root and dump (both password 111) in sys tenant.
- login format: the '-u' option of mysql client has been extended to "tenant:user:role" or "tenant:user"(public role) or "user"(sys tenant, public role)

2. Already known restrictions in this initial version:

- no privilege check
- no drop/alter statement
- no view
- only tenant isolation
- user can see the whole catalog of the tenant that it is belonged to.
- remove the .store directory when mo boots with multi-tenant verison at first time. Just only once.

3. Remove db-server

Approved by: @reusee, @iamlinjunhong, @aressu1985

fileservice: add Path, ParsePath, ParsePathAtService

Approved by: @zhangxu19830126

In some cases, TxnRequest is supported to retry on the DN to resolve DNShardNotFound errors due to inconsistent message propagation

Approved by: @reusee

Co-authored-by: fengttt <fengttt@gmail.com>

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

* Adapt to the new Load Plan

* change word 'colnum' to 'column'

* Add bvt test

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

* use logutil.Info/Infof replace fmt.Printf/Println

* fix compile

* fix static-check

* fix merge

* revert version output

* revert version missing part

* revert tool goyacc modification

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

* Update char.test

* Update varchar.test

* Update char.test

* Update varchar.test

* Update char.result

* Update varchar.result

* adjust result

* adjust test cases

* add explain cases (#2)

* Update decimal.test

* Update timestamp.test

* Update go.mod

* Update go.mod

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.test

* Update timestamp.result

* adjust cases (#3)

* Update bigint.test

* Update bigint.result

* Update char.result

* Update char.test

* CI: add PR UT coverage (#4371)

Create a new yml file to support detect incremental code coverage

Approved by: @sukki37

* Update ut_pr.yml (#4439)

* Delete ut_pr.yml

Co-authored-by: iamlinjunhong <49111204+iamlinjunhong@users.noreply.github.com>
Co-authored-by: Yingfeng <yingfeng.zhang@gmail.com>
Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: brown <1173781832@qq.com>
Co-authored-by: maomao <77312370+sukki37@users.noreply.github.com>
Co-authored-by: ou yuanning <45346669+ouyuanning@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

Co-authored-by: fengttt <fengttt@gmail.com>
Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: fengttt <fengttt@gmail.com>

Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>

No data and logs are uploaded when a job runs successfully, and vice versa, improving the efficiency of ci job execution.

Approved by: @sukki37

Approved by: @aunjgr, @aressu1985, @ouyuanning

Approved by: @aressu1985

Approved by: @XuPeng-SH

vm/engine: add Engine.Hints

Approved by: @nnsgmsone, @XuPeng-SH, @daviszhen

In this pr, I optimized ut_pr and add auto cancel outdate workflows. For the function of automatic cancellation, please refer to this link: https://docs.github.com/en/actions/using-jobs/using-concurrency

Approved by: @sukki37

fileservice: make service name case-insensitive

Approved by: @zhangxu19830126

Approved by: @dengn

txnengine: add ErrReadOnly

txnstorage: add CatalogHandler; refactor TestMVCC

Approved by: @zhangxu19830126, @lni

    mo-service, cnservice, etc: codes for starting standalone mem engine and distributed TAE (#4700)

mo-service, cnservice, etc: codes for starting standalone mem engine and distributed TAE

Approved by: @zhangxu19830126, @lni, @nnsgmsone

1、fix bug:show create table xx when xx is a view
2、refactor:  move show create table/database from frontend to plan

Approved by: @aunjgr, @XuPeng-SH, @daviszhen, @aressu1985

Approved by: @dengn

Approved by: @dengn

Approved by: @aressu1985

Approved by: @aressu1985

Approved by: @yingfeng

different tenants is allowed to create tables with same name in mo_catalog database

Approved by: @XuPeng-SH

sketch disttae package; engine: add DoTxnRequest

Approved by: @nnsgmsone

* add show create view clause support

* remove debug code

* add ut