alexbegg commented on PR #33359:
URL: https://github.com/apache/airflow/pull/33359#issuecomment-1676192815
I have ran the tests and have tested a DAG locally with a MySQL connection
created with the extra set to
```json
{
"init_command": "SET time_zone = '+00:00';"
}
```
and a task to output the `@@SESSION.time_zone` as shown:
```python
SQLExecuteQueryOperator(
task_id='check_time_zone',
sql=r"""@@SESSION.time_zone;""",
autocommit=True,
show_return_value_in_logs=True
)
```
with the `init_command` set in the connection as shown the task returned
`+00:00` as expected, without it the task returned the default time_zone of
`SYSTEM`.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
