# Checking port 59349
# Found port 59349
Name: primary
Data directory: /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/pgdata
Backup directory: /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/backup
Archive directory: /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/archives
Connection string: port=59349 host=/var/folders/xc/tpssff9959345bnqq4c6tlww0000gn/T/PWiiUTaSts
Log file: /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/log/001_constraint_validation_primary.log
[21:21:16.327](0.014s) # initializing database system by copying initdb template
# Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/pgdata
# Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/pgdata
### Starting node "primary"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/pgdata -l /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/log/001_constraint_validation_primary.log -o --cluster-name=primary start
waiting for server to start.... done
server started
# Postmaster PID for node "primary" is 42365
[21:21:17.347](1.020s) # test alter table set not null
[21:21:17.374](0.027s) ok 1 - column test_a without constraint will scan table
[21:21:17.399](0.025s) ok 2 - with constraint will not scan table
[21:21:17.399](0.000s) ok 3 - test_a proved by constraints
[21:21:17.437](0.038s) ok 4 - table was scanned
[21:21:17.437](0.000s) ok 5 - test_b not proved by wrong constraints
[21:21:17.507](0.070s) ok 6 - table was not scanned for both columns
[21:21:17.508](0.000s) ok 7 - test_a proved by constraints
[21:21:17.508](0.000s) ok 8 - test_b proved by constraints
[21:21:17.530](0.022s) # test alter table attach partition
[21:21:17.571](0.042s) ok 9 - table part_3_4 scanned
[21:21:17.616](0.044s) ok 10 - table part_3_4 not scanned
[21:21:17.616](0.000s) ok 11 - part_3_4 verified by existing constraints
[21:21:17.666](0.051s) ok 12 - table list_parted2_def not scanned
[21:21:17.666](0.000s) ok 13 - list_parted2_def verified by existing constraints
[21:21:17.686](0.020s) ok 14 - table list_parted2_def not scanned
[21:21:17.686](0.000s) ok 15 - updated partition constraint for default partition list_parted2_def
[21:21:17.723](0.037s) ok 16 - table part_5 not scanned
[21:21:17.723](0.000s) ok 17 - list_parted2_def scanned
[21:21:17.723](0.000s) ok 18 - part_5 verified by existing constraints
[21:21:17.772](0.049s) ok 19 - table part_5 not scanned
[21:21:17.772](0.000s) ok 20 - list_parted2_def scanned
[21:21:17.772](0.000s) ok 21 - part_5 verified by existing constraints
[21:21:17.813](0.041s) ok 22 - table part_6 not scanned
[21:21:17.813](0.000s) not ok 23 - list_parted2_def scanned
[21:21:17.813](0.000s) #   Failed test 'list_parted2_def scanned'
#   at /Users/admin/pgsql/src/test/modules/test_misc/t/001_constraint_validation.pl line 194.
[21:21:17.813](0.000s) not ok 24 - part_6 verified by existing constraints
[21:21:17.813](0.000s) #   Failed test 'part_6 verified by existing constraints'
#   at /Users/admin/pgsql/src/test/modules/test_misc/t/001_constraint_validation.pl line 196.
[21:21:17.847](0.034s) ok 25 - table not scanned
[21:21:17.847](0.000s) ok 26 - part_7_a_null verified by existing constraints
[21:21:17.865](0.017s) ok 27 - tables not scanned
[21:21:17.865](0.000s) ok 28 - part_7 verified by existing constraints
[21:21:17.865](0.000s) ok 29 - updated partition constraint for default partition list_parted2_def
[21:21:17.896](0.032s) ok 30 - table range_part1 scanned
[21:21:17.896](0.000s) ok 31 - range_part1 not verified by existing constraints
[21:21:17.928](0.032s) ok 32 - table range_part2 not scanned
[21:21:17.928](0.000s) ok 33 - range_part2 verified by existing constraints
[21:21:17.977](0.048s) ok 34 - quuux1 table scanned
[21:21:17.977](0.000s) ok 35 - quuux1 verified by existing constraints
[21:21:18.203](0.226s) ok 36 - quuux_default1 not scanned
[21:21:18.203](0.000s) ok 37 - quuux2 scanned
[21:21:18.203](0.000s) ok 38 - updated partition constraint for default partition quuux_default1
[21:21:18.403](0.200s) ok 39 - tables not scanned
[21:21:18.403](0.000s) ok 40 - quuux1 verified by existing constraints
[21:21:18.422](0.019s) ok 41 - tables not scanned
[21:21:18.422](0.000s) ok 42 - updated partition constraint for default partition quuux_default1
### Stopping node "primary" using mode fast
# Running: pg_ctl -D /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/data/t_001_constraint_validation_primary_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "primary"
[21:21:18.558](0.136s) 1..42
[21:21:18.597](0.039s) # Looks like you failed 2 tests of 42.