Re: [Firebird-devel] Just for Info : building firebird 3.0 RC2 with gcc 6.0
Em 04/03/2016 13:37, Michal Kubecek escreveu: > On Fri, Mar 04, 2016 at 04:53:47PM +0100, Philippe Makowski wrote: >> >> just for information here the log of the attempt to build Firebird 3.0 >> RC2 under Fedora RawHide (gcc 6.0.0) >> >> https://copr-be.cloud.fedoraproject.org/results/makowski/firebird/fedora-rawhide-x86_64/00165626-firebird/build.log.gz > > See http://tracker.firebirdsql.org/browse/CORE-5099 > > The crash is probably caused by the problem mentioned in last two comments. > I added my finds to the ticker: - First, I just committed a change for GPRE generate code compatible with C++-14 I build in C++-14 mode with these options: -fno-sized-deallocation: because C++-14 pass the size to the delete operator. Instead of use this options, it would be better to check __cpluplus >= 201402L and do the appropriate change in the sources. -fno-delete-null-pointer-checks: becase the ->as ->is methods that we call in null pointers. May have others similar things. These options are not needed: -no-lifetime-dse -flifetime-dse=1 But I think -flifetime-dse=1 should be safe. - Adriano -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record level compression for V4
Hi, to be able to do it, I need to switch to record level compression. And for this task I need your help. For first, you can use a memory move instead compression, I will replace by ELekt Labs RLE (+LZ4) for fist iteration. Next I will change to value encoding or value encoding + LZ4 (or LZ4 HC). Finally you will can chose between RLE and value encoding. Is it OK for you? Slavek Ing. Slavomir Skopalik Executive Head Elekt Labs s.r.o. Collection and evaluation of data from machines and laboratories by means of system MASA (http://www.elektlabs.cz/m2demo) - Address: Elekt Labs s.r.o. Chaloupky 158 783 72 Velky Tynec Czech Republic --- Mobile: +420 724 207 851 icq:199 118 333 skype:skopaliks e-mail:skopa...@elektlabs.cz http://www.elektlabs.cz On 4.3.2016 21:27, Dmitry Yemanov wrote: > 04.03.2016 18:49, Slavomir Skopalik wrote: >> if you help me with integration, will do it. > I will. Just consider it a trial development. I cannot promise anything > before seeing the test results. > > > Dmitry > > > -- > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record level compression for V4
04.03.2016 18:49, Slavomir Skopalik wrote: > > if you help me with integration, will do it. I will. Just consider it a trial development. I cannot promise anything before seeing the test results. Dmitry -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5130) Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL --- Key: CORE-5130 URL: http://tracker.firebirdsql.org/browse/CORE-5130 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Initial Reporter: Pavel Zotov create or alter view v2 as select 1 id from rdb$database; recreate table t1(id int, x int, y int); commit; alter view v1 as select * from t1 a where not exists(select * from t1 r where r.x > a.x) -- yes, it's not allowed when using together with clause "with check option" --a.x is not null with check option ; Output in 2.5.6: === Statement failed, SQLSTATE = 42000 Dynamic SQL Error -SQL error code = -607 -Invalid command -No subqueries permitted for VIEW WITH CHECK OPTION === (OK, expected) Output in WI-V3.0.0.32375: === Statement failed, SQLSTATE = HY000 invalid request BLR at offset 79 -context already in use (BLR error) === The same in WI-V3.0.0.32366 Firebird 3.0 Release Candidate 2. -- 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 -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record level compression for V4
Hi Dmitry, if you help me with integration, will do it. Slavek > I have nothing against a value-based encoding. But our v4 development > tasks currently do not include inventing one. If someone jumps in with a > prototype implementation, I'd be definitely willing to review/consider it. > > > Dmitry > > > -- > -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record level compression for V4
03.03.2016 22:49, Slavomir Skopalik wrote: > > Is it right time or will be postponed to V5 So far I see no serious reason to postpone it. Just please wait a couple of weeks, I will post to this thread when ready. Dmitry -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Record level compression for V4
03.03.2016 19:52, James Starkey wrote: > > I was not talking about value-based encoding (which surely requires a > different approach). > > And why not? I have nothing against a value-based encoding. But our v4 development tasks currently do not include inventing one. If someone jumps in with a prototype implementation, I'd be definitely willing to review/consider it. Dmitry -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5129) FB 3 RC2 installer is displaying "empty texts" when Portuguese is selected
FB 3 RC2 installer is displaying "empty texts" when Portuguese is selected -- Key: CORE-5129 URL: http://tracker.firebirdsql.org/browse/CORE-5129 Project: Firebird Core Issue Type: Bug Components: Installation Affects Versions: 3.0 RC2 Reporter: Carlos H. Cantu When Portuguese (Portugal) is choose during installation, installer is not displaying the text (docs) in two screens: 1) Screen right after the license (supposed to display installation_readme.txt) 2) Screen after the files are copied (content should be the readme.txt, = leia-me.txt) In previous versions, the installer displayed the contents in English (since no portuguese translation was available). I suggest to do the same with FB 3 installer. -- 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 -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5128) Allow to specify a prefix protocol for embedded
Allow to specify a prefix protocol for embedded --- Key: CORE-5128 URL: http://tracker.firebirdsql.org/browse/CORE-5128 Project: Firebird Core Issue Type: Improvement Reporter: Simonov Denis Priority: Minor Currently, in the connection string, you can specify one of the protocols work on the network inet, wnet, xnet. It would be nice to be able to specify a prefix to be used only for the embedded protocol without changing the configuration. embed://C:\db\ mydb.fdb -- 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 -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] RFC: Tablespaces
On 03/03/16 20:13, Jim Starkey wrote: >> Where i can see a useful segregation is archival data which will never >> be modified. Would be very usefull if all that could be backed up on a >> Slow cycle, and only the real dynamic data kept in the primary table >> space? But one can do most of that by having multiple databases anyway? > > You know, that's a really good idea. Disk is almost free, too cheap to > meter (so to speak). Store something once and just don't worry if it > goes out of style... I spent last night down at the local A to get a problem sorted. I was reading these emails while waiting and was re-thinking the problem of medical data given the size of the piles of paper records passing by ... Where the bulk of that material is old paper and images, digitizing them for easy access anywhere is a 'cost' problem. but replacing with electronic copies creates the sort of 'blob' data that I was talking about originally. It's the sort of static data that perhaps needs multiple storage sites, but does not need to be continually backed up in any database system ... just the index of available material. Content extracted from that data for easy access such as say 'blood pressure and temperature', while part of the dynamic element of the records is essentially a static set of records to which material is added, and it's this element that could perhaps benefit from a different process? 'Non-deletable' data so the pages containing it are essentially static, but with an active final page? I think a large section of data would be better handled like this such as bank transactions or telephone calls. Delete in these cases would be date related, but 'older' pages could simply be left on the system so one can just scroll back through if necessary? What gets my goat currently is the way my bank 'archives' the on-line data to bank statements so one can't easily scroll back, but each of those 'blob's of data could be made accessable with a different approach to the storage? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel