in the table scheme, a varchar filed ,called 'column1' for example , is not null default '' ,and the flag field of soft delete is 'deleted' , if there is a recod ,and its column1 is '' ,and where operates soft deletion . a error "column1 is required" occurs.
how can we avoid this happening.