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.