Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Updating the name of an encrypted column does not update the corresponding column in the decrypted view #14

Open
joshenlim opened this issue Nov 30, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@joshenlim
Copy link
Member

joshenlim commented Nov 30, 2022

if i have an encrypted column named address, and i rename the column to address_new, the decrypted view's address and decrypted_address do not get updated

i also can’t delete the address_new column, as it throws the following error:
Failed to delete address_new: property cascade should not exist

@joshenlim joshenlim added the bug Something isn't working label Nov 30, 2022
@michelp
Copy link
Contributor

michelp commented Dec 5, 2022

This one is tricky because having the event fire for all ALTER TABLE statements might be overly aggressive, and we're not sure what other event triggers may be firing on the same event. I think we should wait and see what comes out of the work on adding support for JSON representation of the parsed SQL in a ddl_command_start trigger, that way we can fire the trigger, look at the parsed tree, and verify that we're only firing on tables that actually contain encrypted columns.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants