ClaireLytt commented on PR #38896: URL: https://github.com/apache/shardingsphere/pull/38896#issuecomment-4777035025
This PR fixes the SQL Server error **“Column name 'CountryRegionName' is invalid”** when running `UPDATE` on an encrypted view. ShardingSphere was not rewriting `CREATE VIEW` projections correctly, so the view was created with the logical column name instead of the cipher column. Later, `UPDATE ... SET CountryRegionName = ...` was sent to SQL Server with a column the physical view does not have. The change makes encrypt rewrite map logical columns to cipher columns in view definitions, so `UPDATE`/`SELECT` through the view works with encryption rules.   -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
