Add test doing some cloning of extended statistics data
Michael Paquier <michael@paquier.xyz>
Add test doing some cloning of extended statistics data The test added in this commit copies the data of an ANALYZE run on one relation to a secondary relation with the same attribute definitions and extended statistics objects. Once the clone is done, the target and origin should have the same extended statistics information, with no differences. This test would have been able to catch e3094679b983, for example, as we expect the full range of statistics to be copied over, with no differences generated between the results of an ANALYZE and the data copied to the cloned relation. Note that this new test should remain at the bottom of stats_import.sql, so as any additions in the main relation and its clone are automatically covered when copying their statistics, so as it would work as a sanity check in the future. Author: Corey Huinker <corey.huinker@gmail.com> Reviewed-by: Michael Paquier <michael@paquier.xyz> Discussion: https://postgr.es/m/CADkLM=dpz3KFnqP-dgJ-zvRvtjsa8UZv8wDAQdqho=qN3kX0Zg@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/stats_import.out | modified | +65 −0 |
| src/test/regress/sql/stats_import.sql | modified | +55 −0 |
Discussion
- Extended Statistics set/restore/clear functions. 140 messages · 2025-01-22 → 2026-01-29