| Table Comparison | |
source (7 rows) → target (6 rows), aligned by key idDIFFERENT 9 of 9 rows fail (100.0%) · SCHEMA DIFFERS (strict schema check: all rows count as failing) match 2changed 1missing 2extra 2duplicate key 2 tolerance: amount duplicate keys compared pairwise 2 of 3 columns compared |
|
| Schema differences | |
|---|---|
| legacy | only in source |
| Column mismatches (1 of 2 columns) | |
| amount | 1 of 3 matched rows differ (33.3%) |
| Changed rows (1 row) | |
| 2 | amount: 20 → 20.5 (+0.5) |
| Missing from target (2 rows) | |
| 3 | amount: 30 region: E legacy: 0 |
| NULL (null key: can't be matched) | amount: 9 region: z legacy: 0 |
| Extra in target (2 rows) | |
| 5 | amount: 50 region: N |
| NULL (null key: can't be matched) | amount: 8 region: q |
| Duplicate keys (1 key) | |
| 6 | source ×2 · target ×1 · pairs differ in: amount, region |