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

mo has its own error code/message, and need to adapt mysql error code.
- define `moErrorMsgItem{errorCode, mysqlErrorCode, errorMsgOrFormat}` to handle `moErrorCode->mysqlErrorCode` mapping rules
- define `New(errorCoe, args)` and `NewWithContext(context.Context, errorCode, args)` to handle error reporting
- modify reference of `moerr.ErrTxnClosed` error, as an example of `moerr.New(...)`
- predefine `Group 6: sql error` as sql error, which normally can be converted to mysql error code.

Approved by: @fengttt, @zhangxu19830126, @ouyuanning, @nnsgmsone

Approved by: @ouyuanning, @aunjgr, @aressu1985

Add bit or/and/xor function support.
(they are bit operator, not bool, not agg)

Approved by: @aressu1985, @aunjgr

Fix prepare/execute stmt bug

Approved by: @daviszhen, @aressu1985, @aunjgr

Add more states and interfaces for TxnCtx

Approved by: @JinHai-CN, @fengttt

add intersect

Approved by: @nnsgmsone, @aressu1985

Made tan's buffer size configurable, reduced buffer size in tests to be 16KBytes each, it was 4MBytes each. Also set debug.SetMemoryLimit(1GBytes) to further reduce memory usage when running TestGossipInSimulatedCluster.

Approved by: @yingfeng

fileservice: refactor testBlockMapper

fileservice: use CRC32 since most CPU has crc32 instructions

fileservice: rename BlockMappable to FileLike

fileservice: rename BlockMapper to FileWithChecksum

fileservice: ignore ignored io entries in S3 bytes-range calculation

Approved by: @lni

In previous design, there is not context.Context going through the frontend and the computation engine.
In 0.6, the computation engine introduces the context.Context.
So, I add the context.Context in the frontend and try to connect context.Context with modules -- metric and trace.
I am not sure the usage of the conext.Context in these modules is right. So I propose the PR.

The hierarchy of the context.Context:
```
rootCtx(context.Background)
|
|
WithCancel()
|
|
\|/
cancelMoServerCtx
|
|
WithValue(configuration)
|
|
moServerCtx
|
|
----------------------------> context in metric, trace
|
|
\|/
cancelRoutineCtx (every network connection has an independent context)
|
|
------> WithCancel----->AuthenticateCtx (login authentication -- user, password, role)
|
|
cancelRequestCtx (every request from the client has a new context)
|
|
-------> WithCancel ------> LoadBatchCtx ( every batch has a independent context)
```

Approved by: @fengttt, @yingfeng, @aptend

Approved by: @aressu1985, @aunjgr, @ouyuanning

* aggrate sum decimal

* sum with decimal

* modify aggrate sum code

- fix failed ut with timer in `batch_processor_test.go`, which have a little random problem
- fix data race in `batch_processor.go`, which is not found in previous CI.

Approved by: @fengttt

Support uuid function

Approved by: @aressu1985, @ouyuanning

Fix replay catalog. Replace baseEntry in onReplay().

Approved by: @XuPeng-SH