Approved by: @dengn

PR Unit Coverage Test reported an error because there was no Test directory when output Paths were empty.(#4533 #4586 ) This PR fixed this.

Approved by: @sukki37

fix data race in txnstore.getOrSetDB. add dbsMu

Approved by: @XuPeng-SH

cnservice: init hakeeper client

cnservice: init txn sender

cnservice: init txn client

frontend: add wrappedTAETx, wrappedTAEEngine; rename InitDB to InitTAE

frontend: use TxnOperator instead of moengine.Txn

txn: add get txn metadata to txnOperator

replace engine.Snapshot with TxnOperator

Co-authored-by: zhangxu <zhangxu19830126@gmail.com>

solve memory leak in batch alloc

Approved by: @nnsgmsone, @yingfeng

1. cago compiler with link system lib, so  ignore cgo generate files
`/usr/bin/ld` is my local Apple's linker

For example:
```
#16 52.59 # github.com/matrixorigin/matrixone/cmd/db-server
#16 52.59 /usr/local/go/pkg/tool/linux_amd64/link: running gcc failed: exit status 1
#16 52.59 /usr/bin/ld: /tmp/go-link-2126209758/000006.o: in function `_cgo_df8c56550131_Cfunc_Decimal128_Add':
#16 52.59 decimal.cgo2.c:(.text+0x71): undefined reference to `Decimal128_Add'
#16 52.59 /usr/bin/ld: /tmp/go-link-2126209758/000006.o: in function `_cgo_df8c56550131_Cfunc_Decimal128_AddDecimal64':
#16 52.59 decimal.cgo2.c:(.text+0xcd): undefined reference to `Decimal128_AddDecimal64'
#16 52.59 /usr/bin/ld: /tmp/go-link-2126209758/000006.o: in function `_cgo_df8c56550131_Cfunc_Decimal128_AddInt64':
```

2. According to #4535, the `system_vars_config.toml` will be the default config and  `make config` do not generate configuration files. So `system_vars_config.toml` should not be ignored. It's related to [optools/images/Dockerfile](https://github.com/matrixorigin/matrixone/blob/main/optools/images/Dockerfile)

3. Add some other generate files, like `gen_config` and ignore generate data at `store/`.

4. Fix config error

Approved by: @yingfeng

support CMD_STMT_PREPARE/EXECUTE/CLOSE  command for MySQL protocol.

test code see https://github.com/matrixorigin/matrixone/issues/3693  @sukki37 's comment.

Approved by: @daviszhen

Approved by: @yingfeng

- Enable flexible `morpc` option for package `logservice`
- Extend `morpc.WithBackendFilter` in order to support network partition feature

Approved by: @zhangxu19830126, @lni

Approved by: @yingfeng

Approved by: @yingfeng

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

txnengine: add Errors and extract errors in doTxnRequest
txnengine: add Errors.As; create default database; fix Execution.Resolve
txnengine: add MemHandler.mheap; fix MemHandler.HandleRead
txnengine: add TestTPCH
txnengine: add Tx.databaseName
txnengine: add file path param to Tx.Exec
txnengine: add typed errors
txnengine: fix Execution.Resolve
txnengine: fix Tx.Exec to execute all statements
txnengine: fix engineAttrToPlanColDef
txnengine: fix plan types gob registeration
txnengine: gob register plan types
txnengine: save database and table name in lowercase; set default schema name in Execution.Resolve
txnengine: set zap logger for NewTxnService
txnengine: trim comment lines in bvt files
txnstorage: add AttributeRow.Order
txnstorage: add hidden __version column
txnstorage: fix BatchIter
txnstorage: fix MemHandler.HandleRead
txnstorage: use req.TableID,DatabaseID in HandleDelTableDef,HandleGetRelations,HandleGetTableDefs,HandleGetTableDefs

Approved by: @lni

1. Connect the cn-service with the frontend and the computation engine.
2. Change the configuraion mechanism to the general method. Remove the auto-generated configuration.

Approved by: @zhangxu19830126, @yingfeng, @fengttt, @aptend, @reusee, @nnsgmsone, @lni

This pr is used to speed up performance-related things like join conditions like r.a = s.b and r.a > s.b, most typically tpch's q21.

Approved by: @yingfeng, @aunjgr

Fix replay logstore. Replay currlsn by checkpointInfo.  Replay internal entry when replay. When truncate, check all groups instead of checkpointed groups.

Approved by: @XuPeng-SH

update default image go version to 1.19

Approved by: @fengttt, @sukki37

1. updated pkg/common/stopper to stop using logutil from MatrixCube, it should use MO's own logutil.
2. minor fix for proto/gen.sh

Approved by: @yingfeng, @zhangxu19830126, @fengttt

insert statement use BuildPlan now.
so add insert statement support in prepare clause.

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

fix intersect issue and refine the probe step

Approved by: @nnsgmsone

Declaration of supplementary C function

Approved by: @nnsgmsone, @fengttt

support json type export & load

Approved by: @daviszhen

- SpanContext support MarshalTo/Unmarshal
- how-to-use is in [pkg/util/trace/example/main.go](https://github.com/matrixorigin/matrixone/compare/main...xzxiong:trace_morpc)

Approved by: @fengttt

vector: fix Vector.Read;
batch: add EncodeBatch.Attrs

Approved by: @nnsgmsone

rewrite the load plan as insert into table select from external table;
add sql to support external table as we can select info from external table;

Approved by: @daviszhen, @nnsgmsone, @iamlinjunhong, @fengttt, @yingfeng, @aunjgr, @ouyuanning, @XuPeng-SH

Signed-off-by: Abirdcfly <fp544037857@gmail.com>

Signed-off-by: Abirdcfly <fp544037857@gmail.com>
Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
Co-authored-by: Yingfeng <yingfeng.zhang@gmail.com>
Co-authored-by: lni <nilei81@gmail.com>
Co-authored-by: fengttt <fengttt@gmail.com>

This commit adds a `*time.Location` instance in both `frontend.Session` and `process.SessionInfo`, to store session level timezone info. We can use `set time_zone=XXX` to modify it. Three different formats are supported, the same as MySQL:

* set time_zone="SYSTEM". It sets timezone to your operating system's value, which is the default.
* set time_zone="+01:00". The timezone string specifies offset to UTC. It comprises a not omittable "+/-" sign, 2-digit hour, a ":" sign, and 2-digit minute. Legal values are between -13:59 and +14:00.
* set time_zone="America/New_York". The timezone string is a legal IANA TZ database name.

TIMESTAMP values are converted from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such as DATETIME.)

Approved by: @daviszhen, @fengttt, @ouyuanning, @aptend, @aressu1985, @nnsgmsone

1. Add the ignore type  .pb. go to Labeler.
2. Fixed some bugs in UT_PR and optimized the output.

Approved by: @yingfeng, @sukki37

Convert the result of decimal64 sum aggregation to decimal128

Approved by: @nnsgmsone, @aunjgr, @fengttt

Approved by: @yingfeng