If a Ubuntu machine was in 'PST' timezone and on 10 march 2019 at 2:00 AM its timezone gets changed to 'PDT' timezone to accommodate DST changes then does this change is immediately reflected in SYSTEM_TIME_ZONE of mysql 5.7 server running on it i.e. will it also update the value from 'PST' to 'PDT'?
As per my observation it seems the answer is 'NO' but then how does mysql accommodates for DST changes because I can see it taking effect on 'timestamp' value being inserted.
Let me share example:
My Ubuntu machine was in 'PST' timezone and its current timezone is 'PDT' but mysql 5.7 server running on it still shows @@global.system_time_zone as 'PST'.
However, I also see that none of records having timestamp column have value b/w 2019-03-10 02:00:00 to 2019-03-10 02:59:59 i.e. a time shift of 1hr takes place as per DST.
To summarize, 1) are my observations correct? 2) If yes then is SYSTEM_TIME_ZONE not getting updated is a bug that should be fixed?