Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 23.07.2018 16:21, Dimitry Sibiryakov wrote: s = lpad('x', x, 'y') Tried - nothing bad happened. Except long screen blinking :) -- Check out the vibrant tech community on one of the world's most engaging tech

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 22.07.2018 18:03, Mark Rotteveel wrote: On 22-7-2018 16:14, Dimitry Sibiryakov wrote: 22.07.2018 14:56, Mark Rotteveel wrote: If I change one of the two test classes that triggers this problem to create a single database for the entire test class, the problem changes from a too large

Re: [Firebird-devel] alloc.h global operator new replacement violating alignment requirements

On 03.07.2018 12:36, Dimitry Sibiryakov wrote: 02.07.2018 16:01, Alex Peshkoff via Firebird-devel wrote: Should 16-byte alignment be enforced only for x64 builds or for x86 too?   I would invite it for 32 bits too as it would let to use AES and other 128 bits CPU commands without need

Re: [Firebird-devel] alloc.h global operator new replacement violating alignment requirements

On 16.04.2018 15:59, Alex Peshkoff via Firebird-devel wrote: On 04/16/18 15:08, Stephan Bergmann wrote: On 17/02/17 11:48, Alex Peshkoff wrote: On 02/16/17 15:52, Stephan Bergmann wrote: Forgive me if this has already been discussed or even fixed in later versions:  At least the Firebird 3.0

Re: [Firebird-devel] Linux snapshots are outdated

On 27.06.2018 22:36, Alex Peshkoff wrote: On 26.06.2018 16:18, Dmitry Yemanov wrote: 26.06.2018 15:50, Gabor Boros wrote: The latest 3.0/4.0 kits have 2018-06-11 date. I am very unhappy with the outdated Linux builds. I am the only one? The issue is being worked on. Currently linux

Re: [Firebird-devel] Linux snapshots are outdated

On 26.06.2018 16:18, Dmitry Yemanov wrote: 26.06.2018 15:50, Gabor Boros wrote: The latest 3.0/4.0 kits have 2018-06-11 date. I am very unhappy with the outdated Linux builds. I am the only one? The issue is being worked on. Currently linux snapshots are updated but building script was

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

On 25.06.2018 13:17, Dimitry Sibiryakov wrote: 25.06.2018 11:14, Alex Peshkoff via Firebird-devel wrote: Bruteforce passwords over the wire. We are still missing any passwords regulation (like min.length, UP/low letters, etc.) i.e. people can use passwords like 'pass' and such things can

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

On 25.06.2018 12:02, Dimitry Sibiryakov wrote: 25.06.2018 10:35, Alex Peshkoff via Firebird-devel wrote: Afraid you are wrong here. It helps an attacker to detect what plugin is actually used by server (for example - srp or srp256) and use that info to attack particular plugin later.   Does

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

On 25.06.2018 10:47, Mark Rotteveel wrote: On 2018-06-24 20:49, Alex Peshkoff via Firebird-devel wrote: On 23.06.2018 17:06, Mark Rotteveel wrote: Why is an authentication plugin mismatch (as in the list of plugins between client and server have no overlap) not clearly communicated

Re: [Firebird-devel] Passing plugin list to native client

On 25.06.2018 10:51, Mark Rotteveel wrote: On 2018-06-24 20:51, Alex Peshkoff via Firebird-devel wrote: On 23.06.2018 19:05, Mark Rotteveel wrote: When using the native fbclient, why can't I use isc_dpb_auth_plugin_list/isc_spb_auth_plugin_list to pass the authentication plugins to try

Re: [Firebird-devel] Smart end of statement detection in ISQL

On 24.06.2018 21:09, Adriano dos Santos Fernandes wrote: Hi! Due to ISQL dumbness statement processing, SET TERM is an essential feature to write procedures/functions/triggers and execute block. But ISQL already has some smartness to not detect the terminator inside quoted identifiers, strings

