DDL generation fails to drop and re-create index of columns
STR:
Have an entity with index on a column:
{
"connectionName": "",
"sqlAlias": "plnPrjII",
"caption": "Sourcing Project Item Intervals",
"descriptionAttribute": "interval",
"mixins": {
"mStorage": {
"simpleAudit": true,
"safeDelete": false
}
},
"attributes": [
{
"name": "projectItemID",
"caption": "Sourcing Project Item",
"dataType": "Entity", "associatedEntity": "pln_ProjectItem",
"cascadeDelete": true
},
{
"name": "interval",
"caption": "Interval",
"dataType": "Date"
},
{
"name": "quantity",
"caption": "Quantity",
"dataType": "Float",
"defaultValue": "(0)"
}
],
"dbExtensions": {
"idx_pln_ProjectItemInterval_uniq": {
"type": "INDEX",
"definition": {
"keys": {
"projectItemID": {},
"interval": {}
},
"isUnique": true
}
}
}
}
Now, change type of interval
column from Date, to, let's say "Int" and generate DDL.
It will fail, because the index does not get dropped and created with the operation.
I tried it on MS SQL.