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

Multi-active satellite: NULL rows not correctly identified #97

Open
tkirschke opened this issue Jul 18, 2023 Discussed in #96 · 1 comment
Open

Multi-active satellite: NULL rows not correctly identified #97

tkirschke opened this issue Jul 18, 2023 Discussed in #96 · 1 comment
Labels
bug Something isn't working stale

Comments

@tkirschke
Copy link
Member

Discussed in #96

Originally posted by cmettler July 17, 2023
Hey Scalefree Team,
i am finishing a sqlserver adapter based on the previous sqlserver branch. I am trying to understand the ma sat template from the other adapters.
if i understand the template code + remarks correct the hashdiff should be something like the attached sample sql queries.

All three queries would create the same hashhdiff but for different ma groups. The delta check would not work.
But if i include the multi active key in the payload the hashdiffs would be different for the delta check to work.
I think this should be documented in the wiki or the ma keys automatically added to the hashdiff calc if not explicitly added in the src_payload. Or did i miss something else ?
Kind Regards,
Christoph
masat.sql.txt

To-Do: Change Multi Active Hashdiff calculation to properly identify NULL rows. Do that, by replacing the "NULLIF" around the "CONCAT()" by a "REPLACE()" to avoid NULL input to STRING_AGG() and LISTAGG().

@bschlottfeldt bschlottfeldt added the bug Something isn't working label Sep 13, 2023
Copy link

github-actions bot commented Jul 8, 2024

This issue is stale because it has been open for 90 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue. Otherwise it will be closed in 14 days

@github-actions github-actions bot added the stale label Jul 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working stale
Projects
None yet
Development

No branches or pull requests

2 participants