Appendix with SQL operator

Unsupported SQL:

  • The case-insensitive queries are not supported by encrypted fields.
  • Comparison operations are not supported for encrypted fields, such as GREATER THAN, LESS THAN, ORDER BY, BETWEEN.
  • Calculation operations are not supported for encrypted fields, such as AVG, SUM, and computation expressions.
  • SQL that contains encrypt column in subquery and uses asterisks for outer projection is not supported.

Other:

  • You should keep encrypt columns, assisted columns and like columns in encrypt rule same capitalization with columns in database.