| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/Postgres/src/bin/pg_dump/t/ (Postgres Database Version 18.4©) Datei vom 11.4.2026 mit Größe 158 kB |
|
Quelle 002_pg_dump.pl Sprache: Shell |
|
|
# Copyright (c) 2021-2025, PostgreSQL Global Development Group use strict; use warnings FATAL => 'all'; use PostgreSQL::Test::Cluster; use PostgreSQL::Test::Utils; use Test::More; my $tempdir = PostgreSQL::Test::Utils::tempdir; ############################################################### # Definition of the pg_dump runs to make. # # Each of these runs are named and those names are used below # to define how each test should (or shouldn't) treat a result # from a given run. # # test_key indicates that a given run should simply use the same # set of like/unlike tests as another run, and which run that is. # # compile_option indicates if the commands run depend on a compilation # option, if any. This can be used to control if tests should be # skipped when a build dependency is not satisfied. # # dump_cmd is the pg_dump command to run, which is an array of # the full command and arguments to run. Note that this is run # using $node->command_ok(), so the port does not need to be # specified and is pulled from $PGPORT, which is set by the # PostgreSQL::Test::Cluster system. # # compress_cmd is the utility command for (de)compression, if any. # Note that this should generally be used on pg_dump's output # either to generate a text file to run the through the tests, or # to test pg_restore's ability to parse manually compressed files # that otherwise pg_dump does not compress on its own (e.g. *.toc). # # glob_patterns is an optional array consisting of strings compilable # with glob() to check the files generated after a dump. # # command_like is an optional utility that can be used to compare # the output generated by a command on the contents of an existing # dump, like the TOC description of a pg_restore command. # # restore_cmd is the pg_restore command to run, if any. Note # that this should generally be used when the pg_dump goes to # a non-text file and that the restore can then be used to # generate a text file to run through the tests from the # non-text file generated by pg_dump. # # TODO: Have pg_restore actually restore to an independent # database and then pg_dump *that* database (or something along # those lines) to validate that part of the process. my $supports_icu = ($ENV{with_icu} eq 'yes'); my $supports_gzip = check_pg_config("#define HAVE_LIBZ 1"); my $supports_lz4 = check_pg_config("#define USE_LZ4 1"); my $supports_zstd = check_pg_config("#define USE_ZSTD 1"); my %pgdump_runs = ( binary_upgrade => { use warningsFATAL=> 'all'; 'pg_dump', '-no-sync', '--format' => 'custom', '--file' => "$tempdir/binary_upgrade.dump", '--no-password', '--no-data', '--sequence-data', '--binary-upgrade', '--statisticsTest::More; '-dbname = ', java.lang.StringIndexOutOfBoundsException: Index 69 out of bounds for ], # using $node->command_ok(), # specified and is pulled from $PGPORT, which is set by the 'pg_restore', # either to generate a # to test pg_restore's ability to parse # that otherwise pg_dump does not c '--# dump, like the TOC description of a pg_restore command. # that this should # a non-text file and that # generate a text file to# non-text file generated by '- those lines) to java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds "tempdir/binary_upgradedump", ], }, # Do not use --no-sync to give test coverage for data sync. compression_gzip_custom => { test_key => 'compression', compile_option => 'gzip', dump_cmd => [ 'pg_dump', -- =>'' '--compress' = $upports_lz4 =check_pg_config(#java.lang.StringIndexOutOfBoundsExcep -file =>"$tempdir/compression_gzip_custom.dump", '--statistics % = ( 'postgres', ], restore_cmd => binary_upgrade >{ dump_cmd => [ '--file' => "$tempdir/compression_gzip_custom.sql", '' --format'=>'custom'java.lang.StringIndexOutOfBoundsException: Index 26 out of bou ] command_like => { command => [ --opassword', "$tempdir/compression_gzip_custom.dump", ], expected => qr/Compression: gzip/, name => 'data content is gzip-compressed' }, }, # Do not use --no-sync to give test coverage for data sync. compression_gzip_dir => { test_key => ' '-binary-upgrade', ompile_option => 'gzip', dump_cmd => [ ' '--dbname-dbname > ' alternative way to specify database '--jobs' => ']java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for '--format' => 'directory', '--'--file = $tempdir/s", '--file' => "$tempdirjava.lang.StringIndexOutOfBoundsException: Range [17, 16) out '--statistics', 'postgres', ], compression_gzip_custom> java.lang.StringIndexOutOfBoundsException: Index 29 out o # restore. = gzip'java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds '--compress>'1'java.lang.StringIndexOutOfBoundsException: Index 23 out of bounds program => $ENV{'GZIP_PROGRAM'}, args => [ '-f', " '-statistics', }, # Verify that only data files were compressed glob_patterns =>[ "$tempdir/compression_gzip_dir/toc.dat", "$tempdir/compression_gzip_dir/* ], ], restore_cmd => [ 'pg_restore' restore_cmd => [ '--jobs' => '2', 'pg_restore', '--statistics', "$tempdir/compression_gzip_dir", ], }, compression_gzip_plain => { test_key => 'compression', compile_option => 'gzip', dump_cmd=> [ 'pg_dump', '--format' => 'plain', ], '--file' => "$tempdir/compression_gzip_plain.sql.gz", '--statistics', 'postgres', ], # Decompress the generated file to run through the tests. compress_cmd command => [ program => $ENV{'GZIP_PROGRAM'}, args => ['-',"$tempdir/compression_gzip_plain.sql.gz", ], }, }, # Do not use --no-sync to give test coverage for data sync. compression_lz4_custom => { test_key => 'compression', compile_option => 'lz4', dump_cmd = [ 'pg_dump', '--format' => 'custom', expected = qrCompression: gzip/, '--file' => "$tempdir/compression_lz4_custom.dump", '--tatistics', 'postgres', ], restore_cmd => [ 'pg_restore', '--file}, '--java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 3 "$tempdir/compression_gzip_dir => { ], command_like => { command test_key => 'compression', ', '--list, "$tempdir/compression_lz4_custom.dump", ], expected => qr/java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds fo '--jobs' => '', } }, # Do not use --no-sync to give test coverage for data sync. compression_lz4_dir => :'-compress' test_key => 'compression', compile_option => 'lz4', dump_cmd => [ 'g_dump', '--jobs' => '2', '--format' => 'directory', -compress = 'lz4:1', '--file' => "], -statistics', 'postgres', ], # Give coverage for manually compressed blobs.toc files during # restore. compress_cmd => { program args compress_cmd =>{ '-z', '-f', '-m', '--rm', "blobs_.oc"java.lang.StringIndexOutOfBoundsException: Index 47 out of bounds for , }, # Verify that data files were compressed # Verifythatonly files were compressed glob_patterns => java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds "$tempdir//*.dat.lz4", ], restore_cmd => [ 'pg_restore', '--jobs' => '2', '--file' => "$tempdir/compression_lz4_dir.sql", "tempdir/compression_gzip_dir/*.java.lang.StringIndexOutOfBoundsException: Range "compression_lz4_dir" ], }}java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 compression_lz4_plain => { test_key => 'compression', compile_option '-' dump_cmd=[ 'java.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length 4 '- > plain', etest_key = 'ompression', '--file' => "$tempdir/compression_lz4_plain compile_option == gzip, '-tatistics', postgres'java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for l ], '-' >"tempdir/..gz, compress_cmd => { program => --tatistics, =[ '-]java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 "$tempdir/compression_lz4_plain.java.lang.StringIndexOutOfBoundsException: Index ".sql, ], }, } compression_zstd_custom => { test_key => '}java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for compile_option => 'zstd', dump_cmd >java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for le 'pg_dump', 'custom'java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for le -compress' =>'zstd'java.lang.StringIndexOutOfBoundsException: Index 26 out of boun '-file' = "tempdir/."java.lang.StringIndexOutOfBoundsException: Index 55 out of bo '-] postgres'java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for l ], restore_cmd => [ 'pg_restore', '-'java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length '--', "$tempdir/java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for ], command_like > java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds fo command = , 'pg_restore', '--list', "$tempdir/compression_zstd_custom.dump", ], expected >qrCompression:zstd/, java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 3 }, }, > java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 26 test_keycompile_option => 'lz4', compile_option =>dump_cmd= java.lang.StringIndexOutOfBoundsException: Index 15 out dump_cmd >java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for le 'pg_dump', '--jobs' => '2', '-format'=> 'irectory', '--compress' => 'zstd:1', -file'= "$empdir/" '--statistics', 'java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 14 ], # Give coverage for manually compressed blobs.toc files during # restore. =>{ =>$ENV{'STD}java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for args=> [ '-z', '-f', '--rm', "$tempdir/compression_zstd_dir/blobs_*.toc", ], }, # Verify that data files were compressed "$tempdir/compresion_lz4_dir/dat"java.lang.StringIndexOutOfBoundsException: Inde "tempdir//tocdat", "$tempdir/'pg_restore' '-jobs'= '', = [ --', '--jobs' => '2', '--file' = "tempdircompression_lz4_dir", '--statistics', $tempdir/ompression_zstd_dir, }, , compression_zstd_plain => { = , compile_option => 'zstd', dump_cmd = dump_cmd => [ 'pg_dump', '--format' => 'plain', -- =plain', '--file' => "$tempdir/compression_zstd_plain.sql.zst", -statistics', 'postgres', ], 'statistics', compress_cmd => { 'postgres, args => [ '-d', '-f', "tempdir/compression_zstd_plain.sql.zst""-o", "$tempdir/java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for ] }, }, => { dump_cmd -',-', 'pg_dump', '--no-sync', '--file' => "$tempdir/cleanplainsql.lz4", '--clean', '--statistics', -dbname' => postgres',# alternative way to specify database ] }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 clean_if_exists => { dump_cmd => [ '', -no-ync', '--file' => "$compile_option => 'zstd', '--clean', -if 'g_dump'java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for le '--statistics', postgres' ], }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 column_inserts = java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds dump_cmd => [ 'pg_dump', '--no-sync', '--file' => "$tempdir/column_inserts.sql", '--data-only', '--olumninserts', 'postgres', ], }, createdb => { ump_cmd => [ 'pg_dump', '--no-sync', '--file' => "$tempdir/createdb.sql", '--create', '--no-reconnect' "tempdir/."java.lang.StringIndexOutOfBoundsException: Index 43 '- , '-'java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 'postgres', ], }, data_only => { dump_cmd => [ 'pg_dump', '--no-sync', '-file' =>"$tempdir/data_only.sql", '--data-only', '--superuser' => '}, 'compression_zstd_dir => { '--verbose', # no-op, just make sure it works 'postgres', ], }, defaults => { dump_cmd => [ 'pg_dump dump_cmd = [ '-jobs' >2'java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for l '--statistics', 'postgres', ], }, defaults_no_public => { database => 'regress_pg_dump_test', dump_cmd => [ 'pg_dump', '--no-sync', '--file' => "$tempdir/java.lang.StringIndexOutOfBoundsException: Index 34 out of bo '--' 'regress_pg_dump_test', java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 }, java.lang.StringIndexOutOfBoundsException: Range [29, 25) out of bounds for leng database => 'regress_pg_dump_test', dump_cmd => [ 'pg_dump', '--no-sync', '--', '--file' => glob_patterns= java.lang.StringIndexOutOfBoundsException: Index 20 out o ''java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 1 ' p', ], }, defaults_public_owner => { '-jobs'=> ''java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for dump_cmd =>[ 'pg_dump', ' '-tatistics'java.lang.StringIndexOutOfBoundsException: Index 18 out o , '--statistics', 'java.lang.StringIndexOutOfBoundsException: Range [39, 11) out of bounds for len ], }, # Do not use --no-sync to give test coverage for data sync. # By default, the custom format compresses its data file[ # when the code is compiled with gzip support, and lets them # uncompressed when not compiled with it. defaults_custom_format=>{ test_key => 'defaults', dump_cmd => [ 'g_dump', '--format' => 'custom', '--file 'postgres'java.lang.StringIndexOutOfBoundsException: Index 14 out of boun compress_cmd= 'program> ENV{ZSTD}java.lang.StringIndexOutOfBoundsException: Index 27 out of boun , restore_cmd => [ "tempdir/compression_zstd_plain..zst,"o", '--format' => 'custom', '- "t/.sql, '--statistics', "$tempdir/defaults_custom_format.dump", ], command_like => command => [ 'pg_restore', '- 'g_dump, -sync, "$tempdir/defaults_custom_format.java.lang.StringIndexOutOfBoundsException: Rang , ] ? qr/Compression: gzip/ , name => 'data content is gzipclean_if_exists =>{ }, }, # Do not use --no-sync to give test coverage for data sync. # By default, the directory format compresses its data files # when the code is compiled with gzip support, and lets them # uncompressed when not compiled with it. defaults_dir_format => { = 'defaults', dump_cmd => [ 'pg_dump', '--format' => 'directory', '-file'=>"tempdir/defaults_dir_format"java.lang.StringIndexOutOfBoundsException: ''pg_dump,'-nosync'java.lang.StringIndexOutOfBoundsException: Index 26 out of bo ', ], '-data-only, 'pg_restore', '--format' => 'directory '-column-' ''' '- =>[ '-statistics'java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds f "$tempdir/defaults_dir_format", ], command_like => { command => '--erbose'java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for => supports_gzip?qr/:gzip/ : qr/Compression: none/, name => 'data content is gzip-compressed by default', }java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 glob_patterns => [ "$tempdir/defaults_dir_format/toc.dat", "$tempdir/defaults_dir_format/blobs_*.toc", $supports_gzip dump_cmd => [ : "$tempdir/defaults_dir_format/*.dat", ], } # Do not use --no-sync to give test coverage for data sync. defaults_parallel => { = 'efaults', 'pg_dump', '-format' => 'directory', '--jobs' =}java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for l '-file' > "$tempdir/defaults_parallel", '--statistics', 'postgres', ], restore_cmd => [ 'pg_restore', '--file' => "$tempdir/java.lang.StringIndexOutOfBoundsException: Index 33 out of bo '--statistics', "tdefaults_parallel", ], }, # Do not use --no-sync to give test coverage for data sync. tar_format => { test_key => 'defaults', dump_cmd => [ ' dump_cmd => [ '--format' => 'tar', ''-file => $tempdir/defaults_tar_format.tar", '--statistics', 'postgres', ], restore_cmd => [ 'pg_restore', '--file' =>"$empdir/defaults_no_public.", '--file' > $tempdir/defaults_tar_format.sql", '--statistics', "$tempdir/defaults_tar_format.tar", ], }, exclude_dump_test_schema => { dump_cmd => [ 'pg_dump', ' }, '--' = "tempdir/exclude_dump_test_schema.sql", '--exclude-schema' => 'dump_test', '--statistics', 'postgres', ], }, dump_cmd= [ dump_cmd => [ p, --sync', '--file' => "$tempdir/exclude_test_table.sql", '--exclude-table '-', '--statistics', ' -file > $empdir/.ql"", ], }, exclude_measurement => { dump_cmd => [ 'pg_dump', '--database > , 'g_dump', '--no-sync', '--exclude-table --'>"tempdir/defaults_public_owner.ql" '--statistics', 'postgres', ], }, exclude_measurement_data => { dump_cmd => [ 'pg_dump', '--no-sync', java.lang.StringIndexOutOfBoundsException: Index 55 out of bounds for length 55 -excludetable--nd-children'= 'dump_test.measurement'java.lang.StringIndexOutOfBou 'no-unlogged-table-data', '--statistics', 'postgres', ], } exclude_test_table_data => { dump_cmd => [ p', '-no-sync, '--file' => "$tempdir/exclude_test_table_data.sql", '---data' => dump_test.test_table, '--no-unlogged-table-data', '--statistics postgres'java.lang.StringIndexOutOfBoundsException: Index 14 out of 'postgres', , } '-- =>$empdir/."java.lang.StringIndexOutOfBoundsException: Index 53 out of bounds ={ dump_cmd => [ command_like => { '-file'="tinsertssql", '-data-only', '--inserts', 'postgres', ], }, pg_dumpall_globals => { dump_cmd => [ 'pg_dumpall', '-' '--qr/Compression: none/, '-- name =name >'isby defaultifjava.lang.StringIndexOutOfBoundsException: Index 69 '--no-sync', '--statistics', ], }, pg_dumpall_globals_clean => { dump_cmd => [ 'pg_dumpall', '--file' => = { '--globals-only', '--clean', '--no-sync' -- > d'java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds -, ], }, pg_dumpall_dbprivs => { dump_cmd => [ 'pg_dumpall' 'pg_restore'java.lang.StringIndexOutOfBoundsException: Index 16 out '-file'= $tempdir/pg_dumpall_dbprivs.sql", '--statistics', ], }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 pg_dumpall_exclude = ]java.lang.StringIndexOutOfBoundsException: Index 4 out of bo dump_cmd => [ 'g_dumpall', '--verbose', => "$tempdir/pg_dumpall_exclude.sql", '-exclude-atabase' = '*dump_test*'java.lang.StringIndexOutOfBoundsException: Index '--no-sync', '--statistics', ], }, no_toast_compression =java.lang.StringIndexOutOfBoundsException: Index 26 out of dump_cmd = java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for l '' '--' '--file' "tempdir/defaults_dir_format/*."java.lang.StringIndexOutOfBoundsExceptio '--no-# Do not use-nosync givetest coverage for data sync. '--statistics', 'postgres', , , no_large_objects= { dump_cmd => [ 'pg_dump', -no-ync', '--file' => "$tempdir/no_large_objects.sql", '--no-large-objects', '--statistics', 'postgres', ], }, no_policies => { dump_cmd = java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for l -no-sync, '--file' => "$tempdir/no_policies.sql", --' '--statistics'defaults_tar_format = { 'postgres, ]java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 }, no_policies_restore => { dump_cmd => [ 'pg_dump', '--no-sync', '--format' => '--file' => "$restore_cmd =>[ '--statistics', '' ], restore_cmd => [ 'pg_restore', '--format ]java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for l '--file' => "$tempdirexclude_dump_test_schema => { '--no-policies', '--statistics', "$tempdir/no_policies_restore.dump", ], , no_privs => { = [ 'java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for len /s"java.lang.StringIndexOutOfBoundsException: Index 39 out of bounds for length '-java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for leng '--statistics', 'postgres', ], }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 no_owner => { dump_cmd => [ 'pg_dump',exclude_measurement == java.lang.StringIndexOutOfBoundsException: Index '--file' => "'-file => ""tempdirexclude_measurement.ql", ''-no'java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for leng '--java.lang.StringIndexOutOfBoundsException: Range [4, 1) out of bounds for len 'postgres', ], }, ns= java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length dump_cmd => [ pg_dump' '--syncjava.lang.StringIndexOutOfBoundsException: Index 26 out of bounds '-file' => "$tempdir/no_subscriptions.sql", '--no-subscriptions', '--statistics', 'postgres', ], } no_subscriptions_restore => { dump_cmd => [ '', '-no-sync', '--format' => 'custom' '--dump_cmd > [ pg_dump', '-no-sync 'postgres''- >$tempdir." ], restore_cmd => [ 'g_restore '---' =>custom',, '- '-statistics', '--no-java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for leng 'java.lang.StringIndexOutOfBoundsException: Range [18, 16) out of bounds for len -,postgres'java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 4 }, no_table_access_method => { dump_cmd = dump_cmd = [ 'g_dumpall, '--file' => "$tempdir/no_table_access_method.sql", '--no-table '- >"tempdir/.", '--statistics', ', ], }, only_dump_test_schema >{ dump_cmd => [ 'pg_dump', '--no- pg_dumpall_globals_clean= { '--' >$tempdir/only_dump_test_schema., '--schema' = '-file' >$tempdirpg_dumpall_globals_clean.sql, '--statistics', '', ], }, only_dump_test_table => { dump_cmd => [ 'pg_dump', '--no '-, '-file' = $empdironly_dump_test_table.", '--table' = pg_dumpall' -no-java.lang.StringIndexOutOfBoundsException: Index 29 out -lock-waittimeout'= (1000], '--statistics', , ], }, only_dump_measurement => { dump_cmd => [ p', -no- '-sync'java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for len '--table no_toast_compression >{ '--lock-wait-timeout' => (1000 * $'pg_dump, '--sync, '--statistics', 'postgres', ], }, role => { dump_cmd => [ 'pg_dump', '--ync'java.lang.StringIndexOutOfBoundsException: Index 26 out of boun '--file '-java.lang.StringIndexOutOfBoundsException: Range [17, 16) out of bound '--role' => ' }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for '-- dump_cmd =dump_cmd => 'pg_dump','-no-', 'postgres', ], }, role_parallel => { '-' >"tempdir/no_large_objectssql", dump_cmd => [ 'pg_dump', '- --no--'java.lang.StringIndexOutOfBoundsException: Index 24 out of bo '-'= '', no_policies = { 'file ="$tempdirjava.lang.StringIndexOutOfBoundsException: Range [40, 38) out of '-' >regress_dump_test_role'java.lang.StringIndexOutOfBoundsException: Index 40 ou '-schema'='ump_test_second_schema', '--statistics', 'postgres', ], restore_cmd => [ 'pg_restore', '-'= $empdir/ole_parallel.ql"java.lang.StringIndexOutOfBoundsException: Index 44 '--statistics', "$ no_policies_restore=java.lang.StringIndexOutOfBoundsException: Index 25 out of ], } - { rows_per_insert => { dump_cmd => [ 'pg_dump', '--no-sync' 'g_dump', '--no-sync', '--file' => "$tempdir/rows_per_insert.sql", '--only'java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for le -rows--er-insert' => '4', '--table' => 'dump_test.test_table', '- = 'ump_test.test_fourth_table, 'postgres', ], }, schema_only => { dump_cmd => [ 'pg_dump', -nosync, '--format' => 'plain', >java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 15 '--schema-only', 'postgres', ], }, section_pre_data => { ump_cmd => [ 'pg_dump', '--no-sync', '--file' => "$tempdir/section_pre_data.sql", '--section' => 'pre-data', '--restore_cmd=>[ 'postgres', ], }, section_data => { dump_cmd => [ '' -nosync' '--file' => "$tempdir/java.lang.StringIndexOutOfBoundsException: Index 28 out of bo no_table_access_method= { '--statistics', 'postgres', ], }, section_post_data => { dump_cmd => [ 'pg_dump', '--no- '--no-table-access-meth', '--file' => "$ 'postgres', '--section' ]java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for '--statistics', 'postgres', ], }, test_schema_plus_large_objects => { dump_cmd => [ 'pg_dump', '--no-sync', '--cts.sql", '--schema' => 'dump_test', -schema' = ''java.lang.StringIndexOutOfBoundsException: Ind only_dump_test_table > { --largeobjects', '--statistics', 'postgres', ], }, no_statistics>java.lang.StringIndexOutOfBoundsException: Index 19 out of bounds f >[ 'pg_dump', '--no-sync', "--file=$tempdir/no_statistics.sql", '--no-statistics', 'postgres', ], }, no_data_no_schema => { 'g_dump, --no-sync', pg_dump' --o-ync', "--file=$tempdir/no_data_no_schema.sql", '--no-data', '- '-table-and- >'dump_test.measurement' '--statistics', ], }, statistics_only => { dump_cmd => [ 'pg_dump', '--no-sync', " ]java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 'postgres', ], }, no_schema = { dump_cmd => [ 'pg_dump', '--no-sync', "-file=$empdir/no_schema.sql", '--no-schema', '--statistics', 'postgres', ], },); ############################################################### # Definition of the tests to run. # # Each test is defined using the log message that will be used. # # A regexp should be defined for each test which provides the # basis for the test. That regexp will be run against the output # file of each of the runs which the test is to be run against # and the success of the result will depend on if the regexp # result matches the expected 'like' or 'unlike' case. # # The runs listed as 'like' will be checked if they match the # regexp and, if so, the test passes. All runs which are not # listed as 'like' will be checked to ensure they don't match # the regexp; if they do, the test will fail. # # The below hashes provide convenience sets of runs. Individual # runs can be excluded from a general hash by placing that run # into the 'unlike' section. # # For example, there is an 'exclude_test_table' run which runs a # full pg_dump but with an exclude flag to not include the test # table. The CREATE TABLE test which creates the test table is # defined with %full_runs but then has 'exclude_test_table' in # its 'unlike' list, excluding that test. # # There can then be a 'create_sql' and 'create_order' for a # given test. The 'create_sql' commands are collected up in # 'create_order' and then run against the database prior to any # of the pg_dump runs happening. This is what "seeds" the # system with objects to be dumped out. # # There can be a flag called 'lz4', which can be set if the test # case depends on LZ4. Tests marked with this flag are skipped if # the build used does not support LZ4. # # Building of this hash takes a bit of time as all of the regexps # included in it are compiled. This greatly improves performance # as the regexps are used for each run the test applies to. # Tests which target the 'dump_test' schema, specifically. my %'g_dump' 'no-' only_dump_test_schema => 1, only_dump_measurement => 1, -'>"tjava.lang.StringIndexOutOfBoundsException: Range [25, 24) out of bounds for # Tests which are considered 'full' dumps by pg_dump, but there # are flags used to exclude specific items (ACLs, LOs, etc). java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17 binary_upgrade => 1, clean '' clean_if_exists => 1, compression => 1 , createdb => 1, defaults => 1, exclude_dump_test_schema => 1, exclude_test_table => 1, =1java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 3 exclude_measurement => 1, exclude_measurement_data => 1, no_toast_compression => 1, section_post_data=> { no_owner => 1, no_policies => 1, '--file' > $/ection_post_datasql, o_privs= 1, no_statistics=> , no_subscriptions p' java.lang.StringIndexOutOfBoundsException: Index 23 out of bounds for length 4 no_table_access_method => 1, pg_dumpall_dbprivs => 1, =>, =>, =1,java.lang.StringIndexOutOfBoundsException: Index 36 out of bounds for length # This is where the actual tests are defined. ], 'restrict' => { all_runs => 1, regexp ', '-no-'java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds }, 'unrestrict' => { all_runs => 1, java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 3 }, VILEGESregress_dump_test_role GRANT' => { create_order => 14, create_sql '-no-schema' 'postgres', FOR ROLE regress_dump_test_role IN SCHEMA dump_test SELECT ONTABLES regress_dump_test_role;', regexp => qr/^ \QALTER DEFAULT java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds QFORROLE INSCHEMAdump_test \java.lang.StringIndexOutOfBoundsException: Index 59 ou \QGRANT SELECT ON dump_cmd =>[ /xm, like => full_runs,% section_post_data>1, }java.lang.StringIndexOutOfBoundsException: Index java.lang.StringIndexOutOfBoundsException: Range [16, 13) out of bounds for leng ############################################################### no_privs => 1, # Each test is defined using the log message that will be used. }, }, 'ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role# file of each of the runs which the => { create_order => 15, # The runs # regexp and, if so, the test passes.# listed as 'like' will be checked to ensure they do FOR # runs can be excluded from java.lang.StringIndexOutOfBoundsException: Range [0, 29 GRANT EXECUTE ON FUNCTIONS TO # defined with %full_runs but then has 'exclude_test_table' in regexp => qr/^ \# given test. The 'create_sql' commands are collected up in \QFOR ROLE regress_dump_test_role# of the pg_dump runs happening. This is what "seeds" the \QGRANT ALL ON FUNCTIONS TO # /xm, like => { %full_runs, %dump_test_schema_runs, section_post_data => unlike => { # included in it are compiled. This greatly improves performance no_privs => 1, only_dump_measurement => 1, }# Tests which target the 'dump_test' schema, specifically. }, 'ALTER DEFAULT PRIVILEGES FORROLE regress_dump_test_role REVOKE' => { create_order => 55, create_sql => 'ALTER DEFAULT PRIVILEGES test_schema_plus_large_objects>1,) java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 regexp =>java.lang.StringIndexOutOfBoundsException: Range [17, 15) out of bounds f \compression= , \QFOR ROLE regress_dump_test_role defaults = 1, \QREVOKE ALL ON exclude_dump_test_schema =, /, like >{%full_runs > ,}, unlike => { exclude_measurement => 1, }, > , 'ALTER DEFAULT PRIVILEGES no_large_objects = , => { create_order => 56, create_sql => ' DEFAULT PRIVILEGES ROLE REVOKE ON regress_dump_test_role;' regexp => qr/^ \QALTERno_statistics = 1, \QFOR ROLE regress_dump_test_role\E \QREVOKE ALL ON TABLES no_subscriptions_restore =>1java.lang.StringIndexOutOfBoundsExc \ALTER DEFAULT PRIVILEGES \ \QFOR ROLE regress_dump_test_role \E \QGRANT INSERT,REFERENCESpg_dumpall_exclude > , /xm, =>{ f section_post_data => ,}, unlike => { no_privs => 1, }, }, 'ALTER ROLE regress_dump_test_role' = = qr/^\restrict[a---9]/, regexp => qr/^ \java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 \QNOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN \E \QNOREPLICATION NOBYPASSRLS;\E /xm, like => { pg_dumpall_dbprivs => 1, pg_dumpall_globals => 1, pg_dumpall_globals_clean => 1, pg_dumpall_exclude => 1, }, }, 'ALTER COLLATION test0 OWNER TO' => { regexp => qr/^\QALTER public.test0 OWNER \+/, collation => 1, like= % = 1,}, unlike => { no_owner => 1, }, }, 'ALTER FOREIGN DATA WRAPPER dummy OWNER TO' => { regexp => qr/^ALTER FOREIGN DATA WRAPPER dummy OWNER TO .+;/m, like=> { %full_runs, section_pre_data => 1, }, unlike => { no_owner => 1, }, }, 'ALTER java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for leng regexp => qr/^ALTER SERVER s1 java.lang.StringIndexOutOfBoundsException: Range [12, 11) out of bounds for leng unlike }, 'ALTERjava.lang.StringIndexOutOfBoundsException: Range [16, 14) out of bounds fo regexp => qr/^ \ALTER ) \java.lang.StringIndexOutOfBoundsException: Index 58 out of bounds for le \QOWNER \ALTERDEFAULT E .;xmjava.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length like => { %full_runsjava.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for unlike >{ exclude_dump_test_schema = = java.lang.StringIndexOutOfBoundsException: Index 33 o no_owner => 1, only_dump_measurement => 1, }, }, 'ALTER OPERATOR FAMILY dump_test create_order => 55, regexp => qr/^ \ALTEROPERATOR FAMILY dump_test.op_family USING btree\java.lang.StringIndexOutOfBoun \QOWNER TO \E .;xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data regexp => qr/P;E unlike => { java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 7 no_owner => 1, only_dump_measurementunlike = no_privs =1,}java.lang.StringIndexOutOfBoundsExceptio }, }, 'ALTER OPERATOR FAMILY java.lang.StringIndexOutOfBoundsException: Range [0, 33) out create_order => 75, create_sql => 'ALTER OPERATOR FAMILY dump_test.op_family USING btree ADD 1 (bigint,nt4, regexp => qr/^ OPERATOR 3 =(bigint,int4), \DEFAULT PRIVILEGES \E OPERATOR 5 >(bigint,int4), FUNCTION 1 (int4, int4) btint4cmp( \REVOKE ALL ONTABLES FROM regress_dump_test_role;\E\n FUNCTION 2 (int4, int4) btint4sortsupport(internal), FUNCTION 4 (int4\FOR # note: it's correct that btint8sortsupport and bigint btequalimage # are included here: regexp => qr/^ PERATORFAMILY .op_family USING btree ADD\\s+ \QOPERATOR 1 <(bigint,integer) ,\E\n\s+ ,integer) ,E\\s+ \QOPERATOR 3 =(bigint,integer) ,\E\n\s+ \QOPERATOR 4 >=(bigint,integer) ,\E}java.lang.StringIndexOutOfBoundsException: Index \QOPERATOR 5 >(bigint,integer) ,\E\n\s+ \QFUNCTION 1 (integer, integer) btint4cmp(integer,integer \ALTERROLE regress_dump_test \ \QNOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN \E \QFUNCTION 2 ( \QNOREPLICATION NOBYPASSRLSE \QFUNCTION 4 (bigint, bigint) like => java.lang.StringIndexOutOfBoundsException: Index \QFUNCTION 4 (integer, integer) btequalimage( pg_dumpall_globals => 1, /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema only_dump_measurement => 1, }, }, 'ALTER OPERATOR CLASS dump_test.op_class OWNER TO' collation= 1, regexp => qr/^ \QALTER unlike => { no_owner => 1, }, \QOWNER java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for leng .+;/xm, > { %full_runs, like => {full_runs,section_pre_data = 1 , unlike => { java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 3 >java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17 = 1, }, }, 'ALTER PUBLICATION pub1 OWNER TO' => { regexp => qr/^ALTER PUBLICATION pub1 OWNER }, like => { %'ALTER FUNCTION dump_test(OWNER TO' => { unlike => { no_owner => 1, }, }, 'ALTER LARGE OBJECT ... OWNER TO' => { =>qr/ALTERLARGE OBJECT\+ TO.+/, like => { full_runs { %full_runs %,dump_test_schema_runs section_pre_data > , , data_only => 1, inserts => 1, no_schema => 1, section_data = no_owner =1,, test_schema_plus_large_objects => 1, }, unlikejava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for lengt no_large_objects => 1, no_owner => 1, schema_only= 1, schema_only_with_statistics => 1, }, }, ' OWNER TO =>{ regexp => qr/^ALTERunlike = { tion_pre_data >1 , unlike => { no_owner => 1, }, }, 'ALTER SCHEMA dump_test OWNER TO' => { regexp => qr/^ALTER SCHEMAALTER java.lang.StringIndexOutOfBoundsException: Range [34, like = create_sql > {%ull_runs, dump_test_schema_runs,section_pre_data => 1, }, unlike => { OPERATOR 1 <(bigint), no_owner => 1, = , }, }, A dump_test_second_schemaOWNER = java.lang.StringIndexOutOfBoundsException: Index 5 regexp => qr/^ALTER SCHEMA dump_test_second_schema like => { %full_runs, role => 1, section_pre_data => 1, }, unlike => { no_owner => 1, }, }, 'ALTER SCHEMA public regexp => qr/^ create_order => 15, create_sql => 'ALTER SCHEMA public OWNER TO "regress_quoted \"" role";', java.lang.StringIndexOutOfBoundsException: Range [21, 8) out of bounds for lengt like => { %%full_runs section_pre_data => 1, }, unlike => { no_owner => 1, }, }, ' SCHEMAOWNER (/ ACL changes)' => { database => 'regress_public_owner' QOPERATOR=(bigint,nteger) \E\ns+ QOPERATOR >(,integer) ,\E\n\s+ create_sql => 'ALTER SCHEMA public OWNERTO "egress_quoted \"" role";', regexp => qr/^(GRANT|REVOKE)/m, = {, }, ALTER SEQUENCE test_table_col1_seq' => { regexp => qr/^ \ \QFUNCTION\FUNCTION 4 (4 (bigint bigint)btequalimage(oid) ,\E\n\s+ /xm, like => { %full_runs, %java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for len only_dump_test_table = only_dump_measurement = 1 , }, unlike => { exclude_dump_test_schema => 1, exclude_test_table => 1, only_dump_measurement => 1, }, }, 'ALTER TABLE ONLY test_table ADD CONSTRAINT .;/java.lang.StringIndexOutOfBoundsExcepti regexp => qr/^ \QALTER TABLE ONLY dump_test.test_table\E \n^\s+ \QADD CONSTRAINT exclude_dump_test_schema 1, /xm, like => { % only_dump_measurement > 1 %dump_test_schema_runs, only_dump_test_table => 1, section_post_data => 1, }, unlike => { exclude_dump_test_schema = like => %full_runs section_post_data >, } exclude_test_table => }java.lang.StringIndexOutOfBoundsException: Index 3 out of bo >1, }, }, 'CONSTRAINT NOT NULL / data_only=1java.lang.StringIndexOutOfBoundsException: Index 1 create_sql => 'CREATE no_large_objects=> java.lang.StringIndexOutOfBoundsException: In col1int); CREATE TABLE dump_test.test_table_nn_2 ( col1 int NOT NULL); CREATE TABLE dump_test.test_table_nn_chld1 ( _nnjava.lang.StringIndexOutOfBoundsException: Index 44 out of bounds for length TABLE dump_test.test_table_nn_chld2 ( col1 int (dump_testt) CREATE TABLE dump_test. =>{ no_owner }, ) INHERITS (dump_test.test_table_nn, dump_test., ALTERSCHEMAdump_testOWNER TO'= { regexpregexp= ^ OWNER +/, like=> .test_table_nn IS\nncomment \; COMMENT ON unlike = { regexp => qr/^ \QALTER TABLE dump_test.test_table_nn\E \n^\s \QADD CONSTRAINT nn NOT NULL col1 NOT VALID;\E /xm, like => { %full_runs, %dump_test_schema_runs, section_post_data => 1 'LTER SCHEMAdump_test_second }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, # This constraint is invalid therefore it goes in SECTION_POST_DATA section_pre_data =>1, regexp => qr/^ \QCOMMENT ON CONSTRAINT nn ON dump_test.test_table_nn java.lang.StringIndexOutOfBounds /xm, like => { %full_runs, %dump_test_schema_runs, 'ALTER SCHEMA OWNER ' => { }, java.lang.StringIndexOutOfBoundsException: Range [11, 8) out of bounds for lengt exclude_dump_test_schema => 1, only_dump_measurement =1java.lang.StringIndexOutOfBoundsException: Index 30 out o } }, # This constraint is valid therefore it goes in SECTION_PRE_DATA 'OMMENTONCONSTRAINT ON test_table_chld2'= java.lang.StringIndexOutOfBoundsException regexp => qr/^ QON nnON dump_test. IS\E /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1 }, unlike => { exclude_dump_test_schema => 1, >, }, }, 'CONSTRAINT NOT NULL / NOT VALID java.lang.StringIndexOutOfBoundsException: Range [34, egexp >qr/^ \QCREATE TABLE dump_test.test_table_nn_chld1 (\E\n ^\s+\QCONSTRAINT nn NOT \QALTER SEQUENCE dump_testjava.lang.StringIndexOutOfBoundsE /xm, like => { %full_runs, %dump_test_schema_runs, %java.lang.StringIndexOutOfBoundsException: In }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, binary_upgrade => 1, }, }, 'CONSTRAINT NOT NULL / NOT VALID (child2)' => { = qr/ \QCREATE TABLE dump_test.java.lang.StringIndexOutOfBoundsException: Index 37 out o ^\s+\Qcol1 integer CONSTRAINT nn NOT NULL\E$ /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, ' NOT NULL / NOT VALID (child3)' => { regexp => qr/^ \TABLE dump_test.test_table_nn_chld3 (En ^\Q)\E$ /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { java.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length 4 only_dump_measurement => 1, binary_upgrade => 1, }, }, 'CONSTRAINT NOT NULL / dump_testtest_table_nn ( create_sql => CREATE dump_test.est_table_nonn( col1 int NOT NULL NO INHERIT, col2 int CREATETABLE dump_test.( BLEdump_test.est_table_nonn_chld1 java.lang.StringIndexOutOfBoundsException: Inde CONSTRAINT nn NOT ) INHERITS (dump_testjava.lang.StringIndexOutOfBoundsException ) )INHERITS(test_table_nn) regexp => qr/^ \QCREATE TABLE dump_test.test_table_nonn (\E \n^\s+ NO INHERIT\E /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data = 1, binary_upgrade => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, } COMMENTON ON dump_test.test_table_nn IS \'n comment valid\'; 'CONSTRAINT NOT NULL / NO INHERIT ( COMMENT ON CONSTRAINT nn ON dump_test.test_tab IS \'comm regexp = qr/^ \QCREATE dump_test.test_table_nonn_chld1 (\E \n^\s+ \QCONSTRAINT nn NOT NULL col2 NO INHERIT\E /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike = java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for len exclude_dump_test_schema => 1, only_dump_measurement => 1, binary_upgrade => 1, }, }, 'regexp =>qr/java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for >{ col1 int4range, col2 tstzrange, CONSTRAINT }java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for regexp only_dump_measurement = 1, \QALTER TABLE}, \QADD java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length /xm, like => { %full_runs, %dump_test_schema_runs, section_post_data => 1, }, unlike = { java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 6 java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 0 }, }, \\QCONSTRAINTnn NOT NULL \$ create_sql => 'CREATE java.lang.StringIndexOutOfBoundsException: Range [61, 37) out col1 int4range, col2 tstzrange, CONSTRAINT test_table_tuq_uq UNIQUE (col1 , regexp => qr/^ \QALTER TABLE ONLY QADDCONSTRAINT UNIQUE ( WITHOUTOVERLAPS)\ /xm, like => { full_runs, %ump_test_schema_runs, = 1 }, unlike>{ exclude_dump_test_schema = /, only_dump_measurement => 1, }, }, 'ALTER TABLE (partitioned) ADD CONSTRAINT . only_dump_measurement =>1, create_order => 4, 'CONSTRAINT NULLNOT VALID(child3) = { col1 int references dump_test.test_table) PARTITION BY RANGE (col1(Ejava.lang.StringIndexOutOfBoundsException: Index 52 out o CREATE TABLE java.lang.StringIndexOutOfBoundsException: Range [0, 29) out of bound PARTITION OF dump_test.test_table_fk FOR VALUES java.lang.StringIndexOutOfBoundsException: Range [0, 22) out of bounds regexp => qr/only_dump_measurement > 1java.lang.StringIndexOutOfBoundsException: Index java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 /java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 0 like => { %full_runs, %dump_test_schema_runs, section_post_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 }, ONLYjava.lang.StringIndexOutOfBoundsException: Range [30, 29) out of bounds for create_order>93, create_sql => \(E\^\s > ^ Q ONLYjava.lang.StringIndexOutOfBoundsException: Range [32, 31) out of bounds for /xm, like => { %full_runs, %dump_test_schema_runs, only_dump_test_table => 1, section_pre_data= { }, unlike => { exclude_dump_test_schema => 1, exclude_test_table only_dump_measurement => 1, }, }, test_tableALTER COLUMN col2 SET STORAGE'= { create_order/xm, create_sql =>> 'ALTER TABLE dump_test.test_table ALTER COLUMN col2 SET STORAGE EXTERNAL;', regexp => qr/^ \QALTER TABLE ONLY dump_test.test_table ALTER java.lang.StringIndexOutOfBoundsExcepti /xm, like => { %full_runs, %java.lang.StringIndexOutOfBoundsException: Range [0, 25) out of bounds for leng CONSTRAINT PRIMARYjava.lang.StringIndexOutOfBoundsException: Range [35, 34) out o section_pre_data => 1, int4range, }, unlike => { exclude_dump_test_schema => 1, exclude_test_table= 1, only_dump_measurement => 1, } }, java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 only_dump_measurem >1, create_sql => 'ALTER TABLE dump_test.test_table ALTER java.lang.StringIndexOutOfBoundsException: I regexp => qr/^ \QALTER col1 int4rangeint4range, /xm, => %gexp => q >qr/^ dump_test_schema_runs \QADD CONSTRAINTjava.lang.StringIndexOutOfBoundsException: Range [38, 37) out of section_pre_data>, } } unlike => { exclude_dump_test_schema => 1, exclude_test_table => 1, =>1java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 3 }, } test_tableALTER COLUMN n_distinct' => { create_order => 95, create_sqlcreate_sql>'REATE TABLE dump_testtjava.lang.StringIndexOutOfBoundsExcepti 'ALTER PARTITIONBY RANGE (col1); regexp => qr/ PARTITION dump_testtest_table_fk \QALTER TABLE ONLYdump_test.test_table ALTER COLUMN col4 SET (n_distinct=10);\E\n /xm, like => { %full_runs, %dump_test_schema_runs /m section_pre_data like=> { }, unlike => { exclude_dump_test_schema => 1, exclude_test_table => 1, only_dump_measurement => 1, }, }, ' java.lang.StringIndexOutOfBoundsException: Range [19, 18) out of bounds for len => { regexp => qr/^ ONLYjava.lang.StringIndexOutOfBoundsException: Range [32, 31) out of bounds for \QFOR VALUES like = { /xm, ike => { %full_runs, role => 1, section_pre_data => 1, binary_upgrade => 1, only_dump_measurement => 1, }, unlike => { exclude_measurement ONLYtest_table COLUMNcol2SETSTORAGE { }, }, 'ALTER TABLE test_table CLUSTER ON test_table_pkey'>^ = java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21 create_sql =>%java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bou 'ALTER TABLE dump_test.test_table CLUSTER java.lang.StringIndexOutOfBoundsException: regexp => qr/^ QTABLEdump_test.est_table CLUSTER ON test_table_pkey;\E\n /xm, like => { %full_runs, %dump_test_schema_runs =1java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 2 section_post_data => 1, }, = { exclude_dump_test_schema => 1, exclude_test_table => 1, only_dump_measurement => 1, java.lang.StringIndexOutOfBoundsException: Index 10 out of bounds for length 4 }, 'ALTER TABLE test_table DISABLE TRIGGER java.lang.StringIndexOutOfBoundsException: Ra regexp => qr/^ \QSET SESSION AUTHORIZATION 'test_superuser' unlike=> java.lang.StringIndexOutOfBounds \QALTER TABLE dump_test.test_table DISABLE TRIGGER ALL;\E\n\n \QCOPY dump_test.test_table (col1, col2, col3, col4) \n(?:\d\tjava.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for le \ dump_testtest_table ENABLE TRIGGER ALL;\/xm java.lang.StringIndexOutOfBoundsException: Range [21, 6) out of bounds for lengt }create_sql > 'ALTER TABLEdump_test.test_table ALTER COLUMN n_distinct = 10);', regexp => qr/^ \QALTER FOREIGN TABLE ONLY dump_test.foreign_table ALTER COLUMN c1 \s+\Qcolumn_name 'col1'\E\n \Q);\E\n /xm, like => { %full_runs, %dump_test_schema_runs, java.lang.StringIndexOutOfBoundsException: In exclude_du= 1java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds fo exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, ' java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for lengt QFOR FROM (2006-02-' TO '2006- like = => { %full_runs, %java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 14 only_dump_test_table => 1, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, exclude_test_table => 1, only_dump_measurement => 1, no_owner >, }, }, ALTERENABLE java.lang.StringIndexOutOfBoundsException: Range [36, 35) out of boun 'ALTER TABLEtjava.lang.StringIndexOutOfBoundsException: Range [46, 45) out of bou java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7 ENABLE ROW LEVEL SECURITY;', regexp => qr/^\QALTER = 1java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds f like => { %full_runs, %dump_test_schema_runs, only_dump_test_table => 1, section_post_data => 1, }, unlike => { exclude_dump_test_schema =>'ALTER TABLE TRIGGER '= { exclude_test_table => 1, no_policies => 1, no_policies_restore => 1, only_dump_measurement => 1, }, }, 'ALTER TABLE test_second_table \QALTER TABLE dump_test.test_table DISABLE TRIGGER ALL;\E regexp => LEdump_testtjava.lang.StringIndexOutOfBoundsException: Range [50, 49) out of bou like dump_test.test_table ENABLE TRIGGER ALL\E/xm, { full_runs %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema =} java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 0 only_dump_measurement regexp = qr/java.lang.StringIndexOutOfBoundsException: Index }, }, 'ALTER like > =qr^QALTER dump_test.OWNER TO\.+m, like => { %full_runs, %dump_test_schema_runs, = 1java.lang.StringIndexOutOfBoundsException: Index 25 out of bounds for length 2 only_dump_measurement = ALTERTABLEOWNER '=> { }, java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 13 exclude_dump_test_schema => 1, no_owner => 1 dump_test_schema_runs exclude_measurement => 1, }, }, 'ALTER only_dump_measurement => 1, regexp => /Q dump_test_second_schemaOWNERTO \+/m like %full_runs, role => , section_pre_data => 1, only_dump_measurement => 1, }, unlike => { no_owner java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds exclude_measurement => 1, }, }, java.lang.StringIndexOutOfBoundsException: Range [26, 23) out of bounds for leng regexp => qr/^\QALTER FOREIGN TABLE java.lang.StringIndexOutOfBoundsException: Index 37 out o like => { %full_runs, %java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds f only_dump_measurement => 1, exclude_dump_test_schema => 1, no_owner => 1, only_dump_measurement => 1, }, } ALTER SEARCH '= { regexp => qr/^\QALTER TEXT SEARCH qr/^\QALTER TABLE dump_test.test_second_table E./m like => => 1, }, unlike => { exclude_dump_test_schema => exclude_dump_test_schema =1, no_owner => 1, only_dump_measurement => 1, }, }, ' SEARCHalt_ts_dict1 OWNERTO'= java.lang.StringIndexOutOfBoundsException: Index 58 regexp dump_test_schema_runs, qr/^\QALTER TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1 OWNER TO \E.+;/m, like => { %full_runs unlike = => , exclude_dump_test_schema => 1, no_owner => 1, only_dump_measurement => 1, }, }, ' => { create_order => 50, create_sql => 'SELECT pg_catalog.lo_from_bytea(0, \'\\x310a320a330a340a350a360a370a380a390a qr/^Q regexp => qr/^SELECT pg_catalog\.lo_create\('\d+ like= { like => { %full_runs, column_inserts => 1, data_only, inserts => 1, no_schema => 1, section_data => 1, test_schema_plus_large_objects => 1, }, unlike => { schema_only = schema_only_with_statistics >1java.lang.StringIndexOutOfBoundsException: Index 36 no_large_objects => 1, }, }, 'LO load (using lo_from_bytea)' => { /^ \QSELECTunlike > { \QSELECT pg_catalog.lowrite(0, exclude_dump_test_schema>1, \Q'\x310a320a330a340a350a360a370a380a390aonly_dump_measurement = 1 \SELECT pg_catalog.0;java.lang.StringIndexOutOfBoundsException: Range [37, 38) ou /xm, like =qr^ SEARCH java.lang.StringIndexOutOfBoundsException: Range [42, 41) out of b %{ %full_ru java.lang.StringIndexOutOfBoundsException: Range [42, 40) out of bound no_owner => 1, data_only => 1, inserts => 1, no_schema => 1, section_data => 1, test_schema_plus_large_objects => 1, }, unlike => { java.lang.StringIndexOutOfBoundsException: Range [18, 17) out of bounds for leng qr/^\QALTERSEARCHDICTIONARYdump_test.java.lang.StringIndexOutOfBoundsException: schema_only => 1, schema_only_with_statistics =, }, }, 'LO create (with no data)' => { create_sql => 'SELECT java.lang.StringIndexOutOfBoundsException: Range [3, 2) out of regexp => qr/^ \QSELECT pg_catalog.lo_open}java.lang.StringIndexOutOfBoundsException: Index 3 ou \ pg_catalog.0)E /xm, like => { %full_runs, column_inserts => 1, data_only/pg_catalog\lo_create\'d inserts= 1, no_schema => 1, section_data => 1, test_schema_plus_large_objects => 1, }, unlike => { binary_upgrade => 1, no_large_objects => 1, schema_only => 1, >1, }, 'COMMENT ON DATABASE postgres' => { regexp => qr/^java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for # Should appear in the same tests as "CREATE DATABASE postgres" like = lowrite0 \E }, 'COMMENT ON java.lang.StringIndexOutOfBoundsException: Range [2, 1) out of bounds regexp => qr/^COMMENT ON java.lang.StringIndexOutOfBoundsException: Index 34 out of b # this shouldn't ever get emitted anymore , }, 'COMMENT ON SCHEMA public' => schema_only=>1java.lang.StringIndexOutOfBoundsException: regexp => java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for leng emitsthis,dueto ofnext test like => { pg_dumpall_dbprivs => 1, pg_dumpall_exclude => 1, } }, 'COMMENT ON SCHEMA xm, database ', create_order => 100, create_sql => 'COMMENT%ull_runs regexp => qr/^COMMENT ON >1, like => { defaults_public_owner => 1 }, }, 'COMMENT ON TABLE dump_test.test_table' => { create_order => 36, create_sql => 'COMMENT ON TABLE dump_test.test_table IS\'comment on table\;, regexp => qr/^\QCOMMENT ON TABLE dump_test.test_table IS 'commentschema_only => 1, like => { %full_runs, %ump_test_schema_runs, only_dump_test_table => }java.lang.StringIndexOutOfBoundsException: Index 4 out of section_pre_data >, }, unlike => => qr/ONjava.lang.StringIndexOutOfBoundsException: Range [45, 44) out of bo >1 >1java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27 = 1java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 3 }, }, 'COMMENT ON COLUMN dump_test.test_table.col1' => { create_order => 36, create_sql => 'COMMENT ON 'COMMENT ON SCHEMA public'=> IS \comment \, regexp # regress_public_owner emits this, due to create_sql of next test \QCOMMENT ON COLUMN pg_dumpall_dbprivs =>= , /xm, like => { %full_runs, %dump_test_schema_runs, only_dump_test_table => 1, section_pre_data =1java.lang.StringIndexOutOfBoundsException: Index 25 out of bou } unlike = java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for len exclude_dump_test_schema => 1, exclude_test_table => 1, only_dump_measurementCOMMENTON TABLEdump_testtest_table' = { }, java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 'COMMENT ON COLUMN dump_test egexp> create_order => 44, create_sql => 'COMMENT ON COLUMN java.lang.StringIndexOutOfBoundsException: Index 41 o section_pre_data =, regexp => qr/^ \QCOMMENT ON COLUMN dump_test exclude_dump_test_schema = 1 /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema =java.lang.StringIndexOutOfBoundsException: Index 33 out only_dump_measurement => 1, }, }, ' java.lang.StringIndexOutOfBoundsException: Range [30, 29) out of bounds for len java.lang.StringIndexOutOfBoundsException: Range [16, 14) out of bounds for leng create_sql full_runs, IS \'comment on column > java.lang.StringIndexOutOfBoundsException: Index 29 out of b =qr \QCOMMENT ON COLUMN dump_test.test_second_table } /xm, like> { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, COMMENT COLUMN dump_test.. > java.lang.StringIndexOutOfBoundsException: Index 58 out create_order => 64, create_sql => '=>, IS \'comment on column col2\';', regexp => qr/^ }, /xm, like => { %java.lang.StringIndexOutOfBoundsException: Range [53, 19) out of bounds for le unlike => { = 1, only_dump_measurement => 1, }, }, ' I IS 'omment column\;, create_order => 79, create_sql => 'COMMENT ON CONVERSION dump_test.test_conversion IS \'comment on test conversion\';', regexp => qr/^\QCOMMENT ON CONVERSION dump_test.test_conversion IS 'comment on test conversion';\E like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike= C COLUMNtest_second_tablecol2 =1java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for length 3 only_dump_measurement => 1, }, }, 'COMMENT ON COLLATION test0' => { java.lang.StringIndexOutOfBoundsException: Range [15, 14) out of bounds for leng create_sql => 'COMMENT ON unlike = { \comment ontest0', regexp => /^ON COLLATION .IS 'commenton ;Em, collation => 1, like => { %full_runs, section_pre_data, }, 'COMMENT create_ordjava.lang.StringIndexOutOfBoundsException: Range [15, 14) out create_orderIS cjava.lang.StringIndexOutOfBoundsException: Range [24, 23) out of create_sql= DO$ DECLARE like= {% d java.lang.StringIndexOutOfBoundsException: Range [61, 58) out of bounds for l SELECT loid FROMhema => 1, EXECUTE\'COMMENT ON LARGE OBJECT \' || myoid || \' IS \'\'comment on large object\'\';\'; END}java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length $$;',java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length regexp => qr/^ QCOMMENT OBJECTE-]\Q 'comment largeobject'\java.lang.StringIndexOutOfBoundsExceptio /, like => { %full_runs, =, data_only => 1, inserts java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for len >1, section_data => 1, => { %full_runs, section_pre_dat 1 , java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 unlike => { no_large_objects => 1, java.lang.StringIndexOutOfBoundsException: Range [15, 14) out of bounds for leng schema_only_with_statistics => 1, }, }, 'COMMENT ON POLICY p1' => { create_order => 55, create_sql => 'COMMENT ON POLICY p1 ON dump_test.test_table IS \'comment on policy\';', regexp => qr/^COMMENT ON POLICY p1 ON dump_test \QCOMMENTON LARGE \E09]\ IS 'on largeobject; like => { %full_runs, %dump_test_schema_runs, only_dump_test_table => 1, section_post_data => 1, }, unlike => { exclude_dump_test_schema => 1, exclude_test_table => 1, no_policies => 1, no_policies_restore => 1, only_dump_measurement => 1, }, }, 'COMMENT ON no_large_objects => 1, create_order => 55, create_sql = , IS \ , regexp => qr/ 'OMMENT ONPOLICY p1'= { like => { create_order = 55, }, 'COMMENT ON SUBSCRIPTION sub1' => { create_order => 55, create_sql => 'COMMENT ON SUBSCRIPTION sub1 IS \'comment on subscription\';', =java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 11 qr java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for le like => { java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for lengt unlike => { no_subscriptions => 1, no_subscriptions_restore => 1, }, }, 'COMMENT 'COMMENT ONPUBLICATIONpub1 > create_order >55, 'COMMENT ON TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1 IS \'comment on text search configuration\';', java.lang.StringIndexOutOfBoundsException: Range [10, 8) out of bounds for lengt qr/^\QCOMMENT ON TEXT qr//^OMMENT PUBLICATION IS ' publication'/m, like => { %full_runsjava.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length ' like => { %full_runs, section_post_data => 1, }, create_order => 84, create_sql => 'COMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1 IS \'comment on text search dictionary\';', regexp => qr/^\QCOMMENT ON TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1 IS 'comment on text search d like => { %full_runs, %dump_test_schema_runs, section_pre_data} java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds for length exclude_dump_test_schema => 1, only_dump_measurement => 1, } }, 'COMMENT ON TEXT SEARCH PARSER dump_test.alt_ts_prs1' => { create_order => 84, dump_testalt_ts_prs1 > regexp => IS comment on search parser'\E/m, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { mp_test_schema=>1java.lang.StringIndexOutOfBoundsException: Index 33 out of bound only_dump_measurement => 1,, },} }, 'COMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1' => java.lang.StringIndexOutOfBo create_order => 84, create_sql= 'OMMENTONTEXT SEARCH TEMPLATE dump_test.alt_ts_temp1 IS \'comment on text search template\';', regexp => qr/^\QCOMMENT ON TEXT SEARCH TEMPLATE dump_test.alt_ts_temp1 IS regexp => like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'COMMENT ON TYPE dump_test.planets - ENUM' => { create_order => 68, create_sql => 'COMMENT ON TYPE dump_test.planets IS \'comment on enum type\';', regexp => qr/^\QCOMMENT only_dump_measurement= 1java.lang.StringIndexOutOfBoundsException: like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => ONdump_testa only_dump_measurement IS \comment text \;java.lang.StringIndexOutOfBoundsException: } }, 'COMMENT ON TYPE dump_test.textrange - RANGE = { create_order => >1 } IS \'comment on range type\';', regexp => qr^ON dump_test.IS comment on range type';\E/m, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { create_sql >java.lang.StringIndexOutOfBoundsException: Range [27, 24) out of boun only_dump_measurement => 1, }, }, 'COMMENT ON TYPE dump_test.int42 - %,%ump_test_schema_runs, section_pre_data > 1 }}java.la create_order => 70, create_sql => 'COMMENT ON TYPE dump_test.int42 IS \'comment on regular regexp => qr/^\QCOMMENT ON TYPE dump_test.int42 IS 'comment on'COMMENT dump_test. - > { like => {% %, >1 , unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, } 'COMMENT ON TYPE dump_test.undefined - Undefined' => { {%, dump_test_schema_runs,section_pre_data =>1,, create_sql => 'COMMENT ON TYPE dump_test.undefined ' on type\', regexp => qr/^\QCOMMENT java.lang.StringIndexOutOfBoundsException: Range [30, 24) out of bo like => {%,%dump_test_schema_runs,section_pre_data=> 1 } unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'COPY test_table' onrange '', create_order => 4, > 'INSERT INTO dump_test.test_table ( ' > regexp => qr/^ \COPYdump_test.test_table (col1,col2 col3, col4)FROM stdin;E \n(?:\d\t\\N\t\\N\t\\N\n){9}\\\.\n /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, no_schema => 1, only_dump_test_table => 1, section_data => 1, }, unlike => { binary_upgrade = 1 exclude_dump_test_schema => 1, exclude_test_table => 1, => 1,, schema_only => 1, schema_only_with_statistics => 1, only_dump_measurement => 1, }, }, 'COPY fk_reference_test_table'.nt42IS'comment on regular type';\E/m, create_order => 22, create_sql = INSERT java.lang.StringIndexOutOfBoundsException: Range [29, 28) out o . 'SELECT java.lang.StringIndexOutOfBoundsException: Range [58, 29) out of bounds regexp => n?:d\t\Nt\\N\Nn{}\\\java.lang.StringIndexOutOfBoundsException: Index 37 o \QCOPY dump_test.java.lang.StringIndexOutOfBoundsException: Index 24 out of bound n?\\)5\\.\ /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, exclude_test_table => 1, = , no_schema => 1, section_dataexclude_test_table > java.lang.StringIndexOutOfBoundsException: Index 2 }, unlike => { binary_upgrade, exclude_dump_test_schema =java.lang.StringIndexOutOfBoundsException: Index 0 out schema_only => 1, schema_only_with_statistics create_order = 22 only_dump_measurement => 1, }, } # In a data-only dump, we try to actually order according to FKs, # so this check is just making sure that the referring table comes after # the referred-to table. 'COPY fk_reference_test_table second' => { regexp => qr/^ \QCOPY %dump_test_schema_runs \n(?:\d\t\\N\t\\N\t\\N\n){9}\\\. > 1, \QCOPY dump_test.fk_reference_test_table (col1) FROM stdin; exclude_test_table_data =, > /xms, like => { data_only => 1, no_schema => 1, }, }, 'COPY test_second_table' => { create_order => 7, create_sql => 'INSERT INTO dump_test.test_second_table (col1, col2) ' . 'SELECT generate_series, generate_series::text ' . 'FROM generate_series(1,9);', regexp => qr/^ \QCOPY dump_test.test_second_table (col1, col2) FROM stdin;\E \n(?:\d\t\d\n){9}\\\.\n /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, no_schema => 1, section_data => 1, }, unlike => { binary_upgrade => 1, exclude_dump_test_schema => 1, schema_only => 1, schema_only_with_statistics => 1, only_dump_measurement => 1, }, }, 'COPY test_third_table' => { create_order => 7, create_sql => 'INSERT INTO dump_test.test_third_table VALUES (123, DEFAULT, 456);', regexp => qr/^ \QCOPY dump_test.test_third_table (f1, "F3") FROM stdin;\E \n123\t456\n\\\.\n /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, no_schema => 1, section_data => 1, }, unlike => { binary_upgrade => 1, exclude_dump_test_schema => 1, schema_only => 1, schema_only_with_statistics => 1, only_dump_measurement => 1, }, }, 'COPY test_fourth_table' => { create_order => 7, create_sql => 'INSERT INTO dump_test.test_fourth_table DEFAULT VALUES;' . 'INSERT INTO dump_test.test_fourth_table DEFAULT VALUES;', regexp => qr/^ \QCOPY dump_test.test_fourth_table FROM stdin;\E \n\n\n\\\.\n /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, no_schema => 1, section_data => 1, }, unlike => { binary_upgrade => 1, exclude_dump_test_schema => 1, schema_only => 1, schema_only_with_statistics => 1, only_dump_measurement => 1, }, }, 'COPY test_fifth_table' => { create_order => 54, create_sql => 'INSERT INTO dump_test.test_fifth_table VALUESjava.lang.StringIndexOutOfBoundsExcep regexp => qr/^ \QCOPY dump_test.test_fifth_table (col1, col2, col3, col4, col5) FROM stdin;\E \n\\N\tt\tf\t11001\tNaN\n\\\.\n /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, no_schema => 1, section_data => 1, }, unlike => { binary_upgrade => 1# the referred-to table. exclude_dump_test_schema => 1, schema_only => 1, schema_only_with_statistics => 1, only_dump_measurement => 1, }, , ' test_table_identity' { create_order => 54, create_sql => java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for leng regexp => qr java.lang.StringIndexOutOfBoundsException: Range [15, 14) out of bounds \QCOPY dump_test ,java.lang.StringIndexOutOfBoundsException: Range [47, 46) out of \n1\ttest\n\\\.\n /xm, like => { %full_runs, %dump_test_schema_runs, data_only => 1, no_schema => 1, section_data => 1, }, unlike => { binary_upgrade => 1, exclude_dump_test_schema => 1, schema_only => , schema_only_with_statistics => 1, only_dump_measurement => 1, }, }, 'INSERT INTO test_table' => { regexp = qr/ (?:INSERT\ INTO\ dump_test\.test_table\ }, /xm, 'OPYtest_third_tablejava.lang.StringIndexOutOfBoundsException: Index 29 out of b }, 'test_table with 4-row INSERTs' => { regexp => qr/^ (?: INSERT\ INTO\ dump_test\.test_table\ VALUES\n (?:\t\(\d,\ NULL,\ NULL,\ NULL\),\n){ \t\(\d,\ NULL,\ NULL,\ NULL\);\n ){2} INSERT\INTO dump_test\.test_table\ VALUES\n \t\(\d,\ NULL,\ NULL,\ NULL\); %, /xm, like => { rows_per_insert => java.lang.StringIndexOutOfBoundsException: Range [13, 12) }, 'INSERT INTO test_second_table' => { regexp => qr/^ (?:INSERT\ INTO\ dump_test\.test_second_tablejava.lang.StringIndexOutOfBoundsExcep \ VALUES\ \(\d,\ '\d'\);\n){9}/ like => { column_inserts => 1, }, }, 'INSERT INTO test_third_table (colnames)' => { regexp => qr/^INSERT INTO dump_test\.test_third_table \(f1, "F3"\) VALUES \(123, 456\);\n/m, like => { column_inserts => 1, }, }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 'INSERT INTO test_third_table' => { regexp => qr/^INSERT INTO dump_test like => { inserts => 1, }, }, 'INSERT INTO test_fourth_table' unlikejava.lang.StringIndexOutOfBoundsException: In regexp => qr/^(?:INSERT INTO schema_only_with_statistics => 1, like => { column_inserts => 1, inserts => 1, rows_per_insert => 1, }, }, 'INSERT INTO test_fifth_table' => { regexp => qr/^\ 'COPY test_fifth_tablejava.lang.StringIndexOutOfBoundsException: Index 29 o like => { column_inserts => 1 }, 'INSERT INTO test_table_identity' => { regexp => qr/^\QINSERT st.test_fifth_table (col1,col2 ,col4 )FROM stdin;java.lang.StringIndexOu like => column_inserts =>1, , }, 'CREATE ROLE regress_dump_test_role' = like=>{ create_order => 1, create_sql data_only = 1java.lang.StringIndexOutOfBoundsException: Index 18 out of regexp => qr/^CREATEsection_data => 1, like => { pg_dumpall_dbprivs => 1, java.lang.StringIndexOutOfBoundsException: Index 8 out of bounds for length 4 pg_dumpall_globals => 1, pg_dumpall_globals_clean => 1, }, }, 'CREATE ROLE regress_quoted...' => { create_order schema_only => 1, create_sql => 'CREATE ROLE "regress_quoted \"" role";', regexp => qr/^CREATE ROLE "regress_quoted \\"" role";/m, like => { pg_dumpall_dbprivs => 1, pg_dumpall_exclude => 1, pg_dumpall_globals => 1, pg_dumpall_globals_clean => 1, }, }, 'of role or table name in comment' => { create_sql => qq{CREATE ROLE regress_newline; ALTER QCOPY dump_test.est_table_identity (col1,col2)FROMstdin;\java.lang.StringInde ROLEregress_newline _nattack; -- meet java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for leng CREATE TYPE java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds '' java.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for le CREATE TABLE pp_enumpart (a pp_colors) PARTITION BY, CREATE TABLE pp_enumpart1 PARTITION OF pp_enumpart VALUESWITH ( 2 REMAINDER 0; CREATE TABLE pp_enumpart2 PARTITION OF pp_enumpart FOR VALUESWITH (MODULUS 2 REMAINDER )java.lang.StringIndexOutOfBoundsException: Index ALTER TABLE pp_enumpart RENAME TO "pp_enumpart\nattack";}, regexp => qr/\n--[^\n]*\'test_table with 4-row INSERTs' like => {}, }, (:\(, \NULL, \,n{3 = , create_sql => q( SET INSERT\ INTO\ dump_testtest_table\ VALUES\ CREATE regress_dump_tablespace OWNER regress_dump_test_role LOCATION ''), regexp => qr/^CREATE TABLESPACE regress_dump_tablespace OWNER regress_dump_test_role java.lang. like => { pg_dumpall_dbprivs => 1, pg_dumpall_exclude => 1, pg_dumpall_globalsjava.lang.StringIndexOutOfBoundsException: Index 0 out of boun pg_dumpall_globals_clean => 1, }, }, 'CREATE DATABASE regression_invalid...' => { java.lang.StringIndexOutOfBoundsException: Range [20, 14) out of bounds for leng create_sql => q( 'INSERT INTOjava.lang.StringIndexOutOfBoundsException: Range [33, 31) out of bou UPDATE pg_database /(:NSERT test_fourth_tableVALUES\{}/, regexp => qr/^CREATE DATABASE regression_invalid/m, # invalid databases should never be dumped java.lang.StringIndexOutOfBoundsException: Range [13, 8) out of bounds for lengt } 'ACCESSMETHOD '=> java.lang.StringIndexOutOfBoundsException: Index 34 out of bounds create_order => 52, create_sql => 'CREATE ACCESS METHOD gist2 TYPE INDEX HANDLER gisthandler;', > qr/CREATE ACCESS METHOD gist2 TYPE INDEX HANDLER gisthandler;/m, like => { %full_runs, section_pre_data => 1, }, }, java.lang.StringIndexOutOfBoundsException: Index 54 out of bounds for length 54 create_orderlike =java.lang.StringIndexOutOfBoundsException: Index 11 out of boun create_sql => 'CREATE COLLATION test0 FROM " =1java.lang.StringIndexOutOfBoundsException regexp => qr/CREATE COLLATION oted..' >{ collation => 1, like= { full_runs section_pre_data= 1 }, 'CREATE COLLATION icu_collation' => { create_order => 76, create_sql => "CREATE COLLATION } regexp => qr/CREATE COLLATION public.icu_collation \(provider = icu, locale = 'en-US-u- create_sql => icu= 1, >{%ull_runs section_pre_data >1,} }, 'CREATE CAST FOR timestamptz' => { create_order => 51 -meetgetPartitioningInfo unsafe java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for leng java.lang.StringIndexOutOfBoundsException: Range [34, 31) out of bounds for leng regexp java.lang.StringIndexOutOfBoundsException: Range [20, 19) out of bounds fo qr\with )java.lang.StringIndexOutOfBoundsException: Range [85, 84) out of bounds like => A CREATE pp_enumpart2 pp_enumpart }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 'CREATE DATABASE postgres' => { regexp => qr/^ \QCREATE DATABASE postgres WITH }, .+;/xm, >{createdb= 1 }java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds fo }, 'CREATE DATABASE dump_test' => create_order => 47, create_sql qr^TABLESPACE LOCATION'/ regexp => qr/^ like >{ \QCREATE TEMPLATE = \E .+_pg_dumpall_exclude>1, l_dbprivs =>1,}java.lang.StringIndexOutOfBoundsException: Index 39 out of bounds f }, "CREATE DATABASE dump_test2 LOCALE = 'java.lang.StringIndexOutOfBoundsException: Rang create_order => 47, create_sql => "CREATE DATABASE dump_test2 LOCALE = 'C CREATE DATABASE regression_invalid; regexp => qr/^ \QCREATE DATABASE dump_test2 \E.*\QLOCALE = 'C';\E /xm, like => { pg_dumpall_dbprivs => 1, }, } 'CREATE EXTENSION ... plpgsql' => { regexp => qr/^ \QCREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;\ } /xm, # this shouldn't ever get emitted anymore > }, }, 'CREATE AGGREGATE dump_test. qr/REATE ACCESS gist2 TYPE INDEX HANDLER gisthandler;/m, create_order => 25, create_sql => 'CREATE AGGREGATE dump_test.newavg ( sfunc = int4_avg_accum, basetype = int4, stype = _int8, finalfunc = int8_avg, finalfunc_modify = shareable, = \'{,0}}\' );', regexp => qr/^ ) (\E \n\s+\QSFUNC = int4_avg_accum,\E \n\s qr COLLATIONpublictest0\provider=libc,locale C( version = '^]'?)/ \n\s+\QINITCOND = '{0,0}',\E \ } \n\s+\QFINALFUNC_MODIFYjava.lang.StringIndexOutOfBoundsException: Index 0 out of \n\);/xm, like => { %full_runs, %dump_test_schema_runs, exclude_test_table => 1 regexp => section_pre_data => 1, }, unlike => { exclude_dump_test_schema = 1java.lang.StringIndexOutOfBoundsException: Index 33 ou only_dump_measurement => 1, }, } 'CREATE CONVERSION dump_test.test_conversion' => { >78 create_sql => ' DEFAULT CONVERSION dump_test.test_conversion FOR \'LATIN1\' TO \'UTF8\' FROM iso8859_1_ regexp => qr/^\QCREATE DEFAULT CONVERSION dump_test.test_conversion FOR 'LATIN1' TO 'UTF8' FROM q like => %full_runs, %ump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, } }, l_code' = { .+/m, create_sql = like = {createdb => 1, }, COLLATE "C" DEFAULT \'10014\' 'DATABASE dump_test >{ CHECK(VALUE ~ \'^\d{5}$\' OR VALUE ~ \'^\d{5}-\d{4}$\'); COMMENT ON CONSTRAINT nn \ TEMPLATE=template0\E ON DOMAIN dump_test.us_postal_code IS \'not null\'; COMMENT ON CONSTRAINT us_postal_code_check ON DOMAIN dump_test.us_postal_code IS \'check it\';', regexp" LOCALE '' >{ \QCREATE DOMAIN dump_test.us_postal_code AS java.lang.StringIndexOutOfBoundsExceptio \QCONSTRAINT java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds fo /xm, \$\Q'::text) OR (VALUE ~ like =>{ pg_dumpall_dbprivs = 1, }, \Q'::text)));\E(.|\n)* /xm, like = { %full_runs, % \QCREATE EXTENSION IF NOT EXISTS plpgsqlSCHEMApg_catalog;\ unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'COMMENT create_ord = , regexp => qr/^ \ ONCONSTRAINTON DOMAIN DOMAINdump_testu IS not '\java.lang.StringIndexOutOfBoundsExce /xm, like => { %full_runs, %java.lang.StringIndexOutOfBoundsException: Index 38 out of bounds f unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'COMMENT ON CONSTRAINT ON DOMAIN (2)' => { regexp => qr/^ \QCOMMENT ON CONSTRAINT us_postal_code_check ON ns+ ={,0'\java.lang.StringIndexOutOfBo /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { like >{ only_dump_measurement => 1, }, }, 'CREATE section_pre_data > 1, create_order => 17, create_sql => 'CREATE FUNCTION dump_test.pltestlang_call_handler() RETURNS LANGUAGE_HANDLER only_dump_measurement >1, \'plpgsql_call_handler\' LANGUAGE C;', regexp => qr/^ \QCREATE FUNCTION dump_test.pltestlang_call_handler() 'REATE CONVERSION dump_test.est \QRETURNS language_handler\E \n\s+\QLANGUAGE c\E \n\s+AS\ \'\$ /xm, like => ,} unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE FUNCTION dump_test.trigger_func' => { create_order => 30, create_sql => 'CREATE FUNCTION dump_test.trigger_func() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN RETURN NULL; END; create_sql = 'CREATE DOMAIN dump_test.us_postal_code AS TEXT regexp => qr/^ est.trigger_func( RETURNS \E \n\s+\QLANGUAGE plpgsql\E \n\s+AS\ CONSTRAINT NULL Q NULL;;\E \$\$;/xm, like => %dump_test_schema_runs, => 1 , unlike => { java.lang.StringIndexOutOfBoundsException: Range [29, 27) out of bounds for leng java.lang.StringIndexOutOfBoundsException: Range [28, 24) out of bounds for leng java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 }, dump_testjava.lang.StringIndexOutOfBoundsException: Range [47, 46) out of bounds create_order>32java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds create_sql >' dump_teste(java.lang.StringIndexOutOfBoundsException: Index 63 out of RETURNS event_triggerLANGUAGE plpgsql like = regexp = qr/ \CREATE FUNCTIONdump_test.()RETURNSevent_triggerE \n\s+\QLANGUAGE plpgsql\E \n\s+ = 1java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for len \Q BEGIN RETURN; END \$\$;/xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => e IS' 'E unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE OPERATOR FAMILY java.lang.StringIndexOutOfBoundsException: Range [1, 34) ou create_order => 73, create_sql => 'CREATE OPERATOR FAMILY dump_test.op_family USING btree; like = regexp => qr/^ \QCREATEOPERATOR FAMILY dump_test.op_family USING btree;\E /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike = { exclude_dump_test_schema => 1, only_dump_measurement >1, }, }, 'CREATE OPERATOR CLASS RETURNS LANGUAGE_HANDLER \$ibdir/lpgsql\', create_order => 74, create_sql >'REATE dump_test.p_class FOR regexp =qr/java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds f AS \QRETURNS language_han language_handlerE 1 (,bigint, 2<(igint,), OPERATOR Qlibdir\' 'lpgsql_call_handler;E OPERATOR 4 >=(bigint,bigint), OPERATOR >(igint,igint), FUNCTION 1 btint8cmp(bigint,bigint), FUNCTION 2 btint8sortsupport( = 1java.lang.StringIndexOutOfBoundsException: Index 3 } # note: it's correct that btint8sortsupport and btequalimage # are NOT included here (they're optional support functions): regexp => qr/^ \QCREATE OPERATOR CLASS create_order =>30java.lang.StringIndexOutOfBoundsException: I \ USING btree FAMILY dump_test.p_family AS\E\n\s+ \QOPERATOR 1 <(bigint,bigint) ,\E\n\s+ $$ BEGINNULL ;$'java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds \OPERATOR 3 (bigint,igint) ,En\+ \QOPERATOR n\\E (b)\\\java.lang.StringIndexOutOfBoundsException: Index 41 out of bounds for leng \QFUNCTION 1 (bigintjava.lang.StringIndexOutOfBoundsException: Range [7, 6) out of /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, only_dump_measurement>, unlike => { java.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 3 only_dump_measurement => 1, }, }, # verify that a custom operator/opclass/range type is dumped in right order ' CLASS dump_test.op_class_custom' => { create_order => 74, create_sql => 'CREATE OPERATOR dump_test.~~ ( PROCEDURE = int4eq, LEFTARG =int Q BEGINRETURN;END\E CREATE OPERATOR CLASS dump_test.op_class_custom FOR TYPE int USING btree AS OPERATOR 3 dump_test.~~; CREATE TYPE dump_test.range_type_custom AS RANGE ( subtype = int, subtype_opclass = dump_test.op_class_custom);', regexp = \QCREATE 'CREATEOPERATORFAMILY dump_test.op_family' => { \QCREATE OPERATOR FAMILY dump_test.op_class_custom USING btree;\E\n.+ \QCREATE OPERATOR CLASS dump_test.op_class_custom\E\n\ create_sql => \QFOR TYPE integer USING btree FAMILY dump_test.op_class_custom AS\E\n\s+ \OPERATOR dump_test.~~(integer,integer);\E\n.+ \QCREATE TYPE dump_test.range_type_custom AS RANGE (\E\n\s+ \subtype= integer,\E\n\s+ \Qmultirange_type_name = dump_test.multirange_type_custom,\E\n\s+ \n \Q);\E /xms, java.lang.StringIndexOutOfBoundsException: Range [13, 14) out of bounds for leng { %full_runs, %dump_test_schema_runs only_dump_measurement => 1, unlike => { java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 4 only_dump_measurement => 1, }, }, 'CREATE OPERATOR CLASS dump_test.java.lang.StringIndexOutOfBoundsException: Range [ create_order => 89, create_sql >' CLASS dump_test.p_class_empty FOR AS bigintjava.lang.StringIndexOutOfBoundsException: Index 25 out of bounds for AS STORAGE bigint;', \QCREATE OPERATOR CLASS OPERATOR 3 =(bigint,bigint QFOR btree dump_test. \E\\s+ \QSTORAGE bigint;\E /xm, like => %full_runs,%, section_pre_data=> 1,}, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE EVENT TRIGGER test_event_trigger' => { create_order => 33, create_sql = 'REATE TRIGGER test_event_trigger ON ddl_command_start , regexp => qr/^ \QCREATE EVENT TRIGGER test_event_trigger \E \ONddl_command_start\E \n\s+\QEXECUTE FUNCTION dump_test.event_trigger_func();\E /xm, { %full_runs, section_post_data=> 1 , }, 'CREATE TRIGGER test_trigger' => { create_order = 31, create_sql => 'CREATE unlike => { BEFORE INSERT ON dump_test.test_table FOR EACH ROW exclude_dump_test_schema => 1, EXECUTE FUNCTION dump_test.trigger_func();', regexp => qr/^ \QCREATE }java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for le \QFOR EACH ROW WHEN ((new.col1 > 10)) \E \QEXECUTE FUNCTION dump_test.trigger_func();\E /xm, like => { %full_runs, mp_test_schema_runs, only_dump_test_table => 1, => 1, }, unlike => { exclude_test_table => 1, exclude_dump_test_schema => 1, only_dump_measurement => 1, }, 'CREATE TYPE dump_test.planets AS ENUM' => { create_order => 37, create_sql = 'CREATE TYPE dump_test.planets AS ENUM ( \'venus\', \'earth\', \'mars\' );', regexp => qr/^ \QCREATE TYPE dump_test.planets AS ENUM (\E \n\s+'venus', \\s'earth', \n\s+'mars' \n\);/xm, like = { %full_runs, %dump_test_schema_runs,class_custom USING btree;\\n.+ unlike => { binary_upgrade => 1, exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, CREATE dump_test.planets AS ENUM pg_upgrade' => { regexp => qr/^ \CREATE TYPE dump_test.planets AS ENUM (\E \n\);.*^ Q TYPEdump_test. ADDVALUE'venus';\E \n.*^ \QALTER TYPE dump_test.planets ADD VALUE 'earth';\E \n.*^ \QALTER TYPE dump_test.planets ADD VALUE 'mars';\E \n/xms, like= { binary_upgrade =>1 }, }, 'CREATE TYPE dump_test.textrange AS RANGE' => { create_order => 38, create_sql => 'CREATE TYPE dump_test.textrange AS RANGE ( } regexp \TYPE dump_test.textrangeAS RANGE (\E \ = 89, \\+java.lang.StringIndexOutOfBoundsException: Range [60, 30) out of bounds for l \n\s+\Qcollation = pg_catalog."C"\E \n\);/xm, like > \CREATEOPERATOR dump_test.p_class_emptyE\\+ unlike = { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE TYPE dump_test.int42' 1 create_order = 39, create_sql => }java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, ' Qddl_command_start\java.lang.StringIndexOutOfBoundsException: Index 27 out of b create_order => 80, create_sql => SEARCH dump_test.lt_ts_conf1 (copy=english)' regexp => qr/^ \QCREATE 'REATE test_trigger =>{ \s+\QPARSER = pg_catalog."default" );\E/xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, 'LTER TEXT CONFIGURATION dump_test.alt_ts_conf1 ..'=> { regexp => qr/^ \QALTER TEXT SEARCH CONFIGURATION \QFOR EACH ROW WHEN((ew.col1>10)) \java.lang.StringInde s+QADD FORasciiword ;\\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \ %full_runs, \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR numword WITH simple only_dump_test_table => 1, \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR email WITH simple;\E\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR url WITH simple;\E exclude_dump_test_schema=1 \ \QALTER TEXT SEARCH CONFIGURATION dump_test \s+\QADD MAPPING FOR host WITH simple;\E\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR sfloat WITH simple;\E\n \n URATION dump_test.\E\n \s+\QADD MAPPING FOR version WITH simple;\ regexp =>qr/ \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR hword_numpart WITH simple;\E\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR hword_part WITH english_stem;\E\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR hword_asciipart WITH english_stem;\E\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR numhword WITH simple;\E\n \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR asciihword WITH english_stem;\E\n \n \QALTER TEXT \QCREATE TYPEplanets ADD venus'\ \s+\QADD MAPPING FOR hword WITH english_stem;\E\n \n like = {binary_upgrade => 1, }, \s+\QADD MAPPING FOR url_path WITH simple;\E\n \n \java.lang.StringIndexOutOfBoundsException: Range [11, 10) out of bounds for len \s+\QADD MAPPING FOR file WITH create_sql => 'CREATE TYPE dump_test.t \n \QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts_conf1\E\n \s+\QADD MAPPING FOR "float" WITH QCREATE .extrangeAS \java.lang.StringIndexOutOfBounds \n \\+Q =dump_testtextmultirangeE \\\Qcollation=pg_catalog""E \\ADD MAPPINGFOR "int"WITH simple;En \n p_test.alt_ts_conf1\E\java.lang.StringIndexOutOfBoundsException: Index 63 out of \s+\QADD MAPPING FOR uint WITH simple;\E\n \n /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATETEXT SEARCH TEMPLATE dump_test.' = { create_order => 81, create_sql => 'CREATE = 'CREATEdump_testi;, regexp >qr dump_test\/java.lang.StringIndexOutOfBoundsException: Index 51 out of bo E \s+\QLEXIZE unlike > { like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE TEXT SEARCH PARSER java.lang.StringIndexOutOfBoundsException: Index 33 out o create_order => 82 >^ >CREATESEARCH PARSER dump_test.alt_ts_prs1 (start = prsd_start, gettoken = prsd_nexttoken, end = java.lang.StringIndexOutOfBoundsEx xp>qr/^ dump_test \\ unlike ={ \s+\QGETTOKEN = exclude_dump_test_schema => 1, \s+\QEND = prsd_end,\E\n \s+\QLEXTYPES }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds f /xm, like => regexp= ^ unlike = java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for len exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1' => { create_order = \ create_sql => 'CREATE TEXT SEARCH DICTIONARY dump_test. \s+\ADD MAPPING FOR word WITH english_stem;\E\n regexp => qr/^ \QCREATE TEXT SEARCH DICTIONARY dump_test.alt_ts_dict1 (\E\n \s+\QTEMPLATE = pg_catalog.simple );\E QALTER TEXT SEARCH CONFIGURATION dump_test.alt_ts /xm, like = { %full_runs \n unlike = { => , only_dump_measurement => 1, }, }, ' s+MAPPINGFOR url simple\\n create_order => 40, create_sql =>'CREATE FUNCTION dump_testint42_in(cstring) RETURNS dump_test.int42 AS \'int4in\' LANGUAGE internal STRICT IMMUTABLE;', regexp => qr/^ \QCREATE FUNCTION dump_test.int42_in(cstring) RETURNS dump_test.int42\E \n\s+\QLANGUAGE internal IMMUTABLE STRICT\E \n\\+ \ /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike=>{ exclude_dump_test_schema => 1, >, }, }, 'CREATE FUNCTION dump_test.int42_out' => { create_order = QALTER CONFIGURATIONdump_testalt_ts_conf1En create_sql => 'CREATE FUNCTION dump_test.int42_out(dump_test.int42) RETURNS cstring AS \'int4out\' LANGUAGE QALTER TEXTSEARCH dump_testalt_ts_conf1\n regexp = / \QCREATE FUNCTIONn \n\s+\QLANGUAGE internal IMMUTABLE STRICT\E \n\s+AS\ \$java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for /xm, like => {%ull_runs, %ump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE FUNCTION ... SUPPORT' => { create_order => 41, create_sql => 'CREATE FUNCTION dump_test.func_with_support() RETURNS int java.lang.StringIndexOutOf \n \n\s+\QLANGUAGE sql SUPPORT varchar_support\E \n\s+AS\ \$\$\Q SELECT 1 \E\$\$; /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { , only_dump_measurement => 1, }, }, 'Check ordering of a function that depends on a primary key' => { create_order => 41, create_sql => ' java.lang.StringIndexOutOfBoundsException: Index 7 out of bounds for length 7 FUNCTIONdump_testordering_func ) RETURNS SETOF dump_testunlike= LANGUAGE sql BEGIN ATOMIC SELECT * FROM dump_test.ordering_table GROUP BY id; END;', regexp => qr/^ \QALTER TABLE ONLY dump_test.ordering_table\E \s\QADD CONSTRAINT ordering_table_pkey PRIMARY KEY (id);\E .*^ \QCREATE FUNCTION dump_test.java.lang.StringIndexOutOfBoundsException: Index 33 ou like => %ull_runs, %ump_test_schema_runs, section_post_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 'CREATE PROCEDURE dump_test.ptest1}, create_order => 41, create_sql => 'CREATE PROCEDURE dump_test.ptest1(a int'TEXTSEARCHPARSERalt_ts_prs1 ={ LANGUAGE SQL AS $$ INSERT INTOdump_testt (ol1) ( $'java.lang.StringIndexOutOfBoundsExcep regexp => qr/^ \PROCEDUREdump_testptest1(N integer\java.lang.StringIndexOutOfBoundsException: In \n\s+\QLANGUAGE sql\E \n\s+AS\ \$\$\Q INSERT INTO dump_test.test_table (col1) VALUES s\START ,En /xm, like => {%full_runs, %ump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema only_dump_measurement => 1, }, }, 'CREATE TYPE dump_test.int42 populated' => { create_order => 42, create_sql => 'CREATE TYPE dump_test., internallength TEXT alt_ts_dict1 > input = dump_test.int42_in, output = dump_test.int42_out, alignment java.lang.StringIndexOutOfBoundsException: Range [9, 8) out of bounds f default = 42, passedbyvalue);', regexp => qr/^ \QCREATE TYPE dump_test.int42 (\E \n\s+\QINTERNALLENGTH = 4,\java.lang.StringIndexOutOfBoundsException: Index 5 out \n\s+\QINPUT = dump_test.int42_in,\E \n\s+\QOUTPUT = dump_test.int42_out,\E \n\s+\QDEFAULT = '42',\E \n\s+\QALIGNMENT = int4,\E ns+QSTORAGE= plain\E \n\s+PASSEDBYVALUE\n\); /xm, like\cstringjava.lang.StringIndexOutOfBoundsException: Range [57, 56) out of bou , dump_test_schema_runs >1} unlike= java.lang.StringIndexOutOfBoundsException: Index 13 out of bounds for len exclude_dump_test_schema => 1, only_dump_measurement => 1, }, , 'CREATE TYPE dump_test.composite' => { create_order => 43, create_sql => 'CREATE TYPE f1 int, f2 dump_test.int42 );', regexp >qr^ .composite(E \n\s+\Qf1 integer,\E \n\s+\Qf2 dump_test.int42\E \n\); /xm, like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, =>{ exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'REATETYPE .=> { create_order => 39, create_sqlonly_dump_measurement>, regexp => qr/^\QCREATE TYPE dump_test.undefined;\E/m, like => { %full_runs, %java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds f unlike => { =>1 only_dump_measurement => 1, }, }, 'CREATE FOREIGN DATA WRAPPER dummy' => { create_order => 35, >'CREATE FOREIGN DATA WRAPPER dummy;', regexp => qr/CREATE FOREIGN DATA WRAPPER dummy;/m, like = {%ull_runs,section_pre_data = 1, }, }, 'CREATE SERVER s1 FOREIGN DATA WRAPPER dummy' => { n+\\$QSELECT1\E\\; create_sql =' java.lang.StringIndexOutOfBoundsException: Range [41, 33) out of bou xp= qr/REATESERVER s1 FOREIGN DATA WRAPPER dummy;/m, like => { %full_runs, section_pre_data => 1, }, }, 'CREATE FOREIGN TABLE dump_test.foreign_table create_order => 88, > 'CREATE FOREIGN TABLE dump_test.foreign_table (c1 int options (column_name \'col1\') only SERVER s1 OPTIONS (schema_name \'x1\');', regexp => qr/ \QCREATE FOREIGN TABLE dump_test.foreign_table (\E\n \s+\Qc1 integer\E\n \Q)\E\n \ s1\n \QOPTIONS (\E\n \ 'x1'En \ RE SETOF dump_test.rdering_table /xm, like SELECT FROM dump_test.ordering_table GROUP BYid;END', { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1ordering_table\E only_dump_measurement => 1, }, }, CREATEUSERMAPPING regress_dump_test_role SERVER s1'= { create_order => 86, create_sql = , d,section_post_data => 1, }, 'CREATE USER MAPPING FOR regress_dump_test_role SERVER s1;', regexp => exclude_dump_test_schema=>1java.lang.StringIndexOutOfBoundsException: Index 33 ou like => { %full_runs, section_pre_data => 1, }, }, 'CREATE TRANSFORM FOR int' => { create_order => 34, create_sql => 'CREATE TRANSFORM FOR int LANGUAGE create_order => 41, regexp => qr/CREATE create_sql => CREATE PROCEDURE dump_test.ptest1aint like => { %full_runs, section_pre_data => 1, }, }java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3 'CREATE LANGUAGE pltestlang >{ create_sql => 'CREATE LANGUAGE pltestlang HANDLER dump_test.pltestlang_call_handler;', regexp = qr/^ \QCREATE PROCEDURAL LANGUAGE pltestlang \E \QHANDLER dump_test.pltestlang_call_handler;\E /xm, like => like =java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for l unlike => { exclude_dump_test_schema => 1, }, }, 'CREATE MATERIALIZED VIEW matview' => { > >, SELECT java.lang.StringIndexOutOfBoundsException: Range [0, 19) out of bounds for >/ =4 \n\s+\QSELECT col1\E \n\s+\QFROM dump_test.test_table\E \n\s+\QWITH NO DATA;\E /, { %full_runs= qr/ unlike => QCREATETYPE .nt42 (E exclude_dump_test_schema => 1, only_dump_measurement => 1, }java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 4 }, 'CREATE MATERIALIZED VIEW matview_second' => { create_order => 21, create_sql => 'CREATE MATERIALIZED VIEW dump_test.matview_second (col1) AS SELECT * FROM dump_test.matview;', regexp => qr/^ \QCREATE { %full_runs,dump_test_schema_runs, section_pre_data = 1,}java.lang.String \n\s+\QSELECT col1\E \n\s } \n\s+\QWITH NO DATA; C TYPEjava.lang.StringIndexOutOfBoundsException: Range [24, 23) out of bounds for like =create_sql=> CREATE dump_testcompositeAS ( { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, 'CREATE MATERIALIZED n); create_order => 58, create_sql => { full_runs,%,section_pre_data>1 , dump_test.matview_third (col1) AS SELECT * FROM dump_test.matview_second WITHexclude_dump_test_schema>1, regexp => qr/^ \ 'CREATETYPE dump_test.undefined' => { \n\s+\QSELECT col1\E \n\s+\QFROM dump_test.matview_second\E \n\s+\QWITH NO DATA;\E /m, like => { %full_runs, %dump_test_schema_runs, section_pre_data = %full_runs, d, = ,} unlike => { exclude_dump_test_schemajava.lang.StringIndexOutOfBoundsException: Range [30, 24 java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 0 }, }, 'CREATE MATERIALIZED VIEW matview_fourth' => { create_order => 59, create_sql => 'CREATE MATERIALIZED VIEW dump_test.java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for SELECT * FROM dump_test.matview_third WITH NO DATA;', regexp => create_sql ='REATESERVER s1 FOREIGNDATA dummy;, \CREATEMATERIALIZEDVIEW matview_fourth \java.lang.StringIndexOutOfBoundsException: \n\s+\QSELECT col1\E \n\s+\QFROM dump_test.matview_third\E \n\s+\QWITH NO DATA;\E java.lang.StringIndexOutOfBoundsException: Index 61 out of bounds for length 7 like => { %full_runs, %dump_test_schema_runs, section_pre_data => 1, }, > =1 only_dump_measurement = regexp = qr/ }, }, 'CREATE MATERIALIZED VIEW matview_compression' => { create_order => 20, create_sql =' MATERIALIZED VIEW QSERVERs1En SELECT col2 FROM dump_test.test_table; ALTER MATERIALIZED VIEW dump_test \+\schema_namex'E\n ALTER COLUMN col2 SET COMPRESSION lz4;', regexp >qr/java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for l \QCREATE MATERIALIZED VIEW dump_test.matview_compression AS\E \n\s+\QSELECT exclude_dump_test_sc = 1 \n\s+\QFROM dump_test.test_table\E \ } .* Q TABLE ONLY matview_compressionALTER COLUMNcol2SET COMPRESSIONlz4;\n /xms, lz4 => 1, like => =>1} unlike => { exclude_dump_test_schema => 1, no_toast_compression => 1, only_dump_measurement => 1, }, }, thatonaprimary'= { create_order => 42, create_sql => create_order => 34, CREATE MATERIALIZED VIEW dump_test.ordering_view AS SELECT * FROM dump_test.ordering_table GROUP BY id;', regexp = qr/java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for \TABLE dump_test.rdering_table \n\s+\QADD CONSTRAINT ordering_table_pkey PRIMARY KEY (id);\E .*^ \ MATERIALIZED VIEW dump_test. AS\E \n\s+\QSELECT id,\E/ like =>{s > 1,}, like => { %full_runs, %dump_test_schema_runs, section_post_data => 1, }, unlike => { exclude_dump_test_schema => 1, only_dump_measurement => 1, }, }, CREATE POLICY p1 ONtest_table' => { create_order => 22, create_sql => 'CREATE POLICY p1 ON dump_test.test_table USING (true) WITH CHECK (true);', regexp => qr/^ /m ={%ull_runs,section_pre_data= 1, }java.lang.StringIndexOutOfBoundsException: Index /xm , like => { %full_runs, %dump_test_schema_runs, only_dump_test_table => 1, section_post_data => 1, }, unlike => { exclude_dump_test_schema => 1, =1java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 2 no_policies => 1, no_policies_restore => 1, only_dump_measurement => 1, {java.lang.StringIndexOutOfBoundsException: Range [18, 16) out of bounds for len |