24.07.2018 11:13, liviuslivius wrote:
Hi,
question about this patch
https://github.com/FirebirdSQL/firebird/pull/105
Is this possible that this CN(commit number) of transactions (pair transaction
id + CN) can be stored into some table?
Currently - no. Probably we could find a way for it.
I
On 05/08/2018 22:44, Adriano dos Santos Fernandes wrote:
Hi!
In "read consistency" README's patch, it says about statement level
consistency.
JRD_start/JRD_start_and_send was been changed (retry logic).
Can this retry be leaked from "SQL statements" (SELECT / UPDATE /
DELETE) to PL/SQL or requ
27.08.2018 9:54, Dmitry Yemanov пишет:
27.08.2018 09:30, Vlad Khorsun wrote:
On 05/08/2018 22:44, Adriano dos Santos Fernandes wrote:
Hi!
In "read consistency" README's patch, it says about statement level
consistency.
JRD_start/JRD_start_and_send was been changed (retry lo
27.08.2018 13:55, Adriano dos Santos Fernandes wrote:
On 27/08/2018 03:30, Vlad Khorsun wrote:
If it is not what you asked for - please, explain the question.
What if a PSQL request calls an UDF/UDR, then executes a SELECT/UPDATE
that triggers a retry, will the UDF/UDR (that is not in
27.08.2018 18:49, Adriano dos Santos Fernandes wrote:
On 27/08/2018 12:16, Vlad Khorsun wrote:
Whole execution tree, starting from top-level request, will be
executed again
within new snapshot. So, yes, that UDF\UDR will be also executed
again, unless
control flow changed its path because
27.08.2018 19:05, Adriano dos Santos Fernandes wrote:
On 27/08/2018 12:59, Vlad Khorsun wrote:
How it is related with consistency ? Also, we already have such
behaviour
even within single statement.
Show me it, please.
select any_function() ... from ... order by 1
For example
27.08.2018 19:21, Adriano dos Santos Fernandes пишет:
On 27/08/2018 12:59, Vlad Khorsun wrote:
Statement consistency should be about individual SQL (SELECT / UPDATE /
INSERT / MERGE / UPDATE OR INSERT) statements, not requests.
This is not consistency. This is spaghetty.
We should
27.08.2018 20:10, Adriano dos Santos Fernandes wrote:
All,
Please. If nobody else sees the magnitude of this problem, I'll shut up.
What we talk here is something that is being said to fix read committed,
but completely destroys it.
Wrong statement which mixed *read consistency* and *side e
23.07.2018 21:46, Adriano dos Santos Fernandes wrote:
Hi!
I integrated Firebird with AppVeyor CI, like we have with travis, but
appveyor is for Windows.
I think it makes sence to enable "Rolling builds" as described here:
https://www.appveyor.com/docs/build-configuration/#rolling-builds
Re
28.08.2018 13:39, Adriano dos Santos Fernandes wrote:
On 28/08/2018 02:20, Dmitry Yemanov wrote:
27.08.2018 20:10, Adriano dos Santos Fernandes wrote:
the whole thing may execute repeated times
Imagine selectable SP/UDR joined to a table. Depending on the plan,
SP/UDR may be executed once or
31.08.2018 22:23, Gabor Boros wrote:
Hi All,
Now (with 4.0.0.1190) works with one (ISQL) client but got "update conflicts with concurrent update" immediately with two or more
clients.
This is because i fixed handling of request snapshot in autonomous
transactions.
Thank to your message.
24.09.2018 10:19, liviuslivius wrote:
Hi,
can you point me about usage cases about
http://tracker.firebirdsql.org/browse/CORE-5921?
The main goal is to provide ability to investigate new engine characteristics
and behaviour
for end users, testers, etc (i.e. not only for the core developers)
25.09.2018 17:25, liviuslivius wrote:
Ok,
i supposed that this go further.
I need global CN from transaction start POV.
For snapshot\concurrency transaction you could obtain it using SNAPSHOT_CN
context variable. For read-comitted transaction it doesn't exists.
I do not know if i can retr
25.09.2018 19:02, Karol Bieniaszewski wrote:
What is then SNAPSHOT_CN?
This is the commit number of currently used snapshot, if present.
Non-RC transactions create snapshot at own start and SNAPSHOT_CN is the CN of
that snapshot.
RCRC transactions create snapshot when user query execution st
25.09.2018 20:39, Vlad Khorsun wrote:
25.09.2018 19:02, Karol Bieniaszewski wrote:
...
b) run query which returns resultset AND currently used CN as one of the
resultset
column and put it into lastCN variable above:
SELECT NAMES.*, RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_CN&
25.09.2018 22:37, Karol Bieniaszewski wrote:
Hi Vlad,
Maybe you should go first to the end of may email (quite long – sorry please be
patient)
Not so long ;)
I suppose that i misunderstand names and meaining.
This is the commit number of currently used snapshot, if present. Non-RC transa
29.09.2018 19:14, Mark Rotteveel wrote:
...
Do I need to create a ticket for this, or is this a known problem?
Yes, create a ticket please.
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
22.10.2018 16:37, Gabor Boros wrote:
Hi All,
After executed an OLTP test with multiple Firebird SS versions got the attached numbers. The test executed three times per Firebird
version. Same OLTP configuration, same server (Debian 9.5 64bit) and same client (Windows 10 64bit). The result databa
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the
fastest. Is it the truth or I made a mistake somewhere?
Could you provide html reports generated by the test runs ?
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/li
25.10.2018 18:35, Gabor Boros wrote:
2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta:
25.10.2018 15:05, Gabor Boros wrote:
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake
somewhere?
It is kinda expected.
25.10.2018 18:37, Gabor Boros пишет:
2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta:
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake
somewhere?
Could you provide html reports generated by the test runs
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake
somewhere?
It is kinda expected. How many worker isqls you had?
Five.
Five ?! It is not serious, try 50 at least
I do not want to blow up my test machine. ;-)
25.10.2018 19:05, Gabor Boros wrote:
2018. 10. 25. 17:45 keltezéssel, Vlad Khorsun írta:
25.10.2018 18:37, Gabor Boros wrote:
2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta:
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a
02.11.2018 9:23, Karol Bieniaszewski wrote:
Hi,
Result for Firebird 2.5 SuperClassic is amazing.
And i do not know why FB3 here is not so fast? FB2.5 is the fastest. It do 2x
more job then FB4.
Interesting is also db size after.
In FB 2.5 SuperServer it is ~5GB
In FB 2.5 SuperClassic which
23.11.2018 22:12, Dimitry Sibiryakov wrote:
...recently invented SCN
Recently ? What do you speak about ?
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
24.11.2018 0:32, Dimitry Sibiryakov пишет:
23.11.2018 21:36, Vlad Khorsun wrote:
...recently invented SCN
Recently ? What do you speak about ?
"When any transaction is committed, database Commit Number is incremented and
its value is associated with this transaction".
22.01.2019 16:09, Jiří Činčura wrote:
Hi,
do I need to call fb_shutdown on application exit when all connections are closed before the unloading happens by the OS?
The README.fb_shutdown says I don't have to, but I remember some discussion here that it *should* preferably be called.
Prefera
24.01.2019 15:13, Jiří Činčura wrote:
Vlad, is it OK to call this method multiple times (nothing else is called in
between)?
Yes. All calls after first one is (almost) no-op
I'm asking because some application might load same library using different
paths via symlinks. And at least Window
24.01.2019 16:14, Adriano dos Santos Fernandes wrote:
On 24/01/2019 12:00, Vlad Khorsun wrote:
24.01.2019 15:13, Jiří Činčura wrote:
Vlad, is it OK to call this method multiple times (nothing else is
called in between)?
Yes. All calls after first one is (almost) no-op
I'm asking be
26.01.2019 10:41, Mark Rotteveel wrote:
With the recent changes to the ICU version, does Firebird 4 on Windows now have
the full ICU?
Yes.
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
08.02.2019 9:31, Alex Peshkoff via Firebird-devel wrote:
On 2/7/19 6:14 PM, Dimitry Sibiryakov wrote:
Hello, All.
I somehow understand why build of current HEAD is failing with message "Could not find acceptable ICU library", but I wonder why
it takes so much time to get this error? More tha
08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote:
On 2/8/19 10:56 AM, Vlad Khorsun wrote:
Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU
library ?
Suggestions?
The fastest way sooner of all will be storing favorite ICU verson (once detected using long
08.02.2019 13:29, Alex Peshkoff via Firebird-devel wrote:
On 2/8/19 12:15 PM, Vlad Khorsun wrote:
08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote:
On 2/8/19 10:56 AM, Vlad Khorsun wrote:
Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU
library
18.02.2019 1:49, Adriano dos Santos Fernandes wrote:
Open two connections C1 and C2.
C2: select current_transaction from rdb$database; -- let's call the
result T2
C2: commit;
C1: select rdb$get_transaction_cn(T2) from rdb$database;
In Super C1 returns the commit number. In Classic it returns N
18.02.2019 13:19, Adriano dos Santos Fernandes wrote:
On 18/02/2019 05:50, Vlad Khorsun wrote:
18.02.2019 1:49, Adriano dos Santos Fernandes wrote:
Open two connections C1 and C2.
C2: select current_transaction from rdb$database; -- let's call the
result T2
C2: commit;
C1: selec
18.02.2019 13:47, Adriano dos Santos Fernandes wrote:
On 18/02/2019 08:37, Vlad Khorsun wrote:
Seriously, if you (and others) consider it is important enough to
try to refresh
TIP cache in such cases - fill the ticket in tracker and i'll fix it.
If the change is going to appear on
18.02.2019 13:50, Dimitry Sibiryakov wrote:
18.02.2019 12:47, Adriano dos Santos Fernandes wrote:
If the change is going to appear only in Beta 2, then ok and I file a
ticket. Otherwise a ticket would not be necessary as the feature didn't
appeared in any alpha/beta release yet.
This change
18.02.2019 17:18, liviuslivius wrote:
If you consider to remove it in CS only...
Nobody going to remove it, don't worry ;)
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
19.02.2019 18:24, Adriano dos Santos Fernandes wrote:
Hi Vlad,
I restarted work on this feature now using commit numbers.
Good to know. Could you publish user interface before it is too late ? ;)
Initial prototype seems to work easily.
It should be not too hard, agree
So now with cur
23.02.2019 21:14, Adriano dos Santos Fernandes wrote:
Hi!
After changes to use commit number instead of base transaction number, I
offer to make that interfaces for the feature:
I offer to not introduce additional confusing with different usages of commit
numbers.
Commit Number (CN) itsel
24.02.2019 4:23, Adriano dos Santos Fernandes wrote:
On Sat, Feb 23, 2019, 21:30 Vlad Khorsun wrote:
23.02.2019 21:14, Adriano dos Santos Fernandes wrote:
> Hi!
>
> After changes to use commit number instead of base transaction number, I
> offer to make tha
24.02.2019 12:37, Dimitry Sibiryakov wrote:
24.02.2019 3:23, Adriano dos Santos Fernandes wrote:
maybe:
SET TRANSACTION SNAPSHOT [USING SNAPSHOT ]
or
SET TRANSACTION SNAPSHOT [USING SNAPSHOT NUMBER ]
What I dislike here is double SNAPSHOT words.
You can ma
01.03.2019 13:16, Adriano dos Santos Fernandes wrote:
I am assuming nobody objects and will implement the changes in the branch.
No objection, just not forget to change syntax\constant names as was agreed
recently:
---
Which then I would go to isc_tpb_at_snapshot_number and SET TRANSACTION
01.03.2019 15:40, Adriano dos Santos Fernandes wrote:
On 01/03/2019 10:28, Vlad Khorsun wrote:
...
BTW, what branch go you mean ?
https://github.com/FirebirdSQL/firebird/pull/193
I'll change SNAPSHOT_CN name in different commit as it's already present
in master.
Understand
04.03.2019 11:16, Simonov Denis via Firebird-devel wrote:
Faced the following problem when working with Firebird 4.0 via IBExpert.
Trying to execute the following SQL query.
SELECT current_time FROM $RDB$DATABASE
SQLCODE: -902
GDSCODE: 335545167
Unsuccessful execution caused by a system error
04.03.2019 14:01, Alex Peshkoff via Firebird-devel wrote:
On 3/4/19 2:57 PM, Vlad Khorsun wrote:
I have additional question: is it true that fbclient now depends on ICU ?
As fas as I know - not. At least IntlManager.cpp is placed in src/jrd, which is
used only in engine.
Client is using
02.03.2019 14:25, Mark Rotteveel wrote:
On 28-12-2018 17:44, Mark Rotteveel wrote:
It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in
Firebird 3.0.4 (through org.firebirdsql.management.FBManager) takes roughly 200ms, while
05.03.2019 0:59, Vlad Khorsun wrote:
02.03.2019 14:25, Mark Rotteveel wrote:
On 28-12-2018 17:44, Mark Rotteveel wrote:
It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in
Firebird 3.0.4 (through
08.03.2019 17:22, Mark Rotteveel wrote:
On 7-3-2019 10:52, Vlad Khorsun wrote:
...
PS i see how to make database creation faster (by reusing compiled statements
whenever possible), but it will not solve general problem with compiation time.
Is this something that could be improved with
07.03.2019 13:45, Adriano dos Santos Fernandes wrote:
On 07/03/2019 06:52, Vlad Khorsun wrote:
Database creation time mostly contains from compiling and parsing
requests.
Unfortunately, it is slower in fb4 than fb3 and fb3 is much slower
than fb25.
IIRC, it was said here sometime ago and
12.03.2019 17:24, Adriano dos Santos Fernandes wrote:
On 11/03/2019 09:35, Vlad Khorsun wrote:
I just committed few patches and have few more things to ask here:
Vlad, the change just broke reason for NodeRef/NodeRefImpl existence
(which is still commented but not working):
// This
13.03.2019 2:37, Adriano dos Santos Fernandes wrote:
On 12/03/2019 17:22, Vlad Khorsun wrote:
Let me demonstrate it. With this (wrong) patch now the code compiles:
--
diff --git a/src/dsql/ExprNodes.cpp b/src/dsql/ExprNodes.cpp
index 4ff5253a2b..26f826ae09 100644
--- a/src/dsql
09.03.2019 12:01, Omacht András wrote:
Hi All!
I’m unable to add comment tot he tracker,
Hmm... it is strange, you should be able to comment at tracker...
so I send it:
http://tracker.firebirdsql.org/browse/CORE-5658
Hi Vlad!
We tested it and works well.
Thanks for testing.
Is
19.03.2019 12:26, Bastian Seeleib - Ölmühle Solling wrote:
Hello,
I’m trying to build Firebird 2.5 with msvc14 (Visual Studio 2015, Version
14.0.25420.1) but I’m running into issues.
I don’t know if this is the correct Mailing-List to ask this question,
hopefully you can help me (-:
I have th
19.03.2019 15:48, Paul Reeves wrote:
On Tue, 19 Mar 2019 15:33:23 +0200
Vlad Khorsun wrote:
The best (and only guarantee) is to use "official" compiler. For
fb25 on Windows it is VC8 (VS2005).
Actually, it is MSVC10 :-)
VC10 is used for fb3
MSVC8 was for 2.1, i
23.03.2019 15:43, Mark Rotteveel wrote:
I want to refresh the error messages in Jaybird with the messages from a recent Firebird 4 build. Unfortunately, I am running into
problems with building Firebird 4 locally as the build complains I haven't installed the C++ Windows XP support, while - as fa
26.03.2019 8:51, Emil Totev wrote:
The question remained unanswered in firebird-support, so I am trying it here. Basically I'm asking how can a client connect via XNET
to a firebird server using non-default IpcName, for example "Firebird4".
-- Forwarded message -
Date: Mon, 18 M
03.04.2019 18:03, Roman Simakov wrote:
чт, 3 янв. 2019 г. в 14:15, Adriano dos Santos Fernandes :
On 30/12/2018 07:22, Mark Rotteveel wrote:
The error is now:
"""
RAMONASun Dec 30 09:59:28 2018
ICU error (0) retrieving the system time zone (W. Europe Standard
Time). Falling back to
29.04.2019 20:42, Gabor Boros wrote:
Windows builds are not fresh.
You may try AppVeyor builds:
https://ci.appveyor.com/project/FirebirdSQL/firebird/history
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
01.05.2019 15:47, Jiří Činčura wrote:
Hi *,
I'm looking into constants.h and I see this https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/constants.h#L449 .
But this does not seem to be what the parse.y is doing nor what I see in RDB$TRIGGERS. Can somebody check it?
I don't see wh
01.05.2019 20:56, Jiří Činčura wrote:
Somebody check my math for "before alter table or create table":
(TRIGGER_TYPE_DDL | DDL_TRIGGER_{AFTER | BEFORE} [ | DDL_TRIGGER_??? ...]) =>
16384 | 0 | 2 | 1 =>
16387
I see now what is confusing - there is no explicit sign that DDL_TRIGGER_XXX
is a num
06.05.2019 10:48, Massimo Fazzolari wrote:
Hello,
I have an UDF lib compiled with FPC 3.0.4 (Lazarus 2.0.2) that works properly on linux (Ubuntu 18.04 and Firebird 2.5.8.27089) but
Firebird crashes on Windows with this error everytime I invoke any of the user defined functions:
*Error writing
25.05.2019 2:19, Adriano dos Santos Fernandes wrote:
Hi!
We always let btyacc nicely handle parser backtracking alone but seems
in some cases we should not let it.
CORE-6068 is such a case. Parser enters in near-infinite loop allocating
and freeing memory trying new paths.
Based on the short b
08.06.2019 18:00, Simonov Denis via Firebird-devel wrote:
Windows Server 2012 x64. After installation Firebird 4.0.0.1436 x64 we have the
following.
Connect from IBExpert use c:\Program
Files\Firebird\Firebird_4_0\WOW64\fbclient.dll
When trying to execute a query, we get the error "Could not
06.03.2019 17:26, Adriano dos Santos Fernandes wrote:
On 04/03/2019 11:08, Adriano dos Santos Fernandes wrote:
On 04/03/2019 10:57, Alex Peshkoff via Firebird-devel wrote:
On 3/4/19 3:15 PM, Vlad Khorsun wrote:
04.03.2019 14:01, Alex Peshkoff via Firebird-devel wrote:
On 3/4/19 2:57 PM, Vlad
11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
On 10/06/2019 19:41, Vlad Khorsun wrote:
...
Vlad, first of all, please say me what's the difference with Linux
fbclient that has libtommath as dependency since v3.
I don't know. Windows users (and me presonally) definitely
11.06.2019 12:44, Alex Peshkoff via Firebird-devel wrote:
On 11.06.2019 1:41, Vlad Khorsun wrote:
Do this 2 facts
- client have some ICU library, but it can't convert region ID obtained from
server (because of different ICU version), or even
- wrong conversion of region ID at client
11.06.2019 13:34, Adriano dos Santos Fernandes wrote:
On 11/06/2019 03:56, Vlad Khorsun wrote:
11.06.2019 2:15, Adriano dos Santos Fernandes wrote:
On 10/06/2019 19:41, Vlad Khorsun wrote:
...
Vlad, first of all, please say me what's the difference with Linux
fbclient that has libtomma
11.06.2019 1:41, Vlad Khorsun wrote:
06.03.2019 17:26, Adriano dos Santos Fernandes wrote:
On 04/03/2019 11:08, Adriano dos Santos Fernandes wrote:
On 04/03/2019 10:57, Alex Peshkoff via Firebird-devel wrote:
On 3/4/19 3:15 PM, Vlad Khorsun wrote:
04.03.2019 14:01, Alex Peshkoff via Firebird
This is pure demagogy. The problem is not what i like or not like.
The problem is that your "software design" makes Firebird to be less
and less attrictive for people. Small client with no need to install
was a strong point of a Firebird for a long-long time. You going to
destroy it. We must fi
It seems you treat users as dumb and that they never change way to do
things and need to do the same thing they were doing in FB 1.5.
Just ask users, don't be shy.
Ok, but I myself had much more problems needing to installing CRTs
(sometimes more than one with snapshots) to run Firebird.
11.06.2019 15:50, Adriano dos Santos Fernandes wrote:
On 11/06/2019 09:32, Vlad Khorsun wrote:
You trying to speculate on other issues to hide current one.
It will not work.
Issue will not disappear.
It's the same. You don't want to use icu DLL but use others DLLs that is
11.06.2019 16:45, Adriano dos Santos Fernandes wrote:
On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote:
What you mean by install?
Copy one .dll + .msg file is not install.
Copy more than one .dll + .msg file is install?
Adriano, users prefer to copy just one .dll (in many cases .
11.06.2019 15:30, Lester Caine wrote:
On 11/06/2019 12:32, Vlad Khorsun wrote:
One of "simple" solutions could be to ask sever once for whole conversion
table and to keep it at some temp file (or nearby fbclient\app) for future
usage.
It is also not ideal, as different servers
He may also do not use fbclient to format (convert from/to ts to string)
or convert (with/without timestamp) and uses others ways.
What other ways ? Nobody understand what is our region code.
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/f
11.06.2019 18:13, Karol Bieniaszewski wrote:
PS. one more dll is not the problem for me, but maybe for others..
3 dlls and 1 dat file (~30MB in common), look at regular server distribution.
Probably not all 3 dll's is required for TZ support, but the icudt63l.dat (26MB)
is needed.
Also, d
11.06.2019 22:28, Adriano dos Santos Fernandes wrote:
On 11/06/2019 13:08, Vlad Khorsun wrote:
He may also do not use fbclient to format (convert from/to ts to string)
or convert (with/without timestamp) and uses others ways.
What other ways ? Nobody understand what is our region code
12.06.2019 0:23, Dimitry Sibiryakov wrote:
11.06.2019 21:52, Vlad Khorsun wrote:
I want to eliminate needs to translate something at client side.
The simplest way would be to drop IDs and deliver to client only bias. It is enough for all usages of timestamp with timezone I
can think about
12.06.2019 18:27, Adriano dos Santos Fernandes wrote:
On 12/06/2019 10:18, Dimitry Sibiryakov wrote:
12.06.2019 13:43, Adriano dos Santos Fernandes wrote:
Then we will not have a single source of truth anymore.
When user will create a client timestamp-tz value, he will need to fill
that fields
12.06.2019 14:43, Adriano dos Santos Fernandes wrote:
On 11/06/2019 16:52, Vlad Khorsun wrote:
11.06.2019 22:28, Adriano dos Santos Fernandes wrote:
On 11/06/2019 13:08, Vlad Khorsun wrote:
He may also do not use fbclient to format (convert from/to ts to
string)
or convert (with/without
13.06.2019 16:44, Alex Peshkoff via Firebird-devel wrote:
On 13.06.2019 12:43, Vlad Khorsun wrote:
First, you loose things. The adjusted (displayable) timestamp is not
convertible back for duplicated timestamps (DST end).
Not sure i got you. Could you provide an example ?
At 03:00:00
13.06.2019 17:02, Adriano dos Santos Fernandes wrote:
On 13/06/2019 06:43, Vlad Khorsun wrote:
I don't offer to change internal representation (UTC +
offset\region_id) as is.
This is the only way to have correct comparison of timestamp with time
zone.
But i offer to change *ext
14.06.2019 14:58, Mark Rotteveel wrote:
On 2019-06-13 22:12, Vlad Khorsun wrote:
13.06.2019 17:02, Adriano dos Santos Fernandes wrote:
On 13/06/2019 06:43, Vlad Khorsun wrote:
I don't offer to change internal representation (UTC +
offset\region_id) as is.
This is the only way to
14.06.2019 16:17, Adriano dos Santos Fernandes wrote:
On 13/06/2019 17:05, Vlad Khorsun wrote:
13.06.2019 16:44, Alex Peshkoff via Firebird-devel wrote:
On 13.06.2019 12:43, Vlad Khorsun wrote:
First, you loose things. The adjusted (displayable) timestamp is not
convertible back for
14.06.2019 16:27, Adriano dos Santos Fernandes wrote:
On 14/06/2019 09:56, Vlad Khorsun wrote:
Mapping between region_ID and regin_Name could be easily obtained
from server
(RDB$TIME_ZONES) if necessary. It could be done once per client
process lifetime.
Initial mapping could be hardcoded
14.06.2019 22:10, Mark Rotteveel wrote:
On 2019-06-14 20:27, Adriano dos Santos Fernandes wrote:
On 14/06/2019 13:01, Mark Rotteveel wrote:
And I repeat what I said earlier: if Firebird uses an offset that is
too large then I can't use the standard features in Java for date/time
handling and I'
06.07.2019 12:16, Mark Rotteveel wrote:
On 3-7-2019 15:27, Vlad Khorsun wrote:
14.06.2019 22:10, Mark Rotteveel wrote:
On 2019-06-14 20:27, Adriano dos Santos Fernandes wrote:
On 14/06/2019 13:01, Mark Rotteveel wrote:
And I repeat what I said earlier: if Firebird uses an offset that is
too
01.08.2019 11:52, Jiří Činčura wrote:
Hi *,
this might seem silly, but is there a very fast way to generate transactions in
Firebird? I'm trying to test new bigger transaction IDs in .NET provider. As
far as I know using multiple connections in parallel is not going to help. So
far I'm doing
31.07.2019 15:06, Jiří Činčura wrote:
Hi *,
is it possible to get statistics about the executed query similar to what
isc_info_req_insert_count etc. allows? I'm mostly interested in
indexed/non-indexed read counts, but whetever is available I'll include in the
implementation.
These stats
01.08.2019 16:45, Leyne, Sean wrote:
Sean,
How can those stats be related to the *tables* on which the activity is
performed against?
Below is excerpt from APU Guide, if your question was about something else -
please, clarify:
---
Database operation counts
Several information it
02.08.2019 8:25, Leyne, Sean wrote:
More details is available at API Guide, see "Database operation counts" at
chapter 4 "WORKING WITH DATABASES".
Please provide link to the API Guide, went to the project site and was unable
to find the doc.
Links to all IB6 docs are placed here:
https:
02.08.2019 17:16, Leyne, Sean wrote:
Sean,
How can those stats be related to the *tables* on which the activity is
performed against?
Below is excerpt from APU Guide, if your question was about something else -
please, clarify:
---
Database operation counts
Several infor
02.08.2019 19:31, Leyne, Sean wrote:
I was hoping to gather those details via MON$ tables.
It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
Am running v2.5.x
Hope, you have one more argument to try FB4 ;)
I have a DB SP which itself calls several SPs, and I was h
20.08.2019 4:26, Adriano dos Santos Fernandes wrote:
Hi!
When linking optimized static build of re2 with Firebird
Adriano, could you explain, please, - why you choose RE2 for re-implemenation
of
regexp support ? Why not ICU, for example ? There are more free implemenations
(such
as PCRE, b
26.08.2019 9:49, Jiří Činčura wrote:
Hi *,
let's have this structure:
create database 'localhost:slower.fdb' user 'sysdba' password 'masterkey';
create table dummy (i integer);
set term ~;
recreate procedure foobar
as
declare cnt integer;
begin
delete from dummy;
cnt = 10;
26.08.2019 12:19, Dimitry Sibiryakov wrote:
26.08.2019 9:17, Vlad Khorsun wrote:
In theory, engine could remove such records before transaction ends. Not
sure
it will be easy to do.
Delete-in-place is implemented in Avalerion and Firebird 4.
When record is removed from data page
26.08.2019 12:51, Dimitry Sibiryakov wrote:
26.08.2019 11:43, Vlad Khorsun wrote:
When record is removed from data page ?
No immediately, it still leave the stub. Nevertheless GC of the stub should
be faster than full version.
Sure, but it is not about the speed of GC. It is about
30.08.2019 15:24, Dimitry Sibiryakov wrote:
30.08.2019 13:48, Alex Peshkoff via Firebird-devel wrote:
...
3. This solution is for really old clients which anyway can not work with new time formats - use of alternate binding to character
string (like with decimal float values). Syntax is more
30.08.2019 16:36, Dimitry Sibiryakov wrote:
30.08.2019 15:27, Alex Peshkoff via Firebird-devel wrote:
For some applications that makes sense.
Look: you have an old database without new data types and an old application that works with it. The only way to put this old
application into troub
30.08.2019 19:15, Adriano dos Santos Fernandes wrote:
On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote:
1. Let's use SQL subtype in order to represent in the message UTC or
regional time, i.e. for time with time zone 2 subtypes will make sense
- UTC format or regional format. When u
701 - 800 of 1273 matches
Mail list logo
