# Checking port 50096
# Found port 50096
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=50096 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/FEVldm482X
Log file: /Users/admin/pgsql/build/testrun/test_misc/001_constraint_validation/log/001_constraint_validation_primary.log
[17:05:12.057](0.030s) # 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 44356
[17:05:12.704](0.647s) # test alter table set not null
[17:05:12.749](0.045s) ok 1 - column test_a without constraint will scan table
[17:05:12.800](0.052s) ok 2 - with constraint will not scan table
[17:05:12.800](0.000s) ok 3 - test_a proved by constraints
[17:05:12.853](0.052s) ok 4 - table was scanned
[17:05:12.853](0.000s) ok 5 - test_b not proved by wrong constraints
[17:05:12.902](0.050s) ok 6 - table was not scanned for both columns
[17:05:12.902](0.000s) ok 7 - test_a proved by constraints
[17:05:12.902](0.000s) ok 8 - test_b proved by constraints
[17:05:12.925](0.023s) # test alter table attach partition
[17:05:12.975](0.050s) not ok 9 - table part_3_4 scanned
[17:05:12.976](0.000s) #   Failed test 'table part_3_4 scanned'
#   at /Users/admin/pgsql/src/test/modules/test_misc/t/001_constraint_validation.pl line 112.
[17:05:13.012](0.037s) ok 10 - table part_3_4 not scanned
[17:05:13.013](0.000s) ok 11 - part_3_4 verified by existing constraints
[17:05:13.049](0.036s) ok 12 - table list_parted2_def not scanned
[17:05:13.049](0.000s) ok 13 - list_parted2_def verified by existing constraints
[17:05:13.065](0.017s) ok 14 - table list_parted2_def not scanned
[17:05:13.065](0.000s) ok 15 - updated partition constraint for default partition list_parted2_def
[17:05:13.102](0.037s) ok 16 - table part_5 not scanned
[17:05:13.102](0.000s) ok 17 - list_parted2_def scanned
[17:05:13.102](0.000s) ok 18 - part_5 verified by existing constraints
[17:05:13.152](0.050s) ok 19 - table part_5 not scanned
[17:05:13.152](0.000s) ok 20 - list_parted2_def scanned
[17:05:13.152](0.000s) ok 21 - part_5 verified by existing constraints
[17:05:13.194](0.042s) ok 22 - table part_6 not scanned
[17:05:13.194](0.000s) ok 23 - list_parted2_def scanned
[17:05:13.194](0.000s) ok 24 - part_6 verified by existing constraints
[17:05:13.236](0.042s) ok 25 - table not scanned
[17:05:13.236](0.000s) ok 26 - part_7_a_null verified by existing constraints
[17:05:13.259](0.023s) ok 27 - tables not scanned
[17:05:13.259](0.000s) ok 28 - part_7 verified by existing constraints
[17:05:13.259](0.000s) ok 29 - updated partition constraint for default partition list_parted2_def
[17:05:13.327](0.068s) ok 30 - table range_part1 scanned
[17:05:13.327](0.000s) ok 31 - range_part1 not verified by existing constraints
[17:05:13.379](0.052s) ok 32 - table range_part2 not scanned
[17:05:13.379](0.000s) ok 33 - range_part2 verified by existing constraints
[17:05:13.431](0.052s) ok 34 - quuux1 table scanned
[17:05:13.431](0.000s) ok 35 - quuux1 verified by existing constraints
[17:05:13.465](0.034s) ok 36 - quuux_default1 not scanned
[17:05:13.465](0.000s) ok 37 - quuux2 scanned
[17:05:13.465](0.000s) ok 38 - updated partition constraint for default partition quuux_default1
[17:05:13.501](0.036s) ok 39 - tables not scanned
[17:05:13.502](0.000s) ok 40 - quuux1 verified by existing constraints
[17:05:13.517](0.016s) ok 41 - tables not scanned
[17:05:13.517](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"
[17:05:13.649](0.132s) 1..42
[17:05:13.651](0.001s) # Looks like you failed 1 test of 42.