[Firebird-devel] Proper nbackup spelling
Hi *, how's nbackup properly spelled? Nbackup or nbackup or NBackup or nBackup or ...? JC -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4208) IIF and LF CR bug
IIF and LF CR bug - Key: CORE-4208 URL: http://tracker.firebirdsql.org/browse/CORE-4208 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.2 Reporter: Attila Molnár Priority: Minor Hi! SELECT REPLACE('a' || IIF(1 = 1, ' ', ASCII_CHAR(13) || ASCII_CHAR(10)) || 'b', ' ', '*') FROM rdb$database returns a*b, but it shold be a**b, due to padding to 2. SELECT REPLACE('a' || IIF(1 = 1, ' ', x'0D0A') || 'b', ' ', '*') FROM rdb$database returns a*, but it shold be a**b, due to padding to 2. Also in this case padding char is #0, not #32. -- 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 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record Encoding
On 09/04/13 18:11, Jim Starkey wrote: So here's another seriously heretical thought. If you're planning for Firebird to hang around another 27 years, it's time to define a modern OO API that is easy to use from modern languages, is flexible and extensible, supports an efficient remote protocol, and can fully support the legacy SQL APIs as a proper client layer and maybe even BLR, if that's still important. That's what was done in FB3, except probably one point - what do you mean under 'supports an efficient remote protocol'? API is not _directly_ releated with remote protocol. In FB3 we kept remote protocol more or less (sooner more) as it was before. But new OO API, working with that protocol, was defined. SQLDA API is implemented as a layer over it (in FB3 - directly in yvalve, i.e. yvalve currently supports both APIs). -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] RES: RES: RES: Firebird Alpha 1 GBAK bug
Thanks!! It worked now! I Will start testing FB3, thanks Dmitry! -Mensagem original- De: Dmitry Yemanov [mailto:firebi...@yandex.ru] Enviada em: quinta-feira, 5 de setembro de 2013 00:41 Para: For discussion among Firebird Developers Assunto: Re: [Firebird-devel] RES: RES: Firebird Alpha 1 GBAK bug 04.09.2013 23:34, Fabiano - Desenvolvimento SCI wrote: Now I get another problem: gbak:committing metadata gbak: ERROR:invalid request BLR at offset 1769 gbak: ERROR: BLR syntax error: expected variable identifier at offset 1770, encountered 76 gbak: ERROR: Error while parsing procedure SP_TERCEIRO's BLR gbak:Exiting before completion due to errors It has been fixed yesterday, so the next snapshot build (#30636 or above) should help. Dmitry -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] RES: RES: RES: Firebird Alpha 1 GBAK bug
By the way: CORE-3661 is resolved with this too. I originally created CORE-3661, and now is solved. Thanks. -Mensagem original- De: Fabiano - Desenvolvimento SCI [mailto:fabi...@sci10.com.br] Enviada em: quarta-feira, 4 de setembro de 2013 16:34 Para: 'For discussion among Firebird Developers' Assunto: [Firebird-devel] RES: RES: Firebird Alpha 1 GBAK bug O would like to appologies to all... We have 2 hardcoded UDF's in our database - and we do not use those at all! So, I removed those UDF's from our database and tried again. It almost works! Now I get another problem: gbak:committing metadata gbak: ERROR:invalid request BLR at offset 1769 gbak: ERROR: BLR syntax error: expected variable identifier at offset 1770, encountered 76 gbak: ERROR: Error while parsing procedure SP_TERCEIRO's BLR gbak:Exiting before completion due to errors Maybe is an error parsing this stored procedure? I'll try compiling it myself and in case of error will show that code. Thanks a lot! -Mensagem original- De: Thomas Steinmaurer [mailto:t...@iblogmanager.com] Enviada em: quarta-feira, 4 de setembro de 2013 15:36 Para: For discussion among Firebird Developers Assunto: Re: [Firebird-devel] RES: Firebird Alpha 1 GBAK bug Dmitry, I tried again with FB3 today's version and it a little bit different. It stops restoring backup with this: (...) gbak:restoring parameter BDSEQCTA for stored procedure gbak:restoring parameter BDCODCENTROS for stored procedure gbak:restoring parameter BDCODTPCC for stored procedure gbak:restoring parameter BDNOMTPCC for stored procedure gbak:restoring parameter BDSALANT for stored procedure gbak:restoring parameter BDSALMOV for stored procedure gbak:restoring parameter BDSALATU for stored procedure gbak:restoring parameter BDANAVER for stored procedure gbak:restoring parameter BDFORMULA for stored procedure gbak:restoring parameter BDGRPCTA for stored procedure gbak:restoring parameter BDAPECTA for stored procedure gbak:restoring exception EX_DATE gbak:restoring exception NAO_EXCLUIR_TITULO gbak:restoring exception ODSERROR gbak:restoring exception SALDO gbak:restoring exception EX_BLOQLAN gbak:restoring exception EX_GETCHAVELAN gbak:restoring exception EX_TAMANHOCHAVE gbak:committing metadata and error: gbak: ERROR:Access to UDF/BLOV-filter module C:\Arquiv~1\Firebird\Firebird_2_0\UDF\sciudf.dll is denied by server administrator gbak:Exiting before completion due to errors Looks a bit like your UDF library isn't accessible for Firebird 3. Or perhaps you did declare your UDF with a full-qualified path (the one above) to the UDF library dll? -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4209) Firebird memory not released (Using superserver) *Linux*
Firebird memory not released (Using superserver) *Linux* Key: CORE-4209 URL: http://tracker.firebirdsql.org/browse/CORE-4209 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.2 Update 1, 2.5.1 Environment: Linux Ubuntu 11.04 32 bits FirebirdSS-2.5.2.26540-0.i686 Reporter: Roque Priority: Critical This bug is the exact same bug description found on http://tracker.firebirdsql.org/browse/CORE-3533, but now on Linux. Memory is *only* freed when all users disconnect. To reproduce it, just follow the simple procedure below: - Open an ISQL session or an instance of any application using FB. (This session will be the last one to be closed) - Try working with others instances of the same application or open several ISQL sessions using the same DB. Make some heavy operations. - Keep checking the memory every time. (use 'top' command or 'ps axl | grep fbserver') - Close all instances, except the first one. - Check the memory. It is *not* released as it should. - Now close that ISQL session you opened in the beginning. - Check the memory. Now it is all there, given back to the system. I can supply additional information and made additional tests if needed. Thanks. -- 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 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record Encoding
On 9/5/2013 4:28 AM, Alex Peshkoff wrote: On 09/04/13 18:11, Jim Starkey wrote: So here's another seriously heretical thought. If you're planning for Firebird to hang around another 27 years, it's time to define a modern OO API that is easy to use from modern languages, is flexible and extensible, supports an efficient remote protocol, and can fully support the legacy SQL APIs as a proper client layer and maybe even BLR, if that's still important. That's what was done in FB3, except probably one point - what do you mean under 'supports an efficient remote protocol'? API is not _directly_ releated with remote protocol. In FB3 we kept remote protocol more or less (sooner more) as it was before. But new OO API, working with that protocol, was defined. SQLDA API is implemented as a layer over it (in FB3 - directly in yvalve, i.e. yvalve currently supports both APIs). OK, I haven't looked at the protocol for about a million years, so consider this a critique of my earlier work, not necessarily the current state of affairs. Network efficiency has a number of elements. The most important is reducing the number of round trips to a bare minimum. Following that (distantly) is minimizing the number of bytes sent. Last is minimizing the CPU load to encode/decode communication packets. The keys to reducing round trips are to bundle metadata with data to eliminate the need for info trips and, most importantly, to batch record retrievals and batch inserts into single large packets. Sending a MB worth of records is obviously a great win. So is implementing the equivalent of the JDBC batch update semantics. The encoding we've been talking about for record encoding is also an excellent encoding for communication, being both dense and platform independent, eliminating the need for separate homogenous / heterogeneous modes of the original Interbase protocol. And, since all numbers and strings can be arbitrarily large without wasting bytes, there are no tradeoffs necessary on field size (as Ann loves to point out, I'm a victim of the bit depression and tend to makes things a little smaller than I should to save space). For both Netfrastructure and NuoDB I've used JDBC as the client API, though the protocols were quite different. One of the advantages of starting over from time to time is that you get/have to re-evaluate everything thing you've done in past, partly for efficiency and partly to avoid accusation of piracy. It's a good habit to get into, however. When you find a better way to something, go for it. A good example of this came up in a master class class I was teaching before I left NuoDB. Somehow we stumbled onto the topic of string to date conversions. While I was pointing out that the worst part of starting a new software company was rewriting stringToDate, a completely new, incredibly efficient, open ended algorithm for that class of conversions occurred to me. It's really cute, and if anyone is interested, I'll describe it. -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Complex String Decoding
A couple of folks asked, so here it is. The scheme centers around pattern strings. A pattern string represents one of any number of possible interpretations of a target string. A pattern string consists of punctuation characters and the characters A and 9 representing consecutive sequences of alphabetical characters or digits. At initialization time, a hash table is generated containing all possible legitimate target string patterns and respectiive rule codes. At decode time, a target string is scanned constructing a) its pattern string and b) a vector of address, length of all alphabetic or numeric sequences found. Since the max length of a legitimate pattern and the maximum number of possible sequences, these can be statically allocated. Some sample string and corresponding patterns: 9/5/20139/9/9with segments 9 5 2013 5.9.13 9.9.9with segments 5 9 13 September 5, 2013A9,9 with segments September 5 2013 After a target string is scanned the hash table is checked for a matching pattern rule. If found, resulting the rule is used as the argument for a case statement to apply the rule to the vector of segments. There is usually a little more work to be done. For dates, for example, it is necessary to validate day and month, look up alphabetic months, and expand two digit years, etc. -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record Encoding
On 05/09/13 15:45, Jim Starkey wrote: While I was pointing out that the worst part of starting a new software company was rewriting stringToDate, a completely new, incredibly efficient, open ended algorithm for that class of conversions occurred to me. It's really cute, and if anyone is interested, I'll describe it. Yes please! I'm interested Jim, so if/when you get a few minutes to describe it, I'll be all ears! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel