[Firebird-devel] [FB-Tracker] Created: (CORE-5153) Regression: Server crashes when aggregate functions are used together with NOT IN predicate

Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Initial, 3.0 RC2, 3.0 RC1, 3.0 Beta 2, 3.0 Beta 1 Reporter: Dmitry Yemanov Simplified test case: select r.rdb$relation_id, count(*) from rdb$database r group by r.rdb$relation_id

[Firebird-devel] [FB-Tracker] Created: (CORE-5158) Extend ALTER EXTERNAL FUNCTION to adjust arguments

: Engine Reporter: Dmitry Yemanov v3.0 prohibits any system table updates. But it also closed an ability to change arguments for existing UDFs. For example, increasing length from CSTRING(100) to CSTRING(1000) is safe and I believe could be supported. Currently, ALTER EXTERNAL FUNCTION

Re: [Firebird-devel] GitHub

All, The project repository was migrated to GitHub: https://github.com/FirebirdSQL/firebird Please wait a few days for things to settle down, we need to update some infrastructure. SVN repository is still accessible, but new contributions are expected to be provided as pull requests at GitHub.

Re: [Firebird-devel] Git

17.03.2016 13:56, Dimitry Sibiryakov wrote: > I may be wrong, but you cannot create a pull request from local repository > clone. You > must fork it into your account beforehand. Paul doesn't need to use pull requests, he may commit directly. Dmitry

Re: [Firebird-devel] Firebird support for "newer" compilers & SDKs / especially on Windows & MacOS X

15.03.2016 18:37, Lionel Elie Mamane wrote: > > Short version: will Firebird (2.5? 3? latest?) in general be kept > compatible with the latest major compilers (within a reasonable time > of their release) for each platform for the foreseeable future? Yes. Just don't expect it to happen

Re: [Firebird-devel] GitHub

02.03.2016 16:16, Egor Pugin wrote: > What about just 'firebird'? 'core' is misleading. > It does not matter that the same word repeats in address. See: > https://github.com/git/git > https://github.com/FFmpeg/FFmpeg > https://github.com/openssl/openssl > and many others... Let's look at closer

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

11.03.2016 23:26, Leyne, Sean wrote: > >> Why it is better than BY_HANDLE_FILE_INFORMATION used currently ? > > FILE_OBJECTID_BUFFER has a unique File/Object ID, BY_HANDLE_FILE_INFORMATION > doesn't provide such a value. {dwVolumeSerialNumber, nFileIndexHigh, nFileIndexLow} is a unique

Re: [Firebird-devel] ALTER NOT NULL raises error Token unknown FB3.0 RC2

11.03.2016 15:27, Arno Brinkman wrote: > > According to the Firebird 3.0 releases notes i should be able to alter a > column to not nullable. > > But when executing this script: > > CREATE TABLE TESTNULLABLE (ID INT); > COMMIT; > > ALTER TABLE TESTNULLABLE ALTER ID NOT NULL; > COMMIT; > > I get

Re: [Firebird-devel] Phasing out BLR

09.03.2016 19:34, Jim Starkey wrote: > Is there a plan to phase out BLR? Nothing specific yet. > Given that the next version of Firebird is likely to take a decade > anyway, why not start the discussion and planning now? We hope to have it released much sooner, sorry. That said, I have no

Re: [Firebird-devel] Several NOT NULL constraints for the same field

08.03.2016 21:00, Dimitry Sibiryakov wrote: > > Should I put it into tracker to let the change be documented as an > incompatibility with > previous versions? Yes, please. Dmitry -- Transform Data into Opportunity.

Re: [Firebird-devel] Several NOT NULL constraints for the same field

08.03.2016 20:10, Dimitry Sibiryakov wrote: >> Do you want to throw a syntax error from the parser or something more >> intelligent like "duplicate constraint definitions are not allowed" from >> DdlNodes? > > Standard syntax error from parser is the simplest solution: > >> SQL> create table

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

08.03.2016 19:06, Dimitry Sibiryakov wrote: > 05.03.2016 22:28, Lester Caine wrote: >> It would be nice if we did not have re-order scripts from other >> databases so >>NOT NULL DEFAULT '30' >> has to be >>DEFAULT '30' NOT NULL >> in Firebird. > > If DY agree, I can commit this change. I

Re: [Firebird-devel] Several NOT NULL constraints for the same field

08.03.2016 19:51, Dimitry Sibiryakov wrote: > 08.03.2016 17:46, Dmitry Yemanov wrote: >>> "create table t (a integer not null not null not null)" is a valid syntax >>> or a bug? >> I'd call it a bug. A very minor one for sure. > > Am I allowed to c

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

08.03.2016 19:50, Dimitry Sibiryakov wrote: > But you are still sure that "CREATE OR ALTER" must alter attributes that are > not > explicitly mentioned in query?.. I believe that both CREATE and ALTER parts should deliver the same object state. I agree that changing non-referenced attributes

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

06.03.2016 16:55, Dimitry Sibiryakov wrote: > > I think we need DE to make decision. The only way CREATE OR ALTER SEQUENCE S; can be allowed is that is acts as RESTART WITH 0 INCREMENT BY 1 for existing sequences. This way the behaviour is consistent: both CREATE and ALTER produce the same

[Firebird-devel] BLR contexts limit

All, The good thing is that the code internals are more or less ready to work with context/stream number of any size, thanks to Claudio's refactoring. So the issue is mostly about BLR. I see two possible solutions: 1) Bump BLR version, make all context-aware verbs to generate/parse longer

Re: [Firebird-devel] Firebird V4 roadmap?

07.03.2016 13:14, liviuslivius wrote: >>> is somewhere some "initial" roadmap for Firebird v4. >> >> It will be published when ready. Soon. > > maybe some voting system what first to do ;-) Tracker has the voting system and votes are considered when planning. Dmitry

[Firebird-devel] Firebird 3.0 Release Candidate 2 is available for testing

Candidate. Download page: http://www.firebirdsql.org/en/firebird-3-0-0-rc2/ Release Notes: http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_RC2-ReleaseNotes.pdf -- Dmitry Yemanov -- Tran

Re: [Firebird-devel] Firebird V4 roadmap?

07.03.2016 10:04, liviuslivius wrote: > > is somewhere some "initial" roadmap for Firebird v4. It will be published when ready. Soon. > And is some plans to eliminate 255 contexts limit in the near feature? Yes, I will create a separate thread for that. Dmitry

Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

05.03.2016 16:32, Dimitry Sibiryakov wrote: > > Currently parser enforce attribute clauses to have a definite positions in the > statement. SQL standard doesn't require that. > Do you agree that position-insensitive clauses would be more convenient? Agreed. > BTW, shouldn't conflicts in

Re: [Firebird-devel] Misc-type changes

05.03.2016 15:45, Dimitry Sibiryakov wrote: > Must I ask for approval before committing tiny changes such as fixing of > mistypes in > comments and spaces? Nope. Dmitry -- Firebird-Devel mailing list, web interface

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

03.03.2016 19:46, Dimitry Sibiryakov wrote: > 03.03.2016 17:38, Dmitry Yemanov wrote: >> Pretty no difference for short hash strings, thanks. > > Your conclusion is...? I don't see much value, but it looks like it does not hurt either. Feel free to c

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 --

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

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

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

03.03.2016 19:33, Dimitry Sibiryakov wrote: > Original: >> Elapsed time= 1.243 sec vs > CRC32: >> Elapsed time= 1.238 sec Pretty no difference for short hash strings, thanks. Dmitry -- Site24x7 APM Insight: Get Deep

Re: [Firebird-devel] Record level compression for V4

03.03.2016 19:16, Jim Starkey wrote: > On 3/3/2016 11:10 AM, Dmitry Yemanov wrote: >> Am I missing something obvious? > > Yeah. Data. I was not talking about value-based encoding (which surely requires a different appr

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

03.03.2016 18:36, Dimitry Sibiryakov wrote: > varchar(2000) filled with rpad('', 2000, uuid_to_char(gen_uuid())). Can you perform the same test but with INT join key? Dmitry -- Site24x7 APM Insight: Get Deep

Re: [Firebird-devel] Record level compression for V4

03.03.2016 18:34, Slavomir Skopalik wrote: > > But value encoding cannot be implemented until we switch from fragment > compression to true record level compression. I was not speaking about any encoding, just about compacting the record. Fragments are not compressed independently. The whole

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

03.03.2016 18:49, Dimitry Sibiryakov wrote: >> Out of curiosity, why do we need a separate crc32c.cpp? > > To let engine work on processors without SSE4.2 command set. Ah, I missed processor-specific compilation flags for that module. Thanks for clarifying. Dmitry

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

03.03.2016 14:07, Dimitry Sibiryakov wrote: > Ok, here you have it, attached. Much better, thanks. I had the same doubts about the first two if's, but Vlad already asked about them. Out of curiosity, why do we need a separate crc32c.cpp? Cannot the CRC32C function be defined inside Hash.cpp?

Re: [Firebird-devel] Record level compression for V4

All, This is how I see the things. RLE is good for record compression due to the following facts: 1) In-memory record has all the fields expanded up to their maximum size. Shorter values are padded with zeroes (that are easy to compress). 2) In-memory record stores the NULL bitmap and at the

