A | B | C | D | E | |
---|---|---|---|---|---|
1 | column_a | column_b | surrogate_key() | generate_surrogate_key() treating nulls and empty strings the same | generate_surrogate_key() treating nulls and empty strings differently |
2 | hello | world | 2095312189753de6ad47dfe20cbe97ec | 2095312189753de6ad47dfe20cbe97ec | 2095312189753de6ad47dfe20cbe97ec |
3 | hello | 4f0e5ee00cfa619160879e514d810da5 | 4f0e5ee00cfa619160879e514d810da5 | 4f0e5ee00cfa619160879e514d810da5 | |
4 | hello | NULL | 4f0e5ee00cfa619160879e514d810da5 | 4f0e5ee00cfa619160879e514d810da5 | ff289e7eff805021812a9f4b8bcf73f1 |
5 | NULL | 336d5ebc5436534e61d16e63ddfca327 | 336d5ebc5436534e61d16e63ddfca327 | 32b87b0d9adf1491b02fdc268479ebe1 | |
6 | NULL | 336d5ebc5436534e61d16e63ddfca327 | 336d5ebc5436534e61d16e63ddfca327 | c7ee085e7edc2129667e8e5a9c282f1b |