29.04.2020 17:50, Alex Peshkoff wrote:
Client side cursor appears not too complex at the first glance, but not
sure do we want to have client or server side cursor.
Scrollable cursor is already materialized at the server side, so I see
no point doubling efforts on the client. It should
29.04.2020 00:36, Karol Bieniaszewski пишет:
May i ask if this is big developmenet cost to support it on the client
side api?
It's supported in the API, but not supported in the remote protocol.
IIRC, it can be easily implemented if a scrollable cursor would disable
client-side asynchronous
28.04.2020 16:46, Mark Rotteveel wrote:
On 27-04-2020 18:09, Dmitry Yemanov wrote:
The remote protocol support was simply forgotten because nobody asked
for that for years. Mea culpa, I was too busy with the replication
stuff. Obviously, not so many people use the new API... and even less
27.04.2020 20:53, Pavel Cisar wrote:
Ok, shit happens, so what we will do now? Leave it to Firebird 5 that is
who knows how many years in future, or would we try to provide it
sooner? Personally, I think that remote scrollable cursors are just an
improvement that could be introduced in any
26.04.2020 14:41, Roman Simakov wrote:
Maybe it's must be implemented in another way but before we understand
it we should not neither remove it nor deprecate it. At least if there
are no strong reasons that block other good aims.
So far I tend to agree with this position. Let it be "stuck"
27.04.2020 17:34, Pavel Cisar wrote:
Well, I can confirm that IT WORKS *ONLY* in embedded mode.
Yes, this is how FB3 was released. The DSQL/API support was added late
during the development cycle and IIRC I had issues with the existing
batching (prefetch) code in the remote client. Thus it
1
Reporter: Dmitry Yemanov
Sometimes it makes sense to set up the replication set (i.e. tables to be
replicated) inside the database rather than via the configuration file. Or
provide a two-level customization, with tables explicitly included at the
database level and excluded
15.04.2020 16:15, Mark Rotteveel wrote:
Both the Firebird 4 and Firebird 3 snapshot builds for Windows on the
site are outdated. The Firebird 4 snapshot is from April 11
(4.0.0.1876), and the Firebird 3 snapshot from April 10 (3.0.6.33282).
Both should have a snapshot from April 15
Components: Engine
Reporter: Dmitry Yemanov
Currently queries with conditions like (RDB$DB_KEY = :param) use a very fast
lookup of single record based on its number decoded from DBKEY. But if some
range condition is used (e.g. RDB$DB_KEY > :param), then a full table scan is
perfor
All,
Historically, GBAK has two features:
1) Ability to make a backup regardless of the database ODS. This can be
used for downgrading, e.g. when the v2.5 GBAK attaches to the v3 engine
and makes a backup that can be restored on version 2.5. And of course it
can be used for upgrading too --
05.04.2020 18:21, Adriano dos Santos Fernandes wrote:
I also agree that the current behavior is much better.
Me too. Let's keep it.
On the other hand, we have others weird standard behaviors (CASE with
string literals producing CHAR result, for example). Maybe we regret to
did it in the
18.03.2020 18:52, Dimitry Sibiryakov wrote:
What these methods are supposed to return before call of fetchNext()?
isBof() == true, isEof() == false
What they should return if the result set is empty after fetchNext()?
isBof() == false, isEof() == true
Dmitry
Firebird-Devel
06.03.2020 14:03, Tony Whyman wrote:
This is all post Beta 1 stuff. When will there be a Beta 2 release
incorporating EXTENDED TIME(STAMP) WITH TIME ZONE?
When we finalize all the bits and pieces. This discussion should surely
happen before the feature is released to public.
Dmitry
26.02.2020 18:00, Paul Reeves wrote:
It seems to contain two contradictory statements. On the one hand it says:
The journal file I/O is always synchronous and cannot be altered
Synchronous from the filesystem POV. Like with FW=ON for Firebird, but
applies only to journal files.
and in
26.02.2020 17:35, Paul Reeves wrote:
The idea of the failsafe comparison is valid but it depends on how they have
configured journalling.
The common trick for benchmarking is to set up a very long (practically
infinite from the test POV) checkpoint interval. It provides the best
possible
26.02.2020 20:01, Dimitry Sibiryakov wrote:
https://github.com/FirebirdSQL/firebird/wiki redirects back to the
main page. Is it because wiki is disabled or just empty?
Empty.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Adriano et al, Adriano, could you please take a look whether it can be improved.First it would be good if the project decides if unzip should bedeclared as a new dependency and could be used or not.Personally, I don't like the argument about Git (along with GitTools) being a mandatory dependency.
10.02.2020 15:09, Mark Rotteveel wrote:
Apparently the Linux snapshots were repaired, but there are still no
snapshots under Windows. Is there any progress?
The Windows snapshots are still broken.
Fixed and uploaded, thanks for reminding.
It appears that make_icu->zipjs path invokes
16.01.2020 10:17, liviusliv...@poczta.onet.pl wrote:
tested on WI-V3.0.5.33187 Firebird 3.0 and WI-V3.0.5.33232 Firebird 3.0
i see that my query have legacy plan like this:
PLAN (RL ORDER PK_ROZLICZENIE)
but explained plan show this
Select Expression
-> Filter
-> Table
10.01.2020 15:17, Mark Rotteveel wrote:
My intent was more that if we remove it, that we should at least first
explicitly deprecate it and announce removal, and not just remove it
right now.
Agreed.
Dmitry
Firebird-Devel mailing list, web interface at
09.01.2020 16:10, Adriano dos Santos Fernandes wrote:
Better IMO: remove GPRE (and QLI) from the kits.
I may agree re. QLI (starting with FB4), but GPRE is known to be still
used. And yes, they're sponsors ;-) That said, I suppose GPRE will also
disappear one day, just later.
Dmitry
11.12.2019 16:45, Dmitry Yemanov wrote:
On 08/12/2019 17:05, Alex Peshkoff via Firebird-devel wrote:
On 2019-12-08 17:10, Mark Rotteveel wrote:
For consistency of the grammar, I think it is better if the NATIVE
option is also prefixed with TO,
So instead of SET BIND NATIVE, I think
11.12.2019 16:34, Mark Rotteveel wrote:
On 08/12/2019 17:05, Alex Peshkoff via Firebird-devel wrote:
On 2019-12-08 17:10, Mark Rotteveel wrote:
For consistency of the grammar, I think it is better if the NATIVE
option is also prefixed with TO,
So instead of SET BIND NATIVE, I think it
21.11.2019 18:45, Norman Dunbar wrote:
My document still mentions the checksums and the -i[gnore] switch, so if
this is no longer used, I can update that part of the docs too.
Prior to FB3, checksums weren't calculated and all the pages contains
12345 as a dummy checksum. This value was
07.10.2019 13:24, Paul Reeves wrote:
Primary:
database = /srv/data/active/ods130/bmsql_smoketest.fdb
{
log_directory = /var/fb4-replication/bmsql_smoketest
log_archive_directory = /var/fb4-replication/archlog/bmsql_smoketest
log_archive_timeout = 10
verbose_logging = true
}
13.09.2019 15:32, Dimitry Sibiryakov wrote:
What would you recommend for editing Firebird sources on Linux?
Eclipse CDT for coding + integrated debugging. Geany + gcc for simple
changes.
Dmitry
Firebird-Devel mailing list, web interface at
30.08.2019 15:24, Dimitry Sibiryakov 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 or less same:
SET TIME ZONE BIND {NATIVE | LEGACY | CHAR}
27.08.2019 3:59, Adriano dos Santos Fernandes wrote:
Sometimes a object managed by memory-pool may embed non-pooled memory or
other resources.
If the main object is not explicitly destroyed, i.e., destroyed by pool,
the embedded objects leak.
True. And this requires us to avoid the
09.08.2019 18:39, Mark Rotteveel wrote:
to testing client libraries and client side applications.
What would be tested in client library?
You started this thread because you wanted to test a client library, so
you should already know reason for testing a client library.
I think he was
06.08.2019 12:26, Jiří Činčura wrote:
Sooner of all that means that there is UTF8 character which can not be
represebted by ANSI codepage on the server.
Why it would be converted to ANSI on server? I live(d) years under the
impression that the isc_dpb_utf8_filename (and SPB) tells server to
02.08.2019 17:28, Vlad Khorsun wrote:
I was hoping to gather those details via MON$ tables.
It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
Since FB3, actually ;-)
Dmitry
Firebird-Devel mailing list, web interface at
13.07.2019 12:10, Mark Rotteveel wrote:
I propose that for Firebird 4 we bring this inline with the standard:
1. Change and document FLOAT(p) to apply precision in binary digits,
that is:
- p in [1, 24] is a 32 bit single precision
- p in [25, 53] is a 64 bit double precision
- p < 1 and p >
5.1, 2.5.0
Reporter: Dmitry Yemanov
isc_compile_request() returns error but local SQLCODE is not set and later
isc_receive() is executed with zero request handle.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrat
: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Beta 1, 3.0.4, 3.0.3
Reporter: Dmitry Yemanov
Test case:
recreate table t (col1 int, col2 int, col3 int, col4 blob);
insert into t values (0, 0, null, '0');
insert into t values (1, 1, 1, '1
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Beta 1, 3.0.4, 3.0.3
Reporter: Dmitry Yemanov
Test case:
recreate table t (col1 int, col2 blob);
insert into t values (1, '1');
insert into t values (2, '2');
insert into t values (3, '3');
commit;
select * from t
17.06.2019 11:23, Jiří Činčura wrote:
what performance could one accept between UDR and PSQL? I see that UDR is about
30%-40% slower on my machine (just plain execution - empty UDR vs empty PSQL).
Does that align with team's measurements? I'm not saying it's bad or slow. I'm
just looking for
24.04.2019 10:03, liviuslivius wrote:
i have looked at this simple explained plan and i see that from it i
cannot read simply that result set is sorted and retrived by index.
Select Expression
-> Nested Loop Join (inner)
-> Filter
-> Table "DYREKCJA" as "D" Access
18.03.2019 2:24, Leyne, Sean wrote:
There is very little documentation available on the Classic lock manager
related settings, which is why I ask the question in this forum.
Interested in v2. 5 limitations, but details/differences for other
versions would be appreciated.
I assume you mean
13.03.2019 18:07, Alex Peshkoff via Firebird-devel wrote:
Pre-FB3 versions made it possible to modify system tables directly
including creation of new triggers on them. Currently such triggers are
restored from 2.5 backup and can't be removed afterwards. I suggest to
skip such triggers during
07.03.2019 18:25, Adriano dos Santos Fernandes wrote:
But it how IB/FB always worked. Types are defined in platform specific
way to have correctly sizes. As sizes are fixed they align correctly
with existing platforms.
True, but we lack a guarantee. Alignment may vary even between different
04.03.2019 23:01, Mark Rotteveel wrote:
My question is about the **encoding** in the data buffer obtained from
the native client. I want to avoid incorrectly implementing the support
in Jaybird. And FYI, In the wire protocol 16 bit integers are encoded as
32 bit integers, and the length of
04.03.2019 14:40, Alex Peshkoff wrote:
Mark, I'm not 100% sure for TZ id but in all other known to me cases
16-bit integers are sent over the wire in 32-bit network format. I
suppose you should read that id as any other 16-bit value.
Absolutely correct.
Dmitry
Firebird-Devel mailing
02.03.2019 11:30, Mark Rotteveel wrote:
I am just wondering if the requested feature is not already present.
A quick test with isc_database_info, with SYSDBA and a normal user
logged in shows:
- SYSDBA connection: only SYSDBA appears to be returned.
- User connection: only user name is
01.03.2019 16:40, Adriano dos Santos Fernandes wrote:
BTW it would be good to known if this pull request (with
fb_info_tra_snapshot_number, SET TRANSACTION
SNAPSHOT [ AT NUMBER ] and isc_tpb_at_snapshot_number) will go to
master/v4.
No problems from me.
Dmitry
Firebird-Devel mailing
25.02.2019 15:51, Alex Peshkoff via Firebird-devel wrote:
The security database inside the distribution is already initialized
with a Legacy_Auth SYSDBA only. I'm not sure why the same can't be
done for SRP (or at least: isn't done for SRP).
First half of an answer is very simple - in order
21.02.2019 12:46, Pavel Cisar wrote:
And one partially related question from another angle: does it make
sense to implement also replica-side declarative filtering? I mean the
case where changes for all tables are journaled but for some reason
only some tables should be applied to replica -
21.02.2019 10:39, liviuslivius wrote:
http://tracker.firebirdsql.org/browse/CORE-6005
I do not talk about problem itself but think about new feature.
Is this stable cursor a real cursor on which we can work and we can have
some system name for it?
No, it's just low-level visibility rules -
All,
In v4 Beta, replication is fully driven by the configuration file. In
particular, tables to be replicated are (optionally) defined using two
regexp-based options: include_filter and exclude_filter. This was the
easiest solution that doesn't require ODS changes and this matches the
18.02.2019 15:01, Vlad Khorsun wrote:
Second, Beta1 tag is already set so we need DY's opinion on this subject.
The tag will be moved today, but please don't commit before that. This
(even if fixed/changed) is not a showstopper.
Dmitry
Firebird-Devel mailing list, web interface at
15.02.2019 20:14, Dimitry Sibiryakov wrote:
I see that now system tables are replicated unconditionally:
> if (!relation->isSystem() && matcher &&
!matcher->matchTable(relation->rel_name))
> return;
How does it cooperate with separate replication of DDL queries?
See also check
15.02.2019 11:17, Paul Reeves wrote:
First you need to click on the 'Desktop Development with C++'
workload and while on that tab make sure that the WinXP option is
checked (it is off by default).
You then need to go to individual components and make sure that the
VC++ option for v141 tools is
15.02.2019 17:17, Adriano dos Santos Fernandes wrote:
Maybe usage of devenv.exe instead of msbuild.exe would be problematic?
Ideally, we should support both. Worth improving, I'd say.
Dmitry
Firebird-Devel mailing list, web interface at
02.02.2019 13:57, Dimitry Sibiryakov wrote:
Currently replication can be disabled only at database level. Are you
going to provide a way to disable it for single connection or transaction?
Trick with isc_dpb_config won't work for superserver AFAIU.
We could introduce DPB item like for
23.01.2019 17:50, Gabor Boros wrote:
Same script into 5 databases concurrently:
2.5 - 10:55
3.0 - 8:11
4.0 - 8:41
Same script with numbered(1..5) table names into one database concurrently:
2.5 - 10:51 - 336.72 MB
3.0 - 8:09 - 329.79 MB
4.0 - 8:45 - 329.79 MB
i.e. v3 finally becomes
19.01.2019 23:14, Gabor Boros wrote:
The ISQL case is. I made a new database (CREATE DATABASE
'R:\DB\INSERT_TEST.FDB' PAGE SIZE 8192;) with 2.5, 3.0 and 4.0. Then
execute a one table script on it with ISQL (isql.exe -u SYSDBA -p
masterkey 192.168.0.99:R:\DB\INSERT_TEST.FDB -i DATA.sql).
09.12.2018 16:55, Mark Rotteveel wrote:
Back in 2012 I created CORE-3808 to request support for RETURNING *,
which should - equivalent to SELECT * - return all columns instead of
having to manually include all columns in the returning clause.
The primary use case for me would be to more
24.11.2018 13:17, Dimitry Sibiryakov wrote:
24.11.2018 6:43, Dmitry Yemanov wrote:
It could be, but new system generator is also an ODS change. IIRC, we
don't have a safety gap between system and user generator IDs.
It doesn't need to be a system generator. Plugin is free to create a
user
23.11.2018 23:12, Dimitry Sibiryakov wrote:
can store sequence number elsewhere (and it did until recently), but
it's more error-prone to store it inside the database itself. Header
page is an obvious choice. RDB$DATABASE is another option, but it's
also an ODS change.
Isn't a sequence
23.11.2018 22:32, Dimitry Sibiryakov wrote:
AFAIU, journal sequence is completely plugin-related thing. I
understand why your plugin wants to keep it in database, but why in header?
Is replication going to be based on plugin at all?..
Built-in replication, while implementing the same CDC
23.11.2018 20:12, Dimitry Sibiryakov wrote:
I also have a couple of header page changes in my replication branch
Wow... What they are?
(1) Database GUID and (2) journal sequence.
Both are not absolutely required but useful.
Dmitry
Firebird-Devel mailing list, web interface at
23.11.2018 17:53, Adriano dos Santos Fernandes wrote:
Does anyone see any problem in extending (in time zones branch)
hdr_creation_date to include the time zone?
Already existing (created in Alpha) ODS13 databases will be inaccessible
(or FB will crash while accessing them). Probably not an
23.11.2018 17:58, Alex Peshkoff via Firebird-devel wrote:
Before beta release - absolutely no problem. BTW - when are you going to
merge that branch?
I was going to merge it this weekend.
Dmitry
Firebird-Devel mailing list, web interface at
09.11.2018 18:08, Mark Rotteveel wrote:
Do you mean to say that Windows only builds after
commits, and Linux builds always, even if there is nothing new?
Correct.
If so, why that difference?
Scripts are made by different people. Our VMs are so slow that I (while
setting up Windows
28.10.2018 10:45, Karol Bieniaszewski wrote:
I have analysed previous log and i found interesting entry
DESKTOP-6BKOVL9 Sat Oct 27 13:29:19 2018
I/O error during "ReadFile" operation for file
"C:\WINDOWS\TEMP\FB_TABLE_5FBVM1"
Error while trying to
Yes, it gonna be merged from PR soon.Dmitry16:46, 26 октября 2018 г., Mark Rotteveel :What is the status for time zone support? Is it going to be included in Firebird 4 or not?Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
24.10.2018 09:08, liviuslivius wrote:
today's snapshot of FB3 is missing
Uploaded now, thanks.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
29.09.2018 16:57, Dimitry Sibiryakov wrote:
I don't think that to bring completely new meaning ("pull a row from
set") to existing well-known keyword SUSPEND (used to be "push a row
into result set") is a right way to "integrate".
AFAIU, Adriano's point is more about technology (use stall
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 multiple times. You have virtually no
control over this. If that SP/UDR has "side effects",
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 logic).
Can this retry be leaked from "SQL statements"
25.08.2018 17:31, Mark Rotteveel wrote:
When can we expect the release of Firebird 2.5.9 and 3.0.4?
I suppose we may start preparing the v3.0.4 release now. If someone
knows about any showstoppers (uncommitted fixes, etc), please speak.
v2.5.9 gonna be the last one in the v2.5 series, so
15.08.2018 17:13, Alex Peshkoff wrote:
Even with mentioned restrictions feature should sooner of all be useful
- with it one can create databases from SP w/o need to use something
like special UDF/UDR for it.
I don't like this idea, sorry.
Dmitry
20.07.2018 04:59, Adriano dos Santos Fernandes wrote:
When I run the QA tests, some tests results in FAIL and others result in
ERROR.
What is the differences between these results?
FAIL means the test executed OK, but its output doesn't match the
expected one. ERROR means something bad
09.07.2018 20:12, Adriano dos Santos Fernandes wrote:
Maybe because the slow FW=ON in Linux?
Because our VMs are slow in general ;-) The Windows build box takes ~1hr
to build one FB version and ~3hrs to test it (SS + CS). In the worst
case (all three major versions are updated) it takes up
08.07.2018 00:28, Adriano dos Santos Fernandes wrote:
It seems important to (also) run the tests with the debug build.
Not with our current VM infrastructure, I'm afraid. There's no chance to
complete the tests within 24hrs.
Dmitry
26.06.2018 15:50, Gabor Boros wrote:
The latest 3.0/4.0 kits have 2018-06-11 date.
I am very unhappy with the outdated Linux builds. I am the only one?
The issue is being worked on.
Dmitry
--
Check out the
14.06.2018 17:42, Dimitry Sibiryakov wrote:
Is there a way for a plugin to write a message into firebird log?
IIRC, gds__log() is exported from fbclient.
Dmitry
--
Check out the vibrant tech community on one of the
09.06.2018 16:09, Mark Rotteveel wrote:
Besides RDB$DB_KEY and RDB$RECORD_VERSION, does Firebird have any other
pseudo columns?
No, it doesn't.
Dmitry
--
Check out the vibrant tech community on one of the world's
28.05.2018 04:04, Adriano dos Santos Fernandes wrote:
I'm adding system procedure support, coded in C++, initially for list
time zone rule transition, as it can't be done with virtual table (needs
parameters).
I see others great potentials with this. We can also later code system
triggers with
23.05.2018 12:39, Vlad Khorsun wrote:
What useful could such trigger do?
I suppose - the most of the thing that users do on CONNECT (init some
context variables, for example) and DISCONNECT (free some resources).
Wouldn't it make sense to call ON DISCONNECT triggers when the
connection
16.05.2018 21:24, livius wrote:
by the same i mean
ALTER ROLE EXISTING SET SYSTEM PRIVILEGES TO MONITOR_ANY_STATMENTS?
or granting MONITOR_ANY_ATTACHMENT affect any MON$ tables?
I need to have possibility to grant select on all attachemnts but i do
not want that such user see all statements
10.05.2018 18:28, Mark Rotteveel wrote:
I don't see any reason why a virtual table can't have a RDB$ prefix.
+1
Dmitry
--
Check out the vibrant tech community on one of the world's most
engaging tech sites,
01.05.2018 13:45, Vlad Khorsun wrote:
"Official" compiler for fb3 on Windows is (old) VC10. Snapshot builds of
both fb3 and fb4 uses VC12 (VS2013), iirc.
FB3 snapshots are built using VC10.
Dmitry
--
Check out the
27.02.2018 17:19, Rashid Abzalov wrote:
And what about enable/disable the regular system indexes?
Without this capability, system queries will continue to use regular
system indexes, instead of more suitable (for performance reasons in
specific cases) user indexes.
It's up to the optimizer
22.02.2018 16:41, Alex Peshkoff wrote:
As part of CORE-5750 problems, I found that Firebird considers '12Mar92'
as a valid date (1992-03-12).
Should this be considered a bug, i.e., separators should be necessary in
this case (12-Mar-92, 12/Mar/92, 12.Mar.92)?
Let's better treat it as
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 2.5.8, 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6,
3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1,
2.5.2, 2.5.1, 2.5.0
Reporter: Dmitry Yemanov
recreate table tidx (col varchar
03.02.2018 16:05, Mark Rotteveel wrote:
I assume this to also mean the blr_dec_fixed is removed
From the client-server interaction - yes, but supposedly not in
general, as it still can back physical field storage / PSQL variables / etc.
Dmitry
02.02.2018 10:57, Dmitry Yemanov wrote:
sqlscale was always used to indicate
Read: sqlsubtype
Dmitry
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http
01.02.2018 20:24, Mark Rotteveel wrote:
Point taken, but my suggestion was more that we now don't utilize
the Decimal128 to its fullest for decimal, and users of the direct
API now need to handle decfloat and decimal(19+, x) in a very
different manner even though the underlying datatype is
27.01.2018 20:18, Mark Rotteveel wrote:
I'm implementing the new precision 34 decimal/numeric support in
Jaybird, and I notice that the underlying Decimal128 is used as just an
integer container, instead of already applying an appropriate exponent
for the scale. This was a bit of a surprise
22.01.2018 10:35, Dmitry Yemanov wrote:
Any news on this? It is still missing in recent Windows snapshots.
Actually, it misses from all 64-bit snapshots - 2.5 / 3.0 / 4.0. 32-bits
are OK though. Investigating now.
Should be fixed now (starting from tomorrow's snapshots).
Dmitry
21.01.2018 16:23, Mark Rotteveel wrote:
The employee database is missing from the Firebird 4 snapshot builds
(at least on Windows). Is this a known problem?
Usually this means that empbuild don't compile. But it seems to work
for me on Linux. Something Windows specific? I will take a look.
Reporter: Dmitry Yemanov
First, allow this setting to be customized per-database via databases.conf.
Second, even if the global default is used, account the temp cache usage
separately for every attached database instead of per server process as now.
This matches the page cache setup behaviour
19.01.2018 04:10, Adriano dos Santos Fernandes wrote:
Most of types generates reversible sort keys, so only key is written in
sort blocks and data is regenerated from it.
INTL strings (IS_INTL_DATA) does not generate reversible sort keys, so
original data is also written.
I think there is an
18.01.2018 13:44, Dimitry Sibiryakov wrote:
Is this "issue" bad enough for breaking of backward compatibility?
AFAIK, this behavior is documented, so cannot be called "bug".
IMO, no sane person would rely on that intentionally. And AFAIU old
databases will still work, error will be
10.01.2018 18:43, Leyne, Sean пишет:
Tests are different, so results cannot be compared "as is".
I appreciate that the tests are different, I was commenting on the relative
performance impact.
Slowdown mostly depends on % of syscalls. R/O vs R/W tests would show
different relative impact
10.01.2018 18:25, Leyne, Sean wrote:
It is most interesting that FB's post-patch numbers show a much larger impact
(~36% slower) than the Postgres results (~24%).
Tests are different, so results cannot be compared "as is".
Dmitry
06.01.2018 18:15, Mark Rotteveel wrote:
The employee database is missing from the Firebird 4 snapshot builds (at
least on Windows). Is this a known problem?
Usually this means that empbuild don't compile. But it seems to work for
me on Linux. Something Windows specific? I will take a look.
03.01.2018 08:57, Lionel Elie Mamane wrote:
I'd like to avoid completely parsing the SQL statement for that,
mainly so that the SQL statement is not modified by the LibreOffice
SQL parser (and in particular quoting keywords it doesn't know as
identifiers). So I'm hoping to simply go through the
21.11.2017 19:45, Adriano dos Santos Fernandes wrote:
If CURRENT_TIMEZONE returns TIMESTAMP WITH TIME ZONE, it will be
described with the new datatype and will broke all applications that
rely on isc_dsql_describe.
True. I was thinking about "static" applications, sorry.
Then the
21.11.2017 18:56, Dmitry Yemanov wrote:
So only conversion to string seems to be a real problem. And IMHO we
could live with that.
And given that we speak about PSQL (accessible for modifications),
people may replace CURRENT_TIME with LOCALTIME to preserve the string
conversion results
201 - 300 of 1223 matches
Mail list logo
