ShardingSphere 4.x Kernel — Rewrite Engine

SELECT order_id FROM t_order WHERE order_id=1;
SELECT order_id FROM t_order_1 WHERE order_id=1;
SELECT order_id FROM t_order WHERE order_id=1 AND remarks=' t_order xxx';
SELECT order_id FROM t_order_1 WHERE order_id=1 AND remarks=' t_order xxx';
SELECT order_id FROM t_order_1 WHERE order_id=1 AND remarks=' t_order_1 xxx';
SELECT t_order.order_id FROM t_order WHERE t_order.order_id=1 AND remarks=' t_order xxx';
SELECT t_order_1.order_id FROM t_order_1 WHERE t_order_1.order_id=1 AND remarks=' t_order xxx';
SELECT t_order.order_id FROM t_order AS t_order WHERE t_order.order_id=1 AND remarks=' t_order xxx';
SELECT t_order.order_id FROM t_order_1 AS t_order WHERE t_order.order_id=1 AND remarks=' t_order xxx';
SHOW COLUMNS FROM t_order FROM order_ds;
SELECT order_id, user_id FROM t_order ORDER BY user_id;
SELECT order_id FROM t_order ORDER BY user_id;
SELECT order_id, user_id AS ORDER_BY_DERIVED_0 FROM t_order ORDER BY user_id;
SELECT o.* FROM t_order o, t_order_item i WHERE o.order_id=i.order_id ORDER BY user_id, order_item_id;
SELECT o.*, order_item_id AS ORDER_BY_DERIVED_0 FROM t_order o, t_order_item i WHERE o.order_id=i.order_id ORDER BY user_id, order_item_id;
SELECT AVG(price) FROM t_order WHERE user_id=1;
SELECT COUNT(price) AS AVG_DERIVED_COUNT_0, SUM(price) AS AVG_DERIVED_SUM_0 FROM t_order WHERE user_id=1;
INSERT INTO t_order (`field1`, `field2`) VALUES (10, 1);
INSERT INTO t_order (`field1`, `field2`, order_id) VALUES (10, 1, xxxxx);
INSERT INTO t_order VALUES (10, 1);
INSERT INTO t_order VALUES (xxxxx, 10, 1);
SELECT score FROM t_score ORDER BY score DESC LIMIT 1, 2;
INSERT INTO t_order (order_id, xxx) VALUES (1, 'xxx'), (2, 'xxx'), (3, 'xxx');
INSERT INTO t_order_0 (order_id, xxx) VALUES (2, 'xxx');
INSERT INTO t_order_1 (order_id, xxx) VALUES (1, 'xxx'), (3, 'xxx');
SELECT * FROM t_order WHERE order_id IN (1, 2, 3);
SELECT * FROM t_order_0 WHERE order_id IN (2);
SELECT * FROM t_order_1 WHERE order_id IN (1, 3);
SELECT * FROM t_order_0 WHERE order_id IN (1, 2, 3);
SELECT * FROM t_order_1 WHERE order_id IN (1, 2, 3);

--

--

--

Transform any DBMS in a distributed database system & enhance it with sharding, elastic scaling features & more. https://linktr.ee/ApacheShardingSphere

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Using Serverless Framework & Localstack to test your AWS applications locally

Difference Between HTTP/1.1 And HTTP/2

INTERVIEW WITH WOJCIECH KRYSIAK — PART #2

How did that sidecar get there?

Secrets Management with Terraform

How To Get The Most Out Of Pen Tests

Chronicle is Now Available on Binance Smart Chain via ChainPort

Reflections from a CES Newbie

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Apache ShardingSphere

Apache ShardingSphere

Transform any DBMS in a distributed database system & enhance it with sharding, elastic scaling features & more. https://linktr.ee/ApacheShardingSphere

More from Medium

How to Katana — The yield machine on Solana • A deep dive

DCP: An EIP style Data Collaboration Public Infrastructure for Sharing and Co-building Web3 Open…

Articulation points in a graph

What Are Popular AI/ML Based Framework?

artificial intelligence