rdb$time_zone_util.transitions returns an infinite result set

[dmitry-lipetsk]

FB 4.0.3.2957.

The following query

select
 rdb$start_timestamp start_timestamp,
 rdb$end_timestamp stop_timestamp,
 rdb$effective_offset tz_offset
from rdb$time_zone_util.transitions
('Europe/Moscow',
 '0001-01-01 00:00:00.0000 +00:00',
 '9999-12-31 23:59:59.9999 +00:00')

returns infinite result set.

[dmitry-lipetsk]

Fix works correctly. Thanks.

I would like to document here the workaround for previous FB4 releases.

select
 rdb$start_timestamp start_timestamp,
 rdb$end_timestamp stop_timestamp,
 rdb$effective_offset tz_offset
from rdb$time_zone_util.transitions
('Europe/Moscow',
 '0001-01-01 00:00:00.0000 +00:00',
 '9999-12-31 23:59:59.9980 +00:00')