Limitations

Hint based shadow algorithm

No

Column based shadow algorithm

Does not support DDL.

Does not support scope, group, subqueries such as BETWEEN, GROUP BY … HAVING, etc.

SQL support list

  • INSERT
SQLsupport or not
INSERT INTO table (column,…) VALUES (value,…)support
INSERT INTO table (column,…) VALUES (value,…),(value,…),…support
INSERT INTO table (column,…) SELECT column1 from table1 where column1 = value1do not support
  • SELECT/UPDATE/DELETE
condition categoriesSQLsupport or not
=SELECT/UPDATE/DELETE … WHERE column = valuesupport
LIKE/NOT LIKESELECT/UPDATE/DELETE … WHERE column LIKE/NOT LIKE valuesupport
IN/NOT INSELECT/UPDATE/DELETE … WHERE column IN/NOT IN (value1,value2,…)support
BETWEENSELECT/UPDATE/DELETE … WHERE column BETWEEN value1 AND value2do not support
GROUP BY … HAVING…SELECT/UPDATE/DELETE … WHERE … GROUP BY column HAVING column > valuedo not support
Sub QuerySELECT/UPDATE/DELETE … WHERE column = (SELECT column FROM table WHERE column = value)do not support