You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2021/05/20 20:11:11 UTC

[GitHub] [airflow] eladkal opened a new issue #15975: MySQL docs refer to deprecated setting explicit_defaults_for_timestamp

eladkal opened a new issue #15975:
URL: https://github.com/apache/airflow/issues/15975


   `explicit_defaults_for_timestamp` is deprecated from MySQL docs:
   >explicit_defaults_for_timestamp is itself deprecated because its only purpose is to permit control over deprecated TIMESTAMP behaviors that are to be removed in a future MySQL release. When removal of those behaviors occurs, expect explicit_defaults_for_timestamp to be removed as well.
   
   https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp
   
   We are referring to this setting in:
   https://github.com/apache/airflow/blob/38ecbd6769ecee1136b653c17c2c5c2b17937818/docs/apache-airflow/faq.rst#how-to-fix-exception-global-variable-explicit_defaults_for_timestamp-needs-to-be-on-1
   
   and in
   https://github.com/apache/airflow/blob/0f327788b5b0887c463cb83dd8f732245da96577/docs/apache-airflow/howto/set-up-database.rst#setting-up-a-mysql-database
   
   Note: we also use `explicit_defaults_for_timestamp` in migration scripts but for that we have different task https://github.com/apache/airflow/issues/12562


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] grahovam commented on issue #15975: MySQL docs refer to deprecated setting explicit_defaults_for_timestamp

Posted by GitBox <gi...@apache.org>.
grahovam commented on issue #15975:
URL: https://github.com/apache/airflow/issues/15975#issuecomment-879748208


   Since there is no suggestion on how we could make everything work without using `explicit_defaults_for_timestamp`, I suggest we add a note to the docs saying that `explicit_defaults_for_timestamp` is deprecated and we are looking for a different way to handle it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [airflow] ashb commented on issue #15975: MySQL docs refer to deprecated setting explicit_defaults_for_timestamp

Posted by GitBox <gi...@apache.org>.
ashb commented on issue #15975:
URL: https://github.com/apache/airflow/issues/15975#issuecomment-879792629


   Someone who is using MySQL will need to confirm, but I _think_ we want this setting on to get the new behaviour, so it being removed is not a problem for us.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org