Skip to content

Validate position-date matching after the migration rewrite #464

Open

Description

@lewismc

@renato2099

From the review of PR 437 (comment):

ideally this should have been it's own separate PR such that we can really validate that the results we are getting are consistent, I am also ok letting this part go in and coming back to it later on

sp_execute_data_migration now builds migration_position_match and updates data_time_series, data_histogram_bin_data, and data_profile from it (around line 1390 of services/postgis/tagbase_schema.sql). The old form was three correlated UPDATEs. Confirm the new match returns the same position_date_time values. The same SQL is copied in services/postgis/tagbase_schema_tables.sql.

Activity

  1. added
    testsUnit, Systems Intgration or User Acceptance Testing
    on Oct 18, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    testsUnit, Systems Intgration or User Acceptance Testing

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions