Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Alex Peshkoff via Firebird-devel
On 02/02/18 22:19, Dimitry Sibiryakov wrote: 02.02.2018 20:03, Mark Rotteveel wrote: I have the feeling I'm missing part of the discussion here   Thunderbird used to reply to author of message directly instead of sending reply to list. It can be changed in settings. That's my fault - two

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-02 Thread Alex Peshkoff via Firebird-devel
On 02/02/18 10:57, Dmitry Yemanov wrote: 01.02.2018 20:24, Mark Rotteveel wrote: Point taken, but my suggestion was more that we now don't utilize the Decimal128 to its fullest for decimal, and users of the direct API now need to handle decfloat and decimal(19+, x) in a very different manner

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-01 Thread Alex Peshkoff via Firebird-devel
On 02/01/18 15:31, Mark Rotteveel wrote: On 29-1-2018 10:45, Alex Peshkoff via Firebird-devel wrote: May be taken standalone your suggestion is simpler but in conjunction with existing logic for numerics based on bigint and smaller integer values and need to cast between them use of existing

Re: [Firebird-devel] Unknown tag value - missing in the list of possible

2018-01-30 Thread Alex Peshkoff via Firebird-devel
On 01/29/18 21:26, paul reeves wrote: While debugging a an api call I got the error message in which obviously means I need to check the dpb in this case but I'm intrigued about this error message... What is it actually trying to say? - Is it just saying the same thing twice - because the tag

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-01-29 Thread Alex Peshkoff via Firebird-devel
On 01/27/18 20:18, Mark Rotteveel wrote: I'm implementing the new precision 34 decimal/numeric support in Jaybird, and I notice that the underlying Decimal128 is used as just an integer container, instead of already applying an appropriate exponent for the scale. This was a bit of a surprise to

Re: [Firebird-devel] Database restore problem with 3.0(.3.32882)

2018-01-20 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 22:18, Gabor Boros wrote: 2018. 01. 18. 17:50 keltezéssel, Alex Peshkoff via Firebird-devel írta: Sorry -  did not reproduce, restore log for: ./gbak -v -c BSP2018_20180118_121408.fbk /mnt/db/BSP2018_20180118_121408.FDB >log I use "gbak -v -c -user BSPOWNER BSP2018.

Re: [Firebird-devel] SKD_time / SKD_timestamp

2018-01-19 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 18:20, Adriano dos Santos Fernandes wrote: Hi! In little endian version of Sort::diddleKey:         case SKD_timestamp:         case SKD_sql_time:         case SKD_sql_date:             p[3] ^= 1 << 7;             break; How can this be correct for time or timestamp? As a tim

Re: [Firebird-devel] Firebird 3 and ICU

2018-01-19 Thread Alex Peshkoff via Firebird-devel
On 01/19/18 14:03, Roman Simakov wrote: 2018-01-19 12:54 GMT+03:00 Vlad Khorsun via Firebird-devel : 19.01.2018 11:41, Adriano dos Santos Fernandes wrote: On 19/01/2018 07:14, Roman Simakov wrote: it search for ICU library using versions numbers such as 5.19 ... 5.0, 4.19 ... 4.0 etc. But,

Re: [Firebird-devel] Database restore problem with 3.0(.3.32882)

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 16:01, Gabor Boros wrote: 2018. 01. 18. 13:41 keltezéssel, Alex Peshkoff via Firebird-devel írta: Send them to me please. Done. Sorry -  did not reproduce, restore log for: ./gbak -v -c BSP2018_20180118_121408.fbk /mnt/db/BSP2018_20180118_121408.FDB >log is attached.

Re: [Firebird-devel] Weird date/time literals

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 16:28, liviuslivius wrote: Hi, I see only one usage case. To know when proc eas compiled. But i do not know if this can be usefull. I do not know how this is documented, but if as warning than it can be changed without problem. And as Adriano this looks more like bug then feature

Re: [Firebird-devel] Database restore problem with 3.0(.3.32882)

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 15:17, Gabor Boros wrote: Hi All, I have a very minimal database, just created it and added some SQL users into it. After execute the script which create tables, etc. make a backup with gbak. At restore the below error message appears. I found an issue on the tracker which have sa

Re: [Firebird-devel] Error compiling FB for android

2018-01-18 Thread Alex Peshkoff via Firebird-devel
On 01/18/18 12:47, Jorge Gonçalves wrote: Hi, I want to make some tests with FB embedded on android, and I'm getting the follow error compiling the source. /home/jgoncalves/dev/android/android-ndk-r16b/toolchains/arm-linux-androideabi-4.9/prebuilt/linux-x86_64/bin/arm-linux-androideabi-g

Re: [Firebird-devel] Firebird 4 snapshots missing employee example DB

2018-01-06 Thread Alex Peshkoff via Firebird-devel
On 01/06/18 18:15, Mark Rotteveel wrote: The employee database is missing from the Firebird 4 snapshot builds (at least on Windows). Is this a known problem? FYI - present on linux. -- Check out the vibrant tech co

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-12 Thread Alex Peshkoff via Firebird-devel
On 12/12/17 17:57, Adriano dos Santos Fernandes wrote: Oracle also mentions inconsistency that may happen when the time zone database is updated. If user had previously entered a time in a moment that subsequently has updated by the time zone db, it may become inconsistent. So it should be update

