Board Game Arena

We detected that we have a difference of behavior in the framework SQL mode :
All queries are executed in the (recommended) Strict mode, except during table creation (game setup).

To be more consistent, we are activating the Strict mode during table creation, so it match the behavior of all later game actions. This change will be Studio only, to no break running Production games.

If your game isn't working on Studio after the change, 2 solutions :
- Quick & dirty: add at the beginning of your dbmodel.sql to remove the strict mode.
- Clean: fix the error displayed during the table creation.

Of course you can start by the quick solution to continue your dev, and go back to the cleaner solution later.

Most common issues, that were allowed before the restoration of Strict mode, are:

• inserting null to a NOT NULL column with no default value => add default 0 to the column definition
• inserting a string value to a numeric column => insert 0

It can be directly from an SQL, or indirectly using the Deck class, for example during createCards setting card_arg as a string when the column expects a numeric value.

Don't hesitate to post here or in the dev discord if you need help fixing your project!