Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots
25.04.2016 22:34, Michal Kubecek wrote: > No, that's not the reason. If everything works the way it's supposed to, > the connection fails within one roundtrip and client doesn't have to > wait for a full second. For :: address, there is even less reason for > having to wait for a timeout. Unless there is a black hole-type firewall like Win7's FW in stealth mode: https://technet.microsoft.com/en-us/library/dd448557%28WS.10%29 -- WBR, SD. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots
On Mon, Apr 25, 2016 at 05:46:24PM +0200, Dimitry Sibiryakov wrote: > 25.04.2016 17:42, Michal Kubecek wrote: > > A 2.5 server, however, does only listen to IPv4 connections and for > > some reason, client has to wait for timeout of the connection to :: > > which is tried first. > > Reason is simple: addresses for a host are tried one-by-one. No, that's not the reason. If everything works the way it's supposed to, the connection fails within one roundtrip and client doesn't have to wait for a full second. For :: address, there is even less reason for having to wait for a timeout. Michal Kubecek -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
On 25/04/2016 11:29, Dimitry Sibiryakov wrote: > 25.04.2016 16:23, Adriano dos Santos Fernandes wrote: >> Something like DBMS_SQL (and DBMS_LOB too, BTW) would be very useful >> to Firebird >What value they can add? > DBMS_SQL - allow dynamic (count, types) usage of parameters; query inspection (describe) DBMS_LOB - avoid blob trashing Adriano -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5213) Database may get decrypted after changing couple of bytes in database header w/o 'agreement' from crypt plugin.
Database may get decrypted after changing couple of bytes in database header w/o 'agreement' from crypt plugin. --- Key: CORE-5213 URL: http://tracker.firebirdsql.org/browse/CORE-5213 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.0 Reporter: Alexander Peshkov For databases distributed in encrypted form it's necessary to avoid any ability to be decrypted by client including one mentioned in this issue. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots
25.04.2016 17:42, Michal Kubecek wrote: > A 2.5 server, however, does only listen to IPv4 connections and for some > reason, client has to wait for timeout of the connection to :: which is > tried first. Reason is simple: addresses for a host are tried one-by-one. -- WBR, SD. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots
On Mon, Apr 25, 2016 at 05:07:13PM +0200, Stefan Heymann wrote: > >>Try to set option IPv6V6Only to true in firebird.conf and see if > >>it makes any difference. > > > This directive affects only listening sockets (i.e. a server) and > > would actually do the exact opposite: make the server listening on > > (default) address :: accept only IPv6 connections (to any address). > > To accept only IPv4 connections, you would rather want > > "RemoteBindAddress 0.0.0.0" (or e.g. 127.0.0.1). > > We're now talking about Fb3 servers, right? Wenn I connect to a Fb3 > server (using the Fb3 client and "localhost" as the host name), the > connection is quick. > > The problem is when I use the Fb3 client to connect to a Fb2.5 > database. Then there is this one second delay. Yes, that's why I explained that the IPv6V6Only directive cannot help you as it does only affect server so that it can't change the behaviour of a 3.0 client (and a 2.5 server wouldn't recognize it at all). > Connection time using the new Fb3 fbclient.dll: > - 3.0 database using "localhost" - quick > - 3.0 database using "127.0.0.1" - quick > - 2.5 database using "localhost" - slow > - 2.5 database using "127.0.0.1" - quick This agrees with the theory: "localhost" resolves to both :: and 127.0.0.1 and according to your system's rules, :: is preferred. With 3.0 database listening to any IPv6 or IPv4 connection, both are quick. A 2.5 server, however, does only listen to IPv4 connections and for some reason, client has to wait for timeout of the connection to :: which is tried first. Michal Kubecek -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] User password for encryption
25.04.2016 17:03, Alex Peshkoff wrote: > Unlike other methods key in this case is not touched by open source code > making possibility of stealing it much smaller. It doesn't matter if engine will decrypt whole database for you after changing couple of bytes in header. Key is pointless, database is a real target. -- WBR, SD. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots
>>Try to set option IPv6V6Only to true in firebird.conf and see if it >>makes any difference. > This directive affects only listening sockets (i.e. a server) and would > actually do the exact opposite: make the server listening on (default) > address :: accept only IPv6 connections (to any address). To accept only > IPv4 connections, you would rather want "RemoteBindAddress 0.0.0.0" (or > e.g. 127.0.0.1). We're now talking about Fb3 servers, right? Wenn I connect to a Fb3 server (using the Fb3 client and "localhost" as the host name), the connection is quick. The problem is when I use the Fb3 client to connect to a Fb2.5 database. Then there is this one second delay. To sum things up: Connection time using the new Fb3 fbclient.dll: - 3.0 database using "localhost" - quick - 3.0 database using "127.0.0.1" - quick - 2.5 database using "localhost" - slow - 2.5 database using "127.0.0.1" - quick Regards Stefan -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] User password for encryption
On 04/25/2016 03:51 PM, Emil Totev wrote: >> From: Alex Peshkoff >> Subject: Re: [Firebird-devel] User password for encryption >> To: firebird-devel@lists.sourceforge.net >> Message-ID: <571e0924.3010...@mail.ru> >> Content-Type: text/plain; charset=windows-1252; format=flowed >> >> On 04/25/2016 11:28 AM, Emil Totev wrote: >>> How difficult would it be to get the user password to the encryption / >>> key holder plugin, especially for an embedded connection? >> I will start from the most simple part - embedded connection. As far as >> I understand you ask about password which is used to login to the server >> (isc_dpb_password) Unfortunately question makes no sense - for embedded >> connection password is not needed at all and no authentication plugin is >> used (even when password is present in DPB it's just ignored). On the >> other hand it's not too hard to add to firebird engine a code, passing >> isc_dpb_password value to key holder plugin (as one of a keys for >> example). But that hardly makes much sense on my mind. > Then, how would you pass a key to the engine in the embedded case? If the key to be passed from application the best way is to use callback. Unlike other methods key in this case is not touched by open source code making possibility of stealing it much smaller. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
25.04.2016 16:23, Adriano dos Santos Fernandes wrote: > Something like DBMS_SQL (and DBMS_LOB too, BTW) would be very useful > to Firebird What value they can add? -- WBR, SD. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
On 25/04/2016 09:32, Dmitry Yemanov wrote: > 25.04.2016 15:28, Mark Rotteveel wrote: >> Still missing from the list: >> * Substring with regex: >> http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring >> >> Might work; haven't tried it yet but I think it should be possible now >> * Index using a custom function >> * Functions as column default >> >> Incorrect: >> * Session local temporary tables : Firebird doesn't have this > Also: > > Dynamic SQL in functions(*) - NO > Dynamic SQL in triggers(*) - NO > > Why do they ignore EXECUTE STATEMENT? > Must say that when I first read it, I thought it was ok thinking in something like Oracle's DBMS_SQL. So: 1) We have dynamic SQL in functions/triggers 2) Something like DBMS_SQL (and DBMS_LOB too, BTW) would be very useful to Firebird Adriano -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
On 2016-04-25 13:32, Dmitry Yemanov wrote: > 25.04.2016 15:28, Mark Rotteveel wrote: >> >> Still missing from the list: >> * Substring with regex: >> >> http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring >> >> Might work; haven't tried it yet but I think it should be possible >> now >> * Index using a custom function >> * Functions as column default >> >> Incorrect: >> * Session local temporary tables : Firebird doesn't have this > > Also: > > Dynamic SQL in functions(*) - NO > Dynamic SQL in triggers(*) - NO > > Why do they ignore EXECUTE STATEMENT? Probably because it is impossible to check everything (that is also why they have an e-mailaddress listed for corrections). Mark -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5212) PK constraint should be prevented from dropping if there is procedure/trigger which uses it in UPDATE OR INSERT statement (otherwise such SP will wor
PK constraint should be prevented from dropping if there is procedure/trigger which uses it in UPDATE OR INSERT statement (otherwise such SP will work incorrect) - Key: CORE-5212 URL: http://tracker.firebirdsql.org/browse/CORE-5212 Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 3.0.0, 4.0 Initial, 2.5.5 Reporter: Pavel Zotov Consider script: === set echo on; create or alter procedure sp_test as begin end; recreate table test( u int not null, v int not null, w int not null ); alter table test add constraint test_pk primary key( u ); commit; set term ^; create or alter procedure sp_test(a_u int, a_v int, a_w int) as begin update or insert into test( u, v, w ) values ( :a_u, :a_v, :a_w ); end ^ set term ;^ commit; execute procedure sp_test( 1, 10, 20); execute procedure sp_test( 2, 20, 40); execute procedure sp_test( 1, 11, 22); select * from test; delete from test; commit; alter table test drop constraint test_pk; commit; -- // alter table test add constraint test_pk primary key( v ); -- \\ commit; show table test; /* set term ^; create or alter procedure sp_test(a_u int, a_v int, a_w int) as begin update or insert into test( u, v, w ) values ( :a_u, :a_v, :a_w ); end ^ set term ;^ commit; */ execute procedure sp_test( 1, 10, 20); execute procedure sp_test( 2, 20, 40); execute procedure sp_test( 1, 11, 22); select * from test; === If you will NOT make recreation of SP_TEST after dropping PK (and assign it to another column), this SP will work wrong: it seems like OLD PK definition is stored somewhere. With __NEW__ primary key (column'V') last three statements will produce content of table TEST like with __OLD__ PK = 'U': === execute procedure sp_test( 1, 10, 20); execute procedure sp_test( 2, 20, 40); execute procedure sp_test( 1, 11, 22); select * from test; UVW 1 11 22 2 20 40 === So, one need to empty bodies of all such procedures / triggers before this PK will be dropped, and later to fill them again + recompile. It will be great if this job could be done in the single transaction by engine itself. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] User password for encryption
> From: Alex Peshkoff > Subject: Re: [Firebird-devel] User password for encryption > To: firebird-devel@lists.sourceforge.net > Message-ID: <571e0924.3010...@mail.ru> > Content-Type: text/plain; charset=windows-1252; format=flowed > > On 04/25/2016 11:28 AM, Emil Totev wrote: >> How difficult would it be to get the user password to the encryption / >> key holder plugin, especially for an embedded connection? > > I will start from the most simple part - embedded connection. As far as > I understand you ask about password which is used to login to the server > (isc_dpb_password) Unfortunately question makes no sense - for embedded > connection password is not needed at all and no authentication plugin is > used (even when password is present in DPB it's just ignored). On the > other hand it's not too hard to add to firebird engine a code, passing > isc_dpb_password value to key holder plugin (as one of a keys for > example). But that hardly makes much sense on my mind. Then, how would you pass a key to the engine in the embedded case? > What about remote case - passing password in current state f code is > close to impossible. Password NEVER travels over the wire (except of > legacy authentication). Certainly one can write plugin which will send > password from client to server but that's definitely very bad idea from > security POV. Certainly a trick similar to embedded can help (and > password will be sent over already encrypted line in that case) but I'm > afraid that's a bit not what you were asking about. OK. I fully agree. Let's forget about remote and stick to embedded. >> If possible >> at all, would this require new authentication plugin or key holder >> plugin or both? > > New key holder plugin and some changes in it's interfaces. > >> Applications using embedded connections would benefit most from >> database encryption, and using the password (which can be supplied, >> but is not used for authentication) for this seems to be an easy way >> to seamlessly integrate it. > > Don't think so. Sending a key (password will be a key in this case, > yes?) in DPB is the best way to help malicious user steal it. > There is no "sending" in the embedded case. Most current software has the ability to collect a password from the user and pass it to the provider. Why not use this to add database encryption almost transparently? Do you see any problems with it? Regards Emil -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
And our DDL is not so transactional as they think ;-) Dmitry -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
25.04.2016 15:28, Mark Rotteveel wrote: > > Still missing from the list: > * Substring with regex: > http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring > > Might work; haven't tried it yet but I think it should be possible now > * Index using a custom function > * Functions as column default > > Incorrect: > * Session local temporary tables : Firebird doesn't have this Also: Dynamic SQL in functions(*) - NO Dynamic SQL in triggers(*) - NO Why do they ignore EXECUTE STATEMENT? Dmitry -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
On 2016-04-25 13:11, marius adrian popa wrote: > http://www.sql-workbench.net/dbms_comparison.html [1] > > > Links: > -- > [1] http://www.sql-workbench.net/dbms_comparison.html Still missing from the list: * Substring with regex: http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring Might work; haven't tried it yet but I think it should be possible now * Index using a custom function * Functions as column default Incorrect: * Session local temporary tables : Firebird doesn't have this Mark -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird.pas for the windows build
On 04/25/2016 01:57 PM, Simonov Denis wrote: > Alex Peshkoff писал(а) в своём письме Mon, 28 Mar 2016 > 12:46:02 +0300: > >> On 03/25/2016 03:51 PM, Alex Peshkoff wrote: >>> On 03/25/2016 12:48 PM, preeves wrote: On Thu, 24 Mar 2016 12:35:25 +0300 Alex Peshkoff wrote: > On 03/23/2016 06:39 PM, preeves wrote: >> Firebird.pas is generated in the posix builds but it is not >> generated in the windows builds. Posix builds generate it via this >> target: >> >> $(API_PAS_FILE): $(IDL_FILE) $(PASCAL_SOURCES) $(TMP_FUNCS) >> $(CLOOP) $(IDL_FILE) pascal $@ Firebird --uses SysUtils \ >> --interfaceFile $(PAS_ROOT)/Pascal.interface.pas \ >> --implementationFile $(PAS_ROOT)/Pascal.implementation.pas >> \ --exceptionClass FbException \ >> --functionsFile $(TMP_FUNCS) \ >> --prefix I >> >> There seems to be more going on here than simple file >> concatenation. > Much more. > AFAICT a git push will pick up a changed Firebird.pas each time it is rebuilt on a posix host, so it won't be too difficult to keep it up-to-date. >>> Well, if nobody will provide strong arguments against this I will commit >>> the generated file on Monday. >>> >> Added to B3_0, still hope on correct approach in fb4. >> > In Firebird 3.0 release under windows again absent Firebird.pas file. It > is not available in the snapshot too. Denis, unfortunately 'Added' means here that generated Firebird.pas was placed into git tree. Please get it from linux binaries or source tarball (src/include/gen) or from github (B3_0_Release). -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases
http://www.sql-workbench.net/dbms_comparison.html -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;zFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] User password for encryption
On 04/25/2016 11:28 AM, Emil Totev wrote: > How difficult would it be to get the user password to the encryption / > key holder plugin, especially for an embedded connection? I will start from the most simple part - embedded connection. As far as I understand you ask about password which is used to login to the server (isc_dpb_password) Unfortunately question makes no sense - for embedded connection password is not needed at all and no authentication plugin is used (even when password is present in DPB it's just ignored). On the other hand it's not too hard to add to firebird engine a code, passing isc_dpb_password value to key holder plugin (as one of a keys for example). But that hardly makes much sense on my mind. What about remote case - passing password in current state f code is close to impossible. Password NEVER travels over the wire (except of legacy authentication). Certainly one can write plugin which will send password from client to server but that's definitely very bad idea from security POV. Certainly a trick similar to embedded can help (and password will be sent over already encrypted line in that case) but I'm afraid that's a bit not what you were asking about. > If possible > at all, would this require new authentication plugin or key holder > plugin or both? New key holder plugin and some changes in it's interfaces. > Applications using embedded connections would benefit most from > database encryption, and using the password (which can be supplied, > but is not used for authentication) for this seems to be an easy way > to seamlessly integrate it. Don't think so. Sending a key (password will be a key in this case, yes?) in DPB is the best way to help malicious user steal it. -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5211) Compiler error for assignment variable to empty string which is enclosed in DOUBLE QUOTES differ in 3.0 vs previous versions.
Compiler error for assignment variable to empty string which is enclosed in DOUBLE QUOTES differ in 3.0 vs previous versions. - Key: CORE-5211 URL: http://tracker.firebirdsql.org/browse/CORE-5211 Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 3.0.0, 4.0 Initial Reporter: Pavel Zotov Priority: Minor Consider script which shoud raise compiler error (because of DOUBLE quotes in assignment): set term ^; execute block returns(o varchar(10)) as begin o = "qwe"; end ^ If you run this script on 2.1, 2.5 and 3.0 you will get the same error: === Statement failed, SQLSTATE = 42S22 Dynamic SQL Error -SQL error code = -206 -Column unknown -qwe === But if we replace "qwe" with empty string ( o = ""; ) then we get: === Statement failed, SQLSTATE = 42000 Dynamic SQL Error -SQL error code = -104 -Zero length identifiers are not allowed === (I've checked on WI-V3.0.0.32490) As for 2.1 and 2.5 - error will be the same, but without showing value empty string (though this could be clarified by something like ): === Statement failed, SQLSTATE = 42S22 Dynamic SQL Error -SQL error code = -206 -Column unknown === Can the message "-Zero length identifiers are not allowed" be replaced with old one ? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird.pas for the windows build
Adriano dos Santos Fernandes wrote Thu, 24 Mar 2016 13:36:27 +0300: > On 24/03/2016 06:35, Alex Peshkoff wrote: >> How are we meant to do this in the windows build? >> Paul, I see 2 alternatives. >> 1. (correct) Build cloop and execute same command. >> > > Is the Windows guys doing manual editing of the generated file after API > changes? > In principle, you can not include in Firebird.pas snapshots, if it is difficult to collect each time. But then 1. cloop tool must be compiled and included in the kit Firebird utilities. 2. It should be documented. At a minimum, the instrument itself must provide help for the options with the /? or --help. Now to find out you have to read the source code. 3. The release archives and distribution Firebird.pas file should be included. Release and subrelease comes not so often. > > Adriano > > > -- > Transform Data into Opportunity. > Accelerate data analysis in your applications with > Intel Data Analytics Acceleration Library. > Click to learn more. > http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > -- Simonov Denis -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird.pas for the windows build
Alex Peshkoff писал(а) в своём письме Mon, 28 Mar 2016 12:46:02 +0300: > On 03/25/2016 03:51 PM, Alex Peshkoff wrote: >> On 03/25/2016 12:48 PM, preeves wrote: >>> On Thu, 24 Mar 2016 12:35:25 +0300 >>> Alex Peshkoff wrote: >>> On 03/23/2016 06:39 PM, preeves wrote: > Firebird.pas is generated in the posix builds but it is not > generated in the windows builds. Posix builds generate it via this > target: > > $(API_PAS_FILE): $(IDL_FILE) $(PASCAL_SOURCES) $(TMP_FUNCS) >$(CLOOP) $(IDL_FILE) pascal $@ Firebird --uses SysUtils \ >--interfaceFile $(PAS_ROOT)/Pascal.interface.pas \ >--implementationFile $(PAS_ROOT)/Pascal.implementation.pas > \ --exceptionClass FbException \ >--functionsFile $(TMP_FUNCS) \ >--prefix I > > There seems to be more going on here than simple file > concatenation. Much more. >> >>> AFAICT a >>> git push will pick up a changed Firebird.pas each time it is rebuilt on >>> a posix host, so it won't be too difficult to keep it up-to-date. >> Well, if nobody will provide strong arguments against this I will commit >> the generated file on Monday. >> > > Added to B3_0, still hope on correct approach in fb4. > In Firebird 3.0 release under windows again absent Firebird.pas file. It is not available in the snapshot too. > > -- > Transform Data into Opportunity. > Accelerate data analysis in your applications with > Intel Data Analytics Acceleration Library. > Click to learn more. > http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > -- Simonov Denis -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] User password for encryption
How difficult would it be to get the user password to the encryption / key holder plugin, especially for an embedded connection? If possible at all, would this require new authentication plugin or key holder plugin or both? Applications using embedded connections would benefit most from database encryption, and using the password (which can be supplied, but is not used for authentication) for this seems to be an easy way to seamlessly integrate it. Emil -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Feature request & discussion for V4 (same as for V3)
25.04.2016 10:35, Christian Waldmann wrote: > In Firebird CORE-659 (http://tracker.firebirdsql.org/browse/CORE-659) there > is a collection of requests for spatial index, e.g. R*Tree or GiST, for GIS > applications and other. Spatial indexes are also fine to find events in a > interval of time. > > R* Tree at https://en.wikipedia.org/wiki/R*_tree > GiST at http://gist.cs.berkeley.edu/ Unfortunately, we don't have resources for this task. Only if some 3rd party is willing to develop the code and contribute it. I know that RedSoft is interested, but I don't know what is their roadmap on this. > I think the support of spatial indexes can bring a lot of new users from > SQLite (https://www.sqlite.org/rtree.html ) and PostgreSQL > (http://www.postgresql.org/docs/8.1/static/indexes-types.html) to FireBird. Probably for SQLite, unlikely for PGSQL. Dmitry -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Feature request & discussion for V4 (same as for V3)
In Firebird CORE-659 (http://tracker.firebirdsql.org/browse/CORE-659) there is a collection of requests for spatial index, e.g. R*Tree or GiST, for GIS applications and other. Spatial indexes are also fine to find events in a interval of time. R* Tree at https://en.wikipedia.org/wiki/R*_tree GiST at http://gist.cs.berkeley.edu/ I think the support of spatial indexes can bring a lot of new users from SQLite (https://www.sqlite.org/rtree.html ) and PostgreSQL (http://www.postgresql.org/docs/8.1/static/indexes-types.html) to FireBird. Christian Waldmann -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
