Skip to Main Content
Forums

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

enabling NO_ZERO_IN_DATE, NO_ZERO_DATE; disable ALLOW_INVALID_DATES

R.JonasJul 11 2018 — edited Jul 12 2018

Hello,

we are close to enable new strict mode with above settings in mysql 5.7.22

I've checked all schemas and found 15 entries in "system" schemas like these:

information_schema    ROUTINES                            CREATED               

datetime    0000-00-00 00:00:00

mysql            proc                            modified            timestamp    0000-00-00 00:00:00
performance_schema    events_statements_summary_by_digest    FIRST_SEEN            timestamp    0000-00-00 00:00:00

I think above entries will violate new strict mode if not handeld correctly. Some of them don't contain data - those should make no problem right now. The others (I've just checked some) do contain correct timestamps.

Suggesting all 15 fields contain no or at 100% correct data, there should be no problem?

But what happens in future?

Did we forget to update above "system" schemas some day?

Thanks in advance,

R.Jonas
This post has been answered by Gaz in Oz on Jul 12 2018
Jump to Answer
Comments
Post Details
Added on Jul 11 2018
#mysql-user-groups
2 comments
2,024 views