Appendix.En

+++ title = "Appendix with SQL operator" weight = 3 +++

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.
• SQL that contains encrypt column in WITH is not supported.
• SQL that contains encrypt column in INSERT SELECT is not supported.
• SQL that contains encrypt column in UNION, INTERSECT, and EXCEPT statements is not supported.

Other:

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