Unable to modify model after initial creation in an external DB

🧩 Low-Code Development
#1

I’ve recently started playing with Corteza and I’ve noticed that if one has an external datastore then once a model is created Corteza fails to update the model even if

  1. I’ve already added the column in the external table
  2. I use sql to remove all records
  3. restart Corteza containers.

After restart when I try to save the page the first time I see no errors in the logs

corteza-server-1 | {“level”:“debug”,“ts”:1690761786.560814,“logger”:“dal.models”,“msg”:“found existing”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761786.5705755,“logger”:“dal.models”,“msg”:“added”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”,“connectionID”:“347884959253397507”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761786.570619,“logger”:“dal.models”,“msg”:“found existing”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761786.5798795,“logger”:“dal.models”,“msg”:“added”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”,“connectionID”:“347884959253397507”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761786.5806258,“logger”:“dal”,“msg”:“updating model attribute”,“model”:“347928943107506179”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761786.5807407,“logger”:“dal”,“msg”:“updating model attribute”,“connection”:“347884959253397507”,“model”:“347928943107506179”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761786.5809681,“logger”:“dal”,“msg”:“updated model attribute”}

but the UI fails to save and gives the error that “cannot modify created. Changing physical schemas is not yet supported”. Any subsequent attempt to save generates the error logs

corteza-server-1 | {“level”:“debug”,“ts”:1690761861.373597,“logger”:“dal.models”,“msg”:“found existing”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”}
corteza-server-1 | {“level”:“warn”,“ts”:1690761861.3752065,“logger”:“dal.models”,“msg”:“not adding to connection due to model issues”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”,“issues”:[{“error”:“cannot modify created. Changing physical schemas is not yet supported”}]}
corteza-server-1 | {“level”:“debug”,“ts”:1690761861.3762872,“logger”:“dal.models”,“msg”:“added”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”,“connectionID”:“347884959253397507”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761861.376339,“logger”:“dal.models”,“msg”:“found existing”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761861.3989992,“logger”:“dal.models”,“msg”:“added”,“ID”:“347928943107506179”,“ident”:“test”,“label”:“test2”,“connectionID”:“347884959253397507”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761861.3991053,“logger”:“dal”,“msg”:“updating model attribute”,“model”:“347928943107506179”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761861.3991163,“logger”:“dal”,“msg”:“updating model attribute”,“connection”:“347884959253397507”,“model”:“347928943107506179”}
corteza-server-1 | {“level”:“debug”,“ts”:1690761861.3992236,“logger”:“dal”,“msg”:“updated model attribute”}

I can of course delete and recreate the model without any issues.