Re: [Firebird-devel] WNET future

What is a reason of droping it?Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Dmitry Yemanov Data: 30.11.2021 18:25 (GMT+01:00) Do: For discussion among Firebird Developers Temat: Re: [Firebird-devel] WNET future 30.11.2021 20:10, Dimitry Sibiryakov wrote:>>> Then

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

>> Also, I had plans to implement unlimited (well, OK, ULONG-counted) strings >> in the next major ODS. This really requires more API changes than some hacks >> with the sign bitWhen introduced then will be good to describe >> benefits/weekness of using varchar vs blob in such

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

>> For example - make all sizes uint32Why not uint64?Regards,Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Replication - generators' value are notreplicated

But such replica cannot became "master" database if master is broken/unavailable?Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Dimitry Sibiryakov Data: 18.05.2021 16:03 (GMT+01:00) Do: For discussion among Firebird Developers Temat: Re: [Firebird-devel] ODP:

Re: [Firebird-devel] 4.0 replication - One primary database with two modes

For me configuration error should prevent with working with database at all.Consider two entries with same alias but different path this is critical configuration error and silently ignore it is not good.Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Mark Rotteveel

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

Why not standard way by creating new field copy data delete old and rename? It can be slow operation, is it your conern to do not take production database too long offline? If yes, you can speed up such process if you have access to good hardware with a loot of RAM and do all in memory.I do not

Re: [Firebird-devel] New configuration parameter to resolve CORE-1241

wiadomość Od: Mark Rotteveel Data: 05.02.2021 14:42 (GMT+01:00) Do: firebird-devel@lists.sourceforge.net Temat: Re: [Firebird-devel] New configuration parameter to resolve CORE-1241 On 05-02-2021 14:32, liviuslivius wrote:> Are you sure that you talk about Firebird no Interbase con

Re: [Firebird-devel] New configuration parameter to resolve CORE-1241

Developers Temat: Re: [Firebird-devel] New configuration parameter to resolve CORE-1241 05.02.2021 13:29, liviuslivius wrote:> Wouldn't be enough that only first folder in the list will be used for these purposes?   The problem is not folder's usage but respecting configured limit to its s

Re: [Firebird-devel] New configuration parameter to resolve CORE-1241

Wouldn't be enough that only first folder in the list will be used for these purposes? And just mark it in the parameter description. Personall, i would not wait with the implementation to tablespaces existence, especially that someone is interested in implementing it now :)Regards,Karol

Re: [Firebird-devel] New configuration parameter to resolve CORE-1241

HiI do not know if i understand your description fully but for me this new config parameter should have priority over system variable. Is your sentence same as above?Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Dmitry Starodubov Data: 03.02.2021 14:45 (GMT+01:00) Do:

Re: [Firebird-devel] Usage of 32b version of Firebird

Yes, good point :)Onli some new feature need new client. But It is rather rare, but happen as e.g compression as i remember.Regards,Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Usage of 32b version of Firebird

Yes, client library must be 32 bit too for the long time.Many existig applications are 32bit and cannot be "migrated" to 64 bit in the near futureRegards,Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Local table in repicated database

I do not know if my scenario is handled by new replication feature, but i suppose only way is not fixing replicator, only metadata commit stage. E.g. table publication cannot be disabled if table have referential constraints. But i do not know how this can be fixed in opposite direction. Two

Re: [Firebird-devel] Local table in repicated database

I will not be concerning at it at all. As simple other scensrio cause more problems.Consider 2 tables with already replicated metadata. Second table have foreign key on first. But only second table data are replicated but first not. To what data foreign key will reference in replicated

Re: [Firebird-devel] OO API examples for Object Pascal

For me as a developer i need only udr examples to replace/extend old udf.All other code is not required as i drop TFDConnection and choose FB driver. And thats all. New features should be integrated by Embarcadero for its driver for Delphi. And this other part is for Embarcadero or FreePascal

Re: [Firebird-devel] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

Are you sure?It shoul use 2 as it i equal to(registro_pri_roest = 1 and registro_sec_roest = 1) or(registro_pri_roest = 1 and registro_sec_roest = 2)  Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Adriano dos Santos Fernandes Data: 17.06.2020 21:00 (GMT+01:00) Do:

Re: [Firebird-devel] FB 3 & 4, new API and the ARRAY type

HiAs always reality is different then programming paradigm. I opt to extend support of arrays not depricate it.But this is only one vote i do not know  what other users think about.Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Pavel Cisar Data: 22.04.2020 14:13

Re: [Firebird-devel] how to use "set bind" in F4

Go to download snapshots fb4Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

All my experience is same, FB is better then Interbase. FB miss some features available in Interbase but Interbase miss so many features available in FB then + is for FB.I only cannot accept that you say same about Delphi. It is something totally different.It is for me personally the best

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

>>>It is available at https://cc.embarcadero.com/item/30771 but I have no >>> idea if you can get license for it now. >>> >>> >>That link is only for existing, registered, users. >>Paul try this one https://cc.embarcadero.com/Item/30065 you must register - but this is free trial no paid

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

Two things1. What is calling convention should be cdecl.2. How do you alloc memory for string?Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Interbase vs Firebird by Embarcadero

Hi Embarcadero provide in marketing materials comparision about Interbase vs Firebird https://www.embarcadero.com/products/interbase/compare/interbase_firebird and comparision to others

Re: [Firebird-devel] Stored procedures example

HiIt really should be rewritten/updated.1. First select should use new type join kind not comma join kind.2. Field po_number should be prefixed with alias of the table.3. Order of exception and update should be reverted, sussped removed, also maybe this update should be run in autonomous

Re: [Firebird-devel] Legacy plan vs Explained is this ok?

Hmm.. interesting answer. I have thinked about and have more questions - but now it look as suppor question - sorry for continue it here. But >> Index scan without the upper "Bitmap" node means the same as legacy ORDER. when the Bitmap will be than, it will be legacy "2. RL INDEX

[Firebird-devel] Legacy plan vs Explained is this ok?

Hi tested on WI-V3.0.5.33187 Firebird 3.0 and WI-V3.0.5.33232 Firebird 3.0   i see that my query have legacy plan like this: PLAN (RL ORDER PK_ROZLICZENIE) but explained plan show this Select Expression     -> Filter         -> Table "ROZLICZENIE" as "RL" Access By ID             -> Index

[Firebird-devel] CORE-6199 - few question about Firebird 4

Hi   about http://tracker.firebirdsql.org/browse/CORE-6199   few question about Firebird 4   1. difference between GLOBAL_CN and SNAPSHOT_CN   GLOBAL_CN is it a last already commited transaction CN or next not used already CN? SNAPSHOT_CN - what it is? As i do not understand description from

[Firebird-devel] MON$STATEMENTS - DsqlCompiledStatement - Type

Hi   in TraceObjects.cpp in TraceSQLStatementImpl i can access DsqlCompiledStatement from the m_stmt->getStatement() and then i can know "Type" e.g. TYPE_SELECT, TYPE_UPDATE, TYPE_DELETE ...   How can i access this info in Monitoring.cpp for MON$STATEMENTS  (Monitoring::dumpAttachment) where i

Re: [Firebird-devel] Plan formatting

Ok, i need some final decision from the team. But i do not know team hierarchy and do not know who have final word here. If team can answer definitly to: 1. XML plan with or without attributes? I make it with attributes like MSSQL but i see some disadvantages. It is not always know

Re: [Firebird-devel] Plan formatting

>> A schema is a form of documentation and for tooling (classes generation). >> It's very welcome. Of course it will be good to have it. I do not negate this. But i suppose it is not required at start. >>With attributes, example: name="name", and not name. >>Nodes only for structures. I do

Re: [Firebird-devel] Plan formatting

: [Firebird-devel] Plan formatting 10.09.2019 13:30, liviuslivius wrote:> But does it mean that you prefere format with attributes then? Or longer one but without > attributes at all?   I'm not a team member but as an user I would prefer format that is understood by already existing

Re: [Firebird-devel] "set decfloat bind double precision" and others

>>Ok, this makes a bit more sense then. Yes, i do not ask exacly about BIND only all SET commands >> Although why obtain it through MON$STATEMENTS, when that is what the >> information API is for. >>And keep in mind that querying MON$STATEMENTS is relatively expensive, so >>building a

Re: [Firebird-devel] Plan formatting

