I have a host that I use for running some data import scripts. These are pretty old / legacy scripts that aren't important to anything and aren't sensitive. The host recently upgraded mariaDB and now it's in strict mode, such that my old scripts that used work fine are failing when they try to insert empty strings against a column defined for
I've asked the host to disable strict mode so that I can continue without making a bunch of changes to my scripts that always worked fine-- they say they need to think it over to "assess the impact on other customers".
Am I wrong to think that if they were running my user as its own user / schema, they wouldn't need to impact any other customer? While I take their point that using strict mode is a best practice, it seems like they should have more separation between customer environments so this shouldn't be an issue.