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 "select"
02.06.2021 20:39, Jiří Činčura wrote:
IXpbBuilder* pb = utl->getXpbBuilder(&status, 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
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
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
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 w
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...
Regards
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
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
Firebird-Devel
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 (R
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
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
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 it is
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 stac
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
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 /hom
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
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, exist
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
in
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
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?.
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 i
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 two
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
fe
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 corr
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. W
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 no
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 di
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, 0
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` sho
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 e
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 field
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 exa
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 woul
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.
Se
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?
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,
th
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 on
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 n
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
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
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 consistent wi
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
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>
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
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 with not
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 confi
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 f
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 wit
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 into
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 r
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
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 ve
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
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
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 tabl
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 th
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 co
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
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 favo
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
d
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.
isc_get_client_version
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 fe
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 differe
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 PS
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 n
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
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. Think
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 an
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 applicable to
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
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 tha
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 tra
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
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 () else
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, colum
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
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
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
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 Firebird
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 allo
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 will not
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 standar
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, w
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,
V
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 i
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
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 "gbak"
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"
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
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 e
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
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
https://lists.sourceforge.net/li
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 chang
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
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
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 unix2d
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 un
Affects Versions: 2.1.4, 2.5.0, 2.0.6, 2.1.3
Reporter: Vlad Khorsun
Priority: Minor
The bug was accidentally introduced in CORE-2437
Workaround is obvious - don't call isc_que_events if there is nothing to que.
--
This message is automatically generated by JIRA.
-
If you
Environment: Classic Server or Super Classic architectures
Reporter: Vlad Khorsun
Race condition occured when CCH_flush(FLUSH_ALL) is writting page buffer and at
the same time blocking AST is marked this buffer as BDB_blocking. When buffer
is released after write it didn't checked b
g to be changed.
-
Key: CORE-3465
URL: http://tracker.firebirdsql.org/browse/CORE-3465
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Reporter: Vlad Khorsun
--
901 - 1000 of 1273 matches
Mail list logo