>> I prefer JoinType with camelCase attributesOk, name convention two votes.  >> But does it mean that you prefere format with attributes then? Or longer one >> but without attributes at all?>> And if you use a xml schema, you should >> publish that schema.It is no real schema. It is now as

Re: [Firebird-devel] "set decfloat bind double precision" and others

>>I'm not aware of an option to query the current configuration.Will be good to >>have it. Consider situation when in some stored proc you need different >>behvior. You do not know to what walue you should restore settings, as you do >>not have a way to read it at start of proc.Regards,Karol

[Firebird-devel] "set decfloat bind double precision" and others

Hi   there are   SET DECFLOAT BIND double precision; SET TIME ZONE BIND   Is there a way to read current settings? Is there a way to restore it then? eg.   var_previous = GET DECFLOAT BIND;   SET DECFLOAT BIND double precision;   /* calculate something */   /* and now restore previous settings */  

Re: [Firebird-devel] ODP: ODP: ODP: Inserts and FKs

Why do you think that one isql have transaction read commited but second have snapshot? I do not see your transaction command. If you depend on automatic transactions started by isql, then both are the same, no randomness...Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web

Re: [Firebird-devel] Inserts and FKs

Hi"tx2 inserts a detail record in TableB    Trigger on TableB tries to update master record,    since the record is still not visible for this snapshot,    update has null effect"I do not understand this point. If table B i detail it can only insert record for visible to it record in master. Or

Re: [Firebird-devel] TIME WITH TZ

>>About tools: isql supports all newer featuresWho use isql, really?I suppose >>only to confirm some bug. I cannot imagine that someone use it by typing >>directly commands inside or looking at textual output if gui tools have >>grids, filtering...Regards,Karol Bieniaszewski nullFirebird-Devel

[Firebird-devel] Release date and more

Hi   i have few questions.   1.     When it is plan for releasing FB3.0.5?     I am interested in official support for Android there (fixed by Alexander Peshkov) which i can advertise and also report to Embarcadero to support it.   2.     Aproximate release month for FB4 - there are real good

Re: [Firebird-devel] Generating transactions

I have tested it before and now also. gbak -c -v -START 123456789 and database after restore looks like Database header page information: Flags 0 Checksum12345 Write timestamp Aug 9, 2019 15:17:08 Page size

Re: [Firebird-devel] Generating transactions

>>You mean for transaction handle? This really depend what client library do. I do not go into details about client libraries which i do not write, but i am talking abut transaction numbers. This was only sample where it can be usefull. For me it will be usefull in application developement.

Re: [Firebird-devel] Generating transactions

>>What would be tested in client library?If it is working ok in such situation >>like "id" greater then integer and some code in the library can have e.g. >>variable declared as integer.  Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at

Re: [Firebird-devel] Generating transactions

I do not remember where i found this info before, i can't find it now to show details about. But it is as an options listed in "gbak -?" -A(RCHIVE_DATABASE) backup database to archive -ARCHIVE_J(OURNALS) backup journals to archive -ARCHIVE_R(ECOVER)recover database from archive

Re: [Firebird-devel] Generating transactions

>>Other than engine debug of greater IDs, what would this be used for? to testing client libraries and client side applications. regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Generating transactions

liviuslivius napisał: Hi   i remember that was a switch in gbak restore, to restore db with next transaction set for specified value. But maybe this was Interbase not Firebird i have not access to the computer now   Regards, Karol Bieniaszewski  Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] Generating transactions

Hii remember that was a switch in gbak restore, to restore db with next transaction set for specified value. But maybe this was Interbase not Firebird i have not access to the computer nowRegards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at

[Firebird-devel] Can this case have more informative message?

Hi   simple query raise an error  "Cannot use an aggregate or window function in a WHERE clause, use HAVING (for aggregate only) instead."   SELECT  * FROM  RDB$RELATIONS R WHERE  R.RDB$SYSTEM_FLAG = 1  AND  (SELECT  COUNT(DISTINCT R.RDB$RELATION_NAME)  FROM  RDB$RELATION_FIELDS RF  WHERE  

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

>>from rdb$database - BOOM!But why is that boom?Why not show e.g.11.06.2019 >>16:08 (GMT+01:00)?This does require some conversion? This is stored during >>save process.Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

Guys be patient ;-) deep breath..Can i ask what is the problem? When i retrive data by client lib it try to convert it to local timezone or what? Is this the same as formatting normal date field into user interface which should be on the app side and we read only binary data? How it is done in

