Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Vlad Khorsun
19.08.2022 15:04, Gabor Boros wrote: 2022.08.19. 12:31 keltezéssel, Vlad Khorsun írta: ...    At last, ensure your .bat files contains Windows-style EOL's (crlf), not Unix style. (I used "Code/Download ZIP" at GitHub to fetch the source.) Build works after bought an unix2do

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Vlad Khorsun
19.08.2022 13:36, Mark Rotteveel wrote: On 19-08-2022 12:31, Vlad Khorsun wrote:    At last, ensure your .bat files contains Windows-style EOL's (crlf), not Unix style. The repository should contain a .gitattributes file that configures this. I was a bit surprised to see use of unix2dos

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Vlad Khorsun
19.08.2022 13:15, Gabor Boros wrote: 2022.08.19. 10:54 keltezéssel, Vlad Khorsun írta:    It shows that preprocessing was failed. Look for the following line at console: Preprocessing the source files needed to build gpre and isql... Few lines after there should be few blocks like

Re: [Firebird-devel] Build master branch with VS 2019

2022-08-19 Thread Vlad Khorsun
03.07.2022 13:43, Gabor Boros wrote: Hi All, I tried to build master branch with VS 2019 Community 2019 16.11.16 on an up to date Windows 10 Pro 64bit. At make_boot got fatal errors in isql_x64.log: WorkerAttachment.cpp lock.cpp gsec.cpp ppg.cpp  

Re: [Firebird-devel] Current value for parallel workers

2022-08-16 Thread Vlad Khorsun
16.08.2022 12:26, Jiří Činčura wrote: Hi *, Is there a way to get current value of parallel workers (from i.e. monitoring tables)? Not yet. How would you like to see it ? Monitoring table, session context variable, database_info item ? All above ? ;) Should user session be allowed to

Re: [Firebird-devel] op_que_events and database shutdown

2022-08-16 Thread Vlad Khorsun
16.08.2022 11:26, Jiří Činčura wrote: I just want to know there's nothing on protocol level I can use to help this situation. No response. So I suppose nothing? I didn't found anything suitable. Regards, Vlad Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] New statement: EXECUTE SQL

2022-08-15 Thread Vlad Khorsun
15.08.2022 20:42, Vlad Khorsun wrote: Note, semicolon usually mark "client" named parameters Colon, of course, not semicolon. Sorry, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] New statement: EXECUTE SQL

2022-08-15 Thread Vlad Khorsun
14.08.2022 2:28, Adriano dos Santos Fernandes wrote: Hi! When one starts with a DSQL command and need to adapt it to EXECUTE BLOCK (for example to use sub routines or use a single parameter in many places), work is difficult when there are many parameters and output fields. Everything must be

Re: [Firebird-devel] Parallel workers in isc_action_svc_repair + isc_spb_rpr_sweep_db

2022-08-12 Thread Vlad Khorsun
12.08.2022 16:45, Mark Rotteveel wrote: On 12-08-2022 15:13, Vlad Khorsun wrote: 12.08.2022 15:31, Jiří Činčura wrote: Hi *, does the isc_dpb_parallel_workers apply when running sweep via isc_action_svc_repair + isc_spb_rpr_sweep_db?    Sure. There is no isc_spb_parallel_workers, so I

Re: [Firebird-devel] Status of isc_dpb_parallel_workers

2022-08-12 Thread Vlad Khorsun
12.08.2022 14:25, Jiří Činčura WROTE: Is there any prospect for more parallel operations in near future? Especially around i.e. query processing, basically general database operations. The reason I'm asking is whether to implement it in .NET provider on connection string level or only for "gbak"

Re: [Firebird-devel] Status of isc_dpb_parallel_workers

2022-08-12 Thread Vlad Khorsun
08.08.2022 9:57, Jiří Činčura wrote: Is there any prospect for more parallel operations in near future? Especially around i.e. query processing, basically general database operations. The reason I'm asking is whether to implement it in .NET provider on connection string level or only for

Re: [Firebird-devel] Parallel workers in isc_action_svc_repair + isc_spb_rpr_sweep_db

2022-08-12 Thread Vlad Khorsun
12.08.2022 15:31, Jiří Činčura wrote: Hi *, does the isc_dpb_parallel_workers apply when running sweep via isc_action_svc_repair + isc_spb_rpr_sweep_db? Sure. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Vlad Khorsun
11.08.2022 19:31, Mark Rotteveel wrote: On 11-08-2022 18:04, Vlad Khorsun wrote: 11.08.2022 17:46, Jiří Činčura wrote: I was thinking the same when reading the discussion on GH.    There was a LOT of time to write something at that discussion. Nobody asked about NULL's there, while

Re: [Firebird-devel] BLOB_APPEND and returned SUB_TYPE

