Re: [Firebird-devel] Underlying format of high precision numerics

2019-07-03 Thread Jiří Činčura
e looking calculation over a 1M rows. Suddenly the time adds up. -- 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] UDR vs PSQL

2019-07-01 Thread Jiří Činčura
> What is the UDR source code? Is it compiled as "release" (optimized) code? I used the sum_args from examples. Yes, optimized (using VS2019). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/l

Re: [Firebird-devel] UDR vs PSQL

2019-07-01 Thread Jiří Činčura
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] System package for blob manipulation in PSQL

2019-07-01 Thread Jiří Činčura
done in a UDR, so > can be released as a separate library. I agree with you Mark. -- 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] UDR vs PSQL

2019-06-19 Thread Jiří Činčura
a SP. I would say your assumption is not correct. Although I still haven't done the test, my expectation is that the PSQL would beat the UDF in invocation/load and UDF would be faster for execution. I would report back when I do the test, as time permits. -- Mgr. Jiří Činčura https://www.tab

Re: [Firebird-devel] UDR vs PSQL

2019-06-17 Thread Jiří Činčura
> Invocation (call/return) is slower, but execution itself (when the body > is complex enough) may be faster. Surely. -- 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] UDR vs PSQL

2019-06-17 Thread Jiří Činčura
> Perhaps the real comparison should be between UDR and UDF. I don't see what that would tell me. Except for the number itself. Something particular you're looking for? > Can you test that? Probably I can, later this month. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Fi

[Firebird-devel] UDR vs PSQL

2019-06-17 Thread Jiří Činčura
. -- 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] DDL trigger values formula in constants.h

2019-05-01 Thread Jiří Činčura
>DDL_TRIGGER_BEFORE | TRIGGER_TYPE_DDL | (1 << > DDL_TRIGGER_CREATE_TABLE) | (1 << DDL_TRIGGER_ALTER_TABLE) = Yes, that's what I eventually found in parse.y, but doesn't it make sense to have this fromula in the comment? BEcause what's there now isn't helpful at all. --

Re: [Firebird-devel] DDL trigger values formula in constants.h

2019-05-01 Thread Jiří Činčura
ka 16384 | 1 | 2 | 1 gives same result. The parse.y (https://github.com/FirebirdSQL/firebird/blob/master/src/dsql/parse.y#L3818 and related parts below) seems to be doing different computation... -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing lis

Re: [Firebird-devel] DDL trigger values formula in constants.h

2019-05-01 Thread Jiří Činčura
The formula in the highlighted comment doesn't seem to describe what is actually computed and stored. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Wed, May 1, 2019, at 15:55, Vlad Khorsun wrote: > 01.05.2019 15:47, Jiří Činčura wrote: > > Hi *, > > > > I'm loo

[Firebird-devel] DDL trigger values formula in constants.h

2019-05-01 Thread Jiří Činčura
Hi *, I'm looking into constants.h and I see this https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/constants.h#L449 . But this does not seem to be what the parse.y is doing nor what I see in RDB$TRIGGERS. Can somebody check it? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com

Re: [Firebird-devel] Invalid and ambiguous timestamps with time zones

2019-04-24 Thread Jiří Činčura
onally they will be surprised that "some values changed". And they will learn the lesson. But it would be nice to give the people who experienced this situation tool inside the box to solve it. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web int

Re: [Firebird-devel] Invalid and ambiguous timestamps with time zones

2019-04-24 Thread Jiří Činčura
ther level of mess with timezones. -- 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] Invalid and ambiguous timestamps with time zones

2019-04-24 Thread Jiří Činčura
change. So i.e. what was once in DST is no longer in DST. Your way kind of works for past dates (up until some point in past where we have reliable TZ data, but that's IMO fine), but fails badly for future dates (or near past days). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/

Re: [Firebird-devel] Invalid and ambiguous timestamps with time zones

2019-04-23 Thread Jiří Činčura
Regarding the exception, what would happen if you store valid date at that time and you later, with new DST rules, try to read it? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Apr 23, 2019, at 17:46, Adriano dos Santos Fernandes wrote: > Hi! > > With time zones, ther

[Firebird-devel] ADO.NET provider 6.6.0.0

2019-04-01 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233773 link. -- Mgr. Jiří Činčura Independent IT Specialist Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Dropping identity

2019-02-20 Thread Jiří Činčura
Thanks Mark. I missed that in RL. My fault. -- 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] Dropping identity

