Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 10:56 AM, Vlad Khorsun wrote: 08.02.2019 9:31, Alex Peshkoff via Firebird-devel wrote: On 2/7/19 6:14 PM, Dimitry Sibiryakov wrote: Hello, All.   I somehow understand why build of current HEAD is failing with message "Could not find acceptable ICU library", but I wonder why it take

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Vlad Khorsun
08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU library ? Suggestions? The fastest way sooner of all will be storing favorite ICU verson (once detected using long p

[Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Jiří Činčura
Hi, is there a way to change the intial value of generator/sequence *without* restarting it? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 8:31, Alex Peshkoff via Firebird-devel wrote: I can't reproduce performance problem: # time (echo 'exit;' | ./isql employee) Statement failed, SQLSTATE = XX000 Could not find acceptable ICU library -Missing entrypoint u_setDataDirectory in ICU library The error you are getting is

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 1:24 PM, Jiří Činčura wrote: Hi, is there a way to change the intial value of generator/sequence *without* restarting it? ALTER SEQUENCE? But please explain what do you mean under 'restart'. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/list

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 10:15, Vlad Khorsun wrote:   Also, we could limit number of ICU versions to check: - exclude really old versions (at least with old X.Y versioning scheme, i.e. 4.8 and older) - adapt search knowing existing versions numbers (see http://site.icu-project.org/download) - guess number o

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 2:01 PM, Dimitry Sibiryakov wrote: 08.02.2019 8:31, Alex Peshkoff via Firebird-devel wrote: I can't reproduce performance problem: # time (echo 'exit;' | ./isql employee) Statement failed, SQLSTATE = XX000 Could not find acceptable ICU library -Missing entrypoint u_setDataDirectory in

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 12:21, Alex Peshkoff via Firebird-devel wrote:   The error you are getting is different, so I would guess that search loop is aborted faster in this case. Is it good idea to provide full error message? (like I did - not to make other guess) Not in this case, but here it is: cre

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 2:24 PM, Dimitry Sibiryakov wrote: 08.02.2019 12:21, Alex Peshkoff via Firebird-devel wrote:   The error you are getting is different, so I would guess that search loop is aborted faster in this case. Is it good idea to provide full error message? (like I did - not to make other gue

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 12:15 PM, Vlad Khorsun wrote: 08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU library ? Suggestions? The fastest way sooner of all will be storing favori

Re: [Firebird-devel] CORE-5997

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 10:04 AM, liviuslivius wrote: Hi Can we discusse about CORE-5997? Why it was so fast closed as its iplementation is so important from performance POV? In mentioned tracker ticket I see: > This is e.g. slow compared to udf equivalent I.e. I assume that this problem is raised due to U

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Vlad Khorsun
08.02.2019 13:29, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 12:15 PM, Vlad Khorsun wrote: 08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU library ? Sugges

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 3:00 PM, Vlad Khorsun wrote: 08.02.2019 13:29, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 12:15 PM, Vlad Khorsun wrote: 08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil::getConversionIC

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Jiří Činčura
> ALTER SEQUENCE? > But please explain what do you mean under 'restart'. Without changing the current value. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 14:01, Jiří Činčura wrote: ALTER SEQUENCE? But please explain what do you mean under 'restart'. Without changing the current value. Try CREATE OR ALTER SEQUENCE. I cannot remember if I ported this improvement from Avalerion to main tree. -- WBR, SD. Firebird-Devel mailing

[Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread marius adrian popa
What type of UUID we use in Firebird ? I guess Version 1 UUIDs in MySQL are really not random https://news.ycombinator.com/item?id=19085189 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 16:44, marius adrian popa wrote: What type of UUID we use in Firebird ? I guess Version 1 Look at text presentation. UUID version is fourth digit in second group IIRC. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/fire

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Paul Reeves
On Fri, 8 Feb 2019 17:44:16 +0200 marius adrian popa wrote: > What type of UUID we use in Firebird ? > I guess Version 1 > > UUIDs in MySQL are really not random > https://news.ycombinator.com/item?id=19085189 But are they meant to be random? I thought the only guarantee was that they are uniq

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Lester Caine
On 08/02/2019 15:55, Paul Reeves wrote: What type of UUID we use in Firebird ? I guess Version 1 UUIDs in MySQL are really not random https://news.ycombinator.com/item?id=19085189 But are they meant to be random? I thought the only guarantee was that they are unique. I seem to remember a dis

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Mark Rotteveel
On 8-2-2019 11:24, Jiří Činčura wrote: Hi, is there a way to change the intial value of generator/sequence *without* restarting it? Based on its name, I would guess this is the task for 'START WITH' clause in: CREATE OR ALTER SEQUENCE START WITH Unfortunately it behaves as ALTER SEQUE

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Mark Rotteveel
On 8-2-2019 16:55, Paul Reeves wrote: On Fri, 8 Feb 2019 17:44:16 +0200 marius adrian popa wrote: What type of UUID we use in Firebird ? I guess Version 1 UUIDs in MySQL are really not random https://news.ycombinator.com/item?id=19085189 But are they meant to be random? I thought the only

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Mark Rotteveel
On 8-2-2019 16:46, Dimitry Sibiryakov wrote: 08.02.2019 16:44, marius adrian popa wrote: What type of UUID we use in Firebird ? I guess Version 1   Look at text presentation. UUID version is fourth digit in second group IIRC. The first digit of the third group indicates the version, which

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Adriano dos Santos Fernandes
On 08/02/2019 09:29, Alex Peshkoff via Firebird-devel wrote: > On 2/8/19 12:15 PM, Vlad Khorsun wrote: >> 08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: >>> On 2/8/19 10:56 AM, Vlad Khorsun wrote: >>   Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU li

[Firebird-devel] ODP: CORE-5997

2019-02-08 Thread Karol Bieniaszewski
>>I.e. I assume that this problem is raised due to UDR deprecation? >>Why not use UDR (written using any language you like) for complex >>strings manipulatons? Not only. Previously there was no possibility to have PSQL functions and udf was the only option. The main reason to change udf is tha

Re: [Firebird-devel] ODP: CORE-5997

2019-02-08 Thread Adriano dos Santos Fernandes
On 08/02/2019 16:10, Karol Bieniaszewski wrote: >   > > I understand that this require implementation time and team resources. > > And as any feature it require future maitenance. > > But without this, speed of string manipulations is not efficient and > database require to have optimized speed in

[Firebird-devel] ODP: ODP: CORE-5997

2019-02-08 Thread Karol Bieniaszewski
>>You ask for wrong thing. Instead of ask for a non standard feature that >>no DBMS made, and that completely changes SQL, you'd better ask for >>optimized PSQL execution. >>PSQL engine has none optimization currently. >>Adriano If this change something in string allocation on every change, than

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Jiří Činčura
> So it doesn't seem that there is any option. Seems so. I just wanted confirmation from CORE guys, I didn't missed something. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 12:29, Alex Peshkoff via Firebird-devel wrote: - adapt search knowing existing versions numbers (see http://site.icu-project.org/download) Yes, this should be efficient. I would limit tried versions to only those which are known to work with Firebird. For example, cut off tho