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

Run regresscheck on PG13 #2836

Merged
merged 9 commits into from Jan 29, 2021
Merged

Conversation

svenklemm
Copy link
Member

No description provided.

@svenklemm svenklemm force-pushed the pg13_regresscheck branch 3 times, most recently from aac875d to 6762faf Compare January 18, 2021 08:21
@codecov
Copy link

codecov bot commented Jan 18, 2021

Codecov Report

Merging #2836 (d769159) into master (99e450d) will increase coverage by 0.15%.
The diff coverage is n/a.

Impacted file tree graph

@@            Coverage Diff             @@
##           master    #2836      +/-   ##
==========================================
+ Coverage   90.08%   90.24%   +0.15%     
==========================================
  Files         212      212              
  Lines       34775    34725      -50     
==========================================
+ Hits        31326    31336      +10     
+ Misses       3449     3389      -60     
Impacted Files Coverage Δ
src/process_utility.c 93.86% <0.00%> (+0.12%) ⬆️
src/chunk_insert_state.c 97.67% <0.00%> (+0.46%) ⬆️
src/chunk_append/explain.c 83.07% <0.00%> (+1.53%) ⬆️
src/copy.c 87.39% <0.00%> (+1.62%) ⬆️
src/chunk_append/transform.c 96.66% <0.00%> (+6.66%) ⬆️
src/import/planner.c 70.30% <0.00%> (+11.12%) ⬆️

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update 99e450d...d769159. Read the comment docs.

@svenklemm svenklemm force-pushed the pg13_regresscheck branch 4 times, most recently from 55f8c10 to 2e494f8 Compare January 18, 2021 11:14
@svenklemm svenklemm force-pushed the pg13_regresscheck branch 3 times, most recently from fbd9e31 to 8b0c8f2 Compare January 26, 2021 03:04
@svenklemm svenklemm marked this pull request as ready for review January 26, 2021 07:41
@svenklemm svenklemm requested a review from a team as a code owner January 26, 2021 07:41
@svenklemm svenklemm requested review from erimatnor, k-rus, gayyappan, pmwkaa and mkindahl and removed request for a team January 26, 2021 07:42
Copy link
Contributor

@mkindahl mkindahl left a comment

Choose a reason for hiding this comment

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

I compared the output files for PG12 and PG13 to see that there were only benign changes. Here's a summary:

  • These tests are identical in PG12 and PG13: custom_type, multi_transaction_index, parallel, partition, chunk_adaptive, plan_hashagg, query, sql_query
  • These tests have new names in the plans, but otherwise match: delete, plan_expand_hypertable, plan_hypertable_inline, update
  • Test partitionwise have some changes in plans, please check below and verify that they are OK.
  • These tests have changes in error messages: constraint, ddl, insert

test/expected/partitionwise-13.out Show resolved Hide resolved
test/expected/partitionwise-13.out Show resolved Hide resolved
test/expected/partitionwise-13.out Show resolved Hide resolved
test/sql/include/join_query.sql Outdated Show resolved Hide resolved
PG13 adds the relation name to constraint errors making the output
differ from previous PG versions.
PG13 changes relation alias naming in EXPLAIN output making the
output different from previous versions.
PG13 changes relation alias naming in EXPLAIN output making the
output different from previous versions.
PG13 changes relation alias naming in EXPLAIN output making the
output different from previous versions.
PG13 changes the error message on constraint validation to include
the relation making the error message different from previous
PG versions.
PG13 adds the relation to constraint violation error messages making
the test output different from previous PG versions.
PG13 changes the relation name aliasing in EXPLAIN output making
explain output different from previous PG versions.
The order of relations of cluster is different on PG13 compared to
previous versions.
-----------------------------------------------------------------------------------------------------------------------------------------------------
Limit
Output: (time_func(_hyper_3_7_chunk."time")), _hyper_3_7_chunk.device, (avg(_hyper_3_7_chunk.temp))
-> GroupAggregate
Copy link
Contributor

Choose a reason for hiding this comment

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

I see some of the HashAggregate became GroupAggregates (for thsi file) in PG13. Do we need to set enable_hashagg = false here to ensure that plans will not change?

Copy link
Member Author

Choose a reason for hiding this comment

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

i think the groupagg plans are preferable and i think we dont care what type of aggregation postgres uses here and the test is already pg-version specific so it should be stable

Copy link
Contributor

@gayyappan gayyappan left a comment

Choose a reason for hiding this comment

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

Looks good. Have a question about 1 of the tests.

@svenklemm svenklemm merged commit 04d614e into timescale:master Jan 29, 2021
@svenklemm svenklemm deleted the pg13_regresscheck branch April 18, 2021 14:06
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

3 participants