2019-02-20 Thread Jiří Činčura
Nobody? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Feb 19, 2019, at 12:23, Jiří Činčura wrote: > Hi *, > > can I drop identity specification from the column on FB3? I've found only > CORE-5431, but that's only for 4.0. > > -- > Mgr.

[Firebird-devel] Dropping identity

2019-02-19 Thread Jiří Činčura
Hi *, can I drop identity specification from the column on FB3? I've found only CORE-5431, but that's only for 4.0. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] ADO.NET provider 6.5.0.0

2019-02-14 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233772 link. -- Mgr. Jiří Činčura Independent IT Specialist 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 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] 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

[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] fb_shutdown in embedded mode

2019-01-24 Thread Jiří Činčura
as two different paths. Currently there isn't a good xplat way to resolve symlinks. Thus I might end up calling this twice or more times. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-22 Thread Jiří Činčura
>Preferably - yes, it is better to call it explicitly. Thanks. Will do it. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] fb_shutdown in embedded mode

2019-01-22 Thread Jiří Činčura
Hi, do I need to call fb_shutdown on application exit when all connections are closed before the unloading happens by the OS? The README.fb_shutdown says I don't have to, but I remember some discussion here that it *should* preferably be called. -- Mgr. Jiří Činčura https

Re: [Firebird-devel] Services API validation differences

2019-01-17 Thread Jiří Činčura
> But approaches are so different that both should be supported. Absolutely. I'm creating the implementation for isc_action_svc_validate right now. It was just my personal curiosity. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at ht

[Firebird-devel] Negative value for isc_spb_val_lock_timeout

2019-01-17 Thread Jiří Činčura
Hi *, it looks server accepts negative values for isc_spb_val_lock_timeout. Is that expected? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Services API validation differences

2019-01-17 Thread Jiří Činčura
Hi, what's the difference between isc_action_svc_repair + isc_spb_rpr_validate_db and isc_action_svc_validate? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FbNetExternalEngine version 1.0 released

2019-01-10 Thread Jiří Činčura
More info here https://www.tabsoverspaces.com/233760-fbnetexternalengine-version-1-0-released . -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] ADO.NET provider 6.4.0.0

2018-11-02 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233750 link. -- Mgr. Jiří Činčura Independent IT Specialist Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] ADO.NET provider 6.3.0.0

2018-09-04 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233740 link. -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http

Re: [Firebird-devel] op_void response after op_open_blob

2018-08-30 Thread Jiří Činčura
. Strange, it happens only sometimes. Sad I can't replicate it easily. Might be some unexpected bytes are left in input buffer from sequence of previous actions. :( I suppose I have to try poking it until something falls out of it. -- Mgr. Jiří Činčura https://www.tabsovers

[Firebird-devel] op_void response after op_open_blob

2018-08-29 Thread Jiří Činčura
Hi, I'm debugging an issue, when _sometimes_ (so far no connection to any action), after sending op_open_blob, I get op_void as a response. How should this situation be handled? What could be reason for it? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com

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

2018-08-22 Thread Jiří Činčura
Nobody? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list

[Firebird-devel] ADO.NET provider 6.2.0.0

2018-08-20 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233739 link. -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http

[Firebird-devel] Error code 336920631 in header files

2018-08-16 Thread Jiří Činčura
Hi *, why isn't error code 336920631 in header files like iberror.h? I see the message in messages2.sql. Doing isc_action_svc_db_stats I can easily trigger it over the wire. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com

[Firebird-devel] ADO.NET provider 6.1.0.0

2018-07-11 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233733 link. -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http

[Firebird-devel] Introducing FirebirdDbComparer – library for comparing Firebird databases to create alter scripts

2018-07-09 Thread Jiří Činčura
More info here: https://www.tabsoverspaces.com/233731-introducing-firebirddbcomparer-library-for-comparing-firebird-databases-to-create-alter-scripts and here: https://www.tabsoverspaces.com/tools/firebird-db-comparer . -- Mgr. Jiří Činčura https://www.tabsoverspaces.com

Re: [Firebird-devel] Tracker

2018-06-11 Thread Jiří Činčura
nd ServerTokens Prod and bottom line will not be shown. Or the error page can be fully custom (probably not worth the effort). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech c

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

2018-06-08 Thread Jiří Činčura
> 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. Unless HSM is used. Then the key is not in RAM. -- Mgr. Jiří Činčura https://www.tabsover

[Firebird-devel] FirebirdClient 6.0 (+EF& EFCore)

2018-06-07 Thread Jiří Činčura
Read here (https://www.tabsoverspaces.com/233727-firebirdclient-version-6-0-entity-framework-core-2-x-provider-entity-framework-6-provider) and here (https://github.com/FirebirdSQL/NETProvider/releases/tag/6.0.0.0). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Jiří Činčura
without "end" column and for convenience a view would be provided? I totally get Lester's point. The end column kind of breaks normalization. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-25 Thread Jiří Činčura
variables with "random" values, that's a disaster, if you forget to reset those manually. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Reason for "Missing master config file firebird.conf"

2018-05-18 Thread Jiří Činčura
Yes, that was it. I created "$Firebird" variable in AppVeyor and that's surfaced as environment variable. Renamed it and it works fine. Thanks! -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ --

[Firebird-devel] Reason for "Missing master config file firebird.conf"

2018-05-18 Thread Jiří Činčura
I get this messsage. Any hints to check? It's a vanilla Firebird 3, the CWD is the location where firebird.exe is located. Thanks. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant t

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

2018-05-09 Thread Jiří Činčura
> Was this ever implemented/completed? I'm also slowly finishing implementation in .NET so anybody can write SP/... in C#/... -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant t

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

2018-04-17 Thread Jiří Činčura
And more importantly, what's "Skipped due to Avalerion's blunder" about? :) Did I miss something? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of t

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

2018-04-13 Thread Jiří Činčura
rd. It does. But it works. Alex was always saying that it's a problem of plugin a depends on it or it has a problem. Go figure. So I keep sending whatever server asks for as long as it asks for it. -- Mgr. Jiří Činčura https://www.tabsov

Re: [Firebird-devel] Getting location of fbclient.dll via IExternalContext

2018-03-26 Thread Jiří Činčura
quot;fbclient.dll" is then trivial. So it works for me. > >Use it. This is the only correct way. Thanks Vlad. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on

Re: [Firebird-devel] Getting location of fbclient.dll via IExternalContext

2018-03-26 Thread Jiří Činčura
>Just use LoadLibrary() without path. The library is for sure already > loaded into > address space, so the function will return handle to it without further > searching. I need the string. Not load the library. -- Mgr. Jiří Činčura https://www.tabsov

Re: [Firebird-devel] Getting location of fbclient.dll via IExternalContext

2018-03-26 Thread Jiří Činčura
Hmm, found `context->getMaster()->getConfigManager()->getRootDirectory()`. Is there a better/shorter way? And adding "fbclient.dll" is then trivial. So it works for me. -- Mgr. Jiří Činčura https://www

[Firebird-devel] Getting location of fbclient.dll via IExternalContext

2018-03-26 Thread Jiří Činčura
Hi *, can I get location of currently used fbclient.dll via IExternalContext? Or the directory. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Executing statement in the same context as external engine execution

2018-03-26 Thread Jiří Činčura
le code instead of the gu of lines I have now. :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/sl

[Firebird-devel] Executing statement in the same context as external engine execution

2018-03-23 Thread Jiří Činčura
and it's going to be fine? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel

Re: [Firebird-devel] Getting attachment_id from IAttachment

2018-03-23 Thread Jiří Činčura
t the integer from the returned buffer? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Fir

[Firebird-devel] Sometimes weird response for op_get_segment

2018-01-30 Thread Jiří Činčura
at's going on there? And how is it possible that the buffer is not always the same (sometimes it's correct sizes etc.)? Running on vanilla 2.5.8 x64. BTW the correct data I'm getting in other cases is here (https://pastebin.com/JZu0jkq8). -- Mgr. Jiří Činčura https://www.tabsover

Re: [Firebird-devel] Database opened in another session