Re: [Firebird-devel] Browse information in VS 2010

03.03.2016 13:28, Dimitry Sibiryakov wrote: > > Do anybody use subj? Yes, me (sometimes). Dmitry -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App

Re: [Firebird-devel] RFC: Tablespaces

03.03.2016 09:48, Dmitry Yemanov wrote: > >> Blobs could be moved into separate tablespace. It could make backup of >> "data" tablespace faster and smaller. We can even think about "offline" >> tablespace. > > Really good idea. Maybe more importan

Re: [Firebird-devel] RFC: Tablespaces

03.03.2016 00:51, Vlad Khorsun wrote: > > Blobs could be moved into separate tablespace. It could make backup of > "data" tablespace faster and smaller. We can even think about "offline" > tablespace. Really good idea. Maybe more important for an average FB user than the other usage cases. >

Re: [Firebird-devel] RFC: Tablespaces

03.03.2016 02:12, Leyne, Sean wrote: > > While I can see possible use cases, I am concerned that implementing > tablespaces would only make database management more complicated. True, but only for those using it. > Based on your outline/proposal, however, aren't Tablespaces just enabling >

Re: [Firebird-devel] RFC: Tablespaces

03.03.2016 00:23, Dmitry Yemanov wrote: > > Someone may think about per-tablespace physical backups and other > possible usage cases. Personally, I don't care much about tablespaces per se. But I foresee that table partitioning could be stacked over the tablespace implementation a

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

03.03.2016 00:41, Dimitry Sibiryakov wrote: > I did. Look into ICQ logs. > http://www.ibphoenix.com/ibpr_devel/Avalerion.63058.7z > contain every changed source file in obedience to IDPL. I've asked for a particular change patch, you've provided 220KB of the total tree diff to scan for the

Re: [Firebird-devel] Core-1686

02.03.2016 15:59, Atri Sharma wrote: > BTW I tried navigating the codebase to find the parser and rewriter, > along with table commands, but somehow got lost in the structure. > > Can anyone please point me to it? /dsql/parse.y is the grammar. It generates execution nodes as class instances

Re: [Firebird-devel] GitHub

02.03.2016 16:16, Egor Pugin wrote: > What about just 'firebird'? 'core' is misleading. > It does not matter that the same word repeats in address. See: > https://github.com/git/git > https://github.com/FFmpeg/FFmpeg > https://github.com/openssl/openssl > and many others... Personally, I don't

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

Dimitry, > Revision: 63072 >http://sourceforge.net/p/firebird/code/63072 > Author: aafemt > Date: 2016-03-02 15:33:16 + (Wed, 02 Mar 2016) > Log Message: > --- > Savepoints refactoring that fixes CORE-4701, CORE-4424 and CORE-4483 When did the project politics

Re: [Firebird-devel] GitHub

02.03.2016 15:53, Dimitry Sibiryakov wrote: > Am I alone who has no idea what the name is?.. https://github.com/FirebirdSQL/core Dmitry -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM +

Re: [Firebird-devel] GitHub

02.03.2016 15:44, Dimitry Sibiryakov wrote: > 02.03.2016 12:18, Dmitry Yemanov wrote: >> Firebird Project will be moving its repositories to GitHub soon. > > Will be a new repository created? The current mirror repo will be replaced with a freshly imported one. The repo

Re: [Firebird-devel] Core-1686

02.03.2016 15:03, Atri Sharma wrote: > Sounds something I can pick up... I will start a new thread on this subject later today, to discuss what and how could be done in this regard. Dmitry -- Site24x7 APM Insight:

Re: [Firebird-devel] Core-1686

02.03.2016 14:42, Atri Sharma wrote: > Is the tablespaces question still relevant? Yes. Dmitry -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances

Re: [Firebird-devel] Core-1686

02.03.2016 14:33, Atri Sharma wrote: > I meant I cannot participate in GSoC,assuming that is what you meant :) GSoC 2015 was running without our project, unfortunately. But these tasks are still relevant as an easy start. Dmitry

Re: [Firebird-devel] Core-1686

02.03.2016 14:15, Atri Sharma wrote: > Thanks for the heads up but I cant :) > > This is me : https://uk.linkedin.com/in/atrisharma Some of those tasks are not that simple ;-) But feel free to choose what you're really interested in, I don't mind. The tracker is full of open tickets :-) And

Re: [Firebird-devel] Core-1686

02.03.2016 14:09, Atri Sharma wrote: > That's fine, I am fine with anything in the planner, or maybe > transactions ... Then the start would be not from the planner, but from the statistics collector ;-) Take a look at the GSTAT utility, located under /src/utilities/gstat/, the code is

[Firebird-devel] GitHub

All, Firebird Project will be moving its repositories to GitHub soon. I'm asking present contributors to create accounts there. If anyone (including past contributors) wants your past commits to be automatically linked to your GitHub account and be shown in the statistics, please report your

Re: [Firebird-devel] Core-1686

02.03.2016 07:00, Atri Sharma wrote: > Also, let me know if there is anything else that needs hands, and I will > be glad to help with that. As a newcomer, you may also look here for possible tasks: http://www.firebirdsql.org/en/gsoc/ Dmitry

Re: [Firebird-devel] Core-1686

01.03.2016 21:02, Atri Sharma wrote: > > I was looking into the bug tracker to pick something to hack on, and > found Core-1686. This seemed pretty interesting to me, but I have never > had a look at Firebird core before. I think CORE-1686 may actually be more complicated than it appears at the

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

01.03.2016 16:08, Dimitry Sibiryakov wrote: > So, is usage of VS 2013 as a main build for Windows decided? > If so, I'd suggest to delete VS 2010 and lesser projects from build dir. They may be maintained by someone else. We don't require our sources to be built using VS 2013 exclusively. That

[Firebird-devel] [FB-Tracker] Created: (CORE-5122) Expression index may not be used by the optimizer if created and used in different connection charsets

/browse/CORE-5122 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.5, 3.0 RC1, 3.0 Beta 2, 2.5.4, 3.0 Beta 1, 2.5.3, 3.0 RC2 Reporter: Dmitry Yemanov If the index expression contains a string literal, e.g. computed

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

28.02.2016 13:17, Dimitry Sibiryakov wrote: > 28.02.2016 11:05, Dmitry Yemanov wrote: >> It's not about VS 2015, but about C++14 in general > > Read some more. Problem is not standard, but VS 2015 code generator which > unconditionally generate SSE2 instructions. It drives

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

28.02.2016 12:44, Dimitry Sibiryakov wrote: > Before voting for VS 2015 look at this: > http://www.sql.ru/forum/actualthread.aspx?tid=1200248 It's not about VS 2015, but about C++14 in general, including recent GCC versions. We already know our code does not comply the new language

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

10.12.2015 21:27, Mark Rotteveel wrote: [subject changed to follow the thread direction] > Maybe FB 4 should be based on VS 2015 instead of 2013. We need to choose between VS 2012/2013 and VS 2015 for FB4. I'm quite happy with VS 2013 Community Edition, but I never tried VS 2015 and I'm

[Firebird-devel] [FB-Tracker] Created: (CORE-5119) Support autocommit mode in SET TRANSACTION statement

Components: Engine Reporter: Dmitry Yemanov Priority: Trivial Autocommit was always supported in API by using the isc_tpb_autocommit tag. It would make sense to surface it in DSQL too by extending the SET TRANSACTION statement. -- This message is automatically generated by JIRA

Re: [Firebird-devel] isc_random

21.02.2016 14:45, Dimitry Sibiryakov wrote: > 21.02.2016 12:39, Dmitry Yemanov wrote: >> Generally, yes. Just not right now, we're preparing for RC2. > > When are you going to fork 3.0 release branch and open head for development? Don

Re: [Firebird-devel] Status of SQLCODE

24.02.2016 14:28, Lester Caine wrote: > I'm finally taking the time to push the improved Firebird driver for > ADOdb in PHP over to the new development home for that project and one > of the things I decided to tidy up is the error messages which still > relate to the original FB1 list. Currently