Re: [Firebird-devel] FB3 - Explained plan ordered result

> Would something like this be better: > -> Index "PK_DYREKCJA" Full Scan (ordered by < field name(s) >) > > ? > Mayby changing "Full Scan" name here is better? To e.g. "Ordered Retrival" or Full Scan (ordered) or Order Index "PK_DYREKCJA" Full Scan >>> If so, should it be printed for

[Firebird-devel] FB3 - Explained plan ordered result

Hi   i have looked at this simple explained plan and i see that from it i cannot read simply that result set is sorted and retrived by index.   Select Expression     -> Nested Loop Join (inner)         -> Filter             -> Table "DYREKCJA" as "D" Access By ID                 -> Index

Re: [Firebird-devel] Upgrading from 2.5 database with trigger on system table

I do not have this to test butcan such trigger be altered and then droped?Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_database_info and current database user

No, you can have e.g. windows autentication Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CORE-6005

Hi.   http://tracker.firebirdsql.org/browse/CORE-6005 I do not talk about problem itself but think about new feature.     Is this stable cursor a real cursor on which we can work and we can have some system name for it? e.g. name "RDB$UPDATE_RECORDS" What i think about is provide something like

[Firebird-devel] test

test message, because i have send two emails 16.02.2019 23:12 and 16.02.2019 23:27 but i still do see them on the group   regards, Karol Bieniaszewski  Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Latest OLTP results DB size resolved

How many core/threads is your CPU? 6 cores i7-8700K hyper disabled in the bios>> how much RAM does your system have?64GB cl13 Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Latest OLTP results

Hi 48 sessions Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CORE-5997

Hi   Can we discusse about CORE-5997? Why it was so fast closed as its iplementation is so important from performance POV?   Adriano say that strings are immutable - but this is only some implementation detail - all strings in C++ are mutable. PSQL implementation create strings as immutable i

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

Hi. I have thinked about oltp comparision, and i think that comparing e.g. classic vs superserver on RAM disc is wrong. Why? Because read from "disc" is as fast as read from cache. The comparision can show some problems but results must be analysed carefully. Regards,Karol Bieniaszewski

Re: [Firebird-devel] Some OLTP numbers

I suppose you run it too shortly.Run test in 2 or 3 hours. Look also at document count i have used Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

17% bigger and the difference grow with time Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

> > I do not know what was your settings. > > > Same as before. i have sent my settings few weeks ago, maybe you have it in the spam folder? > > > But for me, it is more interesting why db size for Fb2.5 is e.g 6GB but > > for FB3 it is 15GB after test. > > > Because 3.0 is faster for you

Re: [Firebird-devel] Some OLTP numbers

I do not know what was your settings.But for me, it is more interesting why db size for Fb2.5 is e.g 6GB but for FB3 it is 15GB after test.Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Some OLTP numbers

Thank you.Will be god if this repo will be part of Firebird project repo as autor is in the teamRegards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

I am also interestedRegards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB3 snapshot

Hi,today's snapshot of FB3 is missing regards,Karol BieniaszewskiFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] LOCALTIMESTAMP name

Hi,   why "LOCALTIMESTAMP" not "LOCAL_TIMESTAMP" as is for e.g. "CURRENT_TIMESTAMP"?   regards, Karol BieniaszewskiFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Some OLTP numbers

Hi,can you bring some light what that numbers mean?I do not understand your table.I can imagine something like this:Column1: total number of requests e.g. 1000kColumn2: total timeColumn3: requests per second.and maybe alsoColumn4: total fetchesColumn5: total readsRegards,Karol Bieniaszewski

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

Hi, maybe naive. But why keys ar not stored in uppercase then? Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] CORE-5921

Ok, i supposed that this go further. I need global CN from transaction start POV. I do not know if i can retrive it in On Transaction Start Trigger? Is that trigger serialized? If i start transaction no other transaction can be commited until this trigger is finished? You know myTrStartCN:=

[Firebird-devel] CORE-5921

Hi,   can you point me about usage cases about http://tracker.firebirdsql.org/browse/CORE-5921?   regards, Karol Bieniaszewski  Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Crypto functions in firebird

Hi, will be really good to have it.Now we use udf or transfer data to application layer. With encrypted conection itself this will be as a completed whole. Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Alex Peshkoff via Firebird-devel Data: 27.08.2018 11:15

Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue

Hi, > Certainly - it's very hard to have remote connections w/o appropriate > provider ;) i supposed that provider is for Firebird Server not for client library. > Yes - seems to be so. > Please add a ticket to the tracker - I will try to find time to > reproduce and fix it. > A. created

Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue

Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf Providers = Engine12, Remote then

[Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue

Hi,     i have succesfully connected my Delphi application using Firedac to Firebird embeded on Android. Firebird version is LI-V3.0.3.32900.   I can retrive data from tables from field types: Integer, BIGINT, CHAR,  VARCHAR, DATE, TIME, TIMESTAMP, FLOAT, DOUBLE But when i try to fetch something

Re: [Firebird-devel] Read consistency patch

>>In this case exactly. You wrote about read >>committed transactions so I >>made such notation) ok, yes i have wroted i simplified example about read commited but here snapsot is vital >>One more note about your idea. Engine >>will have to read every record >>in anycase. But maybe expression

Re: [Firebird-devel] Read consistency patch

> Note: this SELECT may have greater CN then you have stored and it > means on the next step you may receive records already selected here. > You merge algorithm should take it into account. > > Roman Simakov If transaction is in snapshot isolation mode then problem should not exists Firebird

Re: [Firebird-devel] Read consistency patch

>I don't know if IB's "Change View" really useful feature. Do you have some > expirience\opinon? > > Regards, > Vlad Sadly, no. We have had too many problems with Interbase stability and the worst ever seen paid support (Fortunately, Delphi support works well), that we have not tried to

Re: [Firebird-devel] Read consistency patch

Ok, the name is not so important but call it recentCN but extended sample -- Is this possible that this CN(commit number) of transactions (pair transaction id + CN) can be stored into some table? Is it possible to retrive most recent CN from transaction start point

Re: [Firebird-devel] Read consistency patch

> > you do > > SELECT * from tableX where RDB$RECORD_VERSION>2 > > > > above select will not see data commited by transaction id=1 because > > it modify records before tr2 start > > and tr1 is commited after tr2 start > > :) tr1 committed BEFORE select in tr2 and in read committed mode MUST >

Re: [Firebird-devel] Read consistency patch

see data commited by transaction id=1 because it modify records before tr2 start and tr1 is commited after tr2 start regards, Karol Bieniaszewski W dniu 2018-07-24 11:27:54 użytkownik Dimitry Sibiryakov napisał: > 24.07.2018 10:13, liviuslivius wrote: > > It can provide simple way to

[Firebird-devel] Read consistency patch

Hi,   question about this patch https://github.com/FirebirdSQL/firebird/pull/105   Is this possible that this CN(commit number) of transactions (pair transaction id + CN) can be stored into some table? Is it possible to retrive most recent CN from transaction start point (call this SCN). It can

[Firebird-devel] CORE-5877 Garbage in the compound index after several updates

Hi,   i ask here to not spam into the tracker. I know that indexes in Firebird are not transactional objects.   My understanding was that when we update record then old record vesion go to new place and new record version replace place where old record version was. This prevent for updating index

Re: [Firebird-devel] Smart end of statement detection in ISQL

Hi, remember about CASE ... END Regards,Karol Bieniaszewski null-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web

Re: [Firebird-devel] RFC: External Connections Pool

>>Explain, please. The statement above >>could be understood in many different ways. >>Regards, >>Vlad  if pool contain connection to database 1and user try to connect to also database 1 he can use pool instead normal connection.Now i see that you are talking only when user use execute

Re: [Firebird-devel] RFC: External Connections Pool

Hi, can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on database 2 from 1. Third connect simply to database 1 why it can not benefit from pool? Regards,Karol Bieniaszewski

Re: [Firebird-devel] CORE-5343 and CORE-2557

Hi, Is the same for mon$statements and other mon tables? Regards,Karol Bieniaszewski null-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

[Firebird-devel] CORE-5343 and CORE-2557

Hi,   can you point me if i understand correctly that if user need to see all data in e.g. mon$attachement i cannot grant he/se privilege or add this privilege to currently existed role instead i must create separate role for this and grant this role to user or grant that role to other role?   If

Re: [Firebird-devel] CHAR fields in system tables

Hi, i agree with you totally. Because of something like this i have made wrong assumption when i have created http://tracker.firebirdsql.org/browse/CORE-5807. I never create char fields for variable length data. But FB developers can show some light on this i suppose Regards,Karol Bieniaszewski

Re: [Firebird-devel] "Postfix for CORE-5791. Sorry to snapshot builds users..."

But if i restore database under snapshot without that commit i will got ods_minor=1 And then i must backup without that commmit and restore under commit. Than i must update server to new snapshot. Regards,Karol Bieniaszewski

[Firebird-devel] "Postfix for CORE-5791. Sorry to snapshot builds users..."

Hi Alex   what does comment : ""Postfix for CORE-5791. Sorry to snapshot builds users - had to change ODS minor once again. If someone was using snapshots with ODS 12.1 please backup with old snapshot code and restore using current one. " in commit

Re: [Firebird-devel] About support for embed into iOS/Android

Interesting that CORE-3885 is closed as fixed then i suppose only WEB-146 should be processed? ;-) Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Paul Beach Data: 18.01.2018 15:04 (GMT+01:00) Do: For discussion among Firebird Developers

Re: [Firebird-devel] About support for embed into iOS/Android

Hi Paul, this is wrong assumption :)The interest exists but if work is not advertised, nobody can vote on it.I know that tracker exists but maybe this should be described on web page with link to the tracker to vote on it. You then will se the real interest. You have my vote at start :)

Re: [Firebird-devel] Weird date/time literals

Hi, I see only one usage case. To know when proc eas compiled. But i do not know if this can be usefull. I do not know how this is documented, but if as warning than it can be changed without problem. And as Adriano this looks more like bug then feature Regards,Karol Bieniaszewski

Re: [Firebird-devel] Memory leak - How can I provide information about it?

Hi Vlad, "This temporary blobs could be released on commit (rollback) only" just curious, why it can not be released after it is used? Regards,Karol Bieniaszewski null-- Check out the vibrant tech community on one of the

[Firebird-devel] Build sources

Hi, I try to build Fb master from sources.What is the recommended environment for Windows. Can i use MSVC14 Express?Or it must be MSVC12? I see that for libtomcrypt is only MSVC12.sln.When i tried to compile it under ide i got that command line switches /ZI and /Gy are incompatibile. Is there

Re: [Firebird-devel] FB4 fetches

Oryginalna wiadomość Od: liviuslivius <liviusliv...@poczta.onet.pl> Data: 15.09.2017 10:35 (GMT+01:00) Do: For discussion among Firebird Developers <firebird-devel@lists.sourceforge.net> Temat: [Firebird-devel] FB4 fetches Hi, I test FB4 (744) 64bit on Windows and i h

[Firebird-devel] FB4 fetches

Hi, I test FB4 (744) 64bit on Windows and i have restored db with 32KB page size.Now i have question about query stats.Is it normal that fetches fluctuate on every query run? I mention 32K because it is bigger difference under 32 then 16. E.g. 16KB page size and fetches428937428936428931 E.g.

Re: [Firebird-devel] Lateral derived tables (was: Plans to support cross and outer apply)

Hi, 1aBecause it is the same asFROM LEFT JOIN (SELECT) 2a LATERAL is for context reference and cannot be missed 3b if it work already as lateral but is this the true? Or only for referenced stored proc? 4b as it should be derived table Regards,Karol Bieniaszewski Oryginalna wiadomość

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

Hi, about what stability issues are you talking about? Regards,Karol Bieniaszewski Oryginalna wiadomość Od: Slavomir Skopalik Data: 13.08.2017 21:26 (GMT+01:00) Do: firebird-devel@lists.sourceforge.net Temat: Re: [Firebird-devel] Useful SQL Stored

Re: [Firebird-devel] rare segfault in fb_shutdown()

Hi, http://www.firebirdsql.org/en/snapshot-builds/ or you can build it from code https://github.com/FirebirdSQL/firebird/commits/B3_0_Release regards, Karol Bieniaszewski W dniu 2017-01-16 11:40:23 użytkownik Stephan Bergmann napisał: > On 01/15/2017 07:26 PM, Alex

  1   2   3   >