add file `ut_pr.yml` to support pull request additional unit test coverage

Approved by: @sukki37

Approved by: @aressu1985, @nnsgmsone, @aunjgr

Using CGO to reconstruct the comparison operation

Approved by: @daviszhen, @ouyuanning, @fengttt, @nnsgmsone, @aunjgr

* CI: add PR UT coverage (#4371)

Create a new yml file to support detect incremental code coverage

Approved by: @sukki37

* Add union and minus

* Update ut_pr.yml

* Update ut_pr.yml (#4439)

* Delete ut_pr.yml

* Fix sca

* Adding a strategy choice for group by

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

* use constant connection timeout value which is much smaller than the LOG node heartbeat timeout. this ensures we get chance to try most specified HAKeeper nodes.
* during bootstrap, it is possible for the HAKeeper replica to be removed by a KILL command, terminate the local bootstrap procedure when that happens.
* always keep the ticker worker even after the HAKeeper replica is stopped.

Approved by: @reusee

Fix onReplayAppendCmd. Check whether there exists active block before load data.

Approved by: @XuPeng-SH

- Evaluate health of a log shard via its running replicas, not via its expired replica.

Approved by: @lni

Fix the bug of ssb

Approved by: @yingfeng

When dns names are used in the GossipSeedAddresses field of logservice.Config, mo-service will try to resolve them and pass them to the logservice as a slice of strings in ip:port format. Only IPv4 addresses are kept and ErrInvalidConfig is returned if any dns name is mapped to more than one IPv4 address.

Approved by: @reusee

Approved by: @yingfeng

Shuffle address list before use to make sure we don't always waste all allocated timeout on the first few dead nodes.

Approved by: @reusee

Approved by: @aressu1985

1. upgraded golangci-lint to v1.48.0 which comes with go1.19 support
2. updated CI env to use go1.19
3. applied go1.19's updated `gofmt -s` to MO's codebase

Approved by: @fengttt

Implement interface `ClusterState` for test framework.
NB: Skip `TestClusterState` temporarily.

Approved by: @lni

fileservice: replace Pinned with RC

Approved by: @XuPeng-SH

Approved by: @daviszhen

updateb docs:subqueries/update/delete/data_types/faq_theme/glossary/interval/install_standalone link/  (#4328)

Approved by: @dengn

The grammar of the create/drop/grant/revoke role for the tenant is different the one in mysql.
So, I changed it.

Approved by: @yingfeng

A falut injection tool.   See fault_test.go for how to use it in code, and fault.sql for how to call that in sql.
We will need to sprinkle the triggering of fault in our code.

Approved by: @daviszhen

Approved by: @lni

fileservice: add CachingFileService; implement CachingFileService for S3FS

fileservice: add MemCache

fileservice: add testCachingFileService

fileservice: implement CachingFileService for LocalFS

Approved by: @lni

The grammar of the create/alter/drop user for the tenant is different the one in mysql.
So, I changed it.

Approved by: @yingfeng

Config the CI workflow to build mo-service for each PR.

Approved by: @fengttt, @sukki37

fileservice: add value pinning in LRU

Approved by: @XuPeng-SH

txnstorage: implement MemHandler.HandleCommit,HandleCommitting,HandleDestroy,HandlePrepare,HandleRollback,HandleStartRecovery

txnstorage: make Transaction.State an atomic value

txnengine: refine doTxnRequest

txnengine: separate hakeeper related codes from Engine

engine: add error return value to Engine.Nodes

Approved by: @XuPeng-SH

The tenant feature needs the parser recognizes the grammar for operating the account like create/drop/alter account.

Approved by: @yingfeng

Approved by: @daviszhen

1. Add tp and ap compile
2. Support ExecInfo for Compile

Approved by: @yingfeng, @daviszhen

1. Implement interface `ClusterOperation` for integration test framework;
2. Add unit tests;

Approved by: @lni

Approved by: @daviszhen

define an interface(empty function) to get execute type from plan for test

we will finish the function later

Approved by: @nnsgmsone, @fengttt

Approved by: @lni

fileservice: use a better btree package and simplify MemoryFS codes
fileservice: add BenchmarkS3FS
fileservice: refine minio server S3FS test
fileservice: add ErrEmptyVector; refine TestS3FSMinioServer

Approved by: @lni

Update lz4 version

Approved by: @XuPeng-SH

Switched to use dragonboat's new log storage engine called tan. For testing purposes, using the tee-tan adapter now which duplicates all I/O onto both tan and the proven pebble based engine.

Approved by: @reusee

1. Modify the logic of the INSERT method of the hash table
2. add comments for package `hashmap`

Approved by: @nnsgmsone

Add fill anaylze information

Approved by: @daviszhen

Approved by: @aressu1985

A zonemap with 64-byte serialized data.

If the data type is string, only a part of prefix of minimum and maximum will be written to disk
Rule of thumb: false positive is allowed but false negative is not
That means the searialized min-max range should cover the original min-max range.

Therefore, we must record minv length, because filling zero for minv makes it bigger, which is not acceptable.
For maxv, we have to construct a bigger value in 32 bytes by plus one if needed.
What if the leading 32 bytes are all 0xff? That is means +inf, it should be compared specifically

Layout for string:
```
[B0,...B30,B31,B32,...B62,B63]
---------  -  --------------
minv    |       maxv
|
[b7=init,b6~b5 unused,b4~b0=len(minv)]
```

Approved by: @XuPeng-SH