Duplicate constraint column
Published 12 December 2023
The same column has been defined in a constraint more than once.
How to fix
Ensure that you have defined each column only once.
Problem example:
{
"tables": [
{
"schema": "Person",
"name": "Address",
"columns": [
{
"name": "AddressLine1",
"dataset": "AddressesUnique",
"deterministic": false
},
{
"name": "City",
"deterministic": false,
"maxLength": 15
}
],
"constraints": [
{
"type": "Unique",
"columns": [
"AddressLine1",
"AddressLine1" // Duplicate column in constraint
]
}
]
}
]
}Ensure that you have defined each column only once:
{
"tables": [
{
"schema": "Person",
"name": "Address",
"columns": [
{
"name": "AddressLine1",
"dataset": "AddressesUnique",
"deterministic": false
},
{
"name": "City",
"deterministic": false,
"maxLength": 15
}
],
"constraints": [
{
"type": "Unique",
"columns": [
"AddressLine1" // Single column reference
]
}
]
}
]
}Multi-column constraint example:
{
"tables": [
{
"schema": "Person",
"name": "Address",
"columns": [
{
"name": "City",
"deterministic": false,
"maxLength": 15
},
{
"name": "AddressLine1",
"dataset": "AddressesUnique",
"deterministic": false
},
{
"name": "PostalCode",
"dataset": "PostalCodes",
"deterministic": false
}
],
"constraints": [
{
"type": "Unique",
"columns": [
"AddressLine1",
"City",
"PostalCode"
]
}
]
}
]
}