Re: [Firebird-devel] Present state of cmake build system

2017-12-07 Thread Alex Peshkoff via Firebird-devel
On 12/03/17 20:16, William L. Thomson Jr. wrote: In a case of regular linux build of FB that sources from extern are not used. One can build with builtin libtom* but this is not recommended way to go. A lot of how Firebird on Gentoo has always been against the recommended way. Gentoo has its ow

Re: [Firebird-devel] Double in clumplets

2017-12-06 Thread Alex Peshkoff via Firebird-devel
On 12/06/17 00:04, Dimitry Sibiryakov wrote: Hello, All.   Can someone explain why double in clumplets is handled as two LONGs, instead of single INT64? Sooner of all due to historical reasons - see xdr_double. And compare it in master and FB1.0. --

Re: [Firebird-devel] Present state of cmake build system

2017-12-03 Thread Alex Peshkoff via Firebird-devel
On 12/02/17 22:05, William L. Thomson Jr. wrote: Initial feedback, per another post of mine. I am looking to separate out the stuff in extern and package that on its own. I already had btyacc and libtommath. I packaged libtomcrypt. I think the system btyacc no longer works as its from upstream an

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-29 Thread Alex Peshkoff via Firebird-devel
On 11/29/17 10:57, Jiří Činčura wrote: OK, the Firebird-4.0.0.816-0_Win32 behaves correctly. Will this go into 3.0.3 as well? As you can already see it's fixed in FB3 branch too. -- Check out the vibrant tech commun

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Alex Peshkoff via Firebird-devel
On 11/28/17 17:03, Jiří Činčura wrote: Jiří, can you try with this patch? I'm 99% sure it will help you to but if you can check it will be great. Can you maybe commit it to some branch/master and I'll get the fresh build from CI/nightly when it's done? I'm currently not in front of a computer wi

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 20:39, Jiří Činčura wrote: I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned Great to know, you found it. Jiří, can you try with this patch? I'm 99% sure it will help you to but if you ca

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned up. BTW, for me it's reproduced each time I logoff/logon

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 18:08, Jiří Činčura wrote: What is the size of compressed database backup? 52 264 210 bytes, why? Will not fit into email (32M limit on mail.ru), please put it to some reasonable share. -- Check out t

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? AES128 plugin also works fine for me: localhost bin # localhost bin # ./isql e1.fdb Database: e1.fdb, User: SYSDBA SQL> alter database encrypt with AES128; SQL> insert into country values('Russia', 'Ru

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:55, Jiří Činčura wrote: To be precise - it's IBSurgeon plugin. Hmm. Of course, could be. Wondering why it fails only on this database? Even more. Test table on this database works fine. What is the size of compressed database backup? --

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:43, Alex Peshkoff via Firebird-devel wrote: Wierd - I could not reproduce it with . plugin. To be precise - it's IBSurgeon plugin. -- Check out the vibrant tech community on one o

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Hi, I have a weird behavior here. Database after b&r, no errors. I try to insert non-unique value into table with unique constraint and it fails as it should. I encrypt it (AES128 from IBPhoenix) and the same statement does not fail. Only the next one will

Re: [Firebird-devel] libtool used for libtomcrypt is not using the defined LIBTOOL

2017-11-06 Thread Alex Peshkoff via Firebird-devel
On 11/06/17 17:17, marius adrian popa wrote: Ok i installed libtomcrypt from source , i will create a pull request with new version of it for firebird git clone https://github.com/libtom/libtomcrypt.git cd libtomcrypt git checkout tags/1.18 make make install cd .. https://travis-ci.org/mariuz/f

Re: [Firebird-devel] rpmbuild is still used in 2.5 branch

2017-10-26 Thread Alex Peshkoff via Firebird-devel
On 10/26/17 18:13, marius adrian popa wrote: rpm build failed on travis when doing make dist so I will redo the pull request Marius, just please do not try to place a cart in front of a horse. Changing FB built order, specially for version that people use for many years, is not good idea. C

Re: [Firebird-devel] rpmbuild is still used in 2.5 branch

