- Run mysql in docker
docker-compose -f mysql.yaml up -d
- Init database, run sql scripts:
- user.sql
- user_extend.sql
- Run ShardingSphereDataMigrateApplication
- run it directly to generate a migration script for the data source
ds1
- change application.yaml,
sharding-config: sharding-ds2.yaml
, and data source url to: ds2
, run again
- Run data migration sql scripts sql-scripts
- Run ShardingSphereExamplesApplication
- Try requests api.http
When cross-library join, the whole table will be queried, and then join in memory
- KernelProcessor#generateExecutionContext
- FilterableTableScanExecutor#execute
- watches:
queryResult
, you will find that the whole table is queried, not by id.
- ExecutorEngine#execute