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.

Sign up for GitHub

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

Jump to bottom

MariaDB System versioning #30

Open
Nefarious46 opened this issue Jan 9, 2024 · 1 comment
Open

MariaDB System versioning #30

Nefarious46 opened this issue Jan 9, 2024 · 1 comment
Assignees
@Nefarious46
Labels
Specification Required by software specifications

Comments

@Nefarious46
Copy link
Contributor

Description

Tables require system versioning to track changes in data.
@Nefarious46 Nefarious46 self-assigned this Jan 9, 2024
@Nefarious46 Nefarious46 added the Specification Required by software specifications label Jan 9, 2024
@Nefarious46
Copy link
Contributor Author

Testing how system versioning behaves by deleting and creating records with exact same ID and string.

id test_column row_start row_end
1 one 2024-03-13 13:52:49.867586 2024-03-13 13:53:03.394221
1 one 2024-03-13 13:53:04.750405 2038-01-19 03:14:07.999999
3 three 2024-03-13 13:52:51.387080 2038-01-19 03:14:07.999999
2 two 2024-03-13 13:52:50.761275 2038-01-19 03:14:07.999999

Active row always carries the same "row_end" timestamp.
If row is deleted then "row_end" displays deletion timestamp.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Nefarious46 Nefarious46

Labels
Specification Required by software specifications
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Nefarious46