bytes for RSA_PRIVATE, 1038 bytes for RSA_PUBLIC).
With those results, the return types of these functions seem to be too
wide and could be reduced.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 09-05-2021 18:25, Mark Rotteveel wrote:
On 09-05-2021 18:02, Dimitry Sibiryakov wrote:
09.05.2021 18:00, Mark Rotteveel wrote:
On 09-05-2021 17:54, Dimitry Sibiryakov wrote:
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE
and packages,
so I'm not sure those need an explicit drop clause.
I have also tested it, and packages actually do inherit the SQL SECURITY
from the database.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 09-05-2021 18:24, Roman Simakov wrote:
вс, 9 мая 2021 г. в 19:04, Mark Rotteveel :
Does that mean that the ALTER DATABASE SET DEFAULT SQL SECURITY
influences all objects without an explicit SQL SECURITY property?
I've checked. It influences tables, functions and procedures. Triggers
On 09-05-2021 18:02, Dimitry Sibiryakov wrote:
09.05.2021 18:00, Mark Rotteveel wrote:
On 09-05-2021 17:54, Dimitry Sibiryakov wrote:
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if
the input is a non-BLOB type, is that intentional
On 09-05-2021 18:03, Mark Rotteveel wrote:
Does that mean that the ALTER DATABASE SET DEFAULT SQL SECURITY
influences all objects without an explicit SQL SECURITY property?
I had assumed it would specify the default for creating a new object
(similar as SET DEFAULT CHARACTER SET). Can you
(similar as SET DEFAULT CHARACTER SET). Can you confirm that assumption
was wrong?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 09-05-2021 17:54, Dimitry Sibiryakov wrote:
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if
the input is a non-BLOB type, is that intentional, or is this a bug?
VARBINARY is an alias of VARCHAR CHARACTER SET NONE
L).
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
the
input is a non-BLOB type, is that intentional, or is this a bug?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
QL SECURITY` for `ALTER
TABLE` and `ALTER TRIGGER`.
Would it be sufficient to say something like
"""
The property cannot be dropped for procedures, functions and packages,
but it can be changed from INVOKER to DEFINER and vice versa.
"""
Mark
--
Mark Rott
On 08-05-2021 13:55, Mark Rotteveel wrote:
Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES.
I assume it's a bitset, so which bits map to which privilege?
After some experimentation, it looks like the bit positions map to the
RDB$TYPE for RDB$SYSTEM_PRIVILEGES, meaning that bit
Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES.
I assume it's a bitset, so which bits map to which privilege?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 08-05-2021 13:22, Dimitry Sibiryakov wrote:
08.05.2021 13:02, Mark Rotteveel wrote:
As to RDB$AUTO_ENABLE, I have no clue, and I can't find anything
related to this in the release notes. Is this reserved for future use?
Quote from README.replication:
-- to replicate all tables
anything related
to this in the release notes. Is this reserved for future use?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 2021-05-05 22:58, Pól Ua L. via Firebird-devel wrote:
If I can't even do intra-table (as opposed to inter-table) SQL in the
CHECK constraint, what's the point in allowing SQL in the constraint
at all?
I mean, what does SQL "bring to the party" in this case if I can't use
it in this way?
.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 04-05-2021 15:19, Dmitry Yemanov wrote:
02.05.2021 18:42, Mark Rotteveel wrote:
I attempted to reduce the time to run the Jaybird tests, but I noticed
- against a recent Firebird 4 snapshot - that disabling forced write
on database creation did not make a huge difference (30s less, from 4m
On 03-05-2021 13:30, Mark Rotteveel wrote:
I'll create a ticket to that effect.
https://github.com/FirebirdSQL/firebird/issues/6786
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 03-05-2021 13:13, Adriano dos Santos Fernandes wrote:
On 03/05/2021 07:51, Mark Rotteveel wrote:
Is there a way to obtain the current time zone of a session? I looked at
RDB$GET_CONTEXT, MON$DATABASE and MON$ATTACHMENTS, but I can't find such
a feature. Am I overlooking something or does
Is there a way to obtain the current time zone of a session? I looked at
RDB$GET_CONTEXT, MON$DATABASE and MON$ATTACHMENTS, but I can't find such
a feature. Am I overlooking something or does this not exist yet?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https
create (and drop) a lot of databases)
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 01-05-2021 18:16, Adriano dos Santos Fernandes wrote:
On 01/05/2021 06:00, Mark Rotteveel wrote:
Given I have had to ask Travis CI again for more credits (and we're
running out again already), any objections if I change the configuration
of Travis CI to build once a week, instead of on every
On 30-04-2021 16:25, Dimitry Sibiryakov wrote:
Currently replication drops blob type. Is it a bug or stream blobs are
deprecated?
If anything should be deprecated, it should be segmented blobs, not
stream blobs.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https
On 21-04-2021 16:43, Mark Rotteveel wrote:
Ok, would it then make sense to disable (some of) the travis-ci tests?
Or maybe only trigger them manually or on a schedule?
Given I have had to ask Travis CI again for more credits (and we're
running out again already), any objections if I change
tracker.firebirdsql.org to GitHub issues.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 19-04-2021 13:19, Adriano dos Santos Fernandes wrote:
On 19/04/2021 03:53, Mark Rotteveel wrote:
I was able to get extra credits from Travis CI, but maybe we should do
what Dimitry suggested, and migrate to GitHub Actions.
We are already on GitHub Actions.
We only lack Ubuntu build
On 16-04-2021 18:25, Mark Rotteveel wrote:
On 16-04-2021 16:23, Mark Rotteveel wrote:
https://github.com/FirebirdSQL/firebird currently uses travis-ci.org
for the build, but this must be migrated to travis-ci.com, as
travis-ci.org will shutdown soon.
See also
https://docs.travis-ci.com/user
On 16-04-2021 16:23, Mark Rotteveel wrote:
https://github.com/FirebirdSQL/firebird currently uses travis-ci.org for
the build, but this must be migrated to travis-ci.com, as travis-ci.org
will shutdown soon.
See also
https://docs.travis-ci.com/user/migrate/open-source-repository-migration
On 16-04-2021 16:52, Dimitry Sibiryakov wrote:
16.04.2021 16:49, Mark Rotteveel wrote:
We're already using it, and this migration is just instructing
travis-ci.com to start looking at our repository instead of
travis-ci.org (and updating two or three links), switching to GitHub
Actions
On 16-04-2021 16:43, Dimitry Sibiryakov wrote:
16.04.2021 16:23, Mark Rotteveel wrote:
Any objections if I perform this migration?
What is an advantage of travis CI over github? May be we can just drop
it instead of migration?
We're already using it, and this migration is just
-ci.org/github/FirebirdSQL/firebird
Any objections if I perform this migration? (Should be just a few
clicks, and changing the README.md and a link on the website.)
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
As asked on firebird-support by Luciano Rodrigues Nunes Mendes, the
Firebird 3.0 snapshots on Windows are missing at
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/
Can someone investigate why and fix the issue?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface
ill
just need to ignore this, and for example detect a `UPDATE ... WHERE
RETURNING` as having a RETURNING clause.
For context, this would be used in Jaybird to replace a slightly more
complicated parser with a third-party dependency I want to get rid of.
Why is RETURNING not a reserved word?
Mar
On 20-03-2021 12:40, Vlad Khorsun wrote:
20.03.2021 13:16, Mark Rotteveel wrote:
On 20-03-2021 11:40, Vlad Khorsun wrote:
After reading all of this and refreshing my memory I going to
agree with you.
Note, immediate send of every op_free_stmt could add performance
penalty when
more than
On 20-03-2021 12:18, Dimitry Sibiryakov wrote:
20.03.2021 12:16, Mark Rotteveel wrote:
You could also send the packet, but defer processing of the response.
Sure there is some overhead in sending the packet, but not as much as
also waiting for the response.
Why this packet require
Project: Firebird Core
Issue Type: Improvement
Components: API / Client Library
Affects Versions: 4.0 RC 1, 3.0.7, 2.5.9
Reporter: Mark Rotteveel
Since the v11 protocol, fbclient will defer sending the free packet for
op_free_statement until other activity
deferred packets after short idle timeout could work
better.
It looks like Nagle's algorithm, btw.
You could also send the packet, but defer processing of the response.
Sure there is some overhead in sending the packet, but not as much as
also waiting for the response.
Mark
--
Mark Rotteveel
On 20-03-2021 09:54, Vlad Khorsun wrote:
06.03.2021 20:50, Mark Rotteveel wrote:
Freeing the statement with DSQL_close, DSQL_drop or DSQL_unprepare is
deferred (since the v11 protocol). As a result, the free is only sent
when something else is subsequently sent over the connection.
Yes
On 06-03-2021 19:50, Mark Rotteveel wrote:
Freeing the statement with DSQL_close, DSQL_drop or DSQL_unprepare is
deferred (since the v11 protocol). As a result, the free is only sent
when something else is subsequently sent over the connection.
I wonder if this makes sense for DSQL_drop
problematic? Can something be done to prevent them
(e.g. a lookahead or something)?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 10-03-2021 19:42, Adriano dos Santos Fernandes wrote:
I did some tests and attached is a patch (v3).
I created http://tracker.firebirdsql.org/browse/CORE-6511
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Components: Engine
Reporter: Mark Rotteveel
Attachments: query-expr-v3.diff
See also discussion with subject "Standard-compliance for query expressions" on
firebird-devel (March 6th, 2021).
The SQL standard allows parentheses around query expression
correctly, at least from syntax rules it
should be allowed. :)
After reading your examples again, perhaps you knew about it. :)
Yes :) At first I was a bit surprised, on the other hand, it makes
little sense to disallow such things at a top-level just for aesthetic
purposes.
Mark
--
Mark
On 2021-03-10 09:30, Dmitry Yemanov wrote:
06.03.2021 14:53, Mark Rotteveel wrote:
Now I wonder, what would be necessary to introduce this alternative?
Would this be a matter of adding the right alternative and adding the
order by and offset/fetch info to the RseNode returned by the query
: http://tracker.firebirdsql.org/browse/CORE-6508
Project: Firebird Core
Issue Type: Bug
Affects Versions: 4.0 RC 1, 3.0.7
Reporter: Mark Rotteveel
Attempts to cast floating point values to a string of a short length can result
in errors like
""&q
: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Mark Rotteveel
Implement SQL standard FORMAT clause for CAST between string types and datetime
types, to allow custom formatting of datetime values and conversion from string
values with a specific
for DSQL_drop and
DSQL_unprepare), and only deferring the processing of the response might
make more sense.
What do you think?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
nfo to the RseNode returned by the query
expression, or would more be needed?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 2021-02-25 19:55, Jiří Činčura wrote:
Could you describe the scenario you're thinking of that you think
could
be problematic.
Well, I was mostly thinking what would happen is suddenly some dates
become colliding in UTC in i.e. unique index and you rebuild the
index. It was fine before, but
Hardware-enforced Stack Protection might be something to enable in a
next Firebird:
https://techcommunity.microsoft.com/t5/windows-kernel-internals/developer-guidance-for-hardware-enforced-stack-protection/ba-p/2163340
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https
On 2021-02-25 13:52, Jiří Činčura wrote:
Hi *,
for the unique constraint the times are equivalent if the UTC time is
equivalent. How's this going to be handled when some timezone region
changes its offset and the UTC time becomes the same?
The value stored is in UTC and remains in UTC, so
On 2021-02-25 01:38, Adriano dos Santos Fernandes wrote:
On 24/02/2021 19:09, Lucas Schatz wrote:
Hi, at Firebird 3 and older this SQL works fine:
SELECT timestamp '01.01.2000, 00:00:00' from RDB$DATABASE
or
SELECT cast( '01.01.2000, 00:00:00' as timestamp ) from RDB$DATABASE
But at Firebird 4
,
as the executable was renamed in Firebird 3.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
.
ASCII_CHAR(1).
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 2021-02-23 10:27, Jiří Činčura wrote:
Hi *,
is there a reason why POSITION does not work on binary blobs? I would
expect something like `POSITION(blob, 0x1)` to work.
Did you mean POSITION(blob, x'01'), because I wouldn't expect 0x1 (an
integer literal) to work.
In any case, the problem
On 2021-02-23 07:48, Dmitry Yemanov wrote:
23.02.2021 09:31, Peter Gore wrote:
I also ran all the necessary DDL statements and run GFIX as prescribed
*GFIX - Doc anomaly 2*
Release Notes
I found empirically that
Page 28
gfix -replica read-only
should be
gfix -replica
FYI At the suggestion of Adriano, I have rewritten this to extract the
time in the zone instead of the UTC time.
Mark
On 21-02-2021 14:00, Mark Rotteveel (JIRA) wrote:
Add TIME and TIMESTAMP to EXTRACT to be able to obtain UTC value of WITH TIME
ZONE types
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 4.0 RC 1
Reporter: Mark Rotteveel
As a follow-up to the discussion on firebird-devel titled "Current timestamp
without timezone in given timezone", I suggest that w
On 20-02-2021 15:39, Vlad Khorsun wrote:
20.02.2021 14:27, Mark Rotteveel wrote:
What does SET TRANSACTION option RESTART REQUESTS do?
In the code (tra.cpp, restart_requests(...), I only see the comment:
"""
Restart all requests in the current attachment to utilize the pass
his does, and how it's
useful or supposed to be used (if ever).
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[
http://tracker.firebirdsql.org/browse/CORE-6487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark Rotteveel reopened CORE-6487:
--
I'm reopening the issue as it also needs to be backported.
> FETCH ABSOLUTE and RELATIVE bey
. If not, what is the reason?
Mark
*) Judging by the error message, ALTER ANY ROLE is not even checked for
ALTER ROLE, it just fails because of insufficient privileges to create
the mapping; I reported this as CORE-6490
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https
: Bug
Affects Versions: 4.0 RC 1, 3.0.7
Reporter: Mark Rotteveel
A user executing ALTER ROLE without ALTER ANY ROLE privilege is shown the wrong
error message.
Current behaviour:
```
alter role rdb$admin set auto admin mapping;
Statement failed, SQLSTATE = 28000
unsuccessful
Components: Engine
Affects Versions: 4.0 RC 1, 3.0.7
Reporter: Mark Rotteveel
A normal user without the ALTER ANY ROLE privilege is allowed to put comments
on roles.
```
create user testuser password 'testuser';
commit;
connect '' user testuser password 'testuser';
comment
On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote:
On 2/14/21 4:01 PM, Mark Rotteveel wrote:
For documentation purposes, I was wondering if this was intended
behaviour, both the ability to position beyond the bounds of the
result set using ABSOLUTE, and the remembering of the actual
://tracker.firebirdsql.org/browse/CORE-6487
Project: Firebird Core
Issue Type: Bug
Affects Versions: 4.0 RC 1, 3.0.7
Reporter: Mark Rotteveel
With FETCH ABSOLUTE n and FETCH RELATIVE n, it is possible to position the
cursor beyond the bounds of the result set
IVE where the actual amount
you're out of bounds matters, and having FETCH RELATIVE 1 behave as
FETCH NEXT and FETCH RELATIVE -1 as FETCH PRIOR sounds reasonable.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote:
On 2/14/21 4:01 PM, Mark Rotteveel wrote:
For documentation purposes, I was wondering if this was intended
behaviour, both the ability to position beyond the bounds of the
result set using ABSOLUTE, and the remembering of the actual
Is that remark correct? How I understand it, Firebird can't use an index
for this.
Mark
[1]:
https://firebirdsql.org/file/documentation/html/en/refdocs/fblangref25/firebird-25-language-reference.html#fblangref25-commons-predcontaining
--
Mark Rotteveel
Firebird-Devel mailing
The Firebird 4.0 RC 1 version in tracker is still marked as unreleased.
Can someone with sufficient rights mark it as released (on February 1st)?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
What is the maximum length of an event name? The (English) Firebird 2.5
Language Reference says 127 bytes, the (Russian) Firebird 3.0 Language
Reference says both 64 characters and 127 bytes.
What is the correct size?
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https
the bounds of the result
set using ABSOLUTE, and the remembering of the actual position for
subsequent fetches.
Or if this is just an artifact of implementation, and therefor might
change in a future version and should not be relied on.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface
Components: Engine
Affects Versions: 3.0.7, 4.0 RC 1
Environment: Windows 10 64-bit
Firebird-4.0.0.2353-0-RC1-x64 / Firebird-3.0.7.33374-1_x64
Reporter: Mark Rotteveel
The FETCH RELATIVE 1 FROM cursor_name statement should be equivalent to FETCH
NEXT FROM cursor_name (or FETCH
On 13-02-2021 13:52, Dimitry Sibiryakov wrote:
13.02.2021 13:41, Mark Rotteveel wrote:
However if we're going to change this, we need to ensure that data
type binding to WITHOUT TIME ZONE types will still work correctly
(AFAIK, it currently uses the same code path as a cast), that is:
render
On 13-02-2021 12:06, Dimitry Sibiryakov wrote:
13.02.2021 12:00, Mark Rotteveel wrote:
Firebird already has a TRUNC.
That's good, no need for another reserved word.
The current behaviour of CAST to me makes more sense than the
behaviour defined in the standard. I can see that there might
On 13-02-2021 11:20, Dimitry Sibiryakov wrote:
13.02.2021 08:13, Mark Rotteveel wrote:
Maybe we need a TRUNCATE_TIME_ZONE function, which for a
TIME/TIMESTAMP WITH TIME ZONE will return a WITHOUT TIME ZONE
equivalent with the same wallclock time.
We could borrow general-purpose TRUNC
r,
-extract(timezone_hour from original), value))
Maybe we need a TRUNCATE_TIME_ZONE function, which for a TIME/TIMESTAMP
WITH TIME ZONE will return a WITHOUT TIME ZONE equivalent with the same
wallclock time.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists
p/firebird/mailman/firebird-devel/thread/816608823.36941586045271277.JavaMail.tomcat%40tracker.firebirdsql.org/#msg36971780
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ule, while a trusted
role is a mapped role which has not been explicitly granted to the user).
Never thought this way :-)
Thanks, I think I now have sufficient understanding of SET TRUSTED ROLE
to write the documentation.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web
On 09-02-2021 16:23, Mark Rotteveel wrote:
In other words, does my confusion derive from the fact the Firebird 3
release notes say that CREATE MAPPING ... TO ROLE ... updates the
CURRENT_ROLE, while in fact it does no such thing?
Having done some further tests, a mapping will actually set
On 09-02-2021 15:52, Alex Peshkoff via Firebird-devel wrote:
On 2/9/21 5:42 PM, Mark Rotteveel wrote:
I'm working on the Firebird 3 Language Reference, and I'm currently
writing documentation for SET TRUSTED ROLE. I have tried reading the
Firebird 3 release notes, and a Google-translated
ROLE?
* What exactly is a trusted role?
* What grants a user the right use a trusted role or not?
* Is there a mechanism to assign additional trusted roles to a user?
(the phrasing suggests the mapping sub-system, but if that is the case,
how?)
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
space, the engine
will switch to the next one, and so on."
So although there is no limit specified in the Firebird config, there
can be a limit.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 2021-02-04 15:55, Norbert Saint Georges wrote:
Mark Rotteveel a écrit :
On 2021-02-04 09:39, Norbert Saint Georges wrote:
yes, this is what I found but there is no definition RDB $ FIELD_TYPE
= 30 or 31 in rdb $ types in FB4, what is it for?
The EXTENDED TIMESTAMP WITH TIME ZONE
On 2021-02-04 09:39, Norbert Saint Georges wrote:
yes, this is what I found but there is no definition RDB $ FIELD_TYPE
= 30 or 31 in rdb $ types in FB4, what is it for?
The EXTENDED TIMESTAMP WITH TIME ZONE and EXTENDED TIME WITH TIME ZONE
are protocol-only data-types, where it will always
On 2021-02-02 11:14, Tony Whyman wrote:
There is an important point sitting here for support of legacy
applications. While a standalone x86 Firebird Server is likely to be
of increasingly little interest, an x86 client library may need to be
supported for much longer. This then gives rise to the
On 2021-02-02 00:35, Leyne, Sean wrote:
Vlad,
https://www.gitmemory.com/issue/grpc/grpc/18057/486312183
There is no mention of SIO_LOOPBACK_FAST_PATH in this link
https://support.microsoft.com/en-us/topic/stop-error-0xd1-when-you-set-
„udr_udf” ?
See misc/upgrade/udf in linux distro. Sorry, do not know - was it added
to win package or not.
This directory is not available in the Windows zip packages of snapshots.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo
On 31-01-2021 18:23, Karol Bieniaszewski wrote:
As Udf’s are depricated, are somwhere all current udfs rewriten in udr form?
I mean about fbudf.dll and ib_udf.dll and with source code to look at it
as a sample for self written „udr_udf” ?
Yes they are, for Firebird 4.
Mark
--
Mark Rotteveel
On 31-01-2021 16:11, Dimitry Sibiryakov wrote:
31.01.2021 15:23, Mark Rotteveel wrote:
As far as I'm aware, blob filters use the same mechanics for searching
and loading entrypoints, including the UdfAccess setting.
But they don't have declarable parameters so there is no danger
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.7, 4.0 Beta 2
Reporter: Mark Rotteveel
The COMMENT ON USER statement can only put comments on users of the default
usermanager. The syntax should be extended to include an optional
On 31-01-2021 14:30, Dimitry Sibiryakov wrote:
31.01.2021 14:03, Mark Rotteveel wrote:
Blob filters are a special type of UDF
No, it isn't. From the beginning it is a kind of plugins with fixed
interface.
As far as I'm aware, blob filters use the same mechanics for searching
Blob filters are a special type of UDF, and in Firebird 4, UDF will be
deprecated. Are there any plans for replacement, for example, defining
blob filters through UDR?
For me this is primarily academic curiosity, I don't actually use blob
filters myself.
Mark
--
Mark Rotteveel
Firebird
.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 23-01-2021 14:42, Dimitry Sibiryakov wrote:
23.01.2021 14:20, Mark Rotteveel wrote:
::=
TEMPORARY
Using of
::=
[] [TEMPORARY]
won't make a big difference.
Yes it does, this would introduce a semantic ambiguity (and probably a
syntactic ambiguity. In the original syntax
n-standard clause **at the end** of the CREATE TABLE statement. Maybe
something like the PostgreSQL WITH-clause (although using that specific
keyword would conflict with the standard WITH-clause used for system
versioning).
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface
Issue Type: Improvement
Components: Engine
Affects Versions: 4.0 RC 1
Reporter: Mark Rotteveel
As discussed on firebird-devel, the replica mode should be exposed through an
isc_database_info/Attachment::getInfo(), MON$DATABASE, and - maybe - the SYSTEM
context
On 23-01-2021 10:43, Dmitry Yemanov wrote:
23.01.2021 12:31, Mark Rotteveel wrote:
Going over the Firebird 4 release notes, I was wondering if there is a
isc_database_info / Attachment::getInfo() call to determine if a
database is standalone (no replication), a primary, or a replica
status, I would also be OK with considering standalone
databases a primary.
I didn't see anything for this listed in "Extensions to various
getInfo() Methods" of chapter 4.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinf
201 - 300 of 1483 matches
Mail list logo