NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitadaaaca

committed

Make vacuumdb test regex more modular for its query output

This is in preparation for always using a catalog query to discovertables, where the ANALYZE and VACUUM queries get completed with relationnames.Author: Nathan BossartDiscussion:https://postgr.es/m/20190122060730.GD8719@paquier.xyz

1 parent4a8283d commitadaaacaCopy full SHA for adaaaca

File tree

1 file changed

-8

lines changed

src/bin/scripts/t
- 100_vacuumdb.pl

1 file changed

-8

lines changed

`‎src/bin/scripts/t/100_vacuumdb.pl`

Lines changed: 8 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -15,35 +15,35 @@`
`15`	`15`
`16`	`16`	`$node->issues_sql_like(`
`17`	`17`	`['vacuumdb','postgres' ],`
`18`		`-qr/statement: VACUUM;/,`
	`18`	`+qr/statement: VACUUM.*;/,`
`19`	`19`	`'SQL VACUUM run');`
`20`	`20`	`$node->issues_sql_like(`
`21`	`21`	`['vacuumdb','-f','postgres' ],`
`22`		`-qr/statement: VACUUM$FULL$;/,`
	`22`	`+qr/statement: VACUUM$FULL$.*;/,`
`23`	`23`	`'vacuumdb -f');`
`24`	`24`	`$node->issues_sql_like(`
`25`	`25`	`['vacuumdb','-F','postgres' ],`
`26`		`-qr/statement: VACUUM$FREEZE$;/,`
	`26`	`+qr/statement: VACUUM$FREEZE$.*;/,`
`27`	`27`	`'vacuumdb -F');`
`28`	`28`	`$node->issues_sql_like(`
`29`	`29`	`['vacuumdb','-zj2','postgres' ],`
`30`		`-qr/statement: VACUUM$ANALYZE$ pg_catalog\./,`
	`30`	`+qr/statement: VACUUM$ANALYZE$.*;/,`
`31`	`31`	`'vacuumdb -zj2');`
`32`	`32`	`$node->issues_sql_like(`
`33`	`33`	`['vacuumdb','-Z','postgres' ],`
`34`		`-qr/statement: ANALYZE;/,`
	`34`	`+qr/statement: ANALYZE.*;/,`
`35`	`35`	`'vacuumdb -Z');`
`36`	`36`	`$node->issues_sql_like(`
`37`	`37`	`['vacuumdb','--disable-page-skipping','postgres' ],`
`38`		`-qr/statement: VACUUM$DISABLE_PAGE_SKIPPING$;/,`
	`38`	`+qr/statement: VACUUM$DISABLE_PAGE_SKIPPING$.*;/,`
`39`	`39`	`'vacuumdb --disable-page-skipping');`
`40`	`40`	`$node->issues_sql_like(`
`41`	`41`	`['vacuumdb','--skip-locked','postgres' ],`
`42`		`-qr/statement: VACUUM$SKIP_LOCKED$;/,`
	`42`	`+qr/statement: VACUUM$SKIP_LOCKED$.*;/,`
`43`	`43`	`'vacuumdb --skip-locked');`
`44`	`44`	`$node->issues_sql_like(`
`45`	`45`	`['vacuumdb','--skip-locked','--analyze-only','postgres' ],`
`46`		`-qr/statement: ANALYZE$SKIP_LOCKED$;/,`
	`46`	`+qr/statement: ANALYZE$SKIP_LOCKED$.*;/,`
`47`	`47`	`'vacuumdb --skip-locked --analyze-only');`
`48`	`48`	`$node->command_fails(`
`49`	`49`	`['vacuumdb','--analyze-only','--disable-page-skipping','postgres' ],`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitadaaaca

File tree

1 file changed

1 file changed

`‎src/bin/scripts/t/100_vacuumdb.pl`

0 commit comments