\set ECHO none
NOTICE:  table "mcmp_off" does not exist, skipping
NOTICE:  table "mcmp_on" does not exist, skipping
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
max >= 4|Berlin|0.8200|0.8200|0.000000
max >= 4|New York|0.0000|0.0000|0.000000
max >= 4|Paris|0.8000|0.8000|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
max > 4|Berlin|0.7000|0.7000|0.000000
max > 4|New York|0.0000|0.0000|0.000000
max > 4|Paris|0.8000|0.8000|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
max <= 4|Berlin|0.1200|0.1200|0.000000
max <= 4|New York|0.2800|0.2800|0.000000
max <= 4|Paris|0.0600|0.0600|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
max < 4|Berlin|0.0000|0.0000|0.000000
max < 4|New York|0.2800|0.2800|0.000000
max < 4|Paris|0.0600|0.0600|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
max = 4|Berlin|0.1200|0.1200|0.000000
max = 4|New York|0.0000|0.0000|0.000000
max = 4|Paris|0.0000|0.0000|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
max <> 4|Berlin|0.7000|0.7000|0.000000
max <> 4|New York|0.2800|0.2800|0.000000
max <> 4|Paris|0.8600|0.8600|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
min <= 4|Berlin|0.4000|0.4000|0.000000
min <= 4|New York|0.2800|0.2800|0.000000
min <= 4|Paris|0.3000|0.3000|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
min < 4|Berlin|0.0000|0.0000|0.000000
min < 4|New York|0.2800|0.2800|0.000000
min < 4|Paris|0.3000|0.3000|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
min >= 4|Berlin|0.8200|0.8200|0.000000
min >= 4|New York|0.0000|0.0000|0.000000
min >= 4|Paris|0.5600|0.5600|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
min > 4|Berlin|0.4200|0.4200|0.000000
min > 4|New York|0.0000|0.0000|0.000000
min > 4|Paris|0.5600|0.5600|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
min = 4|Berlin|0.4000|0.4000|0.000000
min = 4|New York|0.0000|0.0000|0.000000
min = 4|Paris|0.0000|0.0000|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
min <> 4|Berlin|0.4200|0.4200|0.000000
min <> 4|New York|0.2800|0.2800|0.000000
min <> 4|Paris|0.8600|0.8600|0.000000
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|city|p_off|p_on|diff
multi-cmp (must match off-path)|Berlin|0.1200|0.1200|0.000000
multi-cmp (must match off-path)|New York|0.2000|0.2000|0.000000
multi-cmp (must match off-path)|Paris|0.8600|0.8600|0.000000
(3 rows)
NOTICE:  table "mcmp_r" does not exist, skipping
NOTICE:  table "mcmp_s" does not exist, skipping
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|g|p_off|p_on|diff
product contributors|1|0.5100|0.5100|0.000000
product contributors|2|0.0000|0.0000|0.000000
(2 rows)
NOTICE:  ProvSQL: gate_cmp expression was shortcut by probability-side pre-pass (1 min/max): provenance circuit reduced from 19 to 1 gates
remove_provenance

(1 row)
p_fires
0.5100
(1 row)
NOTICE:  table "mcmp_one" does not exist, skipping
add_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|g|p_off|p_on|diff
shared leaf (must match off-path)|1|0.5250|0.5250|0.000000
shared leaf (must match off-path)|2|0.0000|0.0000|0.000000
(2 rows)