feat(strategy): Pisanix supports horizontal sharding strategy

[wbtlb]

trafficstars

Development Task

Our goal is to support simple sharding features as follows:

1. Key-based table sharding feature.
2. horizontal sharding strategy.

• query planner
• SQL rewrit
• SQL execute
• Resultset merge

3. Aggregate function

• count()
• sum()
• max()
• min()
• last_insert_id()

4. simple node order by,group by,limit
5. sharding with =, IN, BETWEEN AND, >, <, >=, <=
6. Simple node trasaction
7. set/charset
8. config line expression
9. sharding config

Background

Pisanix will support sharding in v0.3.0.

Implement

Description

[mlycore]

This could be divided into three parts of operators, including equal, in and between.

[wbtlb]

This could be divided into three parts of operators, including equal, in and between.

Hi, mlycore

I will divide the task, and there will be different issue to describe the design of this feature.