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

Add VERSION to the xx_LOGICAL_RESOURCES #2109

Closed
lmsurpre opened this issue Mar 18, 2021 · 3 comments
Closed

Add VERSION to the xx_LOGICAL_RESOURCES #2109

lmsurpre opened this issue Mar 18, 2021 · 3 comments
Assignees
Labels
schema-change a schema change

Comments

@lmsurpre
Copy link
Member

lmsurpre commented Mar 18, 2021

Is your feature request related to a problem? Please describe.
For 4.6.0 we introduced IS_DELETED and LAST_UPDATED columns to the xx_LOGICAL_RESOURCES tables.
But when we went to use these in #1385 we realized that we'd also like the LATEST_VERSION in this table as well.

This could prevent some joins in the case of include/revinclude queries.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Acceptance Criteria
1.
GIVEN [a precondition]
AND [another precondition]
WHEN [test step]
AND [test step]
THEN [verification step]
AND [verification step]

Additional context
Add any other context or screenshots about the feature request here.

@lmsurpre lmsurpre added the schema-change a schema change label Mar 18, 2021
@kmbarton423 kmbarton423 added this to the Sprint 2021-04 milestone Mar 18, 2021
@kmbarton423
Copy link
Contributor

stretch goal for 4.6.1

@prb112
Copy link
Contributor

prb112 commented Mar 23, 2021

I can confirm the version_id is in the db2 describe of the logical_resources table, and has been populated properly.

@prb112 prb112 closed this as completed Mar 23, 2021
@lmsurpre
Copy link
Member Author

I also confirmed the same on a postgresql database with ~10M resources.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
schema-change a schema change
Projects
None yet
Development

No branches or pull requests

4 participants