Re: [firebird-support] OT: Firebird 4.0 xinetd Support on Linux Replaced

Friday, August 25, 2017, 3:36:51 AM, Ismael wrote: > Sorry for the off topic, but I have a doubt that maybe some of you can > clarify > I was reading Firebird 4.0 Release Notes and I found the following note: Yes, any questions about alphas, betas, snapshots, pre-release versions are right

[firebird-support] regex substring similar - how to get all occurrences on a field of a string?

Hi. How can I get all occurrences on a field of a string using regex substring similar? For example: SELECT SUBSTRING('asds 12.34 asd .5 aaa 6. aaa 0.5 aaa 7.3 aaa .4 8. aaa 3.7' SIMILAR '% "[+-]?[0-9]*([0-9].|.[0-9])?[0-9]*" %' ESCAPE '') FROM RDB$DATABASE; This examples catches

[firebird-support] Re:

---In firebird-support@yahoogroups.com, wrote : > I have this table: > > CREATE TABLE TRAZABILIDAD_ERRORES ( > CODIGO_ERROR SMALLINT, > DESCRIPCION_ERROR VARCHAR(400), > TIPO_ERROR SMALLINT > ); > > When I try to add a PK: > ALTER TABLE

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

---In firebird-support@yahoogroups.com, wrote : >>How much virtual memory Firebird process is used before the crash ? >>Any messages in the firebird.log near the crash time ? > > Vlad, not much memory, about 400k out of 12gb. 400KB ? Or 400MB ? 400KB is too small to

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

>How much virtual memory Firebird process is used before the crash ? >Any messages in the firebird.log near the crash time ? Vlad, not much memory, about 400k out of 12gb. There’s no other messages in the log before, just the crash msg “terminated abnormally (4294967295)” Currently I’m

Re: [firebird-support]

Thanks Dimitry. I'm pretty dumb today ... Regards 2017-08-24 15:02 GMT-03:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 24.08.2017 20:00, Jorge Andres Brugger jorge.brug...@gmail.com > [firebird-support] wrote: > > It´s "fixable"? > >First,

Re: [firebird-support]

24.08.2017 20:00, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > It´s "fixable"? First, make versions of client library and message file match server. Second, you cannot create primary key on nullable field. -- WBR, SD.

[firebird-support]

I have this table: CREATE TABLE TRAZABILIDAD_ERRORES ( CODIGO_ERROR SMALLINT, DESCRIPCION_ERROR VARCHAR(400), TIPO_ERROR SMALLINT ); When I try to add a PK: ALTER TABLE TRAZABILIDAD_ERRORES ADD CONSTRAINT PK_TRAZABILIDAD_ERRORES PRIMARY KEY (CODIGO_ERROR); I get:

[firebird-support] udfs in firebird 3 embedded....

I can't get the engine to find/use UDFs in FB3 embedded... I get the message 'module name or entry point cannot be found' - yet it all works when I use the normal server and it was fine in 2.0... The udf is of course located a udf folder above the installation folder and the firebird.conf

[firebird-support] OT: Firebird 4.0 xinetd Support on Linux Replaced

Sorry for the off topic, but I have a doubt that maybe some of you can clarify I was reading Firebird 4.0 Release Notes and I found the following note: Tracker ticket CORE-5238 On Linux, Firebird 4 uses the same network listener process (Firebird) for all architectures. For Classic, the main

Re: [firebird-support] Cast as domain in view - wrong datatype

Thanks Dimitry. Changing the query to: select errores.error, errores.descripcion, errores.gtin, errores.serie, errores.fecha, coalesce(trazabilidad_errores.tipo_error,0) as TIPO_ERROR from trazabilidad_errores inner join ( select cast(substring(trazabilidad_informes_mov.resultado from

Re: [firebird-support] UDF or/and maybe Charset problem

24.08.2017 15:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > is there any problems if I just declare all UDF's with FREE IT? Yes, server will have problems trying to free memory that wasn't allocated. -- WBR, SD.

Re: [firebird-support] Cast as domain in view - wrong datatype

24.08.2017 14:49, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > View GTIN field is "exported" as varchar(20), instead of decimal(14,0). > Am I doing domething wrong or could be a bug? Because of your "else '' end as GTIN" server has no choice. Result of whole CASE

RE: [firebird-support] UDF or/and maybe Charset problem

>You must use ib_util_malloc() to allocate memory in UDF and don't forget >FREE_IT in declaration to avoid memory leak. Dimitry, on a similar question, is there any problems if I just declare all UDF's with FREE IT? We use dozens of UDF's, but only half of them are declared as FREE IT, and I

[firebird-support] Cast as domain in view - wrong datatype

Please check the following view def: CREATE OR ALTER VIEW VW_TRZ_ERRORES( CODIGO_ERROR, DESCRIPCION_ERROR, GTIN, SERIE, FECHA, TIPO_ERROR) AS select errores.error, errores.descripcion, errores.gtin, errores.serie, errores.fecha, coalesce(trazabilidad_errores.tipo_error,0)

Re: [firebird-support] UDF or/and maybe Charset problem

24.08.2017 12:00, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > out = (char*)calloc(strlen(str), sizeof(char)); > result = (char*)calloc(j, sizeof(char)); Besides, here and there you forgot about space for terminating null char. -- WBR, SD.

Re: [firebird-support] UDF or/and maybe Charset problem

No, it has value of TRX12270 On Thursday, August 24, 2017, 12:56:09 PM GMT+3, Antônio Gomes acgomes2...@yahoo.com.br [firebird-support] wrote:   there no a null string? De: "Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]"

Re: [firebird-support] UDF or/and maybe Charset problem

there no a null string? De: "Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]" Para: Firebird-support Enviadas: Quinta-feira, 24 de Agosto de 2017 6:41 Assunto: [firebird-support] UDF or/and maybe

Re: [firebird-support] UDF or/and maybe Charset problem

24.08.2017 11:37, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > result = (char*)calloc(j, sizeof(char)); You must use ib_util_malloc() to allocate memory in UDF and don't forget FREE_IT in declaration to avoid memory leak. -- WBR, SD.

[firebird-support] UDF or/and maybe Charset problem

Hi, i have an UDF function that runs perfectly on Linux 64 bit systems. I wanted to port it to Windows 32 bit, but i'm having problems there. The UDF was written in C (not C++), compiled on Linux with gcc, everything works fine. I compiled the same C file on Windows with MinGW Developer Studio

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

Rudi, How much virtual memory Firebird process is used before the crash ? Any messages in the firebird.log near the crash time ? Regards, Vlad