Bug: at time zone seems to show incorrect behaviour with daylight saving

[joris-bright]

The query:

select timestamp '2024-10-27 00:23:45 UTC' at time zone 'Europe/Brussels',
       timestamp '2024-10-27 01:23:45 UTC' at time zone 'Europe/Brussels',
       timestamp '2024-10-27 02:23:45 UTC' at time zone 'Europe/Brussels';

The result:

2024-10-27 02:23:45.000 +02:00
2024-10-27 02:23:45.000 +02:00 <-- should be 2024-10-27 02:23:45.000 +01:00
2024-10-27 03:23:45.000 +01:00

[u7549482]

Hey @joris-bright, could you please provide more infomation about this bug

[joris-bright]

The second timestamp get converted wrongly
'2024-10-27 01:23:45 UTC' ->
'2024-10-27 02:23:45.000 +02:00' == '2024-10-27 00:23:45 UTC'
This shifts the time with one hour