Re: [Firebird-devel] Srp username charset

21.02.2016 18:30, Jiří Činčura wrote: > There's UTF8 flag for DPB? I'm aware of isc_dpb_utf8_filename only, but > that is only for database path, isn't it? Is it only for FB3? Initially it was for the database pathname only, now it's about everything inside DPB. Maybe it's worth to have the

Re: [Firebird-devel] isc_random

21.02.2016 14:45, Dimitry Sibiryakov wrote: > 21.02.2016 12:39, Dmitry Yemanov wrote: >> Generally, yes. Just not right now, we're preparing for RC2. > > When are you going to fork 3.0 release branch and open head for development? The next

Re: [Firebird-devel] isc_random

21.02.2016 13:56, Dimitry Sibiryakov wrote: > Do everybody agree that subj is a bad thing and must be replaced with proper > gds codes? Generally, yes. Just not right now, we're preparing for RC2. Dmitry -- Site24x7

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[62991] firebird/trunk

20.02.2016 19:39, Dimitry Sibiryakov wrote: > Will you do it for Adriano's "Misc" as well? There's a difference between cosmetic changes that hurt nobody and changes that may affect other developers. You've committed something comfortable for you without asking whether it's suitable for the

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[62991] firebird/trunk

20.02.2016 18:56, Dimitry Sibiryakov wrote: > 1) Changes made in autoconfig_msvc.h aren't visible to the rest of sources > without manual > copying of the file or running boot_build.bat. How many times per day do you modify autoconfig.h? Why? Running boot build may look annoying, but it's a

Re: [Firebird-devel] Limit on Old and New context variables in triggers ?

16.02.2016 22:04, Helen Borrie wrote: > > What if one were to replace some contexts with calls to SPs that > executed those actions? Would the context counts from the SPs be > added to those of the trigger? Nope. The context limit is bound to a request. Every procedure/trigger has its own

Re: [Firebird-devel] Limit on Old and New context variables in triggers ?

16.02.2016 20:07, Leyne, Sean wrote: > > Would INSERTs (as below) to a table count as a context? Sure. Every table reference is a context. Be it SELECT/INSERT/whatever. For UPDATE it takes two contexts. Dmitry --

Re: [Firebird-devel] Limit on Old and New context variables in triggers ?

16.02.2016 18:58, Leyne, Sean wrote: > > We are running into an interesting problem while trying to implement > some triggers. We are getting the following message: > Cannot commit transaction: > Undefined name. > Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255. > We have

Re: [Firebird-devel] Firebird-2.5.5 build fail on Fedora rawhide

08.02.2016 12:01, Philippe Makowski wrote: > > with Vlad patch : > > http://paste.fedoraproject.org/319767/22039145 Other gcc 6 issues have not been addressed yet. Dmitry -- Site24x7 APM Insight: Get Deep Visibility

Re: [Firebird-devel] Firebird-2.5.5 build fail on Fedora rawhide

05.02.2016 14:36, Philippe Makowski wrote: > > can you check these build log ? > > http://paste.fedoraproject.org/318912/14546719/ This issue has been fixed 20-Jan-2016 by Vlad. Dmitry -- Site24x7 APM Insight: Get

Re: [Firebird-devel] JRD_get_thread_data()

29.01.2016 18:51, Dimitry Sibiryakov wrote: > > Getting tdbb in functions that don't have explicit tdbb parameter using subj > is ok, or > it is just an ancient hack waiting for cleanup? I'd suggest to explicitly pass tdbb. But if a small fix needing tdbb in some place asks for a major

Re: [Firebird-devel] fb3 connections limit

21.01.2016 08:43, Dmitry Yemanov wrote: > SS and SC: 2048 connections Correction: this affects Windows only. Dmitry -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM +

Re: [Firebird-devel] fb3 connections limit

21.01.2016 00:37, liviuslivius wrote: > > is there some fb implementation limit like max number of connection in > fb3. i read somwhere that there is 1024 connections, is it true in fb3? > if yes - is this limit related with fb architecture like superserver vs > classic. SS and SC: 2048

Re: [Firebird-devel] String error with actual snapshot of 3.0

07.01.2016 19:44, Mark Rotteveel wrote: > That comment makes no sense. If there is no index it also needs to be > evaluated. It then uses NATURAL instead of an index access to find the > record(s) (or no records). If the natural scan returns no rows, then WHERE conditions are not evaluated. For

Re: [Firebird-devel] Literals in CASE expression

06.01.2016 00:49, Leyne, Sean wrote: > >> First of all, let's distinguish between two things: (1) how string literals >> are >> described and (2) how CASE evaluates the resulting datatype. Changing any >> of them may lead to the desired result. > > The issue is not the intermediate datatype but

Re: [Firebird-devel] Literals in CASE expression

06.01.2016 10:28, Mark Rotteveel wrote: > No, please no. I believe Arno was writing with the sarcasm mode turned on ;-) Dmitry -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] march switch in posix build for x86 architecture

29.12.2015 19:56, Dimitry Sibiryakov wrote: > > Isn't it a good time to drop support of 20 years old processors and raise > -march value > from i386 to i686? Maybe I'm missing something, but I see in both v2.5 and v3.0: OPTIMIZE_FLAGS=-O3 -march=i586 -mtune=i686 -fno-omit-frame-pointer Dmitry

Re: [Firebird-devel] Lock manager's hash calculations

28.12.2015 16:03, Dimitry Sibiryakov wrote: Yes. But in this case the hash is only used internally and not stored anywhere. Because of this, different platforms can use different algorithms for it. >> Of course, but then it should be encapsulated and moved to /common to >> avoid

Re: [Firebird-devel] Lock manager's hash calculations

24.12.2015 20:07, Dimitry Sibiryakov wrote: > > Yes. But in this case the hash is only used internally and not stored > anywhere. Because > of this, different platforms can use different algorithms for it. Of course, but then it should be encapsulated and moved to /common to avoid the same

Re: [Firebird-devel] Allocated memory initialization

23.12.2015 18:17, Dimitry Sibiryakov wrote: > > Does Firebird memory allocator initialize requested block to zeros? No, unless the object is inherited from pool_alloc() or you allocate using MemoryPool::calloc(). Dmitry

Re: [Firebird-devel] Firebird 3 and zlib compression

11.12.2015 11:30, preeves wrote: > I can see zlib.exe and the instructions to use it but it doesn't seem > to be integrated into the build process. make_boot unpacks zlib and copies it into /bin. Dmitry --

Re: [Firebird-devel] Firebird 3 and zlib compression

10.12.2015 23:56, Mark Kendall wrote: > I’ve just been trying out compression with Firebird 3 rc1. It took a > long time to get it working on a Windows 7 64 bit machine until I > discovered a post about whether or not zlib should be compiled into > Firebird or a separate dll should be used.

Re: [Firebird-devel] Compiler for official Firebird 3 release on Windows

10.12.2015 19:27, Vlad Khorsun wrote: >> But perhaps we should consider using a later version of MSVC. >> >> If we are going to change we should do it before final release of 3.0 >> >> Thoughts? > > I use VS 2013 (VC12) with Update 4 for development. > > Not sure if we should change official

Re: [Firebird-devel] Enhancement for numbers calculations

08.12.2015 13:29, Mark Rotteveel wrote: > I'd prefer if anything is changed, this is not done without resorting > hackish solutions that will just create another set of confusion, but > instead by using generally accepted arbitrary precision decimal > calculation rules from standards like ANSI

Re: [Firebird-devel] Enhancement for numbers calculations

07.12.2015 19:21, Carlos H. Cantu wrote: > With currently logic, the result of multiplications or divisions will > have Scale = Sum of the scale of its members. This cause nonsense > situations like the following: > > select 1.0 / 1.00 from rdb$database > > resulting in: >

Re: [Firebird-devel] Speed of 2.5.4 vs 2.5.5

Already known, but reasons are not clear yet. Being investigated.Dmitry15:41, 6 декабря 2015 г., "Jiří Činčura" :Hi *,today I noticed something weird. For .NET provider tests I recentlyupdated from 2.5.4 to 2.5.5 on CI. And the tests are now significantlyslower. Consistently.*

Re: [Firebird-devel] ODP: Re: CORE-5025 - discussion moved here

24.11.2015 09:10, liviuslivius wrote: > Where can i find this in code? In cch.cpp: CCH_fetch() -> CCH_fetch_lock() -> get_buffer() and below CCH_release() and below Just FYI, this is how the difference look like in the profiler output: v2.5.5: 10,10% libfbembed.so.2.5.6 get_buffer

Re: [Firebird-devel] CORE-5025 - discussion moved here

23.11.2015 23:59, liviusliv...@poczta.onet.pl wrote: > > How this work. > 1. > It iterate page by page all of this operations? > > or > > 2. lock is accuired on hash table > and here is some iteration e.g. 1000 processed records (100 pages ..., or > something) > and after that lock is released to

Re: [Firebird-devel] Several connections to encrypted database in SS mode

18.11.2015 20:27, Leyne, Sean wrote: > > Are you saying that the only mode that database encryption will work, is the > one which satisfies only 80% of the installs? Nope. You've been told that *both* key management modes (purely server-side and via client callback) are supported. You asked why

Re: [Firebird-devel] ODP: Re: Database UUID

18.11.2015 19:06, Dimitry Sibiryakov wrote: > 18.11.2015 16:37, liviuslivius wrote: >> what is the purpose of this uuid? >> I disconnect all users and copy db file and i have now two db with same uuid. > > Yes. And then database encryption and replication subsystems (or any other > code that >

Re: [Firebird-devel] Database UUID

18.11.2015 21:17, Leyne, Sean wrote: > > Consider: I want to restore a copy of my production database to my testing > system and have the same UUID as Live because I have defined a number of > config/operational values based on the UUID. Consider: I have a replication set up with replica B

Re: [Firebird-devel] Database UUID

18.11.2015 13:59, Dimitry Sibiryakov wrote: > > Do I understand right that clumplets in header page are not a part of ODS, so > subj can > be added to them even now? What do you mean by "now"? v3 RC2? Dmitry --

Re: [Firebird-devel] Database UUID

18.11.2015 14:24, Dimitry Sibiryakov wrote: >> What do you mean by "now"? v3 RC2? > > Tomorrow. ;) Yes, in v3 RC2. Adding it is one part of the deal. How should it be retrieved by the client? When/how should it be created for already existing ODS12 databases? What if application relies on it

Re: [Firebird-devel] Database UUID

18.11.2015 14:45, Dimitry Sibiryakov wrote: >> How should it be retrieved by the client? > > No way. Why do we need something that nobody can use? >> Should nbackup preserve or reset it? > > Preserve because technically it is the same database. Here we disagree. It becomes a

Re: [Firebird-devel] Database UUID

18.11.2015 23:20, Leyne, Sean wrote: > > as long as UUID and Crypt Database ID are understood to be separate values Here I completely agree. Dmitry -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Several connections to encrypted database in SS mode

17.11.2015 23:48, Leyne, Sean wrote: > > Again, I feel that they issue of client/server connection encryption and > database encryption are being co-mingled. > > Database encryption is about the engine's ability to access/work with a > database, there should be absolutely no client dependency.

Re: [Firebird-devel] class ValueListNode in Nodes.h => Performance issues

16.11.2015 16:50, Adriano dos Santos Fernandes wrote: > > dsqlChild and jrdChild are used for default processing, king of old > nod_count. > > Most nodes has individual members for each sub-node and they are added > to *Child. > > "items" of this class is an array, but it's added to *Child as

Re: [Firebird-devel] Pull request fixed (explained plan xml format)

11.11.2015 01:25, liviusliv...@poczta.onet.pl wrote: > > Is this pull request useful at all or this is useless for FB team? > I try to start to teach FB code, to work in the future on more useful and > harder topics. > But i must get start point, will be good to see feedback (and also > criticism)

Re: [Firebird-devel] ODP: Re: FB3 Run-time Statistics in gbak Verbose Output and also Release Notes

10.11.2015 20:15, liviuslivius wrote: > > for every line date time will be different. Date part will be the same, that was the Vlad's point. Redirect output to gbak-DDMM.log and look inside the log for the timings. Dmitry

Re: [Firebird-devel] Pull request fixed (explained plan xml format)

11.11.2015 04:40, Adriano dos Santos Fernandes wrote: > About the code style... > > You surely should not reinvent another style. It's very easy to see that > things like > > else > if (...) > > Is never used this way in Firebird code. > > Also, nobody write this kind of things

Re: [Firebird-devel] FB3 & W7E

09.11.2015 17:23, Геннадий Забула wrote: > IMO, this is a good solution not to touch folder. But there > should be a separate package for fbclient stuff (maybe even without > msvc*.dll, only icu* dependencies) so software developers can include > it in theirs software packages, and copy nearby

<    1   2   3   4   5   6   7   8   9   10   >