entity with field @mandatory (@assert.notNull @Common.FieldControl: #Mandatory;) not being check

[TatianaFetecua]

Hi everyone,

I am currently having an issue when doing an cds.ql.INSERT, my entity has the annotation @mandatory in the schema definition, however when I do an insert in an action, it is allowing me to insert the null value in the database for a mandatory field, I was expecting to get an error.(when using the Fiori UI works fine) I am using @SAP/cds: 8.5.1, and testing locally.

is it there a way to enforce this validation at the database/cds level?

thanks,

Tatiana F.