v4-0001-Adjust-vacuumdb-test-regex-in-preparation-for-alw.patch
application/octet-stream
Filename: v4-0001-Adjust-vacuumdb-test-regex-in-preparation-for-alw.patch
Type: application/octet-stream
Part: 0
Message:
Re: A few new options for vacuumdb
Patch
Format: format-patch
Series: patch v4-0001
Subject: Adjust vacuumdb test regex in preparation for always using a catalog query to discover tables.
| File | + | − |
|---|---|---|
| src/bin/scripts/t/100_vacuumdb.pl | 8 | 8 |
From 1cdbe18297a1225a1f8665fef4e9b7f4cbf68368 Mon Sep 17 00:00:00 2001 From: Nathan Bossart <bossartn@amazon.com> Date: Tue, 22 Jan 2019 22:33:07 +0000 Subject: [PATCH v4 1/3] Adjust vacuumdb test regex in preparation for always using a catalog query to discover tables. --- src/bin/scripts/t/100_vacuumdb.pl | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/src/bin/scripts/t/100_vacuumdb.pl b/src/bin/scripts/t/100_vacuumdb.pl index 7cb2542e47..951202b40e 100644 --- a/src/bin/scripts/t/100_vacuumdb.pl +++ b/src/bin/scripts/t/100_vacuumdb.pl @@ -15,35 +15,35 @@ $node->start; $node->issues_sql_like( [ 'vacuumdb', 'postgres' ], - qr/statement: VACUUM;/, + qr/statement: VACUUM.*;/, 'SQL VACUUM run'); $node->issues_sql_like( [ 'vacuumdb', '-f', 'postgres' ], - qr/statement: VACUUM \(FULL\);/, + qr/statement: VACUUM \(FULL\).*;/, 'vacuumdb -f'); $node->issues_sql_like( [ 'vacuumdb', '-F', 'postgres' ], - qr/statement: VACUUM \(FREEZE\);/, + qr/statement: VACUUM \(FREEZE\).*;/, 'vacuumdb -F'); $node->issues_sql_like( [ 'vacuumdb', '-zj2', 'postgres' ], - qr/statement: VACUUM \(ANALYZE\) pg_catalog\./, + qr/statement: VACUUM \(ANALYZE\).*;/, 'vacuumdb -zj2'); $node->issues_sql_like( [ 'vacuumdb', '-Z', 'postgres' ], - qr/statement: ANALYZE;/, + qr/statement: ANALYZE.*;/, 'vacuumdb -Z'); $node->issues_sql_like( [ 'vacuumdb', '--disable-page-skipping', 'postgres' ], - qr/statement: VACUUM \(DISABLE_PAGE_SKIPPING\);/, + qr/statement: VACUUM \(DISABLE_PAGE_SKIPPING\).*;/, 'vacuumdb --disable-page-skipping'); $node->issues_sql_like( [ 'vacuumdb', '--skip-locked', 'postgres' ], - qr/statement: VACUUM \(SKIP_LOCKED\);/, + qr/statement: VACUUM \(SKIP_LOCKED\).*;/, 'vacuumdb --skip-locked'); $node->issues_sql_like( [ 'vacuumdb', '--skip-locked', '--analyze-only', 'postgres' ], - qr/statement: ANALYZE \(SKIP_LOCKED\);/, + qr/statement: ANALYZE \(SKIP_LOCKED\).*;/, 'vacuumdb --skip-locked --analyze-only'); $node->command_fails( [ 'vacuumdb', '--analyze-only', '--disable-page-skipping', 'postgres' ], -- 2.16.5