The DDL statement supports the partition by clause. The partition types include:
RANGE Partitioning,
LIST Partitioning,
COLUMNS Partitioning,
RANGE COLUMNS partitioning,
LIST COLUMNS partitioning,
HASH Partitioning,
KEY Partitioning,

The construction of the partition sentence and the semantic check coding have been completed, but the partition information of DDL is not synchronized to the metadata table. Subsequently, the metadata table related to the partition will be added and the partition information will be displayed when show create table is supported, Issue#4749

Approved by: @daviszhen, @zhangxu19830126, @fengttt, @aunjgr, @iamlinjunhong, @ouyuanning, @aressu1985, @nnsgmsone

When drop tbl/db entry, it wait related txn to commit twice. This pr remove the second one.

Approved by: @XuPeng-SH

The current protocol and mysql access code, designed to be confusing, will lead to multiple calls to Quit, here the use of sync.Once also just to solve the problem of multiple closures, the code needs to be refactored

Approved by: @sukki37, @daviszhen

* fix bug. Wrong judgment of statement type

* add bvt

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

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