Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

On 5/11/21 6:18 PM, Dimitry Sibiryakov wrote: 11.05.2021 17:13, Alex Peshkoff via Firebird-devel wrote: Stop-stop. You are mixing crypt and hash in single mix.  No, I don't. I just know what a "signature" is. All of sudden it is an encrypted hash of the message (and some

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

On 5/11/21 6:24 PM, Mark Rotteveel wrote: And I repeat: given RSA_SIGN has a HASH parameter, and applies PSS, I assume it hashes the message using the supplied (or default) hash algorithm, and then signs the resulting hash. Having to hash this yourself makes no sense to me. It _might_ be i

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

On 5/11/21 6:31 PM, Dimitry Sibiryakov wrote: 11.05.2021 17:26, Alex Peshkoff via Firebird-devel wrote: To be precise - signature is a decrypted hash of a message, verify means encrypt it bak - and get same hash.  To be more precise verify is comparison of a hash of the message with

Re: [Firebird-devel] Examples of RSA_SIGN and RSA_VERIFY in the release notes

On 5/11/21 6:41 PM, Mark Rotteveel wrote: On 11-05-2021 17:33, Alex Peshkoff via Firebird-devel wrote: On 5/11/21 6:24 PM, Mark Rotteveel wrote: And I repeat: given RSA_SIGN has a HASH parameter, and applies PSS, I assume it hashes the message using the supplied (or default) hash algorithm

Re: [Firebird-devel] Numeric literals and INT128 (including numeric types) vs DECFLOAT

On 5/13/21 3:47 PM, Mark Rotteveel wrote: I'm in the process of writing the Firebird 4.0 Language Reference, and I'm noticing some odd things with numeric literals and INT128 (including numeric types) and DECFLOAT. 2. Exact numeric literals with 30 or more digits are handled as DECFLOAT(34)

Re: [Firebird-devel] fb 5.0.0.40 ?

On 5/18/21 3:57 PM, Norbert Saint Georges wrote: Hello, I just compiled Firebird via git and he pulls me out the version Firebird 5.0.0.40-Initial.amd64 . Normal? Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Deprecations

On 5/19/21 12:42 AM, Adriano dos Santos Fernandes wrote: Hi! UDF was been deprecated in FB 4. Could we remove them from master for v5? Doubt that. UDF is too actively used feature, lot of users will not be happy. Also QLI, I believe nobody uses it and there should be no good reason to ma

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

On 5/20/21 5:32 PM, Adriano dos Santos Fernandes wrote: Hi! Currently max. CHAR length is limited to 32767 and max. VARCHAR to 32765. I didn't found any blocker prevent raising that limits to 65535 and 65533 respectively. Even not going into details agraid I see one serious problem - ISC API

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

On 5/21/21 3:49 PM, Adriano dos Santos Fernandes wrote: On 21/05/2021 08:33, Dimitry Sibiryakov wrote: 21.05.2021 09:38, Alex Peshkoff via Firebird-devel wrote: Any idea how to avoid that?   Redeclare it as unsigned right now. Yes. But would be very bad to see not recompiled programs just

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

On 5/21/21 9:06 PM, Mark Rotteveel wrote: On 2021-05-21 16:51, Alex Peshkoff via Firebird-devel wrote: We have one more unused value for size - zero, we do not support characters with length == 0. We may store logical data length - 1, this will make it possible to have exactly 64Kb fields

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

On 5/21/21 9:19 PM, Adriano dos Santos Fernandes wrote: And if we do change SQLDA_VERSION it's worth changing something else in it. For example - make all sizes uint32, add separate field for charset, may be something else? My aim is to increase CHAR/VARCHAR lengths. I think there is no real b

Re: [Firebird-devel] Fwd: FB4 RC installation errors ?

There were some fixed issues with tomcrypt & linux install. Can you try with current snapshot http://web.firebirdsql.org/download/snapshot_builds/linux/fb4.0/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

On 5/22/21 12:03 AM, Adriano dos Santos Fernandes wrote: On 21/05/2021 17:53, Alex Peshkoff via Firebird-devel wrote: On 5/21/21 9:19 PM, Adriano dos Santos Fernandes wrote: And if we do change SQLDA_VERSION it's worth changing something else in it. For example - make all sizes uint32

Re: [Firebird-devel] IBlob::putSegment

On 5/27/21 12:13 PM, Jiří Činčura wrote: Hi, Is there a sweet spot for the buffer size/length when using IBlob::putSegment? a) user stream (not segmented) blobs b) use bigger buffers Or is it fine to put even 1 byte segments? It depends upon goals:) May be recommended as an efficient way

Re: [Firebird-devel] IBlob::putSegment

On 5/27/21 4:34 PM, Jiří Činčura wrote: a) user stream (not segmented) blobs Is there some docs for that? What I found in "Using_OO_API.html" is just "Last two parameters are required only if you want to use blob filters or use stream blob, that's out of scope here.". That parameters are BP

Re: [Firebird-devel] CALL statement

On 5/31/21 4:50 PM, Dimitry Sibiryakov wrote: 31.05.2021 15:19, Adriano dos Santos Fernandes wrote:   I propose that standard SQL CALL is adapted for our needs.   Your proposed syntax is far from standard. I see no point in using standard keyword with non-standard syntax. Dimitry, can you

Re: [Firebird-devel] CALL statement

On 5/31/21 4:19 PM, Adriano dos Santos Fernandes wrote: Hi! EXECUTE PROCEDURE is full of weirdness... May be keep old syntax and add some new, not related with SQL-standard CALL: EXECUTE PROCEDURE [ . ]     [ | ( ) ]     [ RETURNING_VALUES |   RETURNING_VALUES ( ) |       RETURNING

Re: [Firebird-devel] CALL statement

On 5/31/21 10:21 PM, Adriano dos Santos Fernandes wrote: As the second, unrelated change, shorten EXECUTE PROCEDURE/STATEMENT/what-else OBJECT to EXEC OBJECT and decide about object type from context - provided it will not raise the hell in btyacc. I do not understood what you mean. Now: E

Re: [Firebird-devel] CALL statement

On 6/1/21 12:51 PM, Dimitry Sibiryakov wrote: 31.05.2021 21:21, Adriano dos Santos Fernandes wrote: [ | ( ) ] [ RETURNING_VALUES |    RETURNING_VALUES ( ) |   RETURNING [ INTO ]  ] This does not support ignore all output in DSQL.   There can be syntax "RETURNING NULL

Re: [Firebird-devel] IBlob::putSegment

On 6/2/21 11:06 PM, Vlad Khorsun wrote: 02.06.2021 20:39, Jiří Činčura wrote:   IXpbBuilder* pb = utl->getXpbBuilder(&status, IXpbBuilder::BPB, NULL, 0); Looks like FB3 does not have BPB (https://github.com/FirebirdSQL/firebird/blob/R3_0_7/src/include/firebird/IdlFbInterfaces.h#L3827

Re: [Firebird-devel] Authentication error connection shutdown

On 6/6/21 7:39 PM, Jiří Činčura wrote: Hi *, What the error "Authentication error connection shutdown" in firebird.log means? May be something gone wrong with sec-db attachments cache. Can you please check - if you wait a minute or 2 w/o restart will it help? Sometimes this happens after a

Re: [Firebird-devel] FB4.0: Operating system call access failed. Error code 20

On 6/30/21 11:21 AM, Pro Turm wrote: Hi, Does anyone know the reason for the following? /Operating system call access failed. Error code 20/ / / /ConfigStorage: Cannot initialize the shared memory region         operating system directive access failed         Not a directory/ / / /Authenticatio

Re: [Firebird-devel] FB4.0: Operating system call access failed. Error code 20

Jun 28 11:07 fb_rename_guard/ Am Mi., 30. Juni 2021 um 10:40 Uhr schrieb Alex Peshkoff via Firebird-devel <mailto:firebird-devel@lists.sourceforge.net>>: On 6/30/21 11:21 AM, Pro Turm wrote: > Hi, > Does anyone know the reason for the following? > > /

Re: [Firebird-devel] FB4.0: Operating system call access failed. Error code 20

On 7/1/21 4:27 PM, Pro Turm wrote: If you use UID/GID in docker with same number as firebird group in host, probably you will not have problem. No, I dont set/use anything explicitly in the docker regarding UID/GID. If docker is using install script for linux distro, different f

Re: [Firebird-devel] Multiple CNCT_specific_data

On 7/5/21 2:27 PM, Jiří Činčura wrote: Hi, Is it possible to sent multiple CNCT_specific_data, basically for each CNCT_plugin_name right away (saving roundtrip)? Never tried and doubt that would work. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listi

Re: [Firebird-devel] Multiple CNCT_specific_data

On 7/5/21 4:18 PM, Jiří Činčura wrote: Never tried and doubt that would work. Does not work on my side. Hence, I take that as that it doesn't work. I suppose the extra op_cont_auth round-trip is going to be needed in case the first auth plugin is not matched. You must also send CNCT_plugin_

Re: [Firebird-devel] Response to op_accept_data

On 7/5/21 5:55 PM, Jiří Činčura wrote: HI, What's the expected response to server from client after client receives op_accept_data? if needed - initialize channel compression, next - attach(create) database or attach service Firebird-Devel mailing list, web interface at https://lists.s

Re: [Firebird-devel] Response to op_accept_data

On 7/5/21 6:28 PM, Jiří Činčura wrote: What's the expected response to server from client after client receives op_accept_data? It's a weird combination I'm doing and something is missing from my implementation here. Client: Srp256, Srp WireCrypt: Disabled CNCT_specific_data sent for Srp

Re: [Firebird-devel] Response to op_accept_data

On 7/5/21 6:30 PM, Jiří Činčura wrote: next - attach(create) database or attach service You mean op_attach? Like again? Because that was sent in the first place (op_connect + op_attach). I have not known that's non-default client config. Certainly, no need to repeat op_attach. You just need

Re: [Firebird-devel] Response to op_accept_data

On 7/5/21 7:17 PM, Jiří Činčura wrote: unavailable database What's the setting of WireCrypt on the server? For a mode you check it should be Enabled or Disabled, not Required default. For Required you get quite correct error. (sorry, sooner of all will next answer only tomorrow) Firebir

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 8:45 AM, Jiří Činčura wrote: This is the order of operations. Compression is disabled. FB3 server has only Srp and Win_Sspi enabled, WireCrypt is Enabled. op_connect + op_attach CNCT_user, ... CNCT_host, ... CNCT_user_verification, CNCT_login, ... CNCT_plugin_name, Srp2

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 12:13 PM, Jiří Činčura wrote: Or maybe I'll just support Srp256 only and ignore Srp forever. :D And be not able to connect to default FB3? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 12:22 PM, Jiří Činčura wrote: And be not able to connect to default FB3? FB3 has Srp256 included starting something like 3.0.4, no? Supports - but not active in default config. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-d

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 12:20 PM, Jiří Činčura wrote: data from plugin to server, net op is op_cont_auth. That's the case for WireCrypt != Disabled. Else it just continues to op_attach and the rest of the auth is done there. Made config match yours. During connect/auth/attach fbclient send 4 packets to s

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 12:44 PM, Jiří Činčura wrote: Made config match yours. During connect/auth/attach fbclient send 4 packets to server: op_connect, op_attach, op_cont_auth: (gdb) print packet->p_auth_cont $7 = {p_data = {cstr_length = 256, cstr_allocated = 0, cstr_address = 0x77accd90 "9488D1F4

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 2:23 PM, Mark Rotteveel wrote: On 2021-07-06 12:12, Alex Peshkoff via Firebird-devel wrote: Not understand your question. 4 packets were sent: 1. op_connect 2. op_attach 3. op_cont_auth 4. op_cont_auth What is op_connect + op_attach? The op_connect packet has a secondary op_attach

Re: [Firebird-devel] Response to op_accept_data

On 7/6/21 3:43 PM, Jiří Činčura wrote: I would almost say, I'll remove it then. :) But fbclient is sending it too, so I'll probably stick with tried and true behavior. Yes, certainly it should stay in place. (It's present since fb 1.0, and I have no idea who used network opcode in wrong way

Re: [Firebird-devel] 64 bit arm buildx/qemu issues for docker

On 7/7/21 10:40 AM, marius adrian popa wrote: Seems that there are still issues with ubuntu 20.04 on arm64 https://github.com/jacobalberty/firebird-docker/issues/67#issuecomment-875220239 I've updated libtool

Re: [Firebird-devel] Ubuntu Firebird built from sources uninstall

On 7/7/21 6:40 PM, Dimitry Sibiryakov wrote: Hello All.   If I installed into Ubuntu 18.04 Firebird built from sources using "make install", how to uninstall it correctly? Is there script FirebirdUninstall.sh? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/

Re: [Firebird-devel] IPluginModule::doClean() call point

On 7/13/21 6:32 PM, Dimitry Sibiryakov wrote: Hello All.   Is doClean() supposed to be guaranteed to be called before plugin library unloading process?   For Firebird 4 (current snapshot) in embedded I see that it is called after some global variables of the library are already destructed,

Re: [Firebird-devel] IPluginModule::doClean() call point

On 7/13/21 7:22 PM, Dimitry Sibiryakov wrote: 13.07.2021 17:48, Alex Peshkoff via Firebird-devel wrote: - your process called exit() and due to it plugin is going to be unloaded, this fact is detected by dtor of UnloadDetectorHelper, which also calls doClean, but in this case some globals may

Re: [Firebird-devel] IPluginModule::doClean() call point

On 7/14/21 12:19 PM, Dimitry Sibiryakov wrote: 14.07.2021 10:51, Alex Peshkoff via Firebird-devel wrote: What does hex value mean?   "this". Used to identify source object for the line.   I'll do a couple more experiments to determine if the problem is with thread races or li

Re: [Firebird-devel] IPluginModule::doClean() call point

On 7/14/21 12:38 PM, Dimitry Sibiryakov wrote: 14.07.2021 11:27, Alex Peshkoff via Firebird-devel wrote:   I'll do a couple more experiments to determine if the problem is with thread races or library unloading order by OS because I suspect that on exit they are unloaded in reverse order

Re: [Firebird-devel] IPluginModule::doClean() call point

On 7/14/21 2:13 PM, Dimitry Sibiryakov wrote: 14.07.2021 13:06, Alex Peshkoff via Firebird-devel wrote: Without a kind of UnloadDetector in your plugin PluginManager is not aware that your plugin was unloaded on exit(). But if all that chain was called from fb_shutdown() it does not matter

Re: [Firebird-devel] IPluginModule::doClean() call point

On 7/14/21 3:37 PM, Vlad Khorsun wrote: 14.07.2021 15:29, Dimitry Sibiryakov wrote: 14.07.2021 14:25, Vlad Khorsun wrote:    Are you sure fb_shutdown() was called before exit() ?    isql calls fb_shutdown() in atexit() handler so it is surely called after exit().  Yes, indeed. In isql fb_s

Re: [Firebird-devel] Client forcing server to encryption

On 7/15/21 12:23 PM, Jiří Činčura wrote: Hi, I have server with "WireCrypt = Disabled", but I can "just" send op_crypt and server follows. Is this expected? With current code - yes. But on my mind that's a bug (never seen with fbclient). Please add a ticket to the tracker. Firebird-Dev

Re: [Firebird-devel] Retrieving statement BLR for debug and test

On 7/15/21 10:56 PM, Dimitry Sibiryakov wrote: 15.07.2021 21:34, Adriano dos Santos Fernandes wrote: Comments?   I see no point in the new interface. Not new iface, just extension of old one. It would be simpler to raise trace BLR event from SQL prepare and let anyone interested to watch

Re: [Firebird-devel] The IBatch Interface and inline blobs

On 7/16/21 12:39 PM, Tony Whyman wrote: I have recently added support for the IBatch interface to IBX and the good news that it all appears to work fine. However, I am still puzzled by why inline blobs exist. For as long as I can remember, Firebird has allowed you to over-ride the input metad

Re: [Firebird-devel] The IBatch Interface and inline blobs

On 7/16/21 4:54 PM, Tony Whyman wrote: So I guess that as long as the string is < 32K and you are not using a segmented blob then it is OK to use SQL_VARYING and not the inline blob facility. On the subject of limits, IBatch does seem to have a silent limit that I am still exploring. I was co

Re: [Firebird-devel] Invalid SPB

On 7/20/21 4:29 PM, Jiří Činčura wrote: Looks OK to me, but obviously it is not. Both the isc_spb_auth_plugin_name and isc_spb_specific_auth_data should be wide (https://github.com/FirebirdSQL/firebird/blob/B3_0_Release/src/common/classes/ClumpletReader.cpp#L324), right? What am I missing?

Re: [Firebird-devel] Invalid SPB

On 7/20/21 4:52 PM, Jiří Činčura wrote: Aha! I suppose in version 2 I can't send data with 2-byte length, right? Aka, I need to jump to version 3 and use 4-byte length. Exactly. V.3 for SPB is like v.2 for DPB. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/li

Re: [Firebird-devel] Invalid SPB

On 7/20/21 5:17 PM, Jiří Činčura wrote: BTW, anybody remembers the reason why version 2 has two values - isc_spb_version, isc_spb_current_version - at the beginning? Sooner of all this should be asked in Borland / Inprise - that was so in IB6.0. Firebird-Devel mailing list, web interfac

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

On 7/23/21 10:50 AM, Mark Rotteveel wrote: Hi, Last week a question was asked on firebird-java regarding a JVM crash on Linux when Firebird Embedded is used in combination with a UDF, but to be honest, I have no clue what to look for. I have been able to reproduce the crash (or possibly even

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

On 7/24/21 12:23 PM, Arnaud Le-roy wrote: Hi, This is the complete gdb logs : >20 frames in a thread without any debug info... nice bug. Must say that firebird sometimes can create such traces w/o debug info - this happens when provider is unloaded (by mistake, certainly) in the middle of

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

On 7/26/21 5:40 PM, Arnaud Le-roy wrote: Also I do not see any thread actively working with database, i.e. probably one with AV (thread 2) is such thread. And in that case problematic UDF (as always) is first candidate to raise problems. Can one confirm that w/o UDF bug does not happen? Y

Re: [Firebird-devel] New getInfo2 API

On 7/26/21 10:08 PM, Dimitry Sibiryakov wrote: Why not return IXpbBuilder? It already has all needed navigation methods. Yes - and functions to read info data in different formats are also there. Just make getinfo2() return XpbBuilder instead InfoBuffer. Firebird-Devel mailing list, web

Re: [Firebird-devel] ConfigStorage mutex error

On 8/8/21 6:54 PM, Dimitry Sibiryakov wrote: Hello All   what can be a reason for the error "ConfigStorage: mutex mutexLock error, status = 22" in firebird.log?    EINVAL The mutex was created with the protocol attribute having the value PTHREAD_PRIO_PROTECT and the calling  thread's pri

Re: [Firebird-devel] Windows installer and ICU files

On 8/16/21 5:25 PM, Carlos H. Cantu wrote: VK>Only by explicit user request, off by default. Beside the ICU DLLs, I also agree with Adriano that zlib1.dll should be installed during a Client install. I would go further and install chacha.dll too. Currently installer doesn't install chacha.d

Re: [Firebird-devel] Windows installer and ICU files

On 8/16/21 5:56 PM, Paul Reeves wrote: On Mon, 16 Aug 2021 17:34:09 +0300 Alex Peshkoff via Firebird-devel wrote: One detail - this should not be called "minimum client install". This should be called "default install", Or maybe just call it 'client install'

Re: [Firebird-devel] isc_info_sql_stmt_type/isc_info_sql_stmt_flags

On 8/19/21 4:17 PM, Adriano dos Santos Fernandes wrote: Hi! Since RETURNING was created, we change values of isc_info_sql_stmt_type so clients can understand that statements with RETURNING have values. With GH-6815, RETURNING will return cursors (except for INSERT INTO ... VALUES RETURNING whic

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

On 8/20/21 4:01 PM, Tony Whyman wrote: .. With my test data, the buffer overflow occurs after several thousand calls to IBatch::add. The number of message buffers lost is of the order of hundreds. I don't want to have to keep a copy of every message buffer as that could result in other ou

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

On 8/21/21 6:26 PM, Tony Whyman wrote: The good news is that I believe I have found a way around the problem. The bad news is that I think I have found another minor bug. The workaround for variable message sizes is to compute the "used" buffer size after each call to IBatch::add by ensuring t

Re: [Firebird-devel] Dialect 3 inconsistent round/trunc - configurable calculation method needed

On 9/1/21 7:13 PM, Omacht András wrote: (Or please support D1 and don’t force developers to rewrite existing codebase.) May be I've missed something - but did we have plans to remove Dialect 1? It seems that not. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net

Re: [Firebird-devel] Tips for a strange bug in firebird integrated into LibreOffice

On 9/3/21 11:54 AM, Mike Kaganski wrote: Hi! I understand that the question is less than ideal, and I'm sorry for that. I'm trying to debug a very strange bug in Firebird built into LibreOffice (embedded DB functionality). A specific ODB (a package that contains a FB database) crashes executi

Re: [Firebird-devel] Tips for a strange bug in firebird integrated into LibreOffice

On 9/3/21 1:24 PM, Mike Kaganski wrote: Sure - here's the stack trace of the moment when VS shows "Exception thrown at 0x7FFA0F4A1A29 (vcruntime140d.dll) in soffice.bin: 0xC005: Access violation writing location 0x025B7D701000."; sorry for not including it from start. Note that t

Re: [Firebird-devel] Rework the error message processing for simpler and faster build

On 9/2/21 7:32 PM, Dimitry Sibiryakov wrote: That's pity. It is a dead piece anyway. After such phraze should fiollow: "instead it I suggest bla-bla-bla...". Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Tips for a strange bug in firebird integrated into LibreOffice

On 9/3/21 2:29 PM, Mike Kaganski wrote: ODB is a ZIP; it contains a database/firebird.fbk, from which a FDB is created when LO opens the DB. I used 'gbak -C firebird.fbk firebird.fdb' to extract the file initially. For example database that has left in tmp dir. Here it is: https://drive.g

Re: [Firebird-devel] fb_info_protocol_version implementation

On 9/3/21 3:32 PM, Jiří Činčura wrote: Hi, Where I can find fb_info_protocol_version implementation? I'm looking into https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/inf.cpp and that case is not there. Nor I can find the fb_info_protocol_version while grep-ing the sources. That

Re: [Firebird-devel] MessageBuffer vs C struct alignment

On 9/12/21 6:40 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 15.05.2018 12:13: On 05/15/18 13:06, Dimitry Sibiryakov wrote: 15.05.2018 11:58, Alex Peshkoff via Firebird-devel wrote:   Do alignment of fields in C struct matches alignment of the same fields in

Re: [Firebird-devel] MessageBuffer vs C struct alignment

On 9/16/21 12:18 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 13.09.2021 9:39: Yes, that should be fixed. If one builds FB with native __int128 it fails on unaligned data access. But changing alignment requirement to 16 bytes is not enough - appears some buffers are

Re: [Firebird-devel] MessageBuffer vs C struct alignment

On 9/16/21 1:00 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 16.09.2021 11:52: First of all it's good to know what places are affected. Do not want to try to guess them.   ODS The most strightforward solution for FB5 is new major ODS. For FB4 I see onl

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/16/21 4:38 PM, Adriano dos Santos Fernandes wrote: Hi! Unfortunately init_priority do not work as we intended in MacOS. clang generate correct assembly/object file but the MacOS linker do not sort and merge the sections of different files. Pity. But typical for Mac :-( Firebird-Devel

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/16/21 10:58 PM, Dimitry Sibiryakov wrote: Unfortunately atexit of executable is called after atexit of the library causing the executable to call the routine(s) from the library with already destructed globals. Is it about a library dynamically (dlopen, LoadLibrary) loaded or linked t

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/17/21 12:44 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 17.09.2021 9:08: Is it about a library dynamically (dlopen, LoadLibrary) loaded or linked to the exacutable?   Both. The library tree is the same (at least on Linux). Tree is the same - but cleanup order

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/17/21 5:53 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 17.09.2021 16:13: First of all dynamically loaded libraries are unloaded in reverse order, next invoken executable dtors/atexits, and only after it - dtors of linked libraries.   Ah, ok. But returning to the

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/17/21 6:15 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 17.09.2021 17:03: as an additional cherry on a cake we have very fast, efficient and (last but not least) familiar for developers support of hunting for memory leaks.   Is it more familiar than DrMemory and

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

On 8/23/21 3:44 PM, Tony Whyman wrote: On 23/08/2021 13:03, Alex Peshkoff via Firebird-devel wrote: The minor bug is that if TAG_BUFFER_BYTES_SIZE is set to > 256MB no error status is reported on a call to createBatch. Instead, you only know you have a problem when an error is returned f

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/21/21 3:24 PM, Adriano dos Santos Fernandes wrote: On 21/09/2021 09:11, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 21.09.2021 13:50: We may split that global default pool in two, so we'll have another default pool for external (not controlled by us) libraries. All memory

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/21/21 3:31 PM, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 21.09.2021 14:24: Though we will lose way to monitor leaks.   Valgrind, drMemory and sanitizers will work in this case. Valgring makes execution many times slower (that's from my own experience). I've never us

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/21/21 4:02 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 21.09.2021 14:51: That's why this solution is usable only if we can't do something else.   https://github.com/google/sanitizers can detect much wider set of problems that our pools. Its support is

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/21/21 2:50 PM, Adriano dos Santos Fernandes wrote: I think we can improve things here. We have our GlobalPtr, InitInstance and we may continue using them. And we have FB_NEW which allocates memory from the global default pool. We may split that global default pool in two, so we'll have ano

Re: [Firebird-devel] Memory manager cleanup / external libraries

On 9/21/21 4:13 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 21.09.2021 15:06: Valgring makes execution many times slower (that's from my own experience).   Does it really matter if test suite isn't run in production anyway?.. Memory leaks detector d

Re: [Firebird-devel] Unhandled exception in Why

On 9/27/21 12:20 PM, Jiří Činčura wrote: I'm almost sure it is it. Could you confirm database have expression index which depends on PSQL function that uses UDR ? As far as I can tell there isn't any such index. Can you share metadata backup? Firebird-Devel mailing list, web interface a

Re: [Firebird-devel] Unhandled exception in Why

On 9/30/21 9:04 PM, Jiří Činčura wrote: Can you share metadata backup? I can, but the build from Vlad works fine, so I think we know what the problem is and what the fix looks like. So probably not needed anymore. Certainly :) Firebird-Devel mailing list, web interface at https://lists.

Re: [Firebird-devel] Pros/cons of stream blobs, and should I use them?

On 10/3/21 2:25 PM, Mark Rotteveel wrote: - New OO API (at least in Firebird 3), not providing an explicit way to create stream blobs (see "[Firebird-devel] IBlob::putSegment" from 27 May 2021) I suppose you mean this phraze: "Last two parameters are required only if you want to use blob fil

Re: [Firebird-devel] Pros/cons of stream blobs, and should I use them?

On 10/5/21 5:49 PM, Mark Rotteveel wrote: No, I was referring to the fact the OO API in Firebird 3 - according to the discussion I referenced - does not provide a way to build BPBs. Exactly. BTW, if needed it's very simple to backport additional Xpb types to FB3. I'm just not sure is it nee

Re: [Firebird-devel] Tablespaces proposal

On 10/6/21 6:32 PM, Roman Simakov wrote: 4. CREATE TABLE … TABLESPACE Given syntax does not let specify tablespace for constraints-related indexes and separate fields. That's serious limitation. At least for blobs that's IMHO needed. Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] Plugins and symlinks

On 10/8/21 4:57 PM, Dimitry Sibiryakov wrote: Hello All.   Currently Firebird is unable to load plugins via symlinks. Is it intentional? Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Tablespaces proposal

On 10/11/21 10:07 PM, Dimitry Sibiryakov wrote: Roman Simakov wrote 11.10.2021 20:23: > Note: *MAIN* - is a name of the basic database file.    Please, use *DEFAULT* for default (main) tablespace at "main" database file.     It is much more consistent with SQL and allows to avoid new

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

On 11/4/21 6:56 PM, Karol Bieniaszewski wrote: „The main reason why this "removal of trailing partial contraction" was done is to achieve behavior "consistent" with search/evaluation in other software (like text editors etc.), so (for example) STARTING WITH "C" or LIKE "C%" will return rows s

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

On 11/5/21 2:36 PM, Pavel Cisar wrote: For example: The key "HROCH" (Czech word for hippopotamus) could have sortkey: 13+27+23+14 (each letter replaced with byte representing it's order place in alphabet, which is simplification for this showcase, i.e. 13=H 27=R 23=O 14=CH) If you would loo

Re: [Firebird-devel] ON DISCONNECT triggers and MON$ATTACHMENTS

On 11/9/21 11:25 AM, Ilya Eremin wrote: Hello! Currently ON DISCONNECT triggers are not called when an attachment is deleted from MON$ATTACHMENTS by another attachment. Is it the correct behavior? On my mind - not. The only case when ON DISCONNECT triggers not to be called is server shutdo

Re: [Firebird-devel] Is it necessary that gbak uses read-write transaction?

On 11/21/21 4:26 PM, Dimitry Sibiryakov wrote: Ivan Přenosil wrote 21.11.2021 14:22: or could it be changed to read-only in FB4?   It is meaningless. Read-write transaction has no differences from read-only until it perform an actual write.   And no, it cannot be "read-only read committed" fo

Re: [Firebird-devel] Is it necessary that gbak uses read-write transaction?

On 11/22/21 2:30 PM, Dimitry Sibiryakov wrote: Ivan Přenosil wrote 22.11.2021 12:21: Thanks for you answers, but you are answering question I did not ask :)   In this case you should ask questions with a little more details. The answer "everything is possible in soft world, it is just a matte

Re: [Firebird-devel] Square brackets in plugin config

On 11/23/21 7:26 PM, Dimitry Sibiryakov wrote: Hello All.   Currently Firebird config file parser accept a string in square brackets and consider it to be a parameter without value.   May I rely on this behavior? square brackets? This one: [ ] ? I do not remember and do not see in a code an

Re: [Firebird-devel] Square brackets in plugin config

On 11/23/21 7:52 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 23.11.2021 17:45: square brackets? This one: [ ] ? I do not remember and do not see in a code any special processing for them.   Yes, there is no special processing of them (so I can use them freely) and

Re: [Firebird-devel] Firebird 5 and Update...Returning

On 11/26/21 5:47 PM, Tony Whyman wrote: On 26/11/2021 14:32, Dmitry Yemanov wrote: 26.11.2021 17:28, Tony Whyman wrote: 1. IAttachment.prepare is used to parse 'Update Employee Set Hire_Date = ? Where EMP_NO = ? Returning LAST_NAME' 2. IStatement.getType is then used to determine the stateme

Re: [Firebird-devel] WNET future

On 11/30/21 19:54, Dimitry Sibiryakov wrote: Leyne, Sean wrote 30.11.2021 17:15: (We have 200+ servers deployed and none of them use (have never) WNET   With dropping this option ability to open database file from mounted network drive also will be dropped (or at least must be heavily rework

Re: [Firebird-devel] Maximum number of HashSlots

On 12/6/21 12:24, Roman Simakov wrote: Hello! Isn't it time to increase the maximum number of HashSlots and make it ULONG instead of USHORT? We can see: Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30 Under heavy load. In FB5? Firebird-Devel mailing list, web interface at h

Re: [Firebird-devel] op_crypt_key_callback during op_connect

On 12/7/21 17:52, Jiří Činčura wrote: Hi, How can I get op_crypt_key_callback during op_connect to test P15 (as I see in protocol.h (https://github.com/FirebirdSQL/firebird/blob/master/src/remote/protocol.h#L86))? My hope was that encrypting security database would do the trick, but even in

<    2   3   4   5   6   7   8   9   >