Skip to content

Conversation

@erezrokah
Copy link
Member

@erezrokah erezrokah commented Feb 21, 2023

Summary

Same as #7819 for MSSQL.

This is a breaking change due to the type change from datetimeoffset to datetime2 as we don't want to save time zone offset, see

return "timestamp without time zone"

I suggest following the code in an IDE as it's hard to understand the changes from the diff.

BEGIN_COMMIT_OVERRIDE
feat(deps): Update MSSQL plugin-sdk to v1.38.2

BREAKING-CHANGE: Update MSSQL plugin-sdk to v1.38.2. You'll need to drop the database and start fresh due to a change in the schema for all timestamp columns from datetimeoffset to datetime2.
END_COMMIT_OVERRIDE

@cq-bot cq-bot added the mssql label Feb 21, 2023
[_cq_parent_id] uniqueidentifier,
[_cq_source_name] nvarchar(4000),
[_cq_sync_time] datetimeoffset,
[_cq_sync_time] datetime2,
Copy link
Member Author

@erezrokah erezrokah Feb 21, 2023

Choose a reason for hiding this comment

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

datetimeoffset saves the time zone information so if we write a time.Time and then read it the time zone information gets added and we get a different value than the original (see comment in PR description and

return "timestamp without time zone"

Copy link
Contributor

Choose a reason for hiding this comment

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

@erezrokah erezrokah marked this pull request as ready for review February 21, 2023 12:42
@erezrokah erezrokah requested review from a team, candiduslynx and yevgenypats and removed request for a team February 21, 2023 12:42
@erezrokah erezrokah force-pushed the feat/update_mssql_sdk branch from de4c7d3 to f7f5cc8 Compare February 21, 2023 12:54
[_cq_parent_id] uniqueidentifier,
[_cq_source_name] nvarchar(4000),
[_cq_sync_time] datetimeoffset,
[_cq_sync_time] datetime2,
Copy link
Contributor

Choose a reason for hiding this comment

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

[_cq_parent_id] uniqueidentifier,
[_cq_source_name] nvarchar(4000),
[_cq_sync_time] datetimeoffset,
[_cq_sync_time] datetime2,
Copy link
Contributor

Choose a reason for hiding this comment

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

Copy link
Contributor

@candiduslynx candiduslynx left a comment

Choose a reason for hiding this comment

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

I'm OK with the changes, however, I think we need to address cloudquery/plugin-sdk#700 prior to merging this

@erezrokah erezrokah changed the title feat(deps)!: Update MSSQL plugin-sdk to v1.38.2 feat(deps)!: Update MSSQL plugin-sdk to v1.39.0 Feb 22, 2023
@erezrokah erezrokah force-pushed the feat/update_mssql_sdk branch from 2cc6640 to b442896 Compare February 22, 2023 17:36
@erezrokah
Copy link
Member Author

@candiduslynx small follow up in b442896 (still needs the UTC fix though)

@erezrokah erezrokah changed the title feat(deps)!: Update MSSQL plugin-sdk to v1.39.0 feat(deps)!: Update MSSQL plugin-sdk to v1.39.1 Feb 22, 2023
@erezrokah erezrokah force-pushed the feat/update_mssql_sdk branch from c610cf2 to 99235be Compare February 27, 2023 09:50
@erezrokah
Copy link
Member Author

@candiduslynx 99235be is related to #8436

@erezrokah
Copy link
Member Author

@candiduslynx see cloudquery/plugin-sdk#716. I think the impact of cloudquery/plugin-sdk#700 is not that big

@erezrokah erezrokah added the automerge Automatically merge once required checks pass label Feb 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

automerge Automatically merge once required checks pass

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants