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 s

Re: [Firebird-devel] Releasing IMessageMetadata

2019-09-17 Thread Jiří Činčura
> Certainly yes. Like with any other reference counted interface returned > by some function. > And it does not depend upon using or not IMetadataBuilder. Thanks. I was just surprised that I'm getting both metadata and IMetadataBuilder in `Plugin::makeFunction`, but the IMetadataBuilder I can ge

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 and ttmat

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 descriptio

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

2019-09-17 Thread Roman Simakov
Exactly. First of all it's interesting to understand an effect of implementation and then we can at least to keep it in mind. вт, 17 сент. 2019 г. в 13:58, Alex Peshkoff via Firebird-devel : > > On 16.09.2019 20:07, Leyne, Sean wrote: > > Roman, > > > >> From: Roman Simakov > >> Sent: Monday, Sep

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

2019-09-17 Thread Simonov Denis via Firebird-devel
Alex Peshkoff via Firebird-devel wrote Tue, 17 Sep 2019 13:42:17 +0300: SQL> select cast(12345678901234567890 as numeric(25, 0)) as n from rdb$database; Statement failed, SQLSTATE = 22003 arithmetic exception, numeric overflow, or string truncation -numeric value is out of range Tha

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

2019-09-17 Thread Simonov Denis via Firebird-devel
Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new type to RDB$TYPES. However, the examples above do not work. -- Simonov Denis Firebird-Devel mailing list, web in

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

2019-09-17 Thread Vlad Khorsun
17.09.2019 16:42, Simonov Denis via Firebird-devel wrote: Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new type to RDB$TYPES. Create new database and it will be t

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

2019-09-17 Thread Simonov Denis via Firebird-devel
Vlad Khorsun wrote Tue, 17 Sep 2019 17:22:10 +0300: 17.09.2019 16:42, Simonov Denis via Firebird-devel wrote: Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new type

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 n

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

2019-09-17 Thread Mark Rotteveel
On 16-9-2019 12:50, Alex Peshkoff via Firebird-devel wrote: 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

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

2019-09-17 Thread Mark Rotteveel
On 16-9-2019 13: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-17 Thread Adriano dos Santos Fernandes
On 16/09/2019 08:21, Alex Peshkoff via Firebird-devel wrote: > 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