It's rather curious that the query should work on Linux, because strictly from an SQL perspective, the original definition can only create records if the queries creating the record provide values for both leadershipaa and assist columns.
Do you actually get group_leader records on a linux server with the original schema?
Looking at the code in database.cpp, I don't see a reason why changing the schema as I suggested would cause a crash. It's all quite properly checked and at the most you should get an error message.
Does it crash if you revert the change to the leadershipaa column but leave the assist column the way I suggested it (default '')?
|