Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue

2018-08-09 Thread livius
Did you try to fetch numerics using isql? i do not know how to run isql on Android Can you attach from your application to remote host? If yes what does happen with numerics in that case? I have tried without success. i have tried by TCP/IP over USB and also by WIFI. I always got "unavaiable

Re: [Firebird-devel] CORE-5877 Garbage in the compound index after several updates

2018-07-20 Thread livius
Not exactly so. When index key is not changed by UPDATE statement, engine doesn't add it into the index. Ok, so it has not changed. tx1: insert record (r1) with index key (k1) >> table contains one record version: r1-tx1 >> index contains one entry: (k2, r1) tx1: commit tx2:

Re: [Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread livius
Hi, thank you for the link. If i understand correctly then all functions "CURRENT_..." and "LOCAL_..." result are in session TZ? If yes, then now it is much clearer, I thought that "CURRENT_" state for server time zone retrieved from e.g. system and "LOCAL_" was for database timezone or

[Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread livius
Hi, moved from support list as requested by Mark Rotteveel question about timezone support in FB4. How “current” timezone is configurred? Is it retrived from system or from Firebird config? I suppose that both configuration should be possible it will be more flexible. We then can have multiple

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

2018-06-19 Thread livius
There is no need for a new error, but a consistent error scheme should be applied, as already exists. this is what i wanted to say. By "new" - i have thinked, change for old as was chosen for new "big" numerics. BTW: Firebird 4 is not a point release, it is a major release. A point release

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

2018-06-19 Thread livius
Hi, it is better to change all already errors to new one in new point release as FB4 is. As Mark say already, it should be not visible to the user that there is some difference between Numeric(18,2) and numeric(34,34)... All numerics should have same error messages. regards, Karol

[Firebird-devel] Tracker

2018-06-11 Thread livius
Hi, will be good if tracker and any FB page do not show server details when it is off now it show something like this: “ Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread livius
Hi, by the same i mean ALTER ROLE EXISTING SET SYSTEM PRIVILEGES TO MONITOR_ANY_STATMENTS? or granting MONITOR_ANY_ATTACHMENT affect any MON$ tables? I need to have possibility to grant select on all attachemnts but i do not want that such user see all statements content. regards, Karol

[Firebird-devel] Fw: [firebird-support] Re: Mapping Windows group to FB role is not implemented?

2018-03-27 Thread livius
regards, Karol Bieniaszewski From: 'livius' liviusliv...@poczta.onet.pl [firebird-support] Sent: Tuesday, March 27, 2018 8:05 PM To: firebird-supp...@yahoogroups.com Subject: [firebird-support] Re: Mapping Windows group to FB role Hi, anybody can help with - point 4? 1. enable windows

Re: [Firebird-devel] RETURNING clause returning NULL row when no value was updated

2017-11-29 Thread livius
I must say that i thinked about this in the same way as you. And i also do not know from where i got this impression ... I really supposed that it return resultset regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Jiří Činčura Sent: Wednesday, November 29, 2017 1:32 PM To:

[Firebird-devel] CORE-5634

2017-10-28 Thread livius
Hi, i know that http://tracker.firebirdsql.org/browse/CORE-5634 is closed but it should be? Alexander Peshkov say there: “So yes, case is correctly always changed to upper case. “" but this is not true because attributes are not upper case only are Gid, Uid – as you can see it is not upper

Re: [Firebird-devel] [SPAM] Re: Build sources

2017-10-13 Thread livius
Hi, thank you all for the answer and really detailed answer from you Vlad. I have finally successfully build it by VS 2015 Community Edition :) regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Vlad Khorsun via Firebird-devel Sent: Friday, October 13, 2017 2:19 PM To:

Re: [Firebird-devel] FB4 fetches

2017-09-19 Thread livius
Karol, I just can confirm that message reached the group. But right now have no time to deal with fetches problem, sorry. Thank you for response, i understand that not all requests can be processed and analyzed immediately and such answer that team is busy is enough regards, Karol

Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing

2017-08-25 Thread livius
Thank you for the answer great news :) regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Dmitry Yemanov Sent: Friday, August 25, 2017 6:09 AM To: For discussion among Firebird Developers ; livius Subject: Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available

Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing

2017-08-24 Thread livius
Hi, first i must thank you for great work :) I really wait for frame in window funcion, longer indentifiers and bigger database page size. And i test this intensively. However i see that context limit is "the same" for the single query Is this really plan for Firebird4 or it is postponed?

Re: [Firebird-devel] Start transaction from base transaction

2017-05-10 Thread livius
Maybe "Starting from"? regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Leyne, Sean Sent: Tuesday, May 9, 2017 9:20 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] Start transaction from base transaction > >>> + | SNAPSHOT SHARING FROM > >>

Re: [Firebird-devel] Start transaction from base transaction

2017-05-06 Thread livius
inalna wiadomość- From: Vlad Khorsun Sent: Saturday, May 6, 2017 11:55 AM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] Start transaction from base transaction 06.05.2017 11:47, livius wrote: > Hi, > > for me name is confusing - beacause here can be two cases

Re: [Firebird-devel] Start transaction from base transaction

2017-05-06 Thread livius
Hi, for me name is confusing - beacause here can be two cases: 1. Snapshot transaction is shared 2. only view of database from its start point is shared and any modification caused by base snapshot and any sharing transaction is not shared between transactions. Name must specify real maining.