Re: [Firebird-devel] Update ICU in Windows
On Monday 17 February 2014 20:39:38 Alex Peshkoff wrote: > On 02/17/14 20:27, Adriano dos Santos Fernandes wrote: > > On 17/02/2014 13:08, Dimitry Sibiryakov wrote: > >> 17.02.2014 17:01, Adriano dos Santos Fernandes wrote: > >>> - The data file is common for win32 and win64. If we include the binary > >>> files in our source repository (and I think we should) it's less > >>> megabytes. > >>> > >>> Do you agree with above? > >>> > >> I disagree with including these files into the repository. > >> > >> BTW: Other projects which depend on external packages (such as GTK, > >> for example) used>> > >> to provide two packages: with and without external packages included. > >> This way those who know what they have installed can save traffic. > > > > I estimate a very few number of files summing around 15 MB. > > > > This is much less than current ICU 3 sources, with thousand files > > summing 50 MB and nobody died yet. > > > > What is the problem with you? > > The problem for me is not bytes. I dislike a whole approach called > 'Everything needed for windows build should be present in single > repository'. I think that building firebird anyway requires at lease > minimum qualification (without it - why build at all? use prebuilt > binaries please.) which should be enough to obtain from the net required > additional packages. > speaking as packager for a small linux distro, I get very upset when I find that a repository has included large chunks from another library, especially as I usually already have more recent versions on my system. Anyone building from source, primarily developers or packagers, should be able to build and install any needed libraries independently of firebird. If packagers wish to include some library in their package, they are free to do so, but this should not be part of the firebird database repository. If the developers wish to maintain separate repositories of upstream libraries, they are free to do so, but should not inflict them on others. The firebird project could include patches which it considers should be applied to certain versions of an upstream library, but it should be the packager's responsibility to apply them. > I can agree when some not ideally supported software (like editline or > btyacc) is added to the repository. But adding to it a library (does not > matter, sources or binaries) well supported by big company is a logical > nonsense on my mind. > > > > > -- Managing the Performance of Cloud-Based Applications > Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. > Read the Whitepaper. > http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4344) "no current record for fetch operation" when table inner join procedure inner join table
"no current record for fetch operation" when table inner join procedure inner join table - Key: CORE-4344 URL: http://tracker.firebirdsql.org/browse/CORE-4344 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Environment: isql Reporter: Simonov Denis SET SQL DIALECT 3; SET NAMES WIN1251; CREATE DATABASE 'localhost:d:\fb\fb30\data\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 16384 DEFAULT CHARACTER SET WIN1251; CREATE TABLE T ( ID INTEGER NOT NULL, A INTEGER, B INTEGER ); INSERT INTO T (ID, A, B) VALUES (1, 2, 3); INSERT INTO T (ID, A, B) VALUES (2, 1, 3); INSERT INTO T (ID, A, B) VALUES (3, 3, 2); COMMIT WORK; ALTER TABLE T ADD PRIMARY KEY (ID); SET TERM ^ ; CREATE PROCEDURE MYPROC ( A INTEGER, C INTEGER) RETURNS ( B INTEGER) AS begin b = a + c; suspend; end^ SET TERM ; ^ SQL> select t3.* CON> from t t1 CON> join t t2 on t1.id = t2.a CON> left join myproc(t1.a, t2.a) p on 1=1 CON> join t t3 on p.b = t3.b; IDAB 123 123 213 213 SQL> select t3.* CON> from t t1 CON> join t t2 on t1.id = t2.a CON> join myproc(t1.a, t2.a) p on 1=1 CON> join t t3 on p.b = t3.b; IDAB Statement failed, SQLSTATE = 22000 no current record for fetch operation<-- Why? SQL> select p.* CON> from t t1 CON> join t t2 on t1.id = t2.a CON> join myproc(t1.a, t2.a) p on 1=1; B 3 3 6 -- 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 -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
Hello Vlad, >> 14.02.2014 22:50, Thomas Steinmaurer wrote: >> >>> Would like to do so, but the latest snapshot build for Windows available >>> is from 2 days ago. Just letting you know. >> >> Windows builds are broken at the moment, please wait a bit. > > It works now Tried todays snapshot build (Win 32-bit). The output looks like a bit weird regarding package/procedure name: 2014-02-18T21:59:55.1080 (456:00C32D20) EXECUTE_PROCEDURE_FINISH tourism.fdb (ATT_332, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) C:\Program Files (x86)\Upscene Productions\Database Workbench 4 Pro\DBW4.exe:4928 (TRA_574, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) Procedure PKG_SCHE´õŸ: 0 ms Thanks for your time. Regards, Thomas -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
> -Original Message- > From: Thomas Steinmaurer [mailto:t...@iblogmanager.com] > Sent: Martes, 18 de Febrero de 2014 17:02 > > Tried todays snapshot build (Win 32-bit). The output looks like a bit > weird regarding package/procedure name: > > Procedure PKG_SCHE´õŸ: >0 ms Probable because the string created by QualifiedName.toString() goes out of scope before the contents can be copied. While it would be more tedious to use, I would prefer this function changed to string toString(string& out) to ensure the result is written in "out" and not in a temporary object. C. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
> Tried todays snapshot build (Win 32-bit). The output looks like a bit > weird regarding package/procedure name: > > 2014-02-18T21:59:55.1080 (456:00C32D20) EXECUTE_PROCEDURE_FINISH > tourism.fdb (ATT_332, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) > C:\Program Files (x86)\Upscene Productions\Database Workbench 4 > Pro\DBW4.exe:4928 > (TRA_574, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) > Procedure PKG_SCHE´õŸ: >0 ms Yes, i know. I and already fixed it at my private tree. Will be committed soon with tracing of functions. Regards, Vlad -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
