Skip to content

Always Encrypted seems to not work properly. #1656

Open
@amrock-my

Description

@amrock-my
  • MSSQL Extension Version: 1.90
  • VSCode Version: 1.43.2 (user setup)
  • OS Version: Windows_NT x64 10.0.18363

Steps to Reproduce:

  1. Create a connection where the connectionString uses Column Encryption Setting=Enabled.
  2. Execute a query against a table which has an encrypted column.
USE SampleDatabase
GO

SELECT * FROM TableWithEncryptedColumn

[8:02:17 PM] Started executing query at Line 1
Commands completed successfully.
[8:02:17 PM] Started executing query at Line 3
(3 rows affected)
Query was canceled by user
Total execution time: 00:00:00.053


Just for clarity, if I remove the Column Encryption Setting=Enabled portion from the connection string and execute the same query, I get results back, with the encrypted columns remaining encrypted.

[10:24:17 AM] Started executing query at Line 1
Commands completed successfully.
[10:24:17 AM] Started executing query at Line 3
(3 rows affected)
Total execution time: 00:00:00.055

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions