Re: [Firebird-devel] Fb 3: recursive local sub routines or routines calling eachother?
Fb 3 introduces local sub routines in stored procedures. It seems these sub routines cannot call themselves nor can then call previously declared routines, this is, I assume, by design? README.subroutines.txt: Limitations: 1) Subroutines may not be nested in another subroutine. They are only supported in the main routine. That I figured out. 2) Currently, a subroutine may not directly access or use variables, cursors or another subroutines of the main statements. This may be allowed in the future. Right. But how about a recursive call to itself? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4605) Rename CryptPlugin parameter in config file
Rename CryptPlugin parameter in config file --- Key: CORE-4605 URL: http://tracker.firebirdsql.org/browse/CORE-4605 Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1, 3.0 Beta 1 Reporter: Alexander Peshkov This parameter describes what wire encryptions can be used, but it's name is not enough descriptive -- 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 -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
So, when I'll be able to compile external modules without including half of FB sources into it?.. -- WBR, SD. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
On 11/13/14 16:14, Dimitry Sibiryakov wrote: 13.11.2014 14:10, Alex Peshkoff wrote: First will definitely be rejected. Reason? A lot of serious advantages without serious disadvantages. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
13.11.2014 14:21, Alex Peshkoff wrote: A lot of serious advantages without serious disadvantages. A little external adapter between fixed PAC and CLOOP has them even more. -- WBR, SD. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
On 11/13/14 16:24, Dimitry Sibiryakov wrote: 13.11.2014 14:21, Alex Peshkoff wrote: A lot of serious advantages without serious disadvantages. A little external adapter between fixed PAC and CLOOP has them even more. What do you mean by PAC here? In http://en.wikipedia.org/wiki/PAC I've not found something reasonable. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
13.11.2014 14:32, Alex Peshkoff wrote: What do you mean by PAC here? Pure Abstract Classes. -- WBR, SD. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
On 11/13/14 16:37, Dimitry Sibiryakov wrote: 13.11.2014 14:32, Alex Peshkoff wrote: What do you mean by PAC here? Pure Abstract Classes. Dmitry, sorry. I have no time for explaining PAC disadvantages once more. It was already done it in a summer time. Wire compression is waiting for me. A. PS. You may add a line to wikipedia article :-) -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
13.11.2014 14:48, Alex Peshkoff wrote: I have no time for explaining PAC disadvantages once more. It was already done it in a summer time. Unfortunately, I have time to repeat: A bug in FPC is not a disadvantage. The rest of problems came from (pointless) interface autoupgrade. Getting rid of both can solve everything. -- WBR, SD. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
You has always the option to clone the tree, fix everything in the best way, as you're wiser than everybody, and submit a patch. Such patch will be rejected for sure (even if someone look at it at all) because it will revert interfaces to plain abstract classes + clean autoupgrade out completely. What's the point then?.. What's the point of our complaint? If you need something that was idled/deprecated years ago, why are you 'blaming' Adriano for the fact that you will need to do work for your fork? You seem to want to throw away anything that it inconvenient for your purposes. At least your changes would provide no benefit to the overall project. Sean -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] IAttachment?
13.11.2014 15:43, Leyne, Sean wrote: If you need something that was idled/deprecated years ago, why are you 'blaming' Adriano for the fact that you will need to do work for your fork? I'm blaming Adriano for the fact that he broke the interface which worked just a week ago and did it in a such way that now he is the only man in the world who can read the code and fix it. That's the difference. You seem to want to throw away anything that it inconvenient for your purposes. I'm an end application developer if you forget. And yes, I'm fighting against anything that makes developing of the application harder or (in this current case) completely impossible. -- WBR, SD. -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4608) Improve Windows installer web page loading in the end of installation
Improve Windows installer web page loading in the end of installation - Key: CORE-4608 URL: http://tracker.firebirdsql.org/browse/CORE-4608 Project: Firebird Core Issue Type: Improvement Components: Installation Affects Versions: 2.5.3, 3.0 Alpha 2, 3.0 Beta 1 Reporter: Carlos H. Cantu Enhance the Windows installer in a way that if it detects that Internet is available, it should automatically open the final web page with details about joining FF, registering to receive newsletter, etc. (the currently installer asks the user if he want to open the page). Maybe it would be also good to open the release notes automatically. -- 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 -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4609) with recursive: provide ability to define recursive part as DERIVED table
with recursive: provide ability to define recursive part as DERIVED table - Key: CORE-4609 URL: http://tracker.firebirdsql.org/browse/CORE-4609 Project: Firebird Core Issue Type: Improvement Reporter: Pavel Zotov Priority: Minor It seems to me that definition of recursive part (e.g. expression below UNION ALL) as derived table does not conflicts with SQL standard. For example, one might be done in postgress: # with recursive c as (select 1 as i union all select x.i from (select c.i+1 as i from c where i5) x ) select * from c; i --- 1 2 3 4 5 The same ability we have in MS SQL. Could you please add this feature in subsequent releases of FB ? PS. I just read document 5WD-02-Foundation-2003-09.pdf, page 378 (on paper this is page 354). Could not understand all from this sentence: -- beg of quote -- WQEi shall not contain a table subqueryTSQ that contains a query name referencing WQNj, unless TSQ is a derived table that is immediately contained in a table primary that is immediately contained in a table reference that is immediately contained in a from clause that is immediately contained in a table expression that is immediately contained in a query specification that constitutes a simple table that constitutes a query primary that constitutes a query term that is immediately contained in a query expression body that is WQEi -- end of quote -- -- but this: unless TSQ is a derived table - seems as hint that we *CAN* use DT in recursive part... :-) -- 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 -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel