Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 16:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely. SET BIND OF DECFLOAT(16) NATIVE; -- work OK But SET BIND OF DECFLOAT(16) TO CHAR; select

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 16:55, Mark Rotteveel wrote: On 08/12/2019 13:12, Alex Peshkoff via Firebird-devel wrote: On 2019-12-07 18:18, Simonov Denis via Firebird-devel wrote: I try snapshot 4.0.0.1683. Basically, the new SET BIND OF statement works as expected. But using a form to return a native type

Re: [Firebird-devel] Documentation of DPB format of SET BIND

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 15:47, Mark Rotteveel wrote: In the documentation of set bind[1], it says: """ Value of clumplet with isc_dpb_set_bind tag in DPB should be specified as a set of partially formed SET BIND statements, i.e. with prefix SET BIND OF is omitted, separated by semicolons. """

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-07 18:18, Simonov Denis via Firebird-devel wrote: I try snapshot 4.0.0.1683. Basically, the new SET BIND OF statement works as expected. But using a form to return a native type does not work. SET BIND OF DECFLOAT (34) TO CHAR (46); - OK SET BIND OF DECFLOAT (34) NATIVE; Can not

Re: [Firebird-devel] IResultSet and IStatement releasing

2019-12-05 Thread Alex Peshkoff via Firebird-devel
On 2019-12-05 13:39, Tony Whyman wrote: IBX's Firebird Pascal API uses the IProvider interface to get an attachment. It uses IAttachment to get a transaction (single database) or IDtc/IDtcStart for a multi-database transaction. Tony, that's absolutely OK for regular API calls. Such

Re: [Firebird-devel] IResultSet and IStatement releasing

2019-12-05 Thread Alex Peshkoff via Firebird-devel
On 2019-12-05 12:01, Jiří Činčura wrote: Maybe better to show some code (simplified). Expecting the free and release to have separate responsibilities I wrote initially (the variables with underscore are class fields). The Execute is called at some point and Free is called either after the

Re: [Firebird-devel] clop and firebird.pas

2019-11-29 Thread Alex Peshkoff via Firebird-devel
On 2019-11-29 14:29, Norbert Saint Georges wrote: Alex Peshkoff via Firebird-devel a écrit : On 2019-11-29 12:57, Norbert Saint Georges wrote: Hello everyone, When compiling sources via the git repository, clop does not create the firebird.pas file on either cent 8 or windows 7 32/64; Why

Re: [Firebird-devel] clop and firebird.pas

2019-11-29 Thread Alex Peshkoff via Firebird-devel
On 2019-11-29 12:57, Norbert Saint Georges wrote: Hello everyone, When compiling sources via the git repository, clop does not create the firebird.pas file on either cent 8 or windows 7 32/64; Why ? :-) Can you send here full build log (i.e. make clean; make >make.log 2>&1) from centos?

Re: [Firebird-devel] MacOS build sometimes hangs

2019-11-28 Thread Alex Peshkoff via Firebird-devel
On 2019-11-28 17:34, Adriano dos Santos Fernandes wrote: On 28/11/2019 05:44, Alex Peshkoff via Firebird-devel wrote: On 2019-11-27 21:37, Adriano dos Santos Fernandes wrote: On 26/11/2019 20:08, Adriano dos Santos Fernandes wrote: Hi! You can see here https://github.com/FirebirdSQL/firebird

Re: [Firebird-devel] MacOS build sometimes hangs

2019-11-28 Thread Alex Peshkoff via Firebird-devel
On 2019-11-28 17:25, Adriano dos Santos Fernandes wrote: g++ in both env. seems just the frontend, using LLVM/clang backend. Is this still problematic and should use clang frontend as well? I think it's not problematic in that case. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] MacOS build sometimes hangs

2019-11-28 Thread Alex Peshkoff via Firebird-devel
On 2019-11-27 21:37, Adriano dos Santos Fernandes wrote: On 26/11/2019 20:08, Adriano dos Santos Fernandes wrote: Hi! You can see here https://github.com/FirebirdSQL/firebird/runs/321529377 that sometimes MacOS build hangs. This is during the build but is when some FB utility is called. I

Re: [Firebird-devel] Interesting WSL 1 bug related to symlinks on Ubuntu vs Windows

2019-11-22 Thread Alex Peshkoff via Firebird-devel
On 2019-11-21 19:07, marius adrian popa wrote: https://github.com/xdenser/node-firebird-libfbclient/issues/84 also with WSL 1 Firebird package can't be installed something related to mmap Could I know exact error message may be I might give some advice. But sooner of all that's something

Re: [Firebird-devel] CHECK_BLOB_FIELD_ACCESS_FOR_SELECT macro

2019-11-18 Thread Alex Peshkoff via Firebird-devel
On 2019-11-16 22:14, Dimitry Sibiryakov wrote: 16.11.2019 19:18, Alex Peshkoff via Firebird-devel wrote: What commit did that change which I can not find?   Your commit: https://github.com/FirebirdSQL/firebird/commit/1ba1af29f0020a4c22b086ae383af22aec76840a What branch?   master branch

Re: [Firebird-devel] CHECK_BLOB_FIELD_ACCESS_FOR_SELECT macro

2019-11-16 Thread Alex Peshkoff via Firebird-devel
On 2019-11-15 22:32, Dimitry Sibiryakov wrote: 15.11.2019 17:58, Alex Peshkoff via Firebird-devel wrote: Not - no ODS change for access check.   But it adds one more member field to blh struct defined in ods.h. What commit did that change which I can not find? What branch? Firebird

Re: [Firebird-devel] CHECK_BLOB_FIELD_ACCESS_FOR_SELECT macro

2019-11-15 Thread Alex Peshkoff via Firebird-devel
On 2019-11-15 19:31, Dimitry Sibiryakov wrote: Hello, All.   Subj really change ODS of databases without changing its version?.. Not - no ODS change for access check. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MacOS build

2019-10-24 Thread Alex Peshkoff via Firebird-devel
On 10/24/19 4:48 PM, Paul Beach wrote: Make sure you use builtin-libtommath Lete me add my 2 words about this. I see no problems with 3d-party tommath, but if one plans to build redistributable universal binaries tomcrypt should better be builtin. By default it's built without any

Re: [Firebird-devel] MacOS build

2019-10-24 Thread Alex Peshkoff via Firebird-devel
On 10/24/19 4:37 PM, Adriano dos Santos Fernandes wrote: Hi! I'm trying to setup github-actions with MacOS build. That's great! Guess what? Errors after errors. Is the master code supposed to build without patches? Sooner of all not, it was never tried. Paul Beach useally starts builds

Re: [Firebird-devel] Replacing zlib with zstd was: Interesting changes in mysql 8.0.18

2019-10-24 Thread Alex Peshkoff via Firebird-devel
On 10/24/19 12:22 PM, Jiří Činčura wrote: One thing to consider is whether "native" (without any interop) implementation is easily available for drivers like Java, .NET, Python, etc. At least as long as that compression method is provided in the box. That's useful but not a showstopper: if

Re: [Firebird-devel] Replacing zlib with zstd was: Interesting changes in mysql 8.0.18

2019-10-24 Thread Alex Peshkoff via Firebird-devel
On 10/24/19 12:58 AM, Leyne, Sean wrote: -Original Message- From: Alex Peshkoff Sent: Wednesday, October 23, 2019 3:38 AM On 10/22/19 6:19 PM, Leyne, Sean wrote: It's faster but that makes no difference for our use cases. When working with LAN passing uncompressed data is anyway the

Re: [Firebird-devel] Replacing zlib with zstd was: Interesting changes in mysql 8.0.18

2019-10-23 Thread Alex Peshkoff via Firebird-devel
On 10/22/19 6:19 PM, Leyne, Sean wrote: It's faster but that makes no difference for our use cases. When working with LAN passing uncompressed data is anyway the best option. Compression makes sense only for very slow and/or very long (many hops) WAN. Under that conditions compression's

Re: [Firebird-devel] Interesting changes in mysql 8.0.18

2019-10-22 Thread Alex Peshkoff via Firebird-devel
On 22.10.2019 10:53, marius adrian popa wrote: And some benchmarks compared to zlib used in firebird https://facebook.github.io/zstd/#benchmarks It's faster but that makes no difference for our use cases. When working with LAN passing uncompressed data is anyway the best option.

Re: [Firebird-devel] File Firebird.pas

2019-10-14 Thread Alex Peshkoff via Firebird-devel
On 10/14/19 1:59 PM, Norbert Saint Georges wrote: Alex Peshkoff via Firebird-devel a écrit : On 10/12/19 5:57 PM, Norbert Saint Georges wrote: Good evening, I find the Firebird.pas file in the B3_0_Release but not in the master, normal? :-) Depends upon _where_ you do not find it. File

Re: [Firebird-devel] File Firebird.pas

2019-10-14 Thread Alex Peshkoff via Firebird-devel
On 10/12/19 5:57 PM, Norbert Saint Georges wrote: Good evening, I find the Firebird.pas file in the B3_0_Release but not in the master, normal? :-) Depends upon _where_ you do not find it. File is generated during the build, i.e. it's missing in git & src tarbell. File should be present

Re: [Firebird-devel] IBlob->getInfo in Firebird.pas

2019-10-09 Thread Alex Peshkoff via Firebird-devel
On 10/9/19 3:19 PM, Norbert Saint Georges wrote: Good morning all, IBlob.getInfo always returns [2,0,0, .] regardless of the requested tags. What is the procedure for knowing the size and number of segments of SQL_Blob with an IBlob? The only known to me sample is in firebird sources,

Re: [Firebird-devel] example 07.blob.cpp

2019-10-08 Thread Alex Peshkoff via Firebird-devel
On 10/8/19 5:27 PM, Norbert Saint Georges wrote: Good morning all, in the example 07.blob.cpp we find the code "// Message for data exchange FB_MESSAGE (Msg, ThrowStatusWrapper, (FB_BLOB, b) ) message (& status, master); " Firebird.pas does not take the definition of FB_Message nor FB_BLOB.

Re: [Firebird-devel] fbclient.dll on Windows 64 bit broken

2019-10-07 Thread Alex Peshkoff via Firebird-devel
On 10/7/19 3:22 PM, Mark Rotteveel wrote: Based on your fix, I found two references for this: - From 2012: https://www.ttmath.org/issue/ttmathuint_x86_64_msvc.asm_uses_esp_instead_of_rsp_causing_general_protection_fault - From 2017, saying it is fixed:

Re: [Firebird-devel] addRef and release

2019-09-20 Thread Alex Peshkoff via Firebird-devel
On 20.09.2019 22:42, Jiří Činčura wrote: Before returning some ref-counted object from a function it's reference count is increased - therefore no need to call addRef() for an object returned by some function. When a pointer is going away (no matter due Just to make sure, by "going away" you

Re: [Firebird-devel] addRef and release

2019-09-20 Thread Alex Peshkoff via Firebird-devel
On 20.09.2019 21:59, Jiří Činčura wrote: Hi *, I'm bit lost in the logic of`addRef` and `release`. So better to ask, than cause some leaks, right? Let's suppose I call `IExternalContext::getAttachment` in a method and assign it to local variable. Do I have to call `addRef` after getting the

Re: [Firebird-devel] TIME WITH TZ

2019-09-20 Thread Alex Peshkoff via Firebird-devel
On 18.09.2019 4:13, Adriano dos Santos Fernandes wrote: In API, but I'm not completely satisfied with solutions as they were done related to above problems. Preferable settings should be done on statement basis, We have a problem with that approach. Cursor may be opened not only using

Re: [Firebird-devel] Underlying format of high precision numerics

2019-09-17 Thread Alex Peshkoff via Firebird-devel
On 17.09.2019 18:05, Simonov Denis via Firebird-devel wrote: I know. I meant that in the freshly created database, the description for RDB$TYPE = 26 is missing. select * from  rdb$types where RDB$FIELD_NAME = 'RDB$FIELD_TYPE' I understand that there should be RDB$TYPE_NAME = INT128 Added

Re: [Firebird-devel] Power efficient userspace waiting with the umwait x86 instructions

2019-09-17 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 20:07, Leyne, Sean wrote: Roman, From: Roman Simakov Sent: Monday, September 16, 2019 7:51 AM I guess it would be interesting alternative for spinlock (https://kernelnewbies.org/Linux_5.3) 1.6. Power efficient userspace waiting with the umwait x86 instructions More

Re: [Firebird-devel] Underlying format of high precision numerics

2019-09-17 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 23:17, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Fri, 21 Jun 2019 16:53:26 +0300: I've compared various possible implementations of high precision numeric. Except existing in fb4 (decfloat based) were checked native gcc's __int128

Re: [Firebird-devel] Releasing IMessageMetadata

2019-09-17 Thread Alex Peshkoff via Firebird-devel
On 17.09.2019 8:07, Jiří Činčura wrote: Hi, in `Plugin::makeFunction` I'm calling `getOutputMetadata` on `IRoutineMetadata` to get `IMessageMetadata` and then using `IMetadataBuilder` to redefine some parameters (char -> varchar, etc.). I'm using `IMetadataBuilder::getMetadata`. I suppose I

Re: [Firebird-devel] TIME WITH TZ

2019-09-16 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 14:02, Adriano dos Santos Fernandes wrote: There should be a way to client request additional data (tz offset, tz region as string, string length) to be returned together with the data. A general solution, not a wrong specific/incomplete solution. OK, that's not bad. But on what

Re: [Firebird-devel] Describing server types on client side

2019-09-16 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 14:05, Dimitry Sibiryakov wrote: 16.09.2019 12:50, Alex Peshkoff via Firebird-devel wrote: It was very good (but left unnoticed suggestion) from Dimitry Sibiryakov: add single SQL statement to tune automatic datatypes coercion. I agree with this suggestion and suggest to drop all

Re: [Firebird-devel] TIME WITH TZ

2019-09-16 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 14:03, Mark Rotteveel wrote: On 2019-09-16 12:51, Alex Peshkoff via Firebird-devel wrote: With ALTER SESSION DESCRIBE STATEMENT a number of problems with extended timestamp format will be gone automatically. But one of key problems remains - what can client do with timezone code

Re: [Firebird-devel] Describing server types on client side

2019-09-16 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 13:50, Alex Peshkoff via Firebird-devel wrote:     Example -  after ALTER SESSION DESCRIBE DECFLOAT AS CHAR char() wll be used for decfloat(16) and char() for decfloat(34). Sorry for missed numbers: ALTER SESSION DESCRIBE DECFLOAT AS CHAR char(23) wll be used for decfloat(16

Re: [Firebird-devel] TIME WITH TZ

2019-09-16 Thread Alex Peshkoff via Firebird-devel
With ALTER SESSION DESCRIBE STATEMENT a number of problems with extended timestamp format will be gone automatically. But one of key problems remains - what can client do with timezone code when it does not know conversion rule for it. A nice solutipn was already suggested by Vlad - extend

[Firebird-devel] Describing server types on client side

2019-09-16 Thread Alex Peshkoff via Firebird-devel
In FB4 there was added a number of new datatypes (and will be added 128-bit integers). For all of them separate SET statement is added to make it possible to bind them with some old, well known to old clients datatype. Also DPB item is added to control initial state of this feature. It was

Re: [Firebird-devel] IDE or code editor on Linux

2019-09-15 Thread Alex Peshkoff via Firebird-devel
What would you recommend for editing Firebird sources on Linux? I use midnight commander but not to say I recommend it to others - it's just a matter of old habit. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Handling FbException

2019-09-11 Thread Alex Peshkoff via Firebird-devel
On 11.09.2019 16:19, Dimitry Sibiryakov wrote: 11.09.2019 15:05, Alex Peshkoff via Firebird-devel wrote: One more related idea - return text in firebird-allocated buffer which is later released by explicit cliens call. The main visible disadvantage is possible deadlock when error is OOM

Re: [Firebird-devel] Handling FbException

2019-09-11 Thread Alex Peshkoff via Firebird-devel
On 11.09.2019 12:59, Dimitry Sibiryakov wrote: 11.09.2019 9:13, Alex Peshkoff via Firebird-devel wrote: No other method - but if you have reasonable suggestion we will be happy to implement it. Just an idea - language details are not needed.   How about an iterator on error lines? It could

Re: [Firebird-devel] Handling FbException

2019-09-11 Thread Alex Peshkoff via Firebird-devel
On 11.09.2019 16:07, Jiří Činčura wrote: No - at least in advance. What can be done is request to calculate it. Is that in API today? No. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Handling FbException

2019-09-11 Thread Alex Peshkoff via Firebird-devel
On 11.09.2019 11:32, Jiří Činčura wrote: No other method - but if you have reasonable suggestion we will be happy to implement it. Just an idea - language details are not needed. Is the size of the message known? No - at least in advance. What can be done is request to calculate it. That

Re: [Firebird-devel] Plan formatting

2019-09-11 Thread Alex Peshkoff via Firebird-devel
On 11.09.2019 10:56, liviuslivius wrote: 2. This interface change is allowed or not. Not Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Handling FbException

2019-09-11 Thread Alex Peshkoff via Firebird-devel
On 10.09.2019 18:32, Jiří Činčura wrote: Hi *, every example I've found uses this structure: catch (const FbException& error) { char buf[256]; utl->formatStatus(buf, sizeof(buf), error.getStatus()); // ... } Is is guaranteed that the 256 buffer is enough? Not - though given buffer

Re: [Firebird-devel] "set decfloat bind double precision" and others

2019-09-10 Thread Alex Peshkoff via Firebird-devel
On 10.09.2019 14:35, liviuslivius wrote: The SQL standard defines a number of session management statements that all start with SET: That's funny but a number of session management statements begin not with SET but with ALTER SESSION. SQL standard is not too careful in this aspect.

Re: [Firebird-devel] Inserts and FKs

2019-09-06 Thread Alex Peshkoff via Firebird-devel
On 06.09.2019 15:09, Carlos H. Cantu wrote: APvFd> Certainly you can repeat search for master record in trigger but IMHO APvFd> that's not beautiful solution. Not sure if I understand what you mean with "repeat search for master record". if (exists (select * from master where )) i.e.

Re: [Firebird-devel] Inserts and FKs

2019-09-06 Thread Alex Peshkoff via Firebird-devel
On 06.09.2019 14:14, Carlos H. Cantu wrote: Re: [Firebird-devel] Inserts and FKs Hi "tx2 inserts a detail record in TableB     Trigger on TableB tries to update master record,     since the record is still not visible for this snapshot,     update has null effect" I do not understand

Re: [Firebird-devel] op_crypt case sensitivity on Linux

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 18:11, Mark Rotteveel wrote: On 5-9-2019 13:53, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive,

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 17:25, Adriano dos Santos Fernandes wrote: On 05/09/2019 10:59, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: Looks like finally you agreed that return a different tz value is like dropping a different database because engine

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: Looks like finally you agreed that return a different tz value is like dropping a different database because engine could not drop the asked one, and no workaround should be inserted replacing region codes by wrong offsets. Why are you

Re: [Firebird-devel] op_crypt case sensitivity on Linux

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows builds are not. Is this expected behavior? Yes for Arc4 (plugins' names are derived from filenames), no for Symmetric (may be side

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 12:04, Lester Caine wrote: On 05/09/2019 08:52, Alex Peshkoff via Firebird-devel wrote:    Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 5:28, Adriano dos Santos Fernandes wrote: On 04/09/2019 06:39, Vlad Khorsun wrote:   Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases ? Looks like

Re: [Firebird-devel] TIME WITH TZ

2019-09-03 Thread Alex Peshkoff via Firebird-devel
On 03.09.2019 9:29, Vlad Khorsun wrote: 03.09.2019 4:20, Adriano dos Santos Fernandes wrote: On 02/09/2019 08:06, Alex Peshkoff via Firebird-devel wrote: ICU library often missing on windows client. No, it's not, the C/C++ runtime causes much more problem in Windows than ICU.   It is very

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 14:30, Dimitry Sibiryakov wrote: 02.09.2019 13:27, Alex Peshkoff via Firebird-devel wrote: May be OK for future versions.   ..."but now we are going to make a quick hack". Ok, ok.   Don't forget to make this hack for boolean datatype as well: those applications that

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 14:22, Dimitry Sibiryakov wrote: 02.09.2019 13:16, Alex Peshkoff via Firebird-devel wrote: How to make server always use offset (not timezone code) in selected TS with TZ using coersion?   Usual way for data coercion: application just set desired data type in metadata during

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:42, Dimitry Sibiryakov wrote: 02.09.2019 12:26, Alex Peshkoff via Firebird-devel wrote: When first pool-enabled classes were added to firebird ~15 years ago allocators were absolutely unable to peresent firebird pools.   Pools were implemented that time because standard

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 14:12, Dimitry Sibiryakov wrote: 02.09.2019 13:06, Alex Peshkoff via Firebird-devel wrote: Suggested approach makes it possible to tune server to return data in a form required by partcular client.   And (just in case) I repeat: suggested approach duplicate data coercion

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:53, Mark Rotteveel wrote: On 2-9-2019 11:35, Alex Peshkoff via Firebird-devel wrote: On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:21, Dimitry Sibiryakov wrote: 02.09.2019 12:15, Alex Peshkoff via Firebird-devel wrote: Don't gorget - 'classic' smart pointers, containers, etc. do NOT work when object is deleted by pool.   That's why object in pool must never use non-pooled child object. Adriano must use

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:10, Dimitry Sibiryakov wrote: 02.09.2019 12:06, Alex Peshkoff via Firebird-devel wrote: Certainly it's much, much better to define rules of object deletion at construction time than to delete something explicitly (here and there) when object is going to be destroyed

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 30.08.2019 19:20, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:56, Dmitry Yemanov wrote: 27.08.2019 3:59, Adriano dos Santos Fernandes wrote: Sometimes a object managed by memory-pool may embed non-pooled memory or other resources. If the main object is not explicitly destroyed,

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe the problem you think this solves, and how your proposal solves it?   Hmm... the first paragraph at

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 11:17, Vlad Khorsun wrote: 30.08.2019 19:15, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote: 1. Let's use SQL subtype in order to represent in the message UTC or regional time, i.e. for time with time zone 2 subtypes will make

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 31.08.2019 12:41, liviuslivius wrote: >>About tools: isql supports all newer features Who use isql, really? I do. :) I suppose only to confirm some bug. I cannot imagine that someone use it by typing directly commands inside or looking at textual output if gui tools have grids,

Re: [Firebird-devel] TIME WITH TZ

2019-08-30 Thread Alex Peshkoff via Firebird-devel
On 30.08.2019 16:12, Dimitry Sibiryakov wrote: 30.08.2019 15:10, Alex Peshkoff via Firebird-devel wrote: why use new datatype at all?   That's a very good question. You took my words out of context... For some applications that makes sense. Firebird-Devel mailing list, web interface

Re: [Firebird-devel] TIME WITH TZ

2019-08-30 Thread Alex Peshkoff via Firebird-devel
On 30.08.2019 15:46, Dimitry Sibiryakov wrote: 30.08.2019 14:29, Dmitry Yemanov wrote:    Which sqltype value is provided by isc_dsql_prepare/describe_bind is irrelevant as long as application can override it. But 99.9% existing (at the moment) applications cannot override unknown for them

[Firebird-devel] TIME WITH TZ

2019-08-30 Thread Alex Peshkoff via Firebird-devel
Hi all! From discussion in a thread "Could not find acceptable ICUlibrary​" it's getting clear that we can not satisfy all requirements to time with timezone fields (when exchanging client/server messages) in single format because they (requirements) are too contradictory. Suggested solution

Re: [Firebird-devel] Linking re2 and libstdc++ in Linux

2019-08-27 Thread Alex Peshkoff via Firebird-devel
On 26.08.2019 18:25, Adriano dos Santos Fernandes wrote: You noted situation above and I could give more reasons: - re2 has it interface in C++, i.e., there is not C wrapper function receiving C objects like ICU, so when we use shared re2, we'll using libstdc++ in our code, and it could be

Re: [Firebird-devel] Linking re2 and libstdc++ in Linux

2019-08-26 Thread Alex Peshkoff via Firebird-devel
On 22.08.2019 19:22, Adriano dos Santos Fernandes wrote: On 22/08/2019 06:20, peshkoff--- via Firebird-devel wrote: Before making a choice i want to know why only optimized build is affected. Pay attention - delete is redefined in it too. Why that behavior difference? Alex, my understand is

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 12:48, Jiří Činčura wrote: I see 2 reasons for your last words - you do not catch difference between UTF8 and Unicode, or I completely misunderstand what do you want to say here... Yeah, sorry about that. I was writing the question with assumption that the server will take the

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 12:41, Dimitry Sibiryakov wrote: 06.08.2019 11:36, Alex Peshkoff via Firebird-devel wrote: Why are filenames on windows converted to ANSI, not Unicode? Do not know...   Because Unicode patch was rejected and someone said "we will do it some day in our own way". Can re

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 12:26, Jiří Činčura wrote: Sooner of all that means that there is UTF8 character which can not be represebted by ANSI codepage on the server. Why it would be converted to ANSI on server? I live(d) years under the impression that the isc_dpb_utf8_filename (and SPB) tells server to

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 11:12, Jiří Činčura wrote: And one more question - what happens if you try to access that database using isql? isql freezes (after sending the "connect" statement). But looks like it's a parsing error, because first Ctrl-C gives "CON>" and second "Expected end of statement,

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 05.08.2019 14:26, Jiří Činčura wrote: Hi *, I'm trying to send SPB with И (U+0418) in isc_spb_dbname, but Firebird is comply to do so with "PATH NOT FOUND". With isc_spb_utf8_filename I see firebird process to accessing access img1.png, without it img2.png. Checking the byte array I'm

Re: [Firebird-devel] Changing FLOAT to a SQL standard compliant FLOAT datatype

2019-07-22 Thread Alex Peshkoff via Firebird-devel
On 20.07.2019 10:54, Mark Rotteveel wrote: Anyone? Single question - does it add more conflicts to grammar? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Win_Sspi and wire encryption

2019-07-16 Thread Alex Peshkoff via Firebird-devel
On 16.07.2019 10:06, Jiří Činčura wrote: Since 3.0.5 - yes. There is one detail - we use MS API function to obtain session key. And it's documented that it provides high quality key only if kerberos is used. Is there a related item in the tracker? CORE-5948 Any chance you know the function

Re: [Firebird-devel] Win_Sspi and wire encryption

2019-07-16 Thread Alex Peshkoff via Firebird-devel
On 16.07.2019 9:51, Jiří Činčura wrote: Hi, can the Win_Sspi auth be somehow used with wire encryption (CNCT_client_crypt)? Since 3.0.5 - yes. There is one detail - we use MS API function to obtain session key. And it's documented that it provides high quality key only if kerberos is used.

Re: [Firebird-devel] Compression and encryption

2019-07-15 Thread Alex Peshkoff via Firebird-devel
On 15.07.2019 13:27, Jiří Činčura wrote: Hi *, is the compression done before the encryption or after (over the wire data)? Certainly compression is done before encryption. Encrypted data can not be compressed. At least with more or less serious encryption :) Firebird-Devel mailing

Re: [Firebird-devel] Underlying format of high precision numerics

2019-07-08 Thread Alex Peshkoff via Firebird-devel
On 06.07.2019 12:03, Mark Rotteveel wrote: This discussion seems to have halted without a conclusion. What is going to happen? Will extended precision numerics change to use an int128 Yes. (and maybe extend maximum precision to 38)? May be. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] System package for blob manipulation in PSQL

2019-06-27 Thread Alex Peshkoff via Firebird-devel
On 27.06.2019 19:48, Mark Rotteveel wrote: P.S. These are use cases where UDF-like functionality is required -- how else would someone provide this functionality?  (I don't see UDRs supporting this) If you think a UDF can do it, why do you think a UDR wouldn't be able to do it? UDRs can do

Re: [Firebird-devel] Underlying format of high precision numerics

2019-06-26 Thread Alex Peshkoff via Firebird-devel
On 26.06.2019 11:48, Dimitry Sibiryakov wrote: 26.06.2019 8:46, Simonov Denis via Firebird-devel wrote: the DECFLOAT type is defined in the SQL:2016 standard as a separate type, so you don’t need to remove anything. We are talking only about the implementation of NUMERIC (19+, x) and DECIMAL

Re: [Firebird-devel] Underlying format of high precision numerics

2019-06-24 Thread Alex Peshkoff via Firebird-devel
On 22.06.2019 13:10, Dimitry Sibiryakov wrote: 21.06.2019 15:53, Alex Peshkoff via Firebird-devel wrote: internal binary layout of 128-bit integer is the same for __int128 on x64 (on x86 unsupported), ttmath's 128-bit class on x64 and ttmath on x86.   128 bits integers are supported on x86

Re: [Firebird-devel] Underlying format of high precision numerics

2019-06-21 Thread Alex Peshkoff via Firebird-devel
On 21.06.2019 18:15, Mark Rotteveel wrote: Is this about the format used in Firebird internally, or are you also proposing to change the format used in the protocol? Both. Mark On 21-6-2019 15:53, Alex Peshkoff via Firebird-devel wrote: I've compared various possible implementations

[Firebird-devel] Underlying format of high precision numerics

2019-06-21 Thread Alex Peshkoff via Firebird-devel
I've compared various possible implementations of high precision numeric. Except existing in fb4 (decfloat based) were checked native gcc's __int128 and ttmath (fixed high precision library with pure .h implementation). Test performed a mix of sum/mult/div operations in a loop. Native code was

Re: [Firebird-devel] UDR vs PSQL

2019-06-20 Thread Alex Peshkoff via Firebird-devel
On 20.06.2019 16:07, Leyne, Sean wrote: Calling UDF is hard process. We must emulate C call stack therefore parameters are multiple times copied here and there, making CSTRING from CHAR / VARCHAR is also headache - there is no place for terminating zero in the end of that string, therefore

Re: [Firebird-devel] UDR vs PSQL

2019-06-20 Thread Alex Peshkoff via Firebird-devel
On 19.06.2019 19:49, Paul Reeves wrote: I have never compared load and call times for UDFs and SPs, but I have always assumed that a UDF will load and execute more quickly than a SP. Calling UDF is hard process. We must emulate C call stack therefore parameters are multiple times copied

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-19 Thread Alex Peshkoff via Firebird-devel
On 14.06.2019 19:41, Gabor Boros wrote: 2019. 06. 14. 15:16 keltezéssel, Alex Peshkoff via Firebird-devel írta: What do ldd isql (in appropriate bin dirs)    and ldd /usr/lib64/libfbclient.so show in both cases? Gabor, please also send me output (rather long - redir to file) of   ldconfig

Re: [Firebird-devel] UDR vs PSQL

2019-06-17 Thread Alex Peshkoff via Firebird-devel
On 17.06.2019 11:23, Jiří Činčura wrote: Hi, what performance could one accept between UDR and PSQL? I see that UDR is about 30%-40% slower on my machine (just plain execution - empty UDR vs empty PSQL). Does that align with team's measurements? I'm not saying it's bad or slow. I'm just

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-14 Thread Alex Peshkoff via Firebird-devel
On 14.06.2019 9:00, Gabor Boros wrote: 2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: a, is there a findable symlink from libfbclient.so.2 to the real name of libfbclient (probably libfbclient.so.3.0.5) b, is the installer creating it? Output of "find / -name "libfbclient*" -type l -ls"

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-14 Thread Alex Peshkoff via Firebird-devel
On 14.06.2019 12:37, Gabor Boros wrote: 2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: b, is the installer creating it? I see some difference between the two install.sh files. The trivial /opt/firebird vs /usr/local/firebird and two times "if [ "yes" = "yes" ]" vs "if [ "no" = "yes" ]".

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Alex Peshkoff via Firebird-devel
On 13.06.2019 12:43, Vlad Khorsun wrote: First, you loose things. The adjusted (displayable) timestamp is not convertible back for duplicated timestamps (DST end).   Not sure i got you. Could you provide an example ? At 03:00:00 due to DST change time is set to 02:00:00. To what UTC

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-13 Thread Alex Peshkoff via Firebird-devel
On 12.06.2019 19:57, Adriano dos Santos Fernandes wrote: On 12/06/2019 13:33, Gabor Boros wrote: Hi All, I try to make and test "my own" build with Debian 10. First with default settings, just execute "autogen.sh", "make" and "make install" without any modification. At the last step I got the

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-13 Thread Alex Peshkoff via Firebird-devel
On 11.06.2019 17:14, Vlad Khorsun wrote: So users don't want messages => don't need .msg file. Users want message but don't want .msg file => it will not have messages.   This is not true. fbclient contains all error messages engine could produce. It have just some messages of utilities,

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-11 Thread Alex Peshkoff via Firebird-devel
On 11.06.2019 14:47, Adriano dos Santos Fernandes wrote: On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote: What you mean by install? Copy one .dll + .msg file is not install. Copy more than one .dll + .msg file is install? Adriano, users prefer to copy just one .dll (in many cases

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-11 Thread Alex Peshkoff via Firebird-devel
On 11.06.2019 14:23, Adriano dos Santos Fernandes wrote: On 11/06/2019 07:57, Vlad Khorsun wrote: 11.06.2019 13:34, Adriano dos Santos Fernandes wrote: On 11/06/2019 03:56, Vlad Khorsun wrote: 11.06.2019 2:15, Adriano dos Santos Fernandes wrote: On 10/06/2019 19:41, Vlad Khorsun wrote: ...

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-11 Thread Alex Peshkoff via Firebird-devel
On 11.06.2019 1:41, Vlad Khorsun wrote: Do this 2 facts - client have some ICU library, but it can't convert region ID obtained from   server (because of different ICU version), or even - wrong conversion of region ID at client side because of mismatched ICU   version (sounds impossible, but

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-11 Thread Alex Peshkoff via Firebird-devel
On 11.06.2019 2:15, Adriano dos Santos Fernandes wrote: On 10/06/2019 19:41, Vlad Khorsun wrote: ... Vlad, first of all, please say me what's the difference with Linux fbclient that has libtommath as dependency since v3. I suppose main difference is that linux pure-client installation is

<    1   2   3   4   5   6   7   8   9   >