Re: [Firebird-devel] Passing plugin list to native client

On 23.06.2018 19:05, Mark Rotteveel wrote: When using the native fbclient, why can't I use isc_dpb_auth_plugin_list/isc_spb_auth_plugin_list to pass the authentication plugins to try, and why do I need to use the isc_dpb_config/isc_spb_config with "AuthClient = " (+ other config items if

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

On 23.06.2018 17:06, Mark Rotteveel wrote: Why is an authentication plugin mismatch (as in the list of plugins between client and server have no overlap) not clearly communicated to the client? For example if I have AuthServer = Srp256,Srp,Legacy_Auth and the client only tries Srp224, then

Re: [Firebird-devel] Fwd: [FB-Tracker] Commented: (CORE-5788) Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256

On 21.06.2018 16:36, Mark Rotteveel wrote: On 21-6-2018 14:07, Alex Peshkoff via Firebird-devel wrote: I've forwarded this FYI to devel & admin. [ http://tracker.firebirdsql.org/browse/CORE-5788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=33942#action_3

[Firebird-devel] Fwd: [FB-Tracker] Commented: (CORE-5788) Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256

I've forwarded this FYI to devel & admin. [ http://tracker.firebirdsql.org/browse/CORE-5788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=33942#action_33942 ] Status of Srp256 plugin in FB3 & FB4. In master branch Srp256 (with enhanced security) becomes single

[Firebird-devel] Services version 1 cleanup

Except well-known to all us services manager service_mgr firebird has a group of so called 'version 1' service managers (backup and gsec are samples, there are also a lot of services related to journalling and shared cache control). They seem to be in half-working (in the best case) state at

Re: [Firebird-devel] Conectar FireBird desde otra pc

On 19.06.2018 14:50, EcoExcel wrote: Good afternoon Sorry for the inconvenience. Could you tell me what steps I should follow to connect my Excel that work through ADO (Active data Objects) by means of VBA programming to a database that is in another PC that I use as a server? I have tried the

Re: [Firebird-devel] ACLs of system objects

On 15.06.2018 19:01, Adriano dos Santos Fernandes wrote: On 13/06/2018 13:08, Adriano dos Santos Fernandes wrote: I didn't played with the code yet, but I suppose we should just backup system ACLs and reset the system ones created during restore with them. Now seeing in a more detailed way,

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

On 17.06.2018 13:17, Mark Rotteveel wrote: I don't agree with this ticket getting closed. I raised an objection to the current solution in the comments that I think needs to be addressed. The current solution causes a divergence in errors between decimals(p,s) with p <=18 and 18 < p <=34,

Re: [Firebird-devel] Write to firebird log file from plugin

On 14.06.2018 18:34, Dimitry Sibiryakov wrote: 14.06.2018 17:20, Dmitry Yemanov wrote: IIRC, gds__log() is exported from fbclient.   Yes, but everything that a plugin has is IMaster. I can get log dir from it, so I can write my own log alongside to firebird.log, but writing into

Re: [Firebird-devel] Support for XTS mode of operation in DbCrypt plugins

On 07.06.2018 21:28, Alex Peshkoff via Firebird-devel wrote: On 07.06.2018 21:16, Dimitry Sibiryakov wrote: 07.06.2018 19:47, Alex Peshkoff via Firebird-devel wrote: Access to server's file system and server's RAM are rather different things.   Not quite so. If someone can write a library

Re: [Firebird-devel] Support for XTS mode of operation in DbCrypt plugins

On 07.06.2018 21:16, Dimitry Sibiryakov wrote: 07.06.2018 19:47, Alex Peshkoff via Firebird-devel wrote: Access to server's file system and server's RAM are rather different things.   Not quite so. If someone can write a library into plugins subdir - memory is accessible. Of course, no write

Re: [Firebird-devel] Support for XTS mode of operation in DbCrypt plugins

