BTW just to make sure, what is the 2nd and 3rd line going to return?
IXpbBuilder* pb = utl->getXpbBuilder(, IXpbBuilder::BATCH, NULL, 0);
pb->getBufferLength();
pb->getBuffer();
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface
eters. So something is lost in my understanding from reading the server
code.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Is that the msgLen in BlrFromMessage::buildBlr? Looking at the code
> then the length for SQL_LONG should be 6 (4 + 2), isn't it?
*One* SQL_LONG, to be precise.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
isn't it?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
w and everybody is unhappy (and even looking for other options).
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ch looked
weird). But you're saying it's "message size". What's that exactly?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
y :)) correct to me. But it's not, why else would
server complain? :D What looks weird to me is the length in p_batch_msglen,
because it's already sent as part of the buffer sending. I'm playing with that
now.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web
ing? I'm failing to find something, except
batch interface description in Using_OO_API.html, but that's about API, not
about the "protocol".
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hello,
What should be in p_batch_create.p_batch_pb? Is this some new format or
something like DPB?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Enable AllowEncryptedSecurityDatabase in firebird.conf (on server side).
Thanks. I realized I forgot about that few minutes ago. :)
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/fireb
sending op_connect.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> IIRC, the only real change in protocol 14 was
Yeah. Not really worth the effort I meant, it will be "solved" by 15
implementation.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/list
Hello,
In a nutshell, what changed in protocol 15 compared to 13? Is it only the early
crypt key callback?
And I suppose there's not much into protocol 14, right?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https
My vote goes to dropping it.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Can you share metadata backup?
I can, but the build from Vlad works fine, so I think we know what the problem
is and what the fix looks like. So probably not needed anymore.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
ht
Hi Vlad,
I can confirm that with the build you provided, the crash does not happen.
That's great news. Is this fix going to make it also into 3.0.8?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists
t it ASAP.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Yes, that looks very similar. Is it worth trying the build with
https://github.com/FirebirdSQL/firebird/commit/2b0dc05f529c13a0dd070c9fde6d048bc7fdccf4
commit?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
n\threadstart.cpp(97)
msvcr100.dll!_callthreadstartex() Line 314
at f:\dd\vctools\crt_bld\self_64_amd64\crt\src\threadex.c(314)
msvcr100.dll!_threadstartex(void * ptd) Line 292
at f:\dd\vctools\crt_bld\self_64_amd64\crt\src\threadex.c(292)
kernel32.dll!BaseThreadInitThunk()
ntdll.dll!R
137
And the time zone and 1 as end.
>The code you mention is buggy:
>The buffer you got contains garbage, if I'm right.
OK, I'll create an issue.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
can `ISC_USHORT` end up in `216, 103, 147, 0`?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
That's pity, because FB4 RN
(https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html)
mention it.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi,
Where I can find fb_info_protocol_version implementation? I'm looking into
https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/inf.cpp and that
case is not there. Nor I can find the fb_info_protocol_version while grep-ing
the sources.
--
Mgr. Jiří Činčura
https
> Or if the
> above statement changes one day.
Was something like that changed before?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi *,
Can I reuse the IExternalContext instance from Plugin::makeFunction (etc.)
across multiple function executions, instead of using the instance from
Function::execute? I'm trying to cache some objects.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web
Never mind. It seems I figured it out. Looks like I can do op_cont_auth with
public client data right there and then continue as usual.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird
ve session key yet (in op_connect)?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
More info at this https://www.tabsoverspaces.com/id/233868 link.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Definitely BLOB size should be bigger. Index key length too.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Interesting:
"An example buffer adheres to the following format: isc_spb_version
isc_spb_current_version This will allow the addition of spb versions without
the need to renumber or add additional flags for buffer versioning."
:D
--
Mgr. Jiří Činčura
https://www.tabsover
BTW, anybody remembers the reason why version 2 has two values -
isc_spb_version, isc_spb_current_version - at the beginning?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> >> Aha! I suppose in version 2 I can't send data with 2-byte length, right?
> > Aka, I need to jump to version 3 and use 4-byte length.
> >
>
> Exactly.
> V.3 for SPB is like v.2 for DPB.
Thanks. Now I see the 2-byte length is only used for i.e. isc_info_svc_line
> Aha! I suppose in version 2 I can't send data with 2-byte length, right?
Aka, I need to jump to version 3 and use 4-byte length.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Jiri, in order to use wide format you should use
> isc_spb_version3
> not
> isc_spb_version, isc_spb_current_version
> in the beginning (as a tag)
Aha! I suppose in version 2 I can't send data with 2-byte length, right?
--
Mgr. Jiří Činčura
https://www.tab
ould be wide
(https://github.com/FirebirdSQL/firebird/blob/B3_0_Release/src/common/classes/ClumpletReader.cpp#L324),
right? What am I missing?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Done.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi,
I have server with "WireCrypt = Disabled", but I can "just" send op_crypt and
server follows. Is this expected?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> But we got a bit offtopic. Do you need help with subj any more?
At the moment I need to start with the refactoring, until that's rolling, I
think there's not much to do now.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
ht
I would almost say, I'll remove it then. :) But fbclient is sending it too, so
I'll probably stick with tried and true behavior.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Tue, Jul 6, 2021, at 13:57, Alex Peshkoff via Firebird-devel wrote:
> On 7/6/21 2:23 PM, Mark Rotteveel wr
rebirdClient/Client/Managed/GdsConnection.cs#L134-L135
or this (Java)
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/WireConnection.java#L258-L259.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://
p_keys =
> {cstr_length = 0, cstr_allocated = 0, cstr_address = 0x0}}
>
> Pay attention - it's SRP (not 256) and p_auth_cont.p_data is differerent
> second time.
But the op_cont_auth is sent as part of 2nd op_attach. Not in the first
op_connect + op_attach.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Supports - but not active in default config.
As a plan C, it's OK-ish.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> And be not able to connect to default FB3?
FB3 has Srp256 included starting something like 3.0.4, no?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> data from plugin to server, net op is op_cont_auth.
That's the case for WireCrypt != Disabled. Else it just continues to op_attach
and the rest of the auth is done there.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
ht
ark.
It sucks for me a lot that the auth is split between two pieces (1. op_connect
+ op_attach; 2. op_attach). Serious refactoring is probably needed. Or maybe
I'll just support Srp256 only and ignore Srp forever. :D
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-D
>Done, hope I did it right.
Memory is stable in my tests. Great work!
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
CNCT_client_crypt
is i.e. Enabled), I proceed with op_cont_auth, sending the public key, etc. and
all is good. But when I do that now, I get op_response with
335544375/"unavailable database" error.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web
> What's the setting of WireCrypt on the server? For a mode you check it
> should be Enabled or Disabled, not Required default. For Required you
> get quite correct error.
WireCrypt = Enabled
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web
I did. But Jaybird has different flow compared to NETProvider.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Mon, Jul 5, 2021, at 19:57, Mark Rotteveel wrote:
> On 2021-07-05 16:55, Jiří Činčura wrote:
> > What's the expected response to server from client after client
>
point I still need to send the public key from Srp to server and
continue with the auth process.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> next - attach(create) database or attach service
You mean op_attach? Like again? Because that was sent in the first place
(op_connect + op_attach).
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/li
When the WireCrypt is Enabled (on client) then the first response after
op_attach is op_cond_accept and the dance with op_cont_auth can start. But with
WireCrypt Disabled (on client) the op_accept_data is the first response. And
I'm having trouble figuring out what's next.
--
Mgr. Jiří Činčura
HI,
What's the expected response to server from client after client receives
op_accept_data?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Never tried and doubt that would work.
Does not work on my side. Hence, I take that as that it doesn't work. I suppose
the extra op_cont_auth round-trip is going to be needed in case the first auth
plugin is not matched.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-De
Hi,
Is it possible to sent multiple CNCT_specific_data, basically for each
CNCT_plugin_name right away (saving roundtrip)?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>You may try next build
I can confirm the leak does not happen in
https://github.com/FirebirdSQL/firebird/actions/runs/999413719 build. Good job!
Will all the fixes be ported back to 3.0.8?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interf
Any progress here? It's starting to be bit ridiculous. There's memory leak
that's taking down about 15 servers I care about daily and I have to constantly
beg for response.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Tue, Jun 29, 2021, at 14:07, Jiří Činčura wrote:
> >
https://snipboard.io/tgzEm2.jpg
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
When calling, from same script, PSQL function (instead of UDR):
https://snipboard.io/Kg6w54.jpg. Stable memory consumption.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Any progress on this? Should I create issue for it?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
asterkey 'localhost:memory.fdb';
}
In case somebody wants to try it, here's
https://www.uschovna.cz/zasilka/MTSA3D3G4BPT3BYY-I8V/ the whole setup.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
3 or 4?
FB4.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> UDR engine uses Firebird memory pool which is destroyed when the plugin
> is unloaded.
BTW what exactly you mean by unloaded? You mean IExternalEngineImpl::release
being called? Or something like FreeLibrary?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailin
lly known
> if its dispose method is being called or not.
It is in FB4. In FB3 it seems that it's not called.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
What is this gonna tell me?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Mon, Jun 21, 2021, at 20:55, Adriano dos Santos Fernandes wrote:
> On 21/06/2021 15:17, Jiří Činčura wrote:
> > Hi *,
> >
> > I think I have an example of memory leaking when using extern
long
runs, it keeps growing):
https://snipboard.io/g5Lzya.jpg
Am I doing something wrong? Or is this a bug?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
.
Is this a known issue in FB3?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
And maybe same question for IExternalResultSetImpl.
I'm asking because I see some weird behavior in terms of memory allocations.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi *,
Who's responsibility is to call IExternal[Function | Procedure |
Trigger]Impl::dispose? Should the plugin do it i.e. in `closeAttachment` or is
Firebird gonna do it when the Function/Procedure/Trigger is no longer used?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird
firebird.exe!threadStart(void * arg) Line 97C++
Running on 3.0.7.33374.
Any ideas what I'm doing wrong?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> > What the error "Authentication error
> > connection shutdown" in firebird.log means?
>
> May be something gone wrong with sec-db attachments cache. Can you
> please check - if you wait a minute or 2 w/o restart will it help?
It will not. It will continue thro
nect. Once the Firebird is restarted, everything is OK - same
application, same everything.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Not needed for me. At the moment I'm fine with IBlob, because so far the
performance of my code is good enough.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> IXpbBuilder* pb = utl->getXpbBuilder(, IXpbBuilder::BPB,
> NULL, 0);
Looks like FB3 does not have BPB
(https://github.com/FirebirdSQL/firebird/blob/R3_0_7/src/include/firebird/IdlFbInterfaces.h#L3827).
Is it only in FB4?
--
Mgr. Jiří Činčura
https://www.tabsovers
> a) user stream (not segmented) blobs
Is there some docs for that? What I found in "Using_OO_API.html" is just "Last
two parameters are required only if you want to use blob filters or use stream
blob, that's out of scope here.".
--
Mgr. Jiří Činčura
https:/
Hi,
Is there a sweet spot for the buffer size/length when using IBlob::putSegment?
Or is it fine to put even 1 byte segments?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Looks like it's what Jiri wants.
>
> It has special support for cursors and its internals record sources.
It's not probably what I want, because my focus is on processing the trace file
for kind of later/offline/post-mortem analysis.
But anyway, where I can read more?
--
Mgr. Jiř
Done.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ce tracing. A SP takes for example 100ms. And there
are 3 updates inside. One update takes 98ms, the remaining two 1ms each. I want
to obviously focus on the 98ms one.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/l
xecuted some update on a table with
trigger).
Thanks.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
statements it works as expected.
Thanks.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
More info at this https://www.tabsoverspaces.com/id/233858 link.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
More info at this https://www.tabsoverspaces.com/id/233856 link.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Wouldn't the warning be a better fit for this case?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ncellation there's always race condition that the currently
executing thing will finish right before the cancellation is sent/processed.
Obviously, I can ignore this particular error and "hide" it from user. I'm
interested in the reasoning.
--
Mgr. Jiří Činčura
https://www.tabsoversp
Hi *,
does fb_cancel_raise cancel also currently running prepare
(op_prepare_statement)?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> If you rebuild the index, there will be no such problem, because the
> date is stored in UTC, so that will not have changed.
Yeah, silly me. Obviously the timezone info isn't lost when converting to UTC
and storing in index. What was I thinking??? 路♂️
--
Mgr. Jiří Činčura
unique constraint is gonna complain, although it's different local time. Again,
is that the expected experience?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi *,
for the unique constraint the times are equivalent if the UTC time is
equivalent. How's this going to be handled when some timezone region changes
its offset and the UTC time becomes the same?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web
> SELECT POSITION(cast(ascii_char(1) AS BLOB SUB_TYPE BINARY),
> CAST(x'0001' as blob sub_type binary)) FROM rdb$database;
Nice. Thanks. It even looks like I don't need the first CAST.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
(hence I could generate x'...' literal), but it can be i.e. column (and hence
the literal approach would not work).
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Ah, there's my problem. With little bit of casting I think I can make it work.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hi *,
is there a reason why POSITION does not work on binary blobs? I would expect
something like `POSITION(blob, 0x1)` to work.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> yes, this is what I found but there is no definition RDB $ FIELD_TYPE =
> 30 or 31 in rdb $ types in FB4, what is it for?
The "extended" definition is just for protocol, where the message contains also
the TZ offset. But this is never stored.
--
Mgr. Ji
In Firebird 4. For example here
https://github.com/FirebirdSQL/firebird/blob/T4_0_0_RC1/src/include/firebird/impl/sqlda_pub.h#L81.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Thu, Feb 4, 2021, at 09:26, Norbert Saint Georges wrote:
> Hi,
> In the NETProvider v8.0 code I ca
>Why not to begin use the old parameter for listed things
Seconded.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Yes, good point :)
> Onli some new feature need new client. But It is rather rare, but
> happen as e.g compression as i remember.
Basically whenever a new protocol version is created.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface
> Yes, client library must be 32 bit too for the long time.
> Many existig applications are 32bit and cannot be "migrated" to 64 bit
> in the near future
On the other hand, these applications can still use older fbclient.dll.
--
Mgr. Jiří Činčura
https://www.tabsoverspac
Hi *,
what action should I do to get isc_arg_warning?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
101 - 200 of 647 matches
Mail list logo