2017-10-26 Thread Alex Peshkoff via Firebird-devel
On 10/26/17 18:00, marius adrian popa wrote: i have seen that is deprecated in 3.0/4.0 so i wanted to cleanup also in 2.5 branch Bad and wrong desire. If feature XXX is removed from version N it does not mean that it should be removed from N-1 too.

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-12 Thread Alex Peshkoff via Firebird-devel
On 10/12/17 13:06, Dimitry Sibiryakov wrote: 12.10.2017 11:55, Alex Peshkoff via Firebird-devel wrote: Suggested implementation of that possibilities is also bad - it's supposed to have different behavior depending upon text in parameter.   You didn't see implementation, how can yo

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-12 Thread Alex Peshkoff via Firebird-devel
On 10/12/17 12:02, Dimitry Sibiryakov wrote: 12.10.2017 10:24, Alex Peshkoff via Firebird-devel wrote: what problem do you want to solve with this change?   No problem to solve. It is not bug fix, it is an improvement. It open new possibilities for app developers, nothing more. That

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-12 Thread Alex Peshkoff via Firebird-devel
Well Dmitry (and please briefly) - what problem do you want to solve with this change? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Fireb

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Alex Peshkoff via Firebird-devel
On 10/11/17 22:22, Dimitry Sibiryakov wrote: 11.10.2017 20:57, Vlad Khorsun via Firebird-devel wrote:   I don't understand your speculations   Ok, turn your imagination on: Performance of gbak must be improved by feeding of backup stream from server using services instead of sending queries.

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/06/17 19:59, Dimitry Sibiryakov wrote: 06.10.2017 18:50, Alex Peshkoff via Firebird-devel wrote: Unfortunately no support in gbak   That's pity. Stream transfer from service is faster than using queries as it is done now, right? Certainly faster. That was main reason t

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/06/17 19:40, Leyne, Sean wrote: A general question about the idea of "streaming" fbk file to a remote server for restore. There would need to be a proper protocol to handle the stream, no? It would be impossible to send the fbk in a single operation, so sending the fbk in blocks would

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/06/17 19:28, Leyne, Sean wrote: It's clear that choice to use isc_info_svc_line to mark chunk of stdin sent to service via SPB was not wise choice (to say it mildly). Both isc_info_svc_to_eof and isc_info_svc_line are normally used for service output (query items) and they were created jus

Re: [Firebird-devel] isc_info_svc_timeout incompatibility between Interbase and Firebird

2017-10-04 Thread Alex Peshkoff via Firebird-devel
On 10/04/17 18:17, Dimitry Sibiryakov wrote: 04.10.2017 17:03, Dmitry Yemanov wrote: Different SPB version perhaps?   No, in both cases isc_spb_current_version is defined as 2. But, perhaps, examples in documentation for Interbase XE are outdated and comply to spb verion 1. Sooner of al

Re: [Firebird-devel] isc_info_svc_timeout incompatibility between Interbase and Firebird

2017-10-04 Thread Alex Peshkoff via Firebird-devel
On 10/04/17 17:48, Dimitry Sibiryakov wrote: Hello.   In Interbase isc_info_svc_timeout is used like this: *spb++ = isc_info_svc_timeout; ADD_SPB_NUMERIC(spb, 60); /* 1 minute timeout */   In Firebird it is used like this: *p++ = isc_info_svc_timeout; ADD_SPB_LENGTH(p, 4); ADD_SPB_NUMERIC(

Re: [Firebird-devel] Unload of fbclient.dll (v3)

2017-10-02 Thread Alex Peshkoff via Firebird-devel
On 10/02/17 13:49, Kovalenko Dmitry wrote: Could anybody confirm this behavior of FB3 client library? Please add big delay (120 sec should be enough) after last attachment closed before unloading client library. Does it unload in such case? --

Re: [Firebird-devel] Unload of fbclient.dll (v3)

2017-10-02 Thread Alex Peshkoff via Firebird-devel
On 10/02/17 13:49, Kovalenko Dmitry wrote: Hello, fbclient.dll (from FB3) not unload when I call ::FreeLibrary. fbclient.dll (from FB2.5) unloads without problems. Could anybody confirm this behavior of FB3 client library? Yes - in a test with FB4 on linux. BTW, ::dlclose does not return

Re: [Firebird-devel] SEC$USERS and indices

2017-09-20 Thread Alex Peshkoff via Firebird-devel
On 09/19/17 20:45, Magnus Johansson wrote: -Original Message- From: Alex Peshkoff via Firebird-devel [mailto:firebird- de...@lists.sourceforge.net] Sent: Tuesday, September 19, 2017 10:19 AM I'm curious about why there is no index on SEC$USERS.SEC$USER_NAME (*) You are right - be

Re: [Firebird-devel] FB4 fetches

2017-09-19 Thread Alex Peshkoff via Firebird-devel
On 09/18/17 19:37, liviuslivius wrote: Hi, i do not know if message reach the group, or it was wrong place to ask about FB4? I asked about fetches because on previous versions of FB this not occure. Maybe not really. on FB3 fetches fluctuate by only 1. But under FB4 it fluctuate by 14 or even

Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Alex Peshkoff via Firebird-devel
On 09/18/17 23:39, Magnus Johansson wrote: Hello, I'm looking on FB 3.0 and doing some thinking comparing with FB 2.5. In 2.5 there is an index on RDB$USERS.RDB$USER_NAME and that field is defined as VARCHAR. In 3.0 there is no index on SEC$USERS.SEC$USER_NAME and it is defined as CHAR. Looki

Re: [Firebird-devel] Changing wire encryption keys?

2017-06-10 Thread Alex Peshkoff via Firebird-devel
On 06/10/17 11:42, Mark Rotteveel wrote: Is there something in the wire encryption implementation that changes wire encryption keys while the connection is already encrypted? No. -- Check out the vibrant tech communit

<    4   5   6   7   8   9