Variable 'sql_mode' can't be set to the value of 'ALLOW_INVALID_DATES'


#1

I am testing our backup process. I created a BACKUP of my database to S3 and then used RESTORE. Everything looked good until I tried to access the database with Metabase, which returned:

java.sql.SQLSyntaxErrorException: Variable 'sql_mode' can't be set to the value of 'ALLOW_INVALID_DATES'

It should be noted that everything worked fine prior to the RESTORE. Why did this change?


#2

That sql_mode = ALLOW_INVALID_DATES setting is not supported in MemSQL and would always give the same error. The change was likely something on the Metabase side.