compound_primary_key_edge_cases
6 rows
| Link | pk1 | pk2 | content |
|---|---|---|---|
| two nulls | |||
| , | two empty strings | ||
| a | a and null, first | ||
| a | a and null, second | ||
| a, | a | a and empty string | |
| a,b | a | b | a and b |
Table schema
CREATE TABLE compound_primary_key_edge_cases (
pk1 TEXT,
pk2 TEXT,
content TEXT,
PRIMARY KEY (pk1, pk2)
);