Limitations.En

+++ title = "Limitations" weight = 2 +++

Hint based shadow algorithm

No

Column based shadow algorithm

SQL does not support lists：

• Does not support DDL.

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

SQL support list

• INSERT

SQL	support 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 = value1	do not support

• SELECT/UPDATE/DELETE

condition categories	SQL	support or not
=	SELECT/UPDATE/DELETE ... WHERE column = value	support
LIKE/NOT LIKE	SELECT/UPDATE/DELETE ... WHERE column LIKE/NOT LIKE value	support
IN/NOT IN	SELECT/UPDATE/DELETE ... WHERE column IN/NOT IN (value1,value2,...)	support
BETWEEN	SELECT/UPDATE/DELETE ... WHERE column BETWEEN value1 AND value2	do not support
GROUP BY ... HAVING...	SELECT/UPDATE/DELETE ... WHERE ... GROUP BY column HAVING column > value	do not support
Sub Query	SELECT/UPDATE/DELETE ... WHERE column = (SELECT column FROM table WHERE column = value)	do not support