[H-source-users] [bug #62574] something is wrong with the server

[Ian Gilfillan]

Follow-up Comment #8, bug #62574 (project h-source):

I mean, how is sql_mode being set? If it's set with something like SET
sql_mode=... when the database server is running, this is not persistent, and
the server will revert back to STRICT_TRANS_TABLES on when it restarts, as
this is the default in MariaDB 10.3. This was changed in MariaDB 10.2, so
presumably the previous version of the server was 10.1 or below, when this
problem wouldn't have occurred.

It would also make sense to identify the cause of this so as not to require
STRICT_TRANS_TABLES to be off. Things failing with it on imply that when it's
off and seemingly working, there are automatic adjustments to invalid values
happening.


    _______________________________________________________

Reply to this item at:

  <https://savannah.nongnu.org/bugs/?62574>

_______________________________________________
Message sent via Savannah
https://savannah.nongnu.org/