Skip to content

Fix surrogate PK ordering#681

Merged
gruuya merged 6 commits intomasterfrom
fix-lq-surrogate-pk-ordering-cu-2jech8y
Jun 6, 2022
Merged

Fix surrogate PK ordering#681
gruuya merged 6 commits intomasterfrom
fix-lq-surrogate-pk-ordering-cu-2jech8y

Conversation

@gruuya
Copy link
Contributor

@gruuya gruuya commented Jun 3, 2022

When performing LQ on a table without PKs, we need to ensure that the surrogate PKs that we use
(the string representation of the entire row) is properly ordered. Otherwise we will end up with some
objects being wrongly categorised as singletons as opposed to being grouped together, which will
lead to wrong query results.

When performing LQ on a table without PKs, we need to ensure that the surrogate PKs that we use
(the string representation of the entire row) is properly ordered. Otherwise we will end up with some
objects being wrongly categorised as singletons as opposed to being grouped together, which will
lead to wrong query results.
@gruuya gruuya requested a review from mildbyte June 3, 2022 09:17
@gruuya gruuya self-assigned this Jun 3, 2022
gruuya added 2 commits June 3, 2022 11:37
If MINIO_CI_CD is not to true Minio container just exits with "Error: Disk `/tmp` is part of root disk, will not be used" and all related tests fail.

In addition change the deprecated cred env var names.

if layered:
self.lq_checkout()
self.lq_checkout(ddn_layout=ddn_layout)
Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Since we've split the read and write shim schemas there's no use in having different overlay layout between cli (_sgov_lower_my_table foreign table, my_table view, _sgov_upper_my_table helper table) and ddn (my_table foreign table, _sgov_merged_my_table view, _sgov_upper_my_table helper table) now in theory.

Even if we decide to try and re-use those schemas to serve up some reads from them, we would need to keep track of the dirty tables. Since the target table is a dirty table (changed after executing the write), we would need to re-mount a clean shim schema anyway.

@gruuya gruuya merged commit 2e52324 into master Jun 6, 2022
@gruuya gruuya deleted the fix-lq-surrogate-pk-ordering-cu-2jech8y branch June 6, 2022 13:27
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants