Use Norms

Shadow database

Supported

  • The database is MySQL, Oracle, PostgreSQL, SQLServer;

Unsupported

  • NoSQL database;

Shadow algorithm

Supported

  • The note shadow algorithm supports MDL and DDL statements;
  • The column shadow algorithm basically supports commonly used MDL statements;

Unsupported

  • Column shadow algorithm does not support DDL statements；
  • The column shadow algorithm does not support range value matching operations, for example: subQuery, BETWEEN, GROUP BY … HAVING…;
  • Use shadow library function + sub-library sub-table function, some special SQL is not supported, please refer toSQL Usage Specification

Column shadow algorithm DML statement support list

  • INSERT statement

Judge the inserted column and inserted value of INSERT operation

OperationSQLSupport
INSERTINSERT INTO table (column,…) VALUES (value,…)true
INSERTINSERT INTO table (column,…) VALUES (value,…),(value,…),…true
INSERTINSERT INTO table (column,…) SELECT column1 from table1 where column1 = value1false
  • SELECT/UPDATE/DELETE statement

Judge the column and values included in the WHERE condition

ConditionSQLSupport
=SELECT/UPDATE/DELETE … WHERE column = valuetrue
LIKE/NOT LIKESELECT/UPDATE/DELETE … WHERE column LIKE/NOT LIKE valuetrue
IN/NOT INSELECT/UPDATE/DELETE … WHERE column IN/NOT IN (value1,value2,…)true
BETWEENSELECT/UPDATE/DELETE … WHERE column BETWEEN value1 AND value2false
GROUP BY … HAVING…SELECT/UPDATE/DELETE … WHERE … GROUP BY column HAVING column > value;false
subQuerySELECT/UPDATE/DELETE … WHERE column = (SELECT column FROM table WHERE column = value)false