On 07.06.2018 20:40, Dimitry Sibiryakov wrote: 07.06.2018 19:08, Alex Peshkoff via Firebird-devel wrote: As I've already said if one has access to server's RAM there are a lot of ways to get both unencrypted data & keys. But that's 'slightly' different level compared with intercep

Re: [Firebird-devel] Support for XTS mode of operation in DbCrypt plugins

On 07.06.2018 20:01, Dimitry Sibiryakov wrote: 07.06.2018 18:40, Alex Peshkoff via Firebird-devel wrote: Ability to easily get ncryption key from working connections mean badly written KeyHolder.   No matter how well is written KeyHolder, thanks to CLOOP signatures it is very easy

Re: [Firebird-devel] Support for XTS mode of operation in DbCrypt plugins

On 07.06.2018 19:24, Dimitry Sibiryakov wrote: 07.06.2018 18:19, Hristo Stefanov wrote: For example you have reached a server in corporate network   At this point encryption cannot protect database anymore because you can easily get unencrypted data or even encryption key from working

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

On 05/16/18 09:26, liviuslivius wrote: Hi, can you point me if i understand correctly that if user need to see all data in e.g. mon$attachement i cannot grant he/se privilege or add this privilege to currently existed role You can add this privilege to existing role: SQL> SHOW ROLE EXISTING;

Re: [Firebird-devel] MessageBuffer vs C struct alignment

On 05/15/18 13:06, Dimitry Sibiryakov wrote: 15.05.2018 11:58, Alex Peshkoff via Firebird-devel wrote:   Do alignment of fields in C struct matches alignment of the same fields in MessageBuffer?   If at compile/preprocess time construct a struct to be used directly in OO API

Re: [Firebird-devel] MessageBuffer vs C struct alignment

On 05/15/18 12:55, Dimitry Sibiryakov wrote: Hello, All.   Do alignment of fields in C struct matches alignment of the same fields in MessageBuffer?   If at compile/preprocess time construct a struct to be used directly in OO API, will it be reliable? Not always.  For example, on 32-bit

Re: [Firebird-devel] Virtual table for time zones

On 05/10/18 19:40, Vlad Khorsun via Firebird-devel wrote: 10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:    I guess the question is about the case when users have historical data and need to apply old time zone rule to the

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

On 05/14/18 15:58, Dimitry Sibiryakov wrote: 14.05.2018 14:28, Alex Peshkoff via Firebird-devel wrote:   Number of combination growth as N^2 at least. Writing of separate plugins for each possible use case is... boring. What combinations? Key holder may need to establish connection to client

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

On 05/14/18 13:15, Dimitry Sibiryakov wrote: 14.05.2018 11:57, Alex Peshkoff via Firebird-devel wrote: If key holder is expected to work with both types of keys secrtainly it should try to talk to client. One written only for use of non-client keys should not. Wjat a problem?   Number

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

On 05/10/18 18:36, Dimitry Sibiryakov wrote: 10.05.2018 17:20, Alex Peshkoff via Firebird-devel wrote:   BTW, is there a way to distinguish cases when a) ICryptKeyCallback::callback() returned zero because application key not needed b) Application callback is not set Both cases are normal

Re: [Firebird-devel] Virtual table for time zones

On 05/10/18 18:21, Adriano dos Santos Fernandes wrote: Hi! I want to create a virtual table that lists available time zones. For now there is RDB$ (non-virtual), MON$ (virtual, but all about monitoring), SEC$ (security plugin). What prefix should TIME_ZONES have? Can you provide a small

Re: [Firebird-devel] Key holder is not used if keyCallback() returned 0

On 04/14/18 13:14, Dimitry Sibiryakov wrote: Hello, All.   What is a meaning of return value of keyCallback() routine?   It is declared as int, not FB_BOOLEAN, so I guess it is not a flag "use me". But it looks like the engine give up if zero is returned even if no error is set in status.  

Re: [Firebird-devel] Firebird v3.0.x support for External Functions plug-in

On 05/08/18 01:18, Leyne, Sean wrote: The Firebird v3.0.x release notes outlines that plug-ins support has been added, and mentions that it will be extended to supporting SP, Functions and Triggers. Was this ever implemented/completed? Ardiano (specially about Java) will answer better - I

Re: [Firebird-devel] SET DECFLOAT command

On 05/03/18 13:31, Dimitry Sibiryakov wrote: 03.05.2018 12:29, Alex Peshkoff via Firebird-devel wrote:   Is subj allowed in ON CONNECT triggers? Directly not - but one can run it via EXECUTE STATEMENT.   What's the point for such complication? It is not a DDL. The decision should

Re: [Firebird-devel] SET DECFLOAT command

On 05/03/18 13:12, Dimitry Sibiryakov wrote: Hello, All.   Is subj allowed in ON CONNECT triggers? Directly not - but one can run it via EXECUTE STATEMENT. -- Check out the vibrant tech community on one of the

Re: [Firebird-devel] exception handling in firebird.pas

On 04/30/18 11:20, Mark Rotteveel wrote: On 30-4-2018 09:52, fbbt wrote: 3. Maybe we need to put a sample of firebird.pas at github. It will allow other developers to patch it in more productive way than now. As I understand it, firebird.pas is generated by Cloop, so allowing people to patch

Re: [Firebird-devel] CHAR fields in system tables

On 04/28/18 12:22, fbbt wrote: For example: CREATE TABLE SEC$USERS ( SEC$USER_NAMECHAR(63), SEC$FIRST_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$MIDDLE_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */, SEC$LAST_NAME

Re: [Firebird-devel] Handling of database encryption callback for service operations

On 04/26/18 15:09, Mark Rotteveel wrote: On 26-4-2018 13:45, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections

Re: [Firebird-devel] Handling of database encryption callback for service operations

On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections. _UTILITY_ gstat supports only -h and -e switches. It is not related with protocol but has some

Re: [Firebird-devel] Handling of database encryption callback for service operations

On 04/26/18 11:34, Mark Rotteveel wrote: On 26-4-2018 10:11, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat

Re: [Firebird-devel] Handling of database encryption callback for service operations

On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat functions that will currently work with encrypted database are print header (-h) and print crypt statistics

Re: [Firebird-devel] Handling of database encryption callback for service operations

On 04/24/18 11:35, Mark Rotteveel wrote: Does anyone know? On 21-4-2018 17:10, Mark Rotteveel wrote: How and when are database encryption callbacks performed for service operations that involve an encrypted callback? For example retrieving statistics like isc_spb_sts_sys_relations. During

Re: [Firebird-devel] encoding of result strings

On 04/18/18 10:01, Dev wrote: What encoding is used for in/out strings in: function IProvider.attachDatabase(status: IStatus; fileName: PAnsiChar; dpbLength: Cardinal; dpb: BytePtr): IAttachment; function IProvider.createDatabase(status: IStatus; fileName: PAnsiChar; dpbLength: Cardinal; dpb:

Re: [Firebird-devel] Protocol for database encryption callback

On 04/17/18 16:21, Mark Rotteveel wrote: On 12-4-2018 16:51, Alex Peshkoff via Firebird-devel wrote: There was a bug in v.13 - size of respond buffer was not passed over the wire. Ok, so in V13 one would only need to read the data buffer, and in v14 and higher, one would also need to read

Re: [Firebird-devel] "Postfix for CORE-5791. Sorry to snapshot builds users..."

On 04/17/18 13:19, liviuslivius wrote: Hi Alex what does comment : ""Postfix for CORE-5791. Sorry to snapshot builds users - had to change ODS minor once again. If someone was using snapshots with ODS 12.1 please backup with old snapshot code and restore using current one. " in commit

Re: [Firebird-devel] Legacy API functions for new features?

On 04/16/18 18:52, Adriano dos Santos Fernandes wrote: Hi! Should exist isc encode/decode time/timestamp tz (with time zone) API functions? Or could this be only in IUtil? I suggest to have them initially only in IUtil. If ISC functions will be actually requested we can always add them

Re: [Firebird-devel] alloc.h global operator new replacement violating alignment requirements

On 04/16/18 15:08, Stephan Bergmann wrote: On 17/02/17 11:48, Alex Peshkoff wrote: On 02/16/17 15:52, Stephan Bergmann wrote: Forgive me if this has already been discussed or even fixed in later versions:  At least the Firebird 3.0 we build as part of LibreOffice defines global operator new

Re: [Firebird-devel] Protocol for database encryption callback

On 04/12/18 18:20, Mark Rotteveel wrote: On 12-4-2018 16:51, Alex Peshkoff via Firebird-devel wrote: On 04/12/18 16:51, Mark Rotteveel wrote: On 12-4-2018 15:31, Alex Peshkoff via Firebird-devel wrote: On 04/12/18 15:18, Mark Rotteveel wrote: How does the protocol for the database encryption

Re: [Firebird-devel] Protocol for database encryption callback

On 04/12/18 16:51, Mark Rotteveel wrote: On 12-4-2018 15:31, Alex Peshkoff via Firebird-devel wrote: On 04/12/18 15:18, Mark Rotteveel wrote: How does the protocol for the database encryption callback work? If I look at the implementation in Firebird ADO.net, it just tries and keep sending

Re: [Firebird-devel] Protocol for database encryption callback

On 04/12/18 15:18, Mark Rotteveel wrote: How does the protocol for the database encryption callback work? If I look at the implementation in Firebird ADO.net, it just tries and keep sending the same key in a while loop until Firebird responds with something other than op_crypt_key_callback,

Re: [Firebird-devel] Firebird fbudf Module Authenticated Remote Code Execution

On 04/12/18 10:37, marius adrian popa wrote: https://www.tenable.com/security/research/tra-2017-36 That's fixed in FB4 - loading UDFs is denied by default configuration, use of them is deprecated, replacement is UDRs which are nt affected by mentioned vulnerability. In FB3 one should be

Re: [Firebird-devel] Question about XDR protocol and BLOB

On 04/09/18 15:55, Arnaud Le-roy wrote: Hi, I contribute to node-firebird provider and I have question about the way to retrieve blob. First it works well, but I think the way is not good and could cause future problems (hang connection). An exemple a request retrieve 2000 rows with two

Re: [Firebird-devel] Update ICU in Windows

On 04/09/18 18:26, Adriano dos Santos Fernandes wrote: Hi! I'm looking for a way to update ICU in Windows. I also think we should just stop to save few megabytes customizing ICU. +1 -- Check out the vibrant tech

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 04/03/18 16:39, Alex Peshkoff via Firebird-devel wrote: On 04/03/18 16:32, Mark Rotteveel wrote: On 2018-04-03 14:45, Alex Peshkoff via Firebird-devel wrote: I've executed it 100 times. Each time in the end I get: one-test-pure-java:     [junit] Running org.firebirdsql.jdbc.TestReproHang

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 04/03/18 16:32, Mark Rotteveel wrote: On 2018-04-03 14:45, Alex Peshkoff via Firebird-devel wrote: I've executed it 100 times. Each time in the end I get: one-test-pure-java:     [junit] Running org.firebirdsql.jdbc.TestReproHang     [junit] Tests run: 46, Failures: 0, Errors: 131, Skipped

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 04/03/18 14:43, Mark Rotteveel wrote: On 2018-04-03 12:54, Alex Peshkoff via Firebird-devel wrote: On 03/29/18 18:45, Mark Rotteveel wrote: On 29-3-2018 13:19, Alex Peshkoff via Firebird-devel wrote: On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 03/29/18 18:45, Mark Rotteveel wrote: On 29-3-2018 13:19, Alex Peshkoff via Firebird-devel wrote: On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767 (the documented maximum value) in my firebird.conf, and when I run the full test suite of Jaybird

Re: [Firebird-devel] Database encryption

On 04/02/18 18:57, Dimitry Sibiryakov wrote: 02.04.2018 17:43, Alex Peshkoff via Firebird-devel wrote: - one more closed-source plugin I've used to deal with   Perhaps, it has the same limitations. No.   Could you reveal the secret then: how application callback receives name of crypt

Re: [Firebird-devel] Database encryption

On 04/02/18 18:31, Dimitry Sibiryakov wrote: 02.04.2018 17:25, Alex Peshkoff via Firebird-devel wrote: Encryption of database using key passed from application over the wire works well in at least 2 known to me plugins: - DbCrypt_example/KeyHolder_example present in firebird distro

Re: [Firebird-devel] Sequence of key holder's methods calls

On 04/02/18 17:58, Dimitry Sibiryakov wrote: Hello, All.   Firebird 3.0.4.32939. Default configuration. Key holder is set in databases.conf for single database.   When I use "alter database encrypt" within embedded connection I see following sequence of calls to my key holder plugin:

Re: [Firebird-devel] Database encryption

On 03/31/18 16:45, Dimitry Sibiryakov wrote: Hello, All.   Is it intentional that database cannot be encrypted via remote connection if encryption plugin requires key obtained from application callback?   I'm getting following error: Statement failed, SQLSTATE = 42000 unsuccessful metadata

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767 (the documented maximum value) in my firebird.conf, and when I run the full test suite of Jaybird Is it that set of tests which is started in the end of $JAYBIRD/build.sh execution? , the tests hang

[Firebird-devel] ICU loader

To all interested in it... Fixing CORE-5764 I've changed a bit process of ICU loading yo make it more universal. That changed may be tested in master branch, FB4 snapshots aready contain modified ICU loader. Please check does your favorite version(s) of ICU loads successfully with fb4

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 03/27/18 20:08, Mark Rotteveel wrote: I increased the TcpRemoteBufferSize to 32767 (the documented maximum value) in my firebird.conf, and when I run the full test suite of Jaybird, the tests hang consistently on the same test. It is blocked on reading from the socket during a fetch. If I

Re: [Firebird-devel] Updating README.keywords

On 03/27/18 14:32, Mark Rotteveel wrote: On 26-3-2018 18:03, Alex Peshkoff via Firebird-devel wrote: On 03/26/18 18:37, Mark Rotteveel wrote: I just noticed that I should also have updated README.keywords in https://github.com/FirebirdSQL/firebird/pull/150 But as I need to update it anyway

Re: [Firebird-devel] Win1252 Charset on MacOS

On 03/27/18 16:47, Elmar Haneke wrote: It will build, but deprecated implies that you might have an issue trying to run it on 10.7 or 10.8... In any event without the fix for the _clock_gettime function in configure.in your code will only run on 10.12 and no OS version below it. By default the

Re: [Firebird-devel] Updating README.keywords

On 03/26/18 18:37, Mark Rotteveel wrote: I just noticed that I should also have updated README.keywords in https://github.com/FirebirdSQL/firebird/pull/150 But as I need to update it anyway, is it OK if I do a slightly more thorough overhaul? I noticed that some of the words marked with * are

Re: [Firebird-devel] some issues with sed on macosx firebird master

On 03/22/18 20:31, marius adrian popa wrote: icu is installed ls /usr/local/opt/icu4c/lib icu libicuio.59.1.dylib libicutu.59.dylib libicudata.59.1.dylib libicuio.59.dylib libicutu.a libicudata.59.dylib libicuio.a libicutu.dylib libicudata.a libicuio.dylib libicuuc.59.1.dylib libicudata.dylib

Re: [Firebird-devel] some issues with sed on macosx firebird master

On 03/22/18 15:52, marius adrian popa wrote: It reached somewhere (Could not find acceptable ICU library) Is any ICU installed or not on travis build machine? If not try to install please. -- Check out the vibrant

Re: [Firebird-devel] GDS_EPOCH_START constant

On 03/18/18 23:16, Adriano dos Santos Fernandes wrote: Is this constant correct? // Number of the first day of UNIX epoch in GDS counting enum { GDS_EPOCH_START = 40617 }; I see that for date 1970-01-01, Firebird stores it as 40587. When counting days and month it's very easy to mix first

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

On 03/11/18 18:12, Mark Rotteveel wrote: I some changes were made in https://github.com/FirebirdSQL/firebird/commit/1636227d401f3c7e9678dc8cd317af5fae9a56bc I'm observing something odd. It is my understanding it would be possible to drop use of blr_dec_fixed, and use blr_dec128 instead. If

Re: [Firebird-devel] Firebird 3.0.3 build on Fedora rawhide icu 60.2

On 02/21/18 13:46, Philippe Makowski wrote: Hi, firebird-3.0.3.32900 doesn't build on Fedora rawhide with icu 60.2 Any idea on how to fix it ? error: 'char16_t' does not name a type; did you mean 'charset'? error: 'UChar' does not name a type; did you mean 'UChar32'? This should help:

Re: [Firebird-devel] Valid date or not

On 02/22/18 16:33, Adriano dos Santos Fernandes wrote: Hi! As part of CORE-5750 problems, I found that Firebird considers '12Mar92' as a valid date (1992-03-12). Should this be considered a bug, i.e., separators should be necessary in this case (12-Mar-92, 12/Mar/92, 12.Mar.92)? Let's better

Re: [Firebird-devel] Existing a subject of privileges and refactoring

On 02/20/18 15:39, Roman Simakov wrote: 2018-02-20 15:27 GMT+03:00 Alex Peshkoff via Firebird-devel <firebird-devel@lists.sourceforge.net>: Always requiring object type is best of possible solutions but I'm afraid that's unreal. I've supposed missing keyword, i.e. real failing sta

Re: [Firebird-devel] Existing a subject of privileges and refactoring

On 02/20/18 15:19, Dimitry Sibiryakov wrote: 20.02.2018 13:14, Alex Peshkoff via Firebird-devel wrote: 2) We have no check of existance a subjects of privileges. I.e. SQL> create table t(i integer); SQL> grant select on t to wrong_func; SQL> show function wrong_func; There is no use

Re: [Firebird-devel] Existing a subject of privileges and refactoring

On 02/20/18 14:55, Roman Simakov wrote: Hello! I fixed several bugs related to GRANT operator and investigated a couple of issues I'd like to discuss: 1) Replace RDB$TRIGGER_9 (trigger1 in trig.h) by code in DdlNodes.epp with the same functions. I already did it in CORE-5747 to check grant

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

On 01/21/18 14:18, Jorge Gonçalves wrote: After some progress I'm blocked... What is missing? Did you choose master branch with knowledge that it is highly experimental or stable B3_0_Release (firebird-3) may be better for you? Anyway - I've fixed android build in master, new features

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

Mark & others - this is missing email Forwarded Message Subject: Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled? Date: Fri, 2 Feb 2018 21:32:46 +0300 From: Alex Peshkoff <peshk...@mail.ru> To: Dimitry Sibiryakov <s...@ibphoenix.

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

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 -

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

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?

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

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?

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

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

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

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

Re: [Firebird-devel] Firebird 3 and ICU

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

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

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] Database restore problem with 3.0(.3.32882)

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

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

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.

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

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

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

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

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

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

Re: [Firebird-devel] Double in clumplets

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

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

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

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

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

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

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

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

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

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

<    3   4   5   6   7   8   9   10   11   12   >