Re: [Firebird-devel] Setting blob values to a binary hex literal returns strange results (PSQL)

2014-09-26 Thread Jim Starkey
I'm not going to promise that this is current, but here is what I think is happening. Blobs have types assigned when they are created. Blob types, by and large, are advisory, but if you ask to open a blob with a specific type, say "text", the system will attempt to find a blob filter from the

Re: [Firebird-devel] Setting blob values to a binary hex literal returns strange results (PSQL)

2014-09-26 Thread Martijn Tonies (Upscene Productions)
>>> 0x40 = 64, you're basically sayg c = 64, why do you think it should not >>> be converted to '64' ? >> >> Perhaps, because it is a binary blob, not text one. >> > >Numbers are converted to string, just like when you would do this with a >VARCHAR or CHAR. When I use: c = 0x414243; I get:

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread Leyne, Sean
> > If v3 has the SMP improvements which are planned, why would we > continue to support 3 engine versions? > > > > Classic and SuperClassic would have functionality which covers all use > > cases. > > v3 has the SMP improvements in *SuperServer*. Ok FYI, the 2.5.x release notes suggest that

Re: [Firebird-devel] Setting blob values to a binary hex literal returns strange results (PSQL)

2014-09-26 Thread Mark Rotteveel
On 26-9-2014 18:14, Dimitry Sibiryakov wrote: > 26.09.2014 18:11, Adriano dos Santos Fernandes wrote: >> 0x40 = 64, you're basically sayg c = 64, why do you think it should not >> be converted to '64' ? > > Perhaps, because it is a binary blob, not text one. > Numbers are converted to string,

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread Mark Rotteveel
On 26-9-2014 18:11, Leyne, Sean wrote: >> XNET is not an option for Jaybird or .NET users. > > Wasn't aware of that. Well, actually it is possible with Jaybird (and probably with the .NET provider as well), but most Java developers prefer not to use native library dependencies. >>> since the lo

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread Dmitry Yemanov
26.09.2014 20:11, Leyne, Sean wrote: > > If v3 has the SMP improvements which are planned, why would we continue to > support 3 engine versions? > > Classic and SuperClassic would have functionality which covers all use cases. v3 has the SMP improvements in *SuperServer*. Dmitry

Re: [Firebird-devel] Setting blob values to a binary hex literal returns strange results (PSQL)

2014-09-26 Thread Dimitry Sibiryakov
26.09.2014 18:11, Adriano dos Santos Fernandes wrote: > 0x40 = 64, you're basically sayg c = 64, why do you think it should not > be converted to '64' ? Perhaps, because it is a binary blob, not text one. -- WBR, SD.

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread Leyne, Sean
> XNET is not an option for Jaybird or .NET users. Wasn't aware of that. > > since the long-term path for Firebird is the deprecation of > > SuperServer > > You're surely misinformed. If v3 has the SMP improvements which are planned, why would we continue to support 3 engine versions? Class

Re: [Firebird-devel] Setting blob values to a binary hex literal returns strange results (PSQL)

2014-09-26 Thread Adriano dos Santos Fernandes
0x40 = 64, you're basically sayg c = 64, why do you think it should not be converted to '64' ? Looks like you mean x'40', that's a different thing. Adriano On 26/09/2014 12:54, Martijn Tonies (Upscene Productions) wrote: > > > Hi all, > I’ve got this following problem and example: > SET TERM ^

[Firebird-devel] Setting blob values to a binary hex literal returns strange results (PSQL)

2014-09-26 Thread Martijn Tonies (Upscene Productions)
Hi all, I’ve got this following problem and example: SET TERM ^^ ; create PROCEDURE DEBUG_TEST returns ( C BLOB SUB_TYPE 0, M2 Numeric(18,0), I2 VarChar(10)) AS declare variable i varchar(4) = X'4131'; declare variable m numeric(18) = 0x2121; declare variable b blob; begin c = 0x40;

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread Dmitry Yemanov
26.09.2014 19:13, Leyne, Sean wrote: > > Localhost is not necessary for Classic and SuperClassic engine (I not sure of > SuperServer, we don't use this mode), since local mode connections are > supported XNET is not an option for Jaybird or .NET users. > since the long-term path for Firebird is

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread Leyne, Sean
Marius, > Maybe is worth to be  implemented in Firebird also > > http://blogs.technet.com/b/wincat/archive/2012/12/05/fast-tcp-loopback- > performance-and-low-latency-with-windows-server-2012-tcp-loopback-fast- > path.aspx Localhost is not necessary for Classic and SuperClassic engine (I not sur

[Firebird-devel] [FB-Tracker] Created: (CORE-4560) gfix -v -full hangs without message "Resource temporarily unavailable" when .fdb is opened by some attach (only in SuperCLASSIC)

2014-09-26 Thread Pavel Zotov (JIRA)
gfix -v -full hangs without message "Resource temporarily unavailable" when .fdb is opened by some attach (only in SuperCLASSIC) Key: CORE-4560

[Firebird-devel] TCP Loopback fast path in Windows

2014-09-26 Thread marius adrian popa
I have seen this patch for openjdk http://mail.openjdk.java.net/pipermail/net-dev/2014-September/008685.html Maybe is worth to be implemented in Firebird also http://blogs.technet.com/b/wincat/archive/2012/12/05/fast-tcp-loopback-performance-and-low-latency-with-windows-server-2012-tcp-loopback

Re: [Firebird-devel] MS SQL over SMB2

2014-09-26 Thread Dimitry Sibiryakov
25.09.2014 21:58, Leyne, Sean wrote: > Your posts suggest that you have fundamental (almost philosophical) problems > with the idea of using SMB v3 storage for FB purposes. I have one fundamental problem indeed: I know what clusters can do and what they cannot. Unfortunately, they have no m