We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Hello there!
Imagine I have a temporal table for personal information:
at T1 I run a schema migration and add a new column, from now on the table has:
Then at T2 I run another schema migration and change the data type of main_document to NUMBER.
Then at T3 I run another schema migration and remove the genre column
Then at T4 I run another schema migration and add the genre column, but now it has the data type NUMBER.
How can I query my DB (going back in time) without breaking my existing queries? SQL:2016
Are there any best practices or strategies to avoid all this complexity with these temporal tables + schema migration?
Any help would be much appreciated.
P.S: I didn't find the RIGHT place to post a question to the community. If that's the wrong place, please feel free to remove it. (sorry)
Thanks
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Hello there!
Imagine I have a temporal table for personal information:
at T1 I run a schema migration and add a new column, from now on the table has:
Then at T2 I run another schema migration and change the data type of main_document to NUMBER.
Then at T3 I run another schema migration and remove the genre column
Then at T4 I run another schema migration and add the genre column, but now it has the data type NUMBER.
How can I query my DB (going back in time) without breaking my existing queries? SQL:2016
Are there any best practices or strategies to avoid all this complexity with these temporal tables + schema migration?
Any help would be much appreciated.
P.S: I didn't find the RIGHT place to post a question to the community. If that's the wrong place, please feel free to remove it. (sorry)
Thanks
The text was updated successfully, but these errors were encountered: