Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-04 Thread Leyne, Sean
> Output columns RULE_START and RULE_END is renamed to > INITIAL_TIMESTAMP and FINAL_TIMESTAMP. START_TIMESTAMP and END_TIMESTAMP would be better (language wize) DEFINITION_START/DEFINITION_END (or EFFECTIVE_FROM/EFFECTIVE_TO) would be even better (the fact that the values are TIMESTAMPs does

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-04 Thread Adriano dos Santos Fernandes
On 03/06/2018 05:32, Mark Rotteveel wrote: > >> Function DATABASE_VERSION >> >> --- >> SQL> select rdb$time_zone_util.database_version() from rdb$database; >> >> DATABASE_VERSION >> >> 2017c >> --- > > Minor nitpick: the current db is 2018e. > The one present in

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-04 Thread Mark Rotteveel
On 4-6-2018 11:49, Vlad Khorsun via Firebird-devel wrote: 02.06.2018 19:54, Mark Rotteveel wrote: JDBC API requires that statements are executed in a transaction. In theory I can break that rule, but the problem with that is that it requires explicit handling, which is 1) annoying to do and 2)

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-04 Thread Vlad Khorsun via Firebird-devel
02.06.2018 19:54, Mark Rotteveel wrote: On 2-6-2018 17:56, Vlad Khorsun via Firebird-devel wrote: 02.06.2018 18:07, Mark Rotteveel wrote: I just saw the following commit: https://github.com/FirebirdSQL/firebird/commit/bbf8348817c4592999fc137b18ba1be7326ad42d This disallows execution of ALTER