We are currently using Always Encrypted with Enclaves in MSSQL 2022. The column encryption option chosen is randomized.
Please refer to the following link: https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-enclaves?view=sql-server-ver16
When trying to perform statistical analysis on encrypted column data using Group By, an error occurs stating that the column must use deterministic encryption in order to use Group By. Is this a bug?
The same issue occurs with Distinct.
I tried switching to deterministic encryption, and the above two DML operations worked fine. However, this contradicts the documentation.
New contributor
1