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

bug: default test TargetSchemaUpdates fails column 'A3' already exists #43

Closed
pnadolny13 opened this issue Jun 5, 2023 · 0 comments · Fixed by #45
Closed

bug: default test TargetSchemaUpdates fails column 'A3' already exists #43

pnadolny13 opened this issue Jun 5, 2023 · 0 comments · Fixed by #45
Assignees

Comments

@pnadolny13
Copy link
Contributor

The test data https://github.com/meltano/sdk/blob/main/singer_sdk/testing/target_test_streams/schema_updates.singer tries to alter the schema of the table multiple times, each time adding a few records. The test is failing because it tries to add a column that already exists. I suspect its an upper/lower case issue related to comparing what exists.

column 'A3' already exists", 'query': 'ALTER TABLE MELTANOLABS_RAW.TARGET_SNOWFLAKE_685220.TEST_SCHEMA_UPDATES ADD COLUMN a3 BOOLEAN', ...
pnadolny13 added a commit that referenced this issue Jun 6, 2023
Closes #28

- implements a fix for the test suites not running properly, also added
it to the SDK meltano/sdk#1749
- implements a lot of the default test validates methods to make asserts
- comment out the tests that fail for legitimate bugs
- logged the bugs
  - #43
  - #41
  - #40
- I also logged
#42 because I
wrote a test to assert the exception but I'm not actually sure if we
want that behavior or not

---------

Co-authored-by: Ken Payne <[email protected]>
@pnadolny13 pnadolny13 self-assigned this Jun 7, 2023
@pnadolny13 pnadolny13 moved this from Todo to In Progress in MeltanoLabs Overview Jun 7, 2023
pnadolny13 added a commit that referenced this issue Jun 8, 2023
Closes #43

It turns out that this test had been fixed by other changes. I suspect
it was part of #39.
Previously I had implemented a way to cache table properties but I
suspect that the cache was not being invalidated when the schema updated
so it was attempting to recreate an existing column since it didnt find
it in the cache.
@github-project-automation github-project-automation bot moved this from In Progress to Done in MeltanoLabs Overview Jun 8, 2023
@github-project-automation github-project-automation bot moved this to Planned in Data Team Jun 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

1 participant