2018-01-28 Thread Jiří Činčura
Sadly it has happened again few hours ago. 2.5.8 x64, running on Windows Server. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech

Re: [Firebird-devel] Database opened in another session

2018-01-20 Thread Jiří Činčura
Not yet. The 2.5.8 update on servers is still on my todo. Also I had to add some retry logic for this error, so now it's harder to spot it, unless is occurs multiple times (which it often does not, hence the retry usually helps). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Fri

Re: [Firebird-devel] Meltdown and Spectre

2018-01-10 Thread Jiří Činčura
Anything doing a lot of user-mode to kernel-mode transitions is affected the most. That's why i.e. IO intensive code suffers more than just computations. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Wed, Jan 10, 2018, at 17:47, Carlos H. Cantu wrote: > I saw a performance compari

Re: [Firebird-devel] Meltdown and Spectre

2018-01-09 Thread Jiří Činčura
you will get useful data (recall heartbleed issue). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.l

Re: [Firebird-devel] Splitting out sub projects in extern

2018-01-04 Thread Jiří Činčura
That's how GH handles submodules. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link

Re: [Firebird-devel] Database opened in another session

2017-12-26 Thread Jiří Činčura
Looks like the issue is not happening in nightly 3.0.3 (about two weeks old). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites

[Firebird-devel] ADO.NET provider 5.12.1.0

2017-12-21 Thread Jiří Činčura
More info: https://www.tabsoverspaces.com/233665-ado-net-provider-5-12-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Database opened in another session

2017-12-20 Thread Jiří Činčura
>I can make build of v2.5 with that patch from v3 for you, if you wish. That would help. Because on 2.5 it's happening daily even hourly. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check

Re: [Firebird-devel] Database opened in another session

2017-12-20 Thread Jiří Činčura
ork connection and to be extra sure, all apps are now running in session 0. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.

Re: [Firebird-devel] Database opened in another session

2017-12-17 Thread Jiří Činčura
this? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list

Re: [Firebird-devel] Database opened in another session

2017-12-07 Thread Jiří Činčura
>This is very strange. Does it put corresponding message into >firebird.log ? > If yes - how exactly it looks ? Cannot initialize the shared memory region Database is probably already opened by another engine instance in another Windows session --

Re: [Firebird-devel] Database opened in another session

2017-12-07 Thread Jiří Činčura
is trigger is only accessing MON$ATTACHMENTS. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- 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] Database opened in another session

2017-12-07 Thread Jiří Činčura
Nope. Still happening. Even with `-i`. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- 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] Database opened in another session

2017-12-07 Thread Jiří Činčura
application there. This will clearly show it. > firebird executable. Also, you may set IPCName setting in firebird.conf > to > the different values at every firebird instance (client should have same > setting to be able to connect). There's only one instance on the each server. --

[Firebird-devel] Database opened in another session

2017-12-07 Thread Jiří Činčura
. The only unusual thing about the servers is the "sharding" - there's about 200 DBs on each and the connections are often very short (few seconds tops) to all databases. Is there a way I can figure out what's going on? -- Mgr. Jiří Činčura https://ww

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

2017-11-30 Thread Jiří Činčura
Looks like we both mixed it up with something. Maybe it was just discussed and then dismissed. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Wed, Nov 29, 2017, at 21:05, livius wrote: > I must say that i thinked about this in the same way as you. > And i also do not know from w

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

2017-11-29 Thread Jiří Činčura
wed since 2.5. But quick test now shows that even 3.0.2 prohibits that. Not sure where I've got that impression from. I just can't get, at least once, helping hand from Firebird. :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ --

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

2017-11-29 Thread Jiří Činčura
returns one row in result with NULL value. Shouldn't it return empty result set? With this I don't know whether the RETURNING returns NULL as a new value or nothing was updated. I would have to go to PSQL and use ROW_COUNT or something like that. -- Mgr. Jiří Činčura https://www.tab

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

2017-11-28 Thread Jiří Činčura
OK, the Firebird-4.0.0.816-0_Win32 behaves correctly. Will this go into 3.0.3 as well? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging

Re: [Firebird-devel] Making Firebird "leak" resources

2017-11-28 Thread Jiří Činčura
OK, I found ticket in tracker - CORE-5416 - about exactly the same behavior. Already fixed. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most

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

2017-11-28 Thread Jiří Činčura
> Committed to master. Great. I'll check the snapshot build tomorrow and I'll let you know. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's m

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

2017-11-28 Thread Jiří Činčura
myself. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing lis

[Firebird-devel] Making Firebird "leak" resources

2017-11-28 Thread Jiří Činčura
. Commit = op_commit Free = op_free_statement with DSQL_drop Works fine: start TX execute free commit Eats memory: start TX execute commit free Am I doing something wrong? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com

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

2017-11-27 Thread Jiří Činčura
> 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. > up. BTW, for me it's reproduced each time I logoff/logon from/to isql. Yes. For me as well. --

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

2017-11-27 Thread Jiří Činčura
>gfix -v -f ? $ .\gfix.exe -v -fu -user sysdba -password masterkey C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB $ Nothing. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech commun

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

2017-11-27 Thread Jiří Činčura
> AES128 plugin also works fine for me: Yeah, as I said. On a new database it works fine. It's something with this database that triggers some undefined behavior. -- Mgr. Jiří Činčura https://www.tabsoverspaces.

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

2017-11-27 Thread Jiří Činčura
> What is the size of compressed database backup? 52 264 210 bytes, why? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech si

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

2017-11-27 Thread Jiří Činčura
ot; on table "PRODUCT2SUPPDOC" -Problematic key value is ("PRODUCTID" = 17, "SUPPORTINGDOCUMENTID" = 1) SQL> Any ideas what could be wrong and where to look at? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ ---

[Firebird-devel] ADO.NET provider 5.12.0.0

2017-11-15 Thread Jiří Činčura
More info: https://www.tabsoverspaces.com/233658-ado-net-provider-5-12-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Lateral derived tables (was: Plans to support cross and outer apply)

2017-09-08 Thread Jiří Činčura
Hi, 1a 2c 3b 4b -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel

[Firebird-devel] ADO.NET provider 5.11.0.0

2017-08-30 Thread Jiří Činčura
More info: https://www.tabsoverspaces.com/233642-ado-net-provider-5-11-0-0-for-firebird-is-ready-with-net-standard-2-0-support/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Jiří Činčura
icely. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Jiří Činčura
There's nothing after this. No further attempts to load anything. Just exception from Firebird and then my application closes from application side of things. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Mon, Aug 28, 2017, at 16:51, Dimitry Sibiryakov wrote: > 28.08.2017 16:47, J

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Jiří Činčura
ter (void*) is actually a pointer to callback interface. That's my problem. I don't think I can marshal the callback interface (I can marshal simple pointer to a function), because I can't create such interface in C#, obviously. :( -- Mgr. Jiří Činčura https://www.tabsovers

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Jiří Činčura
ing). BTW is the callback registration expected to work with "old" (non-OO) API? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Jiří Činčura
to Symbol Table: 0x Number of Symbols: 0 Size of Optional Header: 0x00F0 (240) Characteristics: 0x2022 File is executable App can handle >2GB addresses File is a DLL -- Mgr. Jiří Činčura https://www

[Firebird-devel] Crypt key callback on Embedded

2017-08-28 Thread Jiří Činčura
provided any callback in the first place or it's something else. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org

[Firebird-devel] Creating encrypted database

2017-08-28 Thread Jiří Činčura
Hi *, is there a way to create encrypted database right away (compared to creating database and then altering it to enable encryption)? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech

Re: [Firebird-devel] fbclient - Event call back is called after isc_cancel_events

2017-08-25 Thread Jiří Činčura
lar connection and aux connection is not synchronous. Well, at least on such assumption I've built it in FirebirdClient. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on o

[Firebird-devel] ADO.NET provider 5.10.0.0

2017-08-24 Thread Jiří Činčura
More info: https://www.tabsoverspaces.com/233641-ado-net-provider-5-10-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

2017-08-24 Thread Jiří Činčura
> Post a tracker entry to have it fixed. Or create an index for joining. Done http://tracker.firebirdsql.org/browse/CORE-5598. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant t

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

2017-08-24 Thread Jiří Činčura
ow can I prevent falling into this trap? :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/sl

<    1   2   3   4   5   6   7   >