Re: [Firebird-devel] TraceDatabaseConnection::getConnectionID()

2021-05-20 Thread Dmitry Yemanov
20.05.2021 18:54, Dimitry Sibiryakov wrote: getConnectionID() returns signed 64 bits integer. Have anybody seen negative values there? Given that it's signed inside the header page, it may be theoretically possible ;-) Dmitry Firebird-Devel mailing list, web interface at https://list

[Firebird-devel] TraceDatabaseConnection::getConnectionID()

2021-05-20 Thread Dimitry Sibiryakov
Hello All. getConnectionID() returns signed 64 bits integer. Have anybody seen negative values there? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-20 Thread Adriano dos Santos Fernandes
Hi! Currently max. CHAR length is limited to 32767 and max. VARCHAR to 32765. I didn't found any blocker prevent raising that limits to 65535 and 65533 respectively. But I want to raise them both to 65535 to allow read 64KB segments in RDB$BLOB_UTIL. To support that, internals must be changed s

Re: [Firebird-devel] Deprecations

2021-05-20 Thread Omacht András
UDF has been a compromise for us from the beginning (since IB 6.0 or maybe 5.5). If it is possible, we don’t want to depend on things outside of the database because it is only a problem to have to ask the customers for any extras for the programs to work. András -Original Message- Fro

[Firebird-devel] Slow DDL execution with 4.0 and 3.0

2021-05-20 Thread Gabor Boros
Hi All, I try to find why the real life application's internal database version changer much slower with 4.0. One slow step is the procedure altering. First, made an isql test case with WIN1250 connection because the real life application use that. The script file alter 2265 procedures in the

Re: [Firebird-devel] Deprecations

2021-05-20 Thread Mark Rotteveel
On 2021-05-20 08:28, Omacht András wrote: Mark: Yes, that could be good, but it’s not even in 4.0, so (one day) we wouldn’t be able to switch to 5.0 by rewriting these calls first. For the time being, the original plan remains: writing a function, replacing udf calls with it ... Or rewrite such