dnservice: init txn/storage/mem in MEM backend. rename old MEM to MEMKV

Approved by: @zhangxu19830126

prepare for FileService flush into csv file.
- mv trace *config struct into trace/config.go
- refactor trace_idd/transaction_id/session_id be uuid as [16]byte
- refactor trace.NoReportFiled() as logutil.NoReportFiled()

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

fileservice: allow setting shared config profile in S3 fs

Approved by: @zhangxu19830126, @nnsgmsone

Retry start DNShard if failed

Approved by: @reusee

Approved by: @reusee

Add createAt column for mo_database and mo_tables

Approved by: @daviszhen, @XuPeng-SH

Approved by: @aressu1985

add more BVT test for prepare clause

Approved by: @aressu1985

txnstorage: add ErrStaleWrite, ErrStaleRead

Approved by: @fengttt, @zhangxu19830126, @lni

Approved by: @dengn

Implement `intersect all` operator

Approved by: @nnsgmsone, @iamlinjunhong, @ouyuanning, @aunjgr, @aressu1985

Support create txn sender by config. And DN and CN service can share this implementation.

Approved by: @nnsgmsone, @reusee, @lni

fix the bug while external scan occur the NULL value in char&varcahr data type

Approved by: @nnsgmsone

txn: add error return to TxnClient.New

Approved by: @daviszhen, @XuPeng-SH, @zhangxu19830126, @lni

Approved by: @dengn

cnservice: initialize hakeeper client, txn sender, txn client lazily

Approved by: @zhangxu19830126, @nnsgmsone

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

This commit replaces `os.Setenv` with `t.Setenv` in tests. The
environment variable is automatically restored to its original value
when the test and all its subtests complete.

Reference: https://pkg.go.dev/testing#T.Setenv


Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>

Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>

Support trace context transfer via morpc framework

Approved by: @reusee

cnservice: add memory engine to service.initEngine

txnengine: add ShardToSingleStatic

Approved by: @nnsgmsone

Approved by: @yingfeng

fileservice: add FileService.Name

fileservice: add FileServices; add Get

fileservice: support named path

dnservice: replace store.localFS,s3FS with store.fs,metadataFS

Approved by: @zhangxu19830126, @cnutshell, @nnsgmsone

fix set clause bug: when set uint64 value in sql, but save int64 to session.

Approved by: @daviszhen, @aressu1985

avoid import cycle: trace -> pkg/config -> pkg/txn/client -> pkg/common/morpc -> trace

Approved by: @zhangxu19830126, @fengttt

Approved by: @dengn

Add blob support in MO

Approved by: @nnsgmsone, @fengttt, @zhangxu19830126, @XuPeng-SH

Rename `CNNode`/`DNNode`/`LogNode` to `CNStore`/`DNStore`/`LogStore`.

Add `Shards` field in `DNStore`.

Approved by: @lni, @reusee, @fengttt

txnengine: set Process.SessionInfo.TimeZone

txnstorage: do not remove entry from MemHandler.tables.Map in MemHandler.HandleTruncate

txnengine: do not return SqlError in Tx.Exec

txnengine: refine testBVT; add TestBVT

txnengine: ignore lines with # prefix in bvt files

txnengine: enable optimizer for select, update and delete statement

txnengine: fix testBVT

txnengine: ignore ExplainStmt in Tx.Exec

txnengine: panic on Tx.Exec error

txnengine: add Session

txnengine: fix Execution.DefaultDatabase

txnengine: fix txn client clock

txnengine: set session database to default in Exec

Approved by: @lni

- Implement network partition feature for service test framework
- Maintain `morpc.Client` options within `managedHAKeeperClient`
- Rename `pkg/tests/service/address.go` as `pkg/tests/service/network.go`, the same as its unit test file

Approved by: @zhangxu19830126, @lni

fileservice: implement MutableFileService for LocalETLFS

Approved by: @lni

fix the bug where filter null value in external scan

Approved by: @nnsgmsone, @ouyuanning, @aunjgr

Co-authored-by: tianyahui <tianyahui@tianyahuideMacBook-Pro.local>
Co-authored-by: fengttt <fengttt@gmail.com>

tae supports isolation of db and table by tenantID

1. add access info (tenantID, userID, roleID) to DBEntry, TableEntry and schema
2. add access-related columns to mo_database, mo_tables, mo_columns
3. refactor db iterator and table iterator, add access filter for mo_catalog
4. fix error in `show create table`

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

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