Foreign Key Constraint Failed When Changing Default Value

Details for the issue

What did you do?

I attempted to change the default value for the humour field in the article table of my almanack database from "" to "n". (I also tried " ", with the same result.)

What did you expect to see?

I expected the default value to be changed from "" to "n".

What did you see instead?

An error message. See the attached screenshot.

Useful extra information

I get a similar issue to the above when trying to carry out most other changes to the field, such as toggling Not null, or changing its foreign key constraint. (Currently, there is no foreign key constraint.)

What operating system are you using?

• Linux: ( _distro: Ubuntu)

What is your DB4S version?

• Other: Latest Debian.
  

almanack データベースとその article テーブルを使用して DB4S の失敗を再現し、humour のデフォルト値を空の値から "n" または " " に変更します。まず、報告されたエラーと、Not null の切り替え時または外部キー設定の変更時に発生する関連する失敗を調べます。これらのフィールド変更が正常に完了すれば完了です。