2022-08-11 Thread Vlad Khorsun
11.08.2022 17:40, Mark Rotteveel wrote: I noticed that BLOB_APPEND always returns a blob of SUB_TYPE TEXT, even if the first blob is binary or other type of blob. Is that expected? No, the intention was to use type\charset of first arg (if not NULL). I'll check and fix it, thanks. Regards,

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Vlad Khorsun
11.08.2022 17:46, Jiří Činčura wrote: I was thinking the same when reading the discussion on GH. There was a LOT of time to write something at that discussion. Nobody asked about NULL's there, while it was documented since a very beginning. I believe it's not late to make correction (hey,

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Vlad Khorsun
11.08.2022 17:26, Mark Rotteveel wrote: On 11-08-2022 16:21, Vlad Khorsun wrote: 11.08.2022 17:10, Mark Rotteveel wrote: Why was this NULL behaviour chosen?    To make BLOB_APPEND more convenient for users. I don't understand how using a different NULL behaviour then standard

Re: [Firebird-devel] op_que_events and database shutdown

2022-08-05 Thread Vlad Khorsun
05.08.2022 12:40, Dimitry Sibiryakov wrote: Vlad Khorsun wrote 05.08.2022 11:17: It could be compared with last known counters before re-connect, if necessary.   Bad idea. If database was reloaded counters are reset. If there was just connection (not database) shutdown, counters

Re: [Firebird-devel] op_que_events and database shutdown

2022-08-05 Thread Vlad Khorsun
03.08.2022 16:35, Jiří Činčura wrote: Hi *, op_que_events and waiting for events, database goes into shutdown. What to do next? Good question The socket is kept open, no luck there. And the "database shutdown" error is returned only after some next operation. Yes. This is done to

Re: [Firebird-devel] Status of isc_dpb_parallel_workers

2022-08-04 Thread Vlad Khorsun
04.08.2022 15:58, Jiří Činčura wrote: Hi *, What's the status of isc_dpb_parallel_workers? The only reference I can find is the slide deck from 2019 from Firebird Conference. But I can't find anything in code. Was this implemented? Dropped? Renamed? Postponed? It is implemented in

Re: [Firebird-devel] SIO_LOOPBACK_FAST_PATH deprecated

2022-07-10 Thread Vlad Khorsun
10.07.2022 11:58, Mark Rotteveel wrote: On 02-02-2021 00:45, Vlad Khorsun wrote: 02.02.2021 1:35, Leyne, Sean wrote: https://www.gitmemory.com/issue/grpc/grpc/18057/486312183 There is no mention of SIO_LOOPBACK_FAST_PATH in this link    Read carefully, please. https

Re: [Firebird-devel] GBAK problem after parallel backups changes

2022-06-26 Thread Vlad Khorsun
26.06.2022 2:32, Adriano dos Santos Fernandes wrote: Em sáb., 25 de jun. de 2022 20:15, Vlad Khorsun escreveu: 26.06.2022 1:31, Adriano dos Santos Fernandes wrote: > Em sáb., 25 de jun. de 2022 18:46, Vlad Khorsun escreveu:    I see, thanks. Actually, restore is OK, the prob

Re: [Firebird-devel] GBAK problem after parallel backups changes

2022-06-25 Thread Vlad Khorsun
26.06.2022 1:31, Adriano dos Santos Fernandes wrote: Em sáb., 25 de jun. de 2022 18:46, Vlad Khorsun escreveu: 25.06.2022 23:59, Adriano dos Santos Fernandes wrote: > Hi! > > After these changes, restore of dialect 1 databases with keywords are > making TC

Re: [Firebird-devel] GBAK problem after parallel backups changes

2022-06-25 Thread Vlad Khorsun
25.06.2022 23:59, Adriano dos Santos Fernandes wrote: Hi! After these changes, restore of dialect 1 databases with keywords are making TCS tests fail with this content (or example): gbak: ERROR:Dynamic SQL Error gbak: ERROR:SQL error code = -104 gbak: ERROR:Token unknown - line 1,

Re: [Firebird-devel] Cleaning up Visual Studio detection during build and packaging.

2022-06-17 Thread Vlad Khorsun
17.06.2022 13:33, Adriano dos Santos Fernandes wrote: Em sex., 17 de jun. de 2022 07:27, Paul Reeves escreveu: We are currently doing this sort if thing in several batch files: if defined VS170COMNTOOLS () else if defined VS160COMNTOOLS () else if defined VS150COMNTOOLS ()

Re: [Firebird-devel] WITH CALLER PRIVILEGES propagation

2022-04-22 Thread Vlad Khorsun
21.04.2022 13:38, Jiří Činčura wrote: Hi, Can propagate the privileges down into the call stack when using WITH CALLER PRIVILEGES? For example: CREATE TABLE T_TEST (ID INTEGER NOT NULL, CONSTRAINT PK_TEST PRIMARY KEY (ID)); /* Package header: PKG_TEST, Owner: SYSDBA */ CREATE PACKAGE PKG_TEST

Re: [Firebird-devel] trace_dsql_prepare and statement encoding

2022-04-06 Thread Vlad Khorsun
04.04.2022 19:06, Dimitry Sibiryakov wrote:   Hello.   I've found that for versions 3 and 4 in trace_dsql_prepare() statement->getText() returning SQL statement text converted into UTF-8 and getTextUTF8() - returning it converted twice. ITraceSQLStatement::getTextUTF8() is not used by

Re: [Firebird-devel] ITraceConnection::getCharSet() result TTL

2022-04-06 Thread Vlad Khorsun
04.04.2022 17:50, Dimitry Sibiryakov wrote:   Hello.   How long lives the pointer returned by ITraceConnection::getCharSet()? This is implemenation details that could be changed without notice.   Can I store it or must copy content into local storage in the instance of ITracePlugin

Re: [Firebird-devel] Security vulnerability in zlib library

2022-04-01 Thread Vlad Khorsun
31.03.2022 11:11, Mark Rotteveel wrote: A security vulnerability was found in zlib: https://nakedsecurity.sophos.com/2022/03/29/zlib-data-compressor-fixes-17-year-old-security-bug-patch-errr-now/ Will we include an updated version in the next release? I'll take care about Windows builds

Re: [Firebird-devel] Local tables

2022-03-16 Thread Vlad Khorsun
15.03.2022 20:14, Adriano dos Santos Fernandes wrote: On 15/03/2022 14:02, Vlad Khorsun wrote: SQL standard defines LOCAL TEMPORARY TABLES (LTT), which may be "created" or "declared". The semantics of these standard specs are different and not very easy ap

Re: [Firebird-devel] Local tables

2022-03-16 Thread Vlad Khorsun
15.03.2022 20:50, Adriano dos Santos Fernandes write: On 15/03/2022 15:20, Vlad Khorsun wrote: So CREATEd LTTs cannot be used in PSQL routines, only by DSQL?   At first look I see two way's to go: a) PSQL routines can't see CREATE'd LTT's, or b) PSQL routines can see and use LTT definition

