Connections not reflecting new columns after plugin update

[pskrbasu]

User Context:

Had an old version of the turbot/aws plugin. v0.93 . I then created a connection, did my query etc. I upgraded the plugin to v0.96 (latest) expecting these two new columns in the aws_s3_bucket table: object_ownership_controls and website_configuration. The columns didn’t show up. I had to remove my connection, and add it again and only then the column shows up. See below:

> select object_ownership_controls from art1.aws_s3_bucket;
+---------------------------+
| object_ownership_controls |
+---------------------------+
| <null>                    |
| <null>                    |
| <null>                    |
| <null>                    |
| <null>                    |
+---------------------------+

> select object_ownership_controls from art2.aws_s3_bucket;
Error: column "object_ownership_controls" does not exist (SQLSTATE 42703)

art1 -> connection that I removed and added back, the new column shows up art2 -> existing connection, the new column isn’t there

Reproduction steps tried:

Attempt1:

• install aws - has only 1 conn aws
• install [email protected]
• install [email protected]
• replace the binary in aws@latest with the binary in [email protected]
• query the new column with conn aws - column does not exist
• replace the binary in aws@latest with the binary in [email protected]
• query the new column with conn aws - column exists

Attempt2:

• install aws - has only 1 conn aws
• make v0.93.0
• query the new column with conn aws - column does not exist
• make v0.96.0
• query the new column with conn aws - column exists

Neither of the steps worked. This issue needs to be reproduced.

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.