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

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

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

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.

Re: [Firebird-devel] FB4 fetches

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

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

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 - because

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

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

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

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

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

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 to add

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

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

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

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);

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

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 you appraise

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

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

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

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

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

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] Using ordinary database connection string in isc_service_attach() call

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

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

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

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

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

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

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

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? 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',

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/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/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] libtool used for libtomcrypt is not using the defined LIBTOOL

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 ..

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] 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/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] 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] 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/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] 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] 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] 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] 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] 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] 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] 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 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 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] [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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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

[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] 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] 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] 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] 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 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/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] 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] 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] rpmbuild is still used in 2.5 branch

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.

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

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] 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] 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] 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] 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] 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] 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 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/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 -

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

com> On 02/02/18 21:15, Dimitry Sibiryakov wrote: 02.02.2018 19:08, Alex Peshkoff wrote: On 02/02/18 19:40, Dimitry Sibiryakov wrote: 02.02.2018 17:25, Alex Peshkoff via Firebird-devel wrote: I.e. to represent NUMERIC/DECIMAL(M, N) where M > 18 will be used SQL_DEC34 with sqlsubtype 1

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] 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] 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

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: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] 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

[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

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

Re: [Firebird-devel] ⁨ Firebird 3 embedded om iOS⁩

On 27.07.2018 17:30, Svend Meyland Nicolaisen wrote: Thank you very much for the answer. Adrian Marius Popa wrote in October a blog post regarding Firebird 3 (and 2.5) on iOS: https://mapopa.blogspot.com/2017/10/firebird-3-on-apple-ios.html?m=1 The blog post contains little information

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

On 08.08.2018 14:49, liviuslivius wrote: Hi, i have succesfully connected my Delphi application using Firedac to Firebird embeded on Android. That's great! Firebird version is LI-V3.0.3.32900. I can retrive data from tables from field types: Integer, BIGINT, CHAR, VARCHAR, DATE, TIME, 

Re: [Firebird-devel] Management statements in PSQL

On 07.08.2018 18:28, Adriano dos Santos Fernandes wrote: Hi! Current management (SET ... / ALTER SESSION) statements are valid only as top-level statements (and hence in EXECUTE STATEMENT too), i.e., cannot be in EXECUTE BLOCK or stored routine. This is a problem, as some of these statements

[Firebird-devel] Improvement for EXECUTE STATEMENT

I want to suggest simple improvement to execute statement - make it possible to run in it CREATE DATABASE statements. It will not accept parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL which switches to the context of newly

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

On 15.08.2018 17:19, Leyne, Sean wrote: I want to suggest simple improvement to execute statement - make it possible to run in it CREATE DATABASE statements. It will not accept parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

On 15.08.2018 17:19, Dimitry Sibiryakov wrote: 15.08.2018 16:13, Alex Peshkoff via Firebird-devel wrote: In the simplest form (create database on current server) that will look like this: execute statement 'create database ''/tmp/t1''';   What about security and other settings? Will newly

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

On 15.08.2018 18:08, Dimitry Sibiryakov wrote: 15.08.2018 16:43, Alex Peshkoff via Firebird-devel wrote: Taking into an account that this is suggested for FB4 (not 2.5) I do not see problems with security.   Imagine server configured with DatabaseAccess = none and/or database configured

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

On 10.08.2018 10:26, liviuslivius wrote: Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf

Re: [Firebird-devel] Sometimes appveyor build fail for no reason

On 27.08.2018 04:10, Adriano dos Santos Fernandes wrote: Hi! Sometimes the build fail with message "Object reference not set to an instance of an object." https://ci.appveyor.com/project/FirebirdSQL/firebird/build/1.0.106/job/453y3ialoydf4r4b May be some problem in their environment (.net

[Firebird-devel] Crypto functions in firebird

In firebird4 we have improved hash() function in order to make it support various kinds of hashes. But except hashes there are a lot of other crypto-related tasks that may be useful to execute directly from SP & triggers. Does it make sense to add functions (may be UDR?) for signing something

Re: [Firebird-devel] Crypto functions in firebird

On 27.08.2018 13:37, Sergey Mereutsa wrote: Alex, I think, you can add (using simple warping functions) most used OpenSSL functions - they cover 80%-90% of all needs in most cases. Just my 0.05 MDL :) One detail - that's supposed to be not OpenSSL but tomcrypt. With openssl we have some

Re: [Firebird-devel] Crypto functions in firebird

On 27.08.2018 13:52, Adriano dos Santos Fernandes wrote: But if a functionality is decided to be created in the engine, then it's better to write as a system package using the internal engine (created in time zones branch). Definitely yes - I've just forgotten about new functionality.

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

On 27.08.2018 20:10, Adriano dos Santos Fernandes wrote: All, Please. If nobody else sees the magnitude of this problem, I'll shut up. What we talk here is something that is being said to fix read committed, but completely destroys it. Adriano, I agree that calling function multiple times

Re: [Firebird-devel] Error code 336920631 in header files

On 23.08.2018 08:53, Jiří Činčura wrote: Nobody? Historically this happened as follows. Initially errors registered for use in utilities could never reach user code. Later some of utilities started to be used as services - but that time errors were always returned as text strings (sooner

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

On 23.07.2018 18:21, Adriano dos Santos Fernandes wrote: May be has nothing to do with Mark's problem, but inet.cpp/alloc_port seems to have a race problem: -- if (!INET_initialized) {     MutexLockGuard guard(init_mutex, FB_FUNCTION);     if (!INET_initialized)     {         ...  

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

  1   2   3   4   5   6   7   8   9   >