Re: [Firebird-devel] Local tables

2022-03-16 Thread Vlad Khorsun
15.03.2022 19:41, Dmitry Yemanov wrote: Anyway, IMO "declared" LTTs are much more useful than "created" LTTs, so the latter ones may be deferred. Or we may live without them at all ;-) CREATE'd LTT's could be very useful to store\materialize intermediate results of complex evaluations.

Re: [Firebird-devel] Local tables

2022-03-15 Thread Vlad Khorsun
15.03.2022 19:56, Adriano dos Santos Fernandes wrote: On 15/03/2022 14:39, Vlad Khorsun wrote: 15.03.2022 19:27, Dmitry Yemanov wrote: 15.03.2022 20:17, Vlad Khorsun wrote: For me, "created" LTT is similar to GTT (i.e. stored in the schema) but with data isolated per request

Re: [Firebird-devel] Local tables

2022-03-15 Thread Vlad Khorsun
15.03.2022 19:27, Dmitry Yemanov wrote: 15.03.2022 20:17, Vlad Khorsun wrote: For me, "created" LTT is similar to GTT (i.e. stored in the schema) but with data isolated per request (per PSQL routine). I'd consider about CREATE'd LTT as attachment-private object. I see no need to

Re: [Firebird-devel] Local tables

2022-03-15 Thread Vlad Khorsun
15.03.2022 19:07, Dmitry Yemanov wrote: SQL standard defines LOCAL TEMPORARY TABLES (LTT), which may be "created" or "declared". The semantics of these standard specs are different and not very easy applicable to Firebird as they are based on standard notion of modules, that is not similar to

Re: [Firebird-devel] Local tables

2022-03-15 Thread Vlad Khorsun
15.03.2022 18:00, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 15.03.2022 15:37: On 15/03/2022 11:23, Alex Peshkoff via Firebird-devel wrote: Very interesting - but other name for them should be used. It's too easy to loose difference between LT & LTT that are absolutely

Re: [Firebird-devel] Local tables

2022-03-15 Thread Vlad Khorsun
15.03.2022 16:14, Adriano dos Santos Fernandes wrote: Hi! As part of "Support multiple rows for DML RETURNING (#6815)" feature, BLR verbs for "local table" were created. Local tables (LT) as defined there works outside transaction control. For #6815 this does not matter, but I want to add LT

Re: [Firebird-devel] Knowing whether fbclient supports isc_dpb_utf8_filename

2022-03-01 Thread Vlad Khorsun
01.03.2022 14:15, Jiří Činčura wrote: Sorry for disappointing you, but they not gonna be any helpful, as they always return version "6.3" for InterBase compatibility ;-) Yeah. And looks like no function returns FB_MAJOR_VER. Hope somebody has a nice trick in sleeves.

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Vlad Khorsun
16.02.2022 11:45, Alex Peshkoff via Firebird-devel wrote: On 2/15/22 18:20, Vlad Khorsun wrote: I'd vote to remove idx_numeric2 in favour of idx_decimal Appears to be good idea. and look how to improve Decimal128::makeIndexKey() performance. For example, it stores every 3 decimal digits

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Vlad Khorsun
16.02.2022 11:19, Mark Rotteveel wrote: On 2022-02-16 09:56, Vlad Khorsun wrote: 16.02.2022 10:35, Mark Rotteveel wrote: On 2022-02-15 20:08, Vlad Khorsun wrote: 15.02.2022 20:32, Mark Rotteveel wrote: On 2022-02-15 16:20, Vlad Khorsun wrote:   I'd vote to remove idx_numeric2 in favour

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Vlad Khorsun
16.02.2022 10:35, Mark Rotteveel wrote: On 2022-02-15 20:08, Vlad Khorsun wrote: 15.02.2022 20:32, Mark Rotteveel wrote: On 2022-02-15 16:20, Vlad Khorsun wrote:   I'd vote to remove idx_numeric2 in favour of idx_decimal and look how to improve Decimal128::makeIndexKey() performance

Re: [Firebird-devel] INT64 and index keys

2022-02-15 Thread Vlad Khorsun
15.02.2022 20:32, Mark Rotteveel wrote: On 2022-02-15 16:20, Vlad Khorsun wrote:   I'd vote to remove idx_numeric2 in favour of idx_decimal and look how to improve Decimal128::makeIndexKey() performance. For example, it stores every 3 decimal digits into 10 bits using relatively complex

Re: [Firebird-devel] INT64 and index keys

2022-02-15 Thread Vlad Khorsun
15.02.2022 13:28, Dmitry Yemanov wrote: All, Historically, we store most numerics as double precision inside index keys. It makes stored keys independent of the declared scale and allows both prefix and suffix compression. However, int64 keys (BIGINT and largish NUMERICs/DECIMALs) do not fit

Re: [Firebird-devel] INT64 and index keys

2022-02-15 Thread Vlad Khorsun
15.02.2022 15:20, Dmitry Yemanov wrote: ... I can think of two ways to proceed: 1) Keep rebuilding the index every time the type is changed. Cast all column values into the new format before storing keys into the index. Forget about being scale-independent, pick the scale from the latest

Re: [Firebird-devel] Compiled statement cache

2022-02-10 Thread Vlad Khorsun
10.02.2022 17:35, Dimitry Sibiryakov wrote: Vlad Khorsun wrote 10.02.2022 16:30:    More, I already implemented simple cache of prepared statements near 5 years ago and I know when it is useful :) It was not ported into Firebird because of limited usage and its simplicity. But customer which

Re: [Firebird-devel] Compiled statement cache

2022-02-10 Thread Vlad Khorsun
10.02.2022 14:56, Adriano dos Santos Fernandes wrote: On 10/02/2022 06:44, Vlad Khorsun wrote: 08.02.2022 15:36, Adriano dos Santos Fernandes wrote: Hi! I have refactored DSQL statements/requests (continued worked of many time ago) to separate shared (statement) and specific (request) parts

Re: [Firebird-devel] Compiled statement cache

2022-02-10 Thread Vlad Khorsun
08.02.2022 15:36, Adriano dos Santos Fernandes wrote: Hi! I have refactored DSQL statements/requests (continued worked of many time ago) to separate shared (statement) and specific (request) parts. It seems this ground work for compiled statement cache is complete and I have even did a (very

Re: [Firebird-devel] Database detach after shutdown

2022-01-24 Thread Vlad Khorsun
22.01.2022 14:42, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 22.01.2022 13:37:    After calling IDispatch::shutdown() an attempt to call     IAttachment::detach()     in embedded mode returns error "Database shutdown". But... why? Isn't IDispatch::shutdown already causes

Re: [Firebird-devel] Commit (un)certainity

2022-01-05 Thread Vlad Khorsun
05.01.2022 15:03, Dimitry Sibiryakov wrote:   Hello All.   It is documented that successful return from function send() for TCP doesn't mean successful delivery of data to the target host, mere put them into socket buffer.   If op_commit is sent but network error appear during waiting for

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Vlad Khorsun
13.12.2021 12:45, Dimitry Sibiryakov пишет: Vlad Khorsun wrote 13.12.2021 10:32: Our IFirebirdConf implementation is not generic enough to provide way to get value of any known setting as string.   IMHO it is ok for such UDR to return only subset of known parameters converting them

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Vlad Khorsun
11.12.2021 23:01, Alex Peshkoff via Firebird-devel wrote: I see no big use in full support of v.3. Requested UDR is trivial but I highly displike requirement of keeping it in std distro of firebird. I see no problem to add such UDR into samples but, unfortunately, it can't be implemented

Re: [Firebird-devel] Visual Studio version for v5

2021-10-27 Thread Vlad Khorsun
27.10.2021 21:48, Adriano dos Santos Fernandes wrote: Hi! Do we plan to update Visual Studio to 2019 for v5? I have no such a plan but see nothing wrong with it. If yes, will the VS 2017 build be still maintained? I suppose - yes. If yes for above question, would we create duplicate

Re: [Firebird-devel] Curly brackets in config files

2021-10-14 Thread Vlad Khorsun
14.10.2021 18:48, Dimitry Sibiryakov wrote:   Hello All,   Is there a way to workaround "illegal line" error if curly brackets are part of database GUID used as a key name: {F5B90BDE-6DA3-4095-A9E1-6D26AE34519F} = target.fdb fbtrace.conf: # To enter curvy brackets { } somewhere in a

Re: [Firebird-devel] Tablespaces proposal

2021-10-13 Thread Vlad Khorsun
13.10.2021 15:44, Dimitry Sibiryakov wrote: Vlad Khorsun wrote 13.10.2021 14:39: Due to this, I see no reason to replicate physical layout of master database to the replica. I.e. TABLESPACE-related statements should not be replicated at all, IMO. Other opinions ?   I fully agree

Re: [Firebird-devel] Tablespaces proposal

2021-10-13 Thread Vlad Khorsun
13.10.2021 13:14, Dimitry Sibiryakov wrote:   About moving of tablespaces and objects between tablespaces: on primary site it succeeded, on synchronous replica it failed (and vice versa). How such situation is going to be handled? Tablespace is a concept about physical layout of data. It is

Re: [Firebird-devel] Tablespaces proposal

2021-10-12 Thread Vlad Khorsun
12.10.2021 13:57, Kjell Rilbe wrote: Den 2021-10-12 kl. 08:09, skrev Roman Simakov: пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun mailto:hv...@optima.com.ua>>:     11.10.2021 21:23, Roman Simakov wrote:     > пн, 11 окт. 2021 г. в 18:42, Vlad Khorsun mailto:hv...@optima.com.ua>

Re: [Firebird-devel] Tablespaces proposal

2021-10-12 Thread Vlad Khorsun
12.10.2021 17:53, Roman Simakov wrote: вт, 12 окт. 2021 г. в 13:11, Vlad Khorsun : 12.10.2021 9:09, Roman Simakov wrote: пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun mailto:hv...@optima.com.ua>>: ... > But MAIN exactly specifies the database itself. We especially have remove

Re: [Firebird-devel] Tablespaces proposal

2021-10-12 Thread Vlad Khorsun
12.10.2021 12:02, Mark Rotteveel wrote: On 11-10-2021 17:41, Vlad Khorsun wrote: 11.10.2021 15:17, Roman Simakov wrote: Note: *MAIN* - is a name of the basic database file.    Please, use *DEFAULT* for default (main) tablespace at "main" database file. It is much more consisten

Re: [Firebird-devel] Tablespaces proposal

2021-10-12 Thread Vlad Khorsun
12.10.2021 9:09, Roman Simakov wrote: пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun mailto:hv...@optima.com.ua>>: 11.10.2021 21:23, Roman Simakov wrote: > пн, 11 окт. 2021 г. в 18:42, Vlad Khorsun mailto:hv...@optima.com.ua> <mailto:hv...@optima.com.ua <mailto:h

Re: [Firebird-devel] Tablespaces proposal

2021-10-11 Thread Vlad Khorsun
11.10.2021 21:23, Roman Simakov wrote: пн, 11 окт. 2021 г. в 18:42, Vlad Khorsun mailto:hv...@optima.com.ua>>: 11.10.2021 15:17, Roman Simakov wrote: > SYNTAX > === > > Note: *MAIN* - is a name of the basic database file.    Please, use *DE

Re: [Firebird-devel] Tablespaces proposal

2021-10-11 Thread Vlad Khorsun
11.10.2021 19:24, Dmitry Yemanov wrote: 11.10.2021 18:41, Vlad Khorsun wrote: 2. *ALTER TABLESPACE FILE '/path/to/file'*    In DDL, ALTER usually combined with ADD | SET | DROP, so let follow this convention. I.e. ALTER TABLESPACE SET FILE '/path/to/file' I'm not so sure about "us

Re: [Firebird-devel] Tablespaces proposal

2021-10-11 Thread Vlad Khorsun
11.10.2021 15:17, Roman Simakov wrote: Here is the second version of the proposal. It's taken into account all agreements we made during discussion and we'll do it in this way if there are no objections. PROPOSAL== GOALS == 1) Extend the current limits

Re: [Firebird-devel] Unhandled exception in Why

2021-09-27 Thread Vlad Khorsun
27.09.2021 12:20, Jiří Činčura wrote: I'm almost sure it is it. Could you confirm database have expression index which depends on PSQL function that uses UDR ? As far as I can tell there isn't any such index. Looking closer - index expression uses some table that have computed field,

Re: [Firebird-devel] Unhandled exception in Why

2021-09-27 Thread Vlad Khorsun
27.09.2021 10:33, Jiří Činčura wrote: You may, if you wish. It should fix the crash but there is another (less visible) issues. See discussion at https://github.com/FirebirdSQL/firebird/pull/6844. Sadly the artifacts on GitHub are expired. Is there a way to confirm I'm hitting same issue?

Re: [Firebird-devel] Unhandled exception in Why

2021-09-26 Thread Vlad Khorsun
26.09.2021 18:16, Jiří Činčura wrote: Yes, that looks very similar. Is it worth trying the build with https://github.com/FirebirdSQL/firebird/commit/2b0dc05f529c13a0dd070c9fde6d048bc7fdccf4 commit? You may, if you wish. It should fix the crash but there is another (less visible) issues.

Re: [Firebird-devel] Unhandled exception in Why

2021-09-26 Thread Vlad Khorsun
26.09.2021 17:05, Jiří Činčura пишет: Hi, I can, although in pretty elaborate setup, trigger unhandled exception in Why (see below). It's 99% related to something that external engine is doing, because removing one external engine function call from PSQL function makes it not crash. What

Re: [Firebird-devel] Firebird 4 - MON$ / Trace API changes?

2021-09-13 Thread Vlad Khorsun
13.09.2021 16:59, Maya Opperman wrote: Another possibility is to set coercion rules for new data type for your connection, see https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-msql-set-bind-native-to-legacy-coercion-rules Thanks Vlad! In this

Re: [Firebird-devel] Firebird 4 - MON$ / Trace API changes?

2021-09-13 Thread Vlad Khorsun
Hello Thomas, 13.09.2021 11:43, Thomas Steinmaurer wrote: Hello, congratulations to the Firebird 4 release! How do I best find out what has been changed in the area of MON$ tables and especially Firebird Trace API. MON$ tables get a bit of mentioning in the Release Notes, e.g. what

Re: [Firebird-devel] Firebird 4 - MON$ / Trace API changes?

2021-09-13 Thread Vlad Khorsun
13.09.2021 11:43, Thomas Steinmaurer wrote: Hello, congratulations to the Firebird 4 release! How do I best find out what has been changed in the area of MON$ tables and especially Firebird Trace API. MON$ tables get a bit of mentioning in the Release Notes, e.g. what fields have been added

Re: [Firebird-devel] Timezone in fb_info_creation_timestamp_tz

2021-09-09 Thread Vlad Khorsun
09.09.2021 12:36, Jiří Činčura wrote: I'm trying to read response for `fb_info_creation_timestamp_tz`. Timezone piece. But I'm getting some weird data. The whole buffer is `139, 12, 0, 8, 232, 0, 0, 10, 71, 173, 16, 216, 103, 147, 0, 1`, thus if I'm counting correctly the `216, 103, 147, 0`

Re: [Firebird-devel] Timezone in fb_info_creation_timestamp_tz

2021-09-09 Thread Vlad Khorsun
09.09.2021 11:51, Jiří Činčura wrote: Hi, I'm trying to read response for `fb_info_creation_timestamp_tz`. Timezone piece. But I'm getting some weird data. The whole buffer is `139, 12, 0, 8, 232, 0, 0, 10, 71, 173, 16, 216, 103, 147, 0, 1`, thus if I'm counting correctly the `216, 103, 147,

Re: [Firebird-devel] Dialect 3 inconsistent round/trunc - configurable calculation method needed

2021-08-31 Thread Vlad Khorsun
31.08.2021 23:53, Mark Rotteveel wrote: The only debatable feature of dialect 3 division is the fact the calculation stops (equivalent to floor rounding), while reduction of scale through assignment or cast applies half-up rounding, on the other hand, this behaviour is consistent with integer

Re: [Firebird-devel] isc_info_sql_stmt_type/isc_info_sql_stmt_flags

2021-08-19 Thread Vlad Khorsun
19.08.2021 17:57, Adriano dos Santos Fernandes wrote: On 19/08/2021 11:43, Dmitry Yemanov wrote: Perhaps, although I'm not sure why the client application would need to know the statement type at all ;-) Before isc_info_sql_stmt_flags, I think that was the way to know if there is cursor or

Re: [Firebird-devel] Trace session and choice of events

2021-08-17 Thread Vlad Khorsun
13.08.2021 19:02, Dimitry Sibiryakov wrote:   Hello All,   As I see in TraceManager code every trace session is receiving not only events it is subscribed for with trace_needs() but also everything that previous sessions were subscribed for.   For me it looks like a rather strange design.

Re: [Firebird-devel] Windows installer and ICU files

2021-08-14 Thread Vlad Khorsun
14.08.2021 15:54, Carlos H. Cantu wrote: Hi! I see Firebird 4.0 Windows Installer does not copy the ICU dlls when doing a client+tools or minimum client install. Speaking with Adriano, it seems that having tzdata files are not enough to assure that all time zones conversions will be handled

Re: [Firebird-devel] Local temporary tables (internals)

2021-07-29 Thread Vlad Khorsun
29.07.2021 22:06, Adriano dos Santos Fernandes wrote: Hi! As discussed in #6815 and have atomic RETURNING (records are first changed, then returned) I'd want to implement local temporary tables, initially only in BLR level. I don't want to discuss user visible complete local temporary tables

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

2021-07-23 Thread Vlad Khorsun
23.07.2021 10:50, Mark Rotteveel wrote: Hi, Last week a question was asked on firebird-java regarding a JVM crash on Linux when Firebird Embedded is used in combination with a UDF, but to be honest, I have no clue what to look for. I have been able to reproduce the crash (or possibly even

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
16.07.2021 15:22, Dimitry Sibiryakov wrote: 16.07.2021 14:19, Adriano dos Santos Fernandes wrote: Instead of isc_info_sql_blr_bytes/isc_info_sql_blr_text, we can add single top level info code with sub code for raw/blr / dsql/jrd parse trees.   Info request cannot have subcodes, it'll break

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
16.07.2021 13:03, Dimitry Sibiryakov wrote: 16.07.2021 11:52, Vlad Khorsun wrote:    We need a way to know when application uses BLR API directly.   Direct BLR compilation won't have DSQL prepare event with the same statement ID. Isn't it enough for this topic's purpose

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
16.07.2021 12:26, Dimitry Sibiryakov wrote: 16.07.2021 11:21, Vlad Khorsun wrote: Second, we need separate trace event to show generated BLR.   Isn't trace_blr_compile enough? We need a way to know when application uses BLR API directly. I.e. trace_blr_compile is very different from

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
15.07.2021 22:34, Adriano dos Santos Fernandes wrote: Hi! Currently it's possible to set TraceDSQL config parameter in dev build to have formatted statement BLR in firebird.log, but that is not sufficient for automated tests. I want to add facility to make it possible to applications request

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
15.07.2021 22:56, Dimitry Sibiryakov wrote: 15.07.2021 21:34, Adriano dos Santos Fernandes wrote: Comments? ...   It would be simpler to raise trace BLR event from SQL prepare and let anyone interested to watch generated BLR using existing (currently unused) trace parameter. First,

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 16:16, Dimitry Sibiryakov wrote: 14.07.2021 15:08, Vlad Khorsun wrote: And this is correct. What is not good for you is that it is called not because of module unload (by Plugin Manager), AFAIU.   For me it is irrelevant because I don't set any logic on this Hmm... so what

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 15:34, Dimitry Sibiryakov wrote:   And here is a call stack from module destructor which in this case workd as UnloadDetector: #1  0x768f4921 in __GI_abort () at abort.c:79 #2  0x70a5ff89 in PluginModule::~PluginModule (this=0x70f971b0 , __in_chrg=)     at

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 15:29, Dimitry Sibiryakov wrote: 14.07.2021 14:25, Vlad Khorsun wrote:    Are you sure fb_shutdown() was called before exit() ?   isql calls fb_shutdown() in atexit() handler so it is surely called after exit(). Yes, indeed. In isql fb_shutdown() is called as part of exit

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 15:14, Dimitry Sibiryakov wrote: 14.07.2021 13:06, Alex Peshkoff via Firebird-devel wrote:   Looks like it is not thread races or I did call gettid() wrongly. But if all that chain was called from fb_shutdown() it does not matter - UnloadDetector is not needed. Can you show the

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 14:16, Dimitry Sibiryakov пишет: 14.07.2021 13:12, Vlad Khorsun wrote:    Good. In this case the scenario is: - app call fb_shutdown() - fb_shutdown() call doClean() of every loaded plugin module and unload dll module - windows loader call DllMain of unloading module (actually

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 13:22, Dimitry Sibiryakov wrote: 14.07.2021 12:13, Vlad Khorsun wrote:    Why do you think it does ? Do you have a stack trace ?   Yes. Functions after global destructors are called from fb_shutdown(). Does your embedded app calls fb_shutdown() before exit() ?   My "emb

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Vlad Khorsun
14.07.2021 12:38, Dimitry Sibiryakov wrote: 14.07.2021 11:27, Alex Peshkoff via Firebird-devel wrote:   I'll do a couple more experiments to determine if the problem is with thread races or library unloading order by OS because I suspect that on exit they are unloaded in reverse order As far

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

2021-07-12 Thread Vlad Khorsun
12.07.2021 7:15, Gabor Boros wrote: 2021.05.20. 10:36 keltezéssel, Gabor Boros írta: 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. Vlad suggested and index privately: RDB$DEPENDENCIES

Re: [Firebird-devel] Memory leak with external engine plugin

2021-07-05 Thread Vlad Khorsun
05.07.2021 10:17, Jiří Činčura wrote: You may try next build I can confirm the leak does not happen in https://github.com/FirebirdSQL/firebird/actions/runs/999413719 build. Good job! Will all the fixes be ported back to 3.0.8? Done, hope I did it right. Regards, Vlad

Re: [Firebird-devel] Memory leak with external engine plugin

2021-07-03 Thread Vlad Khorsun
02.07.2021 16:43, Vlad Khorsun wrote: 02.07.2021 16:35, Jiří Činčura wrote: Any progress here? It's starting to be bit ridiculous. There's memory leak that's taking down about 15 servers I care about daily and I have to constantly beg for response.   I found and fixed few more places

Re: [Firebird-devel] Memory leak with external engine plugin

2021-07-02 Thread Vlad Khorsun
02.07.2021 16:35, Jiří Činčura wrote: Any progress here? It's starting to be bit ridiculous. There's memory leak that's taking down about 15 servers I care about daily and I have to constantly beg for response. I found and fixed few more places but not all of them. Still looking...

Re: [Firebird-devel] Memory leak with external engine plugin

2021-06-29 Thread Vlad Khorsun
21.06.2021 21:55, Adriano dos Santos Fernandes wrote: I'm testing with the example function: create function sum_args ( n1 integer, n2 integer, n3 integer ) returns integer external name 'udrcpp_example!sum_args' engine udr; select sum_args(1, 2, 3) from rdb$database

Re: [Firebird-devel] Trace plugins instance's usage

2021-06-23 Thread Vlad Khorsun
23.06.2021 12:13, Dimitry Sibiryakov wrote: 22.06.2021 16:47, Vlad Khorsun wrote:    Can engine reuse an instance of ITracePlugin for different attachment or services (interchangeable)?    No   And when backup service establish a new connection to a database, this connection will have

Re: [Firebird-devel] Trace plugins instance's usage

2021-06-22 Thread Vlad Khorsun
22.06.2021 17:15, Dimitry Sibiryakov wrote:   Hello All.   Can engine reuse an instance of ITracePlugin for different attachment or services (interchangeable)? No Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] IBlob::putSegment

2021-06-02 Thread Vlad Khorsun
02.06.2021 20:39, Jiří Činčura wrote: IXpbBuilder* pb = utl->getXpbBuilder(, IXpbBuilder::BPB, NULL, 0); Looks like FB3 does not have BPB (https://github.com/FirebirdSQL/firebird/blob/R3_0_7/src/include/firebird/IdlFbInterfaces.h#L3827). > > Is it only in FB4? Seems yes,

Re: [Firebird-devel] CALL statement

2021-05-31 Thread Vlad Khorsun
31.05.2021 16:19, Adriano dos Santos Fernandes wrote: Hi! EXECUTE PROCEDURE is full of weirdness, so I propose that standard SQL CALL is adapted for our needs. EXECUTE PROCEDURE [ . ] [ | ( ) ] [ RETURNING_VALUES | RETURNING_VALUES ( ) ] It does not allow one to

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Vlad Khorsun
10.05.2021 17:52, Adriano dos Santos Fernandes wrote: On 10/05/2021 11:45, Vlad Khorsun wrote: People wanting a functionality should not be worried about a DLL (which in 99% of cases will be there already).   I can agree about 99% of non-Windows cases, but on Windows it is wrong assumption

Re: [Firebird-devel] DefaultTimeZone config

2021-05-10 Thread Vlad Khorsun
10.05.2021 17:12, Adriano dos Santos Fernandes wrote: On 10/05/2021 11:03, Dimitry Sibiryakov wrote: 10.05.2021 14:55, Adriano dos Santos Fernandes wrote: May be explicit DefaultTimeZone=Auto can turn on passing implicit client time zone? Not to say I treat it as absoluely needed, just

Re: [Firebird-devel] Plugin used by trace session

2021-05-03 Thread Vlad Khorsun
03.05.2021 21:57, Dimitry Sibiryakov пишет: 03.05.2021 20:22, Vlad Khorsun wrote:    Trace session can't choose trace plugin, yes. Thus, all loaded plugins receives notifications from the engine.   Does it mean that output for this session will be a mess from all plugins at once

  1   2   3   4   5   6   7   8   9   10   >