Use Norms

Supported

  • Hint based shadow algorithm support all SQL;
  • Column based shadow algorithm support part of SQL.

Unsupported

Hint based shadow algorithm

  • None

Column based shadow algorithm

  • Does not support DDL;
  • Does not support range, group and subquery, for example: BETWEEN, GROUP BY … HAVING…;

SQL support list:

  • INSERT
SQLSupported
INSERT INTO table (column,…) VALUES (value,…)Y
INSERT INTO table (column,…) VALUES (value,…),(value,…),…Y
INSERT INTO table (column,…) SELECT column1 from table1 where column1 = value1N
  • SELECT/UPDATE/DELETE
ConditionSQLSupported
=SELECT/UPDATE/DELETE … WHERE column = valueY
LIKE/NOT LIKESELECT/UPDATE/DELETE … WHERE column LIKE/NOT LIKE valueY
IN/NOT INSELECT/UPDATE/DELETE … WHERE column IN/NOT IN (value1,value2,…)Y
BETWEENSELECT/UPDATE/DELETE … WHERE column BETWEEN value1 AND value2N
GROUP BY … HAVING…SELECT/UPDATE/DELETE … WHERE … GROUP BY column HAVING column > valueN
SubquerySELECT/UPDATE/DELETE … WHERE column = (SELECT column FROM table WHERE column = value)N