Re: [Firebird-devel] Build firebird 2.5 problem

2023-08-05 Thread Mark Rotteveel via Firebird-devel
tu SMP Thu Jul 13 19:41:22 UTC 2023 66.96 configure: error: cannot guess build type; you must specify one Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Mark Rotteveel Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] nullOffset on vacation ?

2022-09-25 Thread Mark Rotteveel
identical to the nullOffset of the previous field. Did I miss something? -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ACTION REQUIRED: This list is moving to Google Groups, please resubscribe on the new location

2022-09-25 Thread Mark Rotteveel
On 25-09-2022 11:29, Mark Rotteveel wrote: On 25-09-2022 11:19, Dimitry Sibiryakov via Firebird-devel wrote: Mark Rotteveel wrote 25.09.2022 11:15: This list is moving to Google Groups, and we'd like you to move with it.    "Join" button in your invitation sends to 404 page. D

Re: [Firebird-devel] ACTION REQUIRED: This list is moving to Google Groups, please resubscribe on the new location

2022-09-25 Thread Mark Rotteveel
On 25-09-2022 11:19, Dimitry Sibiryakov via Firebird-devel wrote: Mark Rotteveel wrote 25.09.2022 11:15: This list is moving to Google Groups, and we'd like you to move with it.   "Join" button in your invitation sends to 404 page. Do you mean the invite I sent you directly f

[Firebird-devel] ACTION REQUIRED: This list is moving to Google Groups, please resubscribe on the new location

2022-09-25 Thread Mark Rotteveel
doesn't show up immediately. We'll try to manually clear moderation status for known subscribers. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Test (please ignore)

2022-09-21 Thread Mark Rotteveel
Test (please ignore) -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Mark Rotteveel
libraries, but at least doing things in a sane way when a build is performed explicitly requesting to use our own version of libraries. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Mark Rotteveel
On 15-09-2022 13:13, Adriano dos Santos Fernandes wrote: On 15/09/2022 07:52, Mark Rotteveel wrote: On 15-09-2022 03:52, Adriano dos Santos Fernandes wrote: On 05/09/2022 08:13, Mark Rotteveel wrote: That is not really embedded IMHO. Firebird Embedded with Firebird 3.0 has become unwieldy

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Mark Rotteveel
On 15-09-2022 03:52, Adriano dos Santos Fernandes wrote: On 05/09/2022 08:13, Mark Rotteveel wrote: That is not really embedded IMHO. Firebird Embedded with Firebird 3.0 has become unwieldy and even harder to use than earlier versions, especially if you compare it to other embedded database

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Mark Rotteveel
-- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Mark Rotteveel
On 05-09-2022 12:06, Alex Peshkoff via Firebird-devel wrote: On 9/5/22 12:59, Mark Rotteveel wrote: On 05-09-2022 11:50, Alex Peshkoff via Firebird-devel wrote: On 9/5/22 12:31, Mark Rotteveel wrote: That is inconsistent compared to what is done for --with-builtin-tomcrypt. I explicitly

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Mark Rotteveel
On 05-09-2022 11:50, Alex Peshkoff via Firebird-devel wrote: On 9/5/22 12:31, Mark Rotteveel wrote: On 05-09-2022 11:23, Alex Peshkoff via Firebird-devel wrote: This is solved by install script - it creates symlink to /inst/path/firebird/lib/.tm/libtommath.so.0 in system lib directory

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Mark Rotteveel
a usable build. I won't be using the install script, because I don't want to install it, I want to package it for an embedded deployment. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-03 Thread Mark Rotteveel
embedded to be loaded. What is wrong here? Did I miss a configuration option somewhere? Is this a bug in the build? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve release filenames

2022-08-25 Thread Mark Rotteveel
the point to deviate from this for Windows. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve release filenames

2022-08-25 Thread Mark Rotteveel
this package revision (or whatever we should call it) entirely. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve release filenames

2022-08-25 Thread Mark Rotteveel
st because I'm a bit allergic to capitals in filenames ;) Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Mark Rotteveel
debug symbols, not binaries. Sorry, but they are created by 'cp' command ;) One can run them directly. Nonetheless, those Linux archives are not complete builds. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Mark Rotteveel
On 24-08-2022 16:06, Alex Peshkoff via Firebird-devel wrote: On 8/24/22 17:04, Mark Rotteveel wrote: On 24-08-2022 15:36, Dimitry Sibiryakov wrote: Mark Rotteveel wrote 24.08.2022 15:32: If the term is confusing or ambiguous, it already is so in its current form.    Yes, it is. That's why I

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Mark Rotteveel
On 24-08-2022 15:36, Dimitry Sibiryakov wrote: Mark Rotteveel wrote 24.08.2022 15:32: If the term is confusing or ambiguous, it already is so in its current form.   Yes, it is. That's why I would suggest to change that. The Windows pdb packages are complete builds though. So maybe those

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Mark Rotteveel
uild" in "debug" package. What confusion, debuginfo packages are already listed as a "Debug build" on the download page. If the term is confusing or ambiguous, it already is so in its current form. In other words, consolidating it under the term "debug" shouldn't

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Mark Rotteveel
with this, but currently our download page claims the ARM32 and ARM64 build are for Android, and not generically Linux. So, are they actually generically Linux, or specifically for Android? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo

Re: [Firebird-devel] Purpose of op_batch_sync

2022-08-19 Thread Mark Rotteveel
On 19-08-2022 17:30, Alex Peshkoff via Firebird-devel wrote: On 8/19/22 18:24, Mark Rotteveel wrote: It looks like op_batch_sync is just used to force the client to send the deferred messages to the server, and the server to send the deferred responses. Is that correct? exactly So, just

[Firebird-devel] Purpose of op_batch_sync

2022-08-19 Thread Mark Rotteveel
It looks like op_batch_sync is just used to force the client to send the deferred messages to the server, and the server to send the deferred responses. Is that correct? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo

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

2022-08-19 Thread Mark Rotteveel
snapshots from https://github.com/FirebirdSQL/firebird/actions/workflows/main.yml (e.g. use one built from master) Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2022-08-19 Thread Mark Rotteveel
this for the batch files. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Named parameters in client libraries

2022-08-19 Thread Mark Rotteveel
. On the other hand, maybe that could lead to other weird issues (e.g. consider a query TIME+VARCHAR that works fine, but stops working when TIMESTAMP is added in the mix. So, maybe using VARCHAR instead for those cases is the least intrusive alternative after all :( Mark -- Mark Rotteveel

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

2022-08-19 Thread Mark Rotteveel
reference the `gen` path, it is likely the preprocess phase failed, and this is just a subsequent error. That said, you probably need one of the core developers to respond to diagnose this better. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] Named parameters in client libraries

2022-08-19 Thread Mark Rotteveel
On 19-08-2022 02:36, Adriano dos Santos Fernandes wrote: On 18/08/2022 04:37, Mark Rotteveel wrote: In other words, most specific type with the highest precision/scale/length. When confronted with combinations of non-string types and string/blob types, use the most specific non-string type. I

Re: [Firebird-devel] Named parameters in client libraries

2022-08-18 Thread Mark Rotteveel
TIME ZONE => TIMESTAMP WITH TIME ZONE ... In other words, most specific type with the highest precision/scale/length. When confronted with combinations of non-string types and string/blob types, use the most specific non-string type. -- Mark Rotteveel Firebird-Devel m

Re: [Firebird-devel] Named parameters in client libraries

2022-08-18 Thread Mark Rotteveel
rld, named parameters are usually emulated by layers like Hibernate, or Spring's NamedParameterJdbcTemplate, which will map names to positional parameters, and set the values of those positional parameters appropriately. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface

Re: [Firebird-devel] op_que_events and database shutdown

2022-08-16 Thread Mark Rotteveel
is shutdown? In that case you should be able to detect the connection close. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2022-08-16 Thread Mark Rotteveel
clause with DO would raise an error (maybe easiest is to allow it in the parse.y syntax, but raise an error when its present). A downside of this is that statement recognition by clients that currently just look for EXECUTE BLOCK might break. Mark -- Mark Rotteveel Firebird-Devel mailing

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

2022-08-16 Thread Mark Rotteveel
:p2 So, no explicit positional parameter markers ('?')? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Is there a way to get the server to send deferred messages?

2022-08-15 Thread Mark Rotteveel
no effect. I could send an op_ping or another simple request, but that requires consuming an additional response. This is mostly for test purposes, so if using a ping or similar is the only way, then so be it, but if there is something I missed, then that would be appreciated. -- Mark Rotteveel

Re: [Firebird-devel] Do repeated op_batch_create leak the batch?

2022-08-15 Thread Mark Rotteveel
On 15-08-2022 12:47, Alex Peshkoff via Firebird-devel wrote: On 8/13/22 14:59, Mark Rotteveel wrote: I'm implementing batch execution in Jaybird. Looking at the code of rem_port::batch_create(P_BATCH_CREATE* batch, PACKET* sendL) in server.cpp, it looks like sending multiple op_batch_create

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

2022-08-15 Thread Mark Rotteveel
parameters in the example are basically equivalent to stored procedure / execute block parameters (a.k.a. PSQL variables), and PSQL supports named parameters in SQL. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2022-08-14 Thread Mark Rotteveel
for INSERT, etc? I assume this is a toplevel statement only, so it can't occur as a derived table or subquery inside another statement. Is that correct? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Do repeated op_batch_create leak the batch?

2022-08-13 Thread Mark Rotteveel
statement->rsr_batch->release() before assigning a new batch to statement->rsr_batch. Is my assessment correct? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2022-08-12 Thread Mark Rotteveel
actions. What am I missing? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Mark Rotteveel
Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Mark Rotteveel
. Unfortunately I don't always have time or energy to monitor all GitHub updates, and there was no previous discussion on this list about BLOB_APPEND, so I simply had not noticed its existence before. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Mark Rotteveel
On 11-08-2022 17:58, Vlad Khorsun wrote: 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

[Firebird-devel] BLOB_APPEND and returned SUB_TYPE

2022-08-11 Thread Mark Rotteveel
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? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] BLOB_APPEND and NULL

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

[Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Mark Rotteveel
- rewrite concatenation to BLOB_APPEND internally. Why was this NULL behaviour chosen? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-09 Thread Mark Rotteveel
the configuration files remotely (e.g. using some configuration management tool like Puppet), but not necessarily be able to run process on the host, or create databases. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Is batch release necessary in the wire protocol?

2022-07-26 Thread Mark Rotteveel
On 16-07-2022 10:54, Mark Rotteveel wrote: Is sending op_batch_rls necessary in the wire protocol, or is closing the statement itself sufficient? Similar question, is a batch automatically released when unpreparing the statement, or preparing a new statement text? Mark -- Mark Rotteveel

Re: [Firebird-devel] Wrong doc RDB$INDICES.RDB$INDEX_TYPE ?

2022-07-18 Thread Mark Rotteveel
On 18-07-2022 17:35, Ariel Álvarez wrote: Great! But I see the table format broken in langref 3.0. Check again. Aargh, thanks, and fixed :) Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Wrong doc RDB$INDICES.RDB$INDEX_TYPE ?

2022-07-18 Thread Mark Rotteveel
On 16-07-2022 11:15, Mark Rotteveel wrote: On 14-07-2022 18:23, Ariel Álvarez wrote: In language reference it is documented: Table RDB$INDICES Column RDB$INDEX_TYPE: Distinguishes between an expression index (1) and a regular index (0 or null). Not used in databases created before Firebird 2.0

Re: [Firebird-devel] Wrong doc RDB$INDICES.RDB$INDEX_TYPE ?

2022-07-16 Thread Mark Rotteveel
when expression indexes were added in Firebird 2, the assumption was codified in the book, and then copied when the Language Reference was written. I'll double check this and fix the documentation. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourc

[Firebird-devel] Is batch release necessary in the wire protocol?

2022-07-16 Thread Mark Rotteveel
Is sending op_batch_rls necessary in the wire protocol, or is closing the statement itself sufficient? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] More attention to preventing breaking changes in point releases

2022-07-13 Thread Mark Rotteveel
I think https://github.com/FirebirdSQL/firebird/issues/6987 shows that we should be more careful with introducing (or better, preventing) breaking changes in point releases. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo

Re: [Firebird-devel] SIO_LOOPBACK_FAST_PATH deprecated

2022-07-10 Thread Mark Rotteveel
the feature, but consider to deactivate it by default. I want to revisit this discussion. I think that given Microsoft deprecated SIO_LOOPBACK_FAST_PATH and warns against it, we should either remove this entirely from Firebird 5.0, or at minimum disable it by default. Thoughts? Mark -- Mark Rotteveel

Re: [Firebird-devel] Add scroll fetch support in legacy API?

2022-06-04 Thread Mark Rotteveel
On 04-06-2022 15:17, Dmitry Yemanov wrote: 04.06.2022 15:07, Mark Rotteveel wrote: Currently scroll fetch is only exposed in the OO API. Any plans for exposing it in the legacy API Nope, we have an agreement to not extending the legacy API with new features. Ok, too bad. (e.g

[Firebird-devel] Add scroll fetch support in legacy API?

2022-06-04 Thread Mark Rotteveel
Currently scroll fetch is only exposed in the OO API. Any plans for exposing it in the legacy API (e.g. isc_dsql_fetch_scroll / fb_dsql_fetch_scroll)? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Strange CAST result

2022-05-25 Thread Mark Rotteveel
.45, which is odd as 345.12e-2 is a double precision literal, but it looks like it gets coerced to something else in the presence of the cast to varchar. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Incorrect string right truncation errors in Firebird 5

2022-05-17 Thread Mark Rotteveel
On 17-05-2022 15:07, Adriano dos Santos Fernandes wrote: On 17/05/2022 09:54, Mark Rotteveel wrote: Thanks! I will change Jaybird to switch to using blr_varying2/blr_text2 for Jaybird 4.0.7 and Jaybird 5. When you did it for test, did you used the charset number or CS_dynamic? I'm asking

Re: [Firebird-devel] Incorrect string right truncation errors in Firebird 5

2022-05-17 Thread Mark Rotteveel
On 17-05-2022 14:47, Adriano dos Santos Fernandes wrote: On 17/05/2022 08:30, Mark Rotteveel wrote: Is this happening with fbclient library too? Good question: no it doesn't. Which suggests Jaybird is doing something different. Jaybird uses blr_varying/blr_text, not blr_varying2/blr_text2

Re: [Firebird-devel] Incorrect string right truncation errors in Firebird 5

2022-05-17 Thread Mark Rotteveel
On 16-05-2022 21:00, Adriano dos Santos Fernandes wrote: On 16/05/2022 12:07, Mark Rotteveel wrote: On 16-05-2022 16:50, Mark Rotteveel wrote: I was running some tests against Firebird-5.0.0.494-0_x64 (latest snapshot, from last Saturday), and I notice that I get incorrect string right

Re: [Firebird-devel] Incorrect string right truncation errors in Firebird 5

2022-05-16 Thread Mark Rotteveel
On 16-05-2022 16:50, Mark Rotteveel wrote: I was running some tests against Firebird-5.0.0.494-0_x64 (latest snapshot, from last Saturday), and I notice that I get incorrect string right truncation errors with CHAR/VARCHAR. I currently cannot dive deeper into it, but as a datapoint, the error

[Firebird-devel] Incorrect string right truncation errors in Firebird 5

2022-05-16 Thread Mark Rotteveel
-0_x64. Based solely on the commit message, maybe this commit is at fault? https://github.com/FirebirdSQL/firebird/commit/dd18a3b11b28c3ed8126a6f54b829989954bfa03 Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Refresh roles

2022-05-11 Thread Mark Rotteveel
properly convey intent. Given we already have `ALTER SESSION RESET`, I would suggest `ALTER SESSION UPDATE PRIVILEGES` or something like that. However, I'm wondering how other database systems behave in a scenario like this. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface

Re: [Firebird-devel] DEFAULT grants to PUBLIC

2022-05-10 Thread Mark Rotteveel
with normal default roles: granularity. You can group related permissions together, and make is easier to revoke those permissions en bloc if you no longer want everyone to have them. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo

Re: [Firebird-devel] isc_spb_version Call Without Global User?

2022-05-04 Thread Mark Rotteveel
should be used during service attach (including security database). I assume you mean isc_spb_expected_db, right? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Remove travis-ci?

2022-04-30 Thread Mark Rotteveel
On 30-04-2022 12:05, Mark Rotteveel wrote: On 28-04-2022 11:51, Adriano dos Santos Fernandes wrote: On 28/04/2022 05:37, Mark Rotteveel wrote: Our travis-ci builds haven't actually run for the past 10 months as we ran out of credits. As no one has noticed this in that time, it looks like

Re: [Firebird-devel] Remove travis-ci?

2022-04-30 Thread Mark Rotteveel
On 28-04-2022 11:51, Adriano dos Santos Fernandes wrote: On 28/04/2022 05:37, Mark Rotteveel wrote: Our travis-ci builds haven't actually run for the past 10 months as we ran out of credits. As no one has noticed this in that time, it looks like the travis-ci builds serve no actual purpose

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2022-04-28 Thread Mark Rotteveel
On 22-04-2022 17:51, Dmitry Yemanov wrote: 22.04.2022 14:49, Mark Rotteveel wrote: I was wondering if this - fetching rowcount of a scrollable cursor - was already implemented. If so, how do I get it? And if not, when can I expect it to be implemented? PR #7083, was left for review

[Firebird-devel] Remove travis-ci?

2022-04-28 Thread Mark Rotteveel
github.com/FirebirdSQL ? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2022-04-22 Thread Mark Rotteveel
On 08-12-2021 10:13, Dmitry Yemanov wrote: 28.11.2021 14:45, Mark Rotteveel wrote: 3) "row count" makes it possible to know the position after fetchLast() and everything else could be calculated locally by the client library, thus making the server-supported "current po

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

2022-03-31 Thread Mark Rotteveel
On 2022-03-31 15:39, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 31.03.2022 15:21:   Note that the crash happen on compression so it doesn't affect Firebird security. Did not catch why - we use zlib compression on the wire (since fb3) and in gbak (since fb4). Both

[Firebird-devel] Security vulnerability in zlib library

2022-03-31 Thread Mark Rotteveel
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? Can people just drop in a replacement? Mark Firebird-Devel mailing list, web

Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename

2022-03-01 Thread Mark Rotteveel
On 2022-03-01 12:47, Alex Peshkoff via Firebird-devel wrote: On 2/28/22 21:39, Jiří Činčura wrote: Thanks. I suppose not only TPB, but also buffers for batch, events, etc., right? Yes. Basically only DPB and SPB are "UTF8-ready". If one wants everyting to be utf8 why not have

Re: [Firebird-devel] INT64 and index keys

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

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Mark Rotteveel
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. For example, it stores every 3 decimal digits

Re: [Firebird-devel] INT64 and index keys

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

Re: [Firebird-devel] Statement type for INSERT ... RETURNING

2022-02-12 Thread Mark Rotteveel
On 11-02-2022 17:46, Mark Rotteveel wrote: On 2022-02-11 12:54, Jiří Činčura wrote: Is there a way to get as a response to isc_info_sql_stmt_type for "INSERT ... RETURNING" isc_info_sql_stmt_insert instead of isc_info_sql_stmt_exec_procedure? Or something similar that would sp

Re: [Firebird-devel] Statement type for INSERT ... RETURNING

2022-02-11 Thread Mark Rotteveel
On 2022-02-11 12:54, Jiří Činčura wrote: Is there a way to get as a response to isc_info_sql_stmt_type for "INSERT ... RETURNING" isc_info_sql_stmt_insert instead of isc_info_sql_stmt_exec_procedure? Or something similar that would specify it's an "insert"? No. In fact, with Firebird 5,

Re: [Firebird-devel] User name case

2022-01-20 Thread Mark Rotteveel
On 2022-01-19 16:46, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 18.01.2022 18:03:     fb_utils::dpbItemUpper(userName); That's quite strange routine. It will uppercase the string even if it contains ASCII letters disallowed for not-delimited SQL identifier (which user

Re: [Firebird-devel] isc_usrname_too_long

2022-01-14 Thread Mark Rotteveel
On 14-01-2022 17:10, Dimitry Sibiryakov wrote: Mark Rotteveel wrote 14.01.2022 17:06:    Also shouldn't it to be returned if user name received in DPB (after conversion into UTF-8) doesn't fit as well? I'm not sure what you mean with that.   Currently if someone put into DPB non-ASCII user

Re: [Firebird-devel] isc_usrname_too_long

2022-01-14 Thread Mark Rotteveel
On 14-01-2022 16:41, Dimitry Sibiryakov wrote:   Hello All.   Shouldn't subj text to be corrected? I probably should.   Also shouldn't it to be returned if user name received in DPB (after conversion into UTF-8) doesn't fit as well? I'm not sure what you mean with that. Mark -- Mark

Re: [Firebird-devel] Sub routines accessing outer variables, parameters and cursors

2022-01-11 Thread Mark Rotteveel
On 2022-01-11 20:15, Adriano dos Santos Fernandes wrote: Hi! Currently sub routines cannot access the outer (main routine/block) variables, parameters and cursors - #4769. There is some details to make that happen safely. Currently a variable cannot have its value changed while its being

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

2022-01-06 Thread Mark Rotteveel
On 2022-01-05 21:48, Jiří Činčura wrote: Yes. You probably have the same problem in your provider, no? The problem exists there. Same as with fbclient. But I don't explicitly solve it, application developer is responsible for handling such scenario (if ever). I agree. If the application

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-26 Thread Mark Rotteveel
, not about the "protocol". Added chapter to https://github.com/FirebirdSQL/firebird-documentation/blob/master/src/docs/asciidoc/en/firebirddocs/wireprotocol/firebird-wire-protocol.adoc#wireprotocol-batches-release I did some minor copy editing and published it. Mark -- Mark Rotteveel

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-26 Thread Mark Rotteveel
, not about the "protocol". Added chapter to https://github.com/FirebirdSQL/firebird-documentation/blob/master/src/docs/asciidoc/en/firebirddocs/wireprotocol/firebird-wire-protocol.adoc#wireprotocol-batches-release Thanks Alex! Mark -- Mark Rotteveel Firebird-Devel mailing list, web

Re: [Firebird-devel] Documentation of SET DEBUG OPTION

2021-12-24 Thread Mark Rotteveel
On 24-12-2021 13:14, Adriano dos Santos Fernandes wrote: On 24/12/2021 07:12, Mark Rotteveel wrote: Checking the changes of Firebird 4.0.1 to update the docs, I noticed that a new statement `SET DEBUG OPTION` has been introduced, but I can't find much about it, except for "To

[Firebird-devel] Documentation of SET DEBUG OPTION

2021-12-24 Thread Mark Rotteveel
trieve one of the isc_info_sql_exec_path_blr_* options from? (checking the commit, it seems to be attachment level, but I'd like confirmation 3. How do you clear an option, set value to false, can you set to null? Also, is there more to it than this? -- Mark Rotteveel Firebird-Devel mailing

Re: [Firebird-devel] varbinary

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 14:04, Norbert Saint Georges wrote: Thank you for your two responses. unfortunately I have a problem with an old project, following the update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 11:51, Dmitry Yemanov wrote: Mark et al, Looked at it again, and being able to get the total row count will work for me. Is this information already available, or does this still need to be implemented? What would you expect from the "row count" requested for a non-scrollable

Re: [Firebird-devel] varbinary

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 12:40, Norbert Saint Georges wrote: Hello, a varbinary has a subtype of 1 and not 0 (binary) normal? You're thinking of BLOB SUB_TYPE, and this is unrelated to BLOB SUB_TYPE, as it isn't a BLOB type. In Firebird 4, VARBINARY is introduced as *an alias* for VARCHAR CHARACTER

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-19 Thread Mark Rotteveel
On 08-12-2021 10:13, Dmitry Yemanov wrote: 28.11.2021 14:45, Mark Rotteveel wrote: We don't have anything like this. Theoretically, we could extend IRecordSet with something similar (although it would also require a protocol change), but the question is whether it's really needed

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Mark Rotteveel
On 2021-12-16 14:23, Alex Peshkoff via Firebird-devel wrote: On 12/16/21 15:12, Mark Rotteveel wrote: On 2021-12-16 10:28, Alex Peshkoff via Firebird-devel wrote: be segmented and swap bytes in segment length when needed. Afraid there is - as always :( - no protocol description except source

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Mark Rotteveel
On 2021-12-16 10:28, Alex Peshkoff via Firebird-devel wrote: be segmented and swap bytes in segment length when needed. Afraid there is - as always :( - no protocol description except source code. Key ops are op_batch_msg, op_batch_blob_stream & also op_batch_cs (retuning batch execution state

[Firebird-devel] Fwd: [FirebirdSQL/firebird] Connection hangs after delivery of 2**32 - 1 packets (Issue #7065)

2021-12-12 Thread Mark Rotteveel
I strongly disagree with the chosen fix to make the counter size configurable. ChaCha20 is standardized in RFC-7539 with a 32-bit counter size[1]. Making the counter size configurable has two problems: 1) It is harder to support (as non-standard forms of ChaCha are not always available) 2)

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-08 Thread Mark Rotteveel
On 2021-12-08 10:13, Dmitry Yemanov wrote: 28.11.2021 14:45, Mark Rotteveel wrote: We don't have anything like this. Theoretically, we could extend IRecordSet with something similar (although it would also require a protocol change), but the question is whether it's really needed

Re: [Firebird-devel] Protocol 15

2021-12-07 Thread Mark Rotteveel
On 2021-12-06 19:10, Jiří Činčura wrote: IIRC, the only real change in protocol 14 was Yeah. Not really worth the effort I meant, it will be "solved" by 15 implementation. Yeah, I did the same in Jaybird: skipped implementation of protocol 14. Mark Firebird-Devel mailing list, web

Re: [Firebird-devel] Protocol 15

2021-12-06 Thread Mark Rotteveel
in the op_crypt_key_callback. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-01 Thread Mark Rotteveel
. An oversight? You need to set the cursor name before you open it, IIRC. So - assuming I'm not mistaken in this - adding it to IResultSet doesn't make sense, as that will only return once the cursor has been opened. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] WNET future

2021-11-30 Thread Mark Rotteveel
On 30-11-2021 15:26, Adriano dos Santos Fernandes wrote: On 30/11/2021 10:24, Jiří Činčura wrote: My vote goes to dropping it. Agreed. I have no opinion on this. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-11-28 Thread Mark Rotteveel
have their own size). Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

  1   2   3   4   5   6   7   8   9   10   >