Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> I’ve been having quite a few crashes on a new server with not much databases > or requests. terminated abnormally (4294967295) > It seems to be very random, there are not many different operations going > on. > > It’s a google cloud Windows vm, I’ve checked for hardware / driver problems >

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> I've been having quite a few crashes on a new server with not much > databases or requests. terminated abnormally (4294967295) > > It seems to be very random, there are not many different operations going > on. > > It's a google cloud Windows vm, I've checked for hardware / driver problems >

[firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

I’ve been having quite a few crashes on a new server with not much databases or requests. terminated abnormally (4294967295) It seems to be very random, there are not many different operations going on. It’s a google cloud Windows vm, I’ve checked for hardware / driver problems but it seems

[firebird-support] Re: Automatic Firing of Query.

Yes Jesús, we are using ibx. Can u please share the details with me. Of share the modified file if possible. Regards Anshuman

Re: [firebird-support] Re: Automatic Firing of Query.

> El 17 ago 2017, a las 15:33, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] escribió: Are you using ibx? I modified the source code of ibx in order to avoid this queries, that are only used to know if a field is computed or not, and of course I

Re: [firebird-support] Re: Automatic Firing of Query.

On 2017-08-17 13:40, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Since the query contains 'from RDB$RELATION_FIELDS R, RDB$FIELDS F > where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN) > and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON >

Re: [firebird-support] Re: Automatic Firing of Query.

17.08.2017 11:32, anshuman.na...@airtelmail.in [firebird-support] wrote: > These queries are getting fired on its own even when there is no action taken > in the > system at a particular time interval. Not only that, these queries are > getting fired > even at the time when there are only

[firebird-support] Re: Automatic Firing of Query.

Thanks for the detailed Response. These queries are getting fired on its own even when there is no action taken in the system at a particular time interval. Not only that, these queries are getting fired even at the time when there are only select queries and no updates or insert are

Re: [firebird-support] Automatic Firing of Query.

On 17.08.2017 at 07:59, anshuman.na...@airtelmail.in [firebird-support] wrote: > > I would like some help to identify as to why and from where the following > query is getting executed on its own at particular intervals. We have Thick > Client Application written using Delphi and Firebird

RE: [firebird-support] Evaluate "empty" string

too complicated, less readable and i guess consuming more Bogdan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, August 17, 2017 9:17 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Evaluate "empty" string

Re: [firebird-support] Evaluate "empty" string

>If (coalesce(terminal, '') <> '') then No need for coalesce since is an unknown state and compared with a value it neither returns true nor false. Hence, I suspect if (trim(terminal) > '') to be equivalent to if (((CHAR_LENGTH(trim(terminal))>0) and (terminal is not null)) Set

[firebird-support] Automatic Firing of Query.

I would like some help to identify as to why and from where the following query is getting executed on its own at particular intervals. We have Thick Client Application written using Delphi and Firebird (2.5.2). The query is: Select F.RDB$COMPUTED_BLR, F.RDB$DEFAULT_VALUE,