Re: [Firebird-devel] column naming rules

On Wed, Jun 15, 2011 at 8:34 AM, Treeve Jelbert tre...@scarlet.be wrote: I have been converting some code which was written to access a database from python. The origin code was for postgresql/sqlite but Firebird objects to some names of the type '_xyz'. Apparently the leading underscore has

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

On Mon, Aug 29, 2011 at 5:57 PM, Vlad Khorsun hv...@users.sourceforge.netwrote: Another issue here is that when a non-recoverable error happens (e.g. request synchronisation error), Hmm... is it unrecoverable error ? BTW, request synchronisation error could happen only at fetching

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

On Mon, Nov 14, 2011 at 5:11 PM, Thomas Steinmaurer t...@iblogmanager.comwrote: Ok, but is there a way then to tell how many pages have been fetched from the cache as the number above for fetched is more likely referenced and not real number of pages fetched from memory? Pages aren't

Re: [Firebird-devel] Database shutdown when udf raises an exception

On Thu, Dec 8, 2011 at 3:19 PM, Jesus Garcia jeg...@gmail.com wrote: If using superserver, when the abnormally shutdown starts, if another thread is committing and updating a big amount of pages of several types, the commit process can be terminated without finish, and some pages are writen

Re: [Firebird-devel] Firebird Transaction ID limit solution

On Mon, Jan 2, 2012 at 2:32 PM, Yi Lu y...@ramsoft.biz wrote: Approach 1 seems to be least risky. Disk space should not be a big issue with today's hardware. The problem is not disk space, but locality of reference. With small records, adding four bytes could decrease the number of rows per

Re: [Firebird-devel] Firebird Transaction ID limit solution - Email found in subject

Sean, The problem is not downtime is how much downtime. Backup and restore is so much downtime. There are a couple of possible solutions which would reduce the downtime; - a new backup/restore tool which would use multiple readers/writers to minimize execution time, Here we're talking

Re: [Firebird-devel] Firebird Transaction ID limit solution

Dimitry, - a data port utility which would allow for data to be ported from a live database to a new database while live is active but would need a finalization step where the live database is shutdown to apply the final data changes and add FK constraints.   And exactly this utility is

Re: [Firebird-devel] Firebird Transaction ID limit solution

Woody, Maybe I'm a little dense, (probably :), but doesn't FB already know what the oldest interesting transaction id is? Why couldn't transaction numbers be allowed to wrap back around up to that point? As long as transactions are committed at some point, the oldest transaction would move

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

Mark, I am currently going over the JDBC metadata returned by Jaybird, and I was looking for a way to see if a column is COMPUTER BY / GENERATED ALWAYS AS. I found that I should probably look at RDB$FIELDS.RDB$COMPUTED_BLR or RDB$COMPUTED_SOURCE for this, but I noticed that

Re: [Firebird-devel] [SPAM 5] Re: Firebird Transaction ID limit solution

Kjell, Or a more automated and built-in support to do such a replicate/backup/restore/reverse. For me it's question of time. Sure, I could learn how to setup a cluster and replication. But there are dozens of other things I also need to do yesterday, so having to learn this on top of

Re: [Firebird-devel] Meaning of RDB$RELATION_FIELDS.RDB$UPDATE_FLAG

On Tue, Jan 3, 2012 at 4:56 PM, Mark Rotteveel m...@lawinegevaar.nl wrote: The definitive sign of a computed field is RDB$COMPUTED_BLR in either RDB$FIELDS or RDB$DOMAINS if the field is defined through a domain There is no RDB$DOMAINS ... Too many databases... indeed, it's RDB$FIELDS

Re: [Firebird-devel] Raising the BLR level

Claudio, Hello, currently the engine supports BLR4 (legacy) and BLR 5. All FB versions generate BLR 5. But we are hitting some limits and I think we should increase it again (this would be for the first time for FB). Dmitry asked me to get rid of the 255 streams limit but what I did is only

Re: [Firebird-devel] Raising the BLR level

Having started this discussion by agreeing with Claudio, now let me suggest that I was probably wrong. I'll think about it a bit more, but finding a way of extending blr compatibly seems like a much better idea. That lets old databases continue to work and avoids the whole discussion of what

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

On Wed, Apr 4, 2012 at 6:42 AM, Dmitry Yemanov firebi...@yandex.ru wrote: 2. gfix -encryptplugin {-cryptparparameter} database gfix passes plugin name and parameter in DPB, the rest of activity are like in database validation. This implementation looks like most simple to implement.

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

On Wed, Apr 4, 2012 at 8:26 AM, Kjell Rilbe kjell.ri...@datadia.se wrote: OK, but that doesn't change what its current name seems to imply. And it is the tool we have that fixes databases - with the mend option. Not that I'd use it if I had a choice like IBSurgeon, but ... Ann

Re: [Firebird-devel] Raising the BLR level

On Mon, Mar 5, 2012 at 6:25 PM, Claudio Valderrama C. cva...@usa.net wrote: (Thorny issue, I hope Ann Harrison will comment.) And now, finally, a month later she does. Included after my signature is a bit of MySQL code which may explain my desire to keep things as simple as possible. Hello

Re: [Firebird-devel] Index and INNER JOIN

On Mon, Aug 13, 2012 at 11:15 AM, arnaud le roy sdnetw...@gmail.com wrote: it's normal that only the indexes on one table is used during an inner join ? No, but this is a support question, not a developer question, and should be sent to firebird-supp...@yahoogroups.com. When you send your

Re: [Firebird-devel] Database dialect and BIGINT in metadata

On Wed, Oct 31, 2012 at 6:51 AM, Mark Rotteveel m...@lawinegevaar.nlwrote: Also didn't Firebird internally already have 64 bit fields (eg DOUBLE, ISC_QUAD), or are all those also artefacts of dialect 3? InterBase was developed on MicroVaxen which had a 64-bit integer datatype. So from V1,

Re: [Firebird-devel] Database dialect and BIGINT in metadata

On Thu, Nov 1, 2012 at 9:32 AM, Dimitry Sibiryakov s...@ibphoenix.com wrote: Way to nowhere. No matter how long new datatype is, 1/3 won't be precise. 1/3 is precise in base 6, though of course 1/5 isn't. And frankly, double precision doesn't help much either since it can't represent

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

On Sat, Nov 17, 2012 at 3:36 AM, Dmitry Yemanov firebi...@yandex.ru wrote: gbak - fb_dump nbackup - fb_backup because IMO it better reflects their goals. Gbak is not equivalent to the MySQL or Postgres dumps which produce a series of insert statements that can be edited. From my

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

On Mon, Nov 19, 2012 at 11:41 AM, Alex Peshkoff peshk...@mail.ru wrote: What can be said for sure - a series of insert statements is definitely not optimized for size, but certainly well compressable. The more serious problem is that each insert statement has to be compiled and optimized -

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

On Mon, Nov 19, 2012 at 11:51 AM, Dalton Calford dalton.calf...@gmail.comwrote: Most hex encoded dumps have special programs to load the data back into the engine - I could not imagine anyone trying to use a straight sql script to handle any large datasets. I assure you that MySQL dump

Re: [Firebird-devel] Sweep process too many writes to disc

On Thu, Jan 3, 2013 at 4:22 PM, Karol Bieniaszewski wrote: i have problem with understanding internal work of sweep my db size is 52.74GB i detach from db restart fb server and run sweep by gfix -sweep. now i see in task manager that Firebird 2.5.3.26584 write to disk 1154 GB this is 21

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

On Sat, Jan 5, 2013 at 5:35 AM, Dimitry Sibiryakov s...@ibphoenix.com wrote: A dumb question: when touched pages are flushed to disk? a) after each single version removal b) after all versions of a record removal c) after all versions of all records on a data page removal d) after

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

On Sat, Jan 5, 2013 at 6:12 AM, Dimitry Sibiryakov s...@ibphoenix.com wrote: 05.01.2013 11:59, Vlad Khorsun wrote: In general, pages are written as result of a) page cache preemption (when new page should be read into cache and least recently used page is dirty) b) precedence

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

Sean, To be clear, you are saying that if a row as an index on Field A which has 4 record versions (3 which can be dropped), and the value of the index for those versions where 1, 2, 3 and 4. When the sweep encounters the row, when it scrubs version 1, if reads the index and tries to find

Re: [Firebird-devel] API data types

Dmitry, 1) If we ever face a platform with sizeof(int) == 8 (IA64? anything else?) would it be OK that our API becomes platform-specific in regard to its ABI? Or was it exactly the goal? IIRC, we had discussed using types from stdint.h instead, but I don't remember any decision. When there

Re: [Firebird-devel] RFC: non-expandable fields

On Thu, Apr 4, 2013 at 3:29 PM, Sergey Mereutsa s...@dqteam.com wrote: Hello Vlad and all, IMHO, the easiest way to implement this is to make all fields with prefix RDB$ (or whatever) hidden by default. Untill you do not address to those fields directly - they are ignored by the engine,

Re: [Firebird-devel] RFC: human-readable DBKEY

Unfortunately, DBKEY has variable size and not always fit into int64. It has a fixed size and its recno part (leaving the relation id aside) always fits into int64. It's currently fixed at 8 bytes for simple tables and 8 bytes * number of streams for views. I like the function approach.

Re: [Firebird-devel] RFC: non-expandable fields

On Fri, Apr 5, 2013 at 11:34 AM, Doug Chamberlin chamberlin.d...@gmail.comwrote: I would implement it so that if a user does not have SELECT permission on a field that any mention of that field in a SELECT statement is an outright error for that user. Just as if the field did not exist. I

Re: [Firebird-devel] RFC: human-readable DBKEY

Dmitry, True, db_keys from aggregate views are problematic, but not for simple joined views. Correct and it hasn't changed. I just meant that the view's DBKEY is not something separate, it simply a concatenation of the individual tables DBKEYs. You cannot select from a joined view using

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4190) Wring value of data pages average fill percent in GSTAT in case of storing varchars that much longer than page size

On Aug 22, 2013, at 7:37 AM, Pavel Zotov (JIRA) trac...@firebirdsql.org wrote: Wrong value of data pages average fill percent in GSTAT in case of storing varchars that much longer than page size --- ... Page size4096 ODS

Re: [Firebird-devel] Unicode UTF-16 etc

On Aug 31, 2013, at 4:55 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: On 29-8-2013 17:41, Jim Starkey wrote: Paradoxically, Japanese strings tend to be shorter in UTF-8 than 16 bit Unicode. The reason is simple: There are enough single byte characters -- punctuation, control characters,

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4201) computed field has null value inside BI trigger

I think this is correct - if unexplicable - behavior according to the Standard. Something about the state of the coulmn prior to the operation. On Aug 31, 2013, at 8:13 AM, Gorynich (JIRA) trac...@firebirdsql.org wrote: computed field has null value inside BI trigger

Re: [Firebird-devel] Record Encoding, was Unicode UTF-16 etc

On Tue, Sep 3, 2013 at 5:04 AM, Dimitry Sibiryakov s...@ibphoenix.com wrote: What problem do you foresee? AFAIK, ccess to single field values is already incapsulated in record class, so string buffer in DSC can be replaced with pointer without hacking whole engine. So, only SQZ

Re: [Firebird-devel] FWD: Re: Compatibility FB3.0 boolean and Interbase

On Wed, Nov 13, 2013 at 4:01 AM, Dimitry Sibiryakov s...@ibphoenix.comwrote: 13.11.2013 9:17, Alex wrote: For me main problem is that we do not know format of interbase messages when boolean is used in them. We do not know alignment rules. We know _nothing_ about internals of boolean

Re: [Firebird-devel] Some aspects of the optimizer hints

Alex, Furthermore, despite the everyone's instinct, it's a good deal faster in the general case to read a table in an optimal order and sort the data in memory that to read the data in index order - random order relative to storage. Ann, from server POV you are definitely right. But

Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db

On Mon, Jan 13, 2014 at 3:52 PM, Andrzej Hunt andr...@ahunt.org wrote: Unfortunately we have no choice but to use the backup format as we have to have to be endian-agnostic. It's possible to modify Firebird to be endian agnostic - I did it for a customer some years ago. Works fine for

Re: [Firebird-devel] MySQL versus Firebird

On Tue, Mar 11, 2014 at 9:47 AM, marius adrian popa map...@gmail.comwrote: I posted here so maybe it can help us to update the sql conformance page http://www.firebirdsql.org/en/sql-conformance/ ps: he is not quite a random guy on the internet but a quite biased at the end Software

Re: [Firebird-devel] The invisible generator and the rdb$ prefix

On Thu, Apr 3, 2014 at 2:06 PM, Claudio Valderrama C. cva...@usa.netwrote: AFAIK, you can put triggers on sys tables and they last until the last attachment finished. When the db is loaded again, those triggers do not load. I don't know if that changed recently, but was this way since I

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

On Sat, May 10, 2014 at 3:03 AM, Molnár Attila amol...@mve.hu wrote: *Optimization II. *- temporal indexing of materialization : e.g. when ORDER/GROUP BY has no index then currently the whole resultset is materialized, and the sorting moves the whole row each time. Instead of this it

Re: [Firebird-devel] A patch to submit

On Mon, May 19, 2014 at 11:47 AM, Dimitry Sibiryakov s...@ibphoenix.comwrote: 6) Implement erase-in-place which leads to significant code simplification. Can you explain erase in place briefly? In specific, how is it undone in a catastrophic failure (i.e. not a transaction cleanup)? Thanks,

Re: [Firebird-devel] A patch to submit

On Mon, May 19, 2014 at 12:29 PM, Dimitry Sibiryakov s...@ibphoenix.comwrote: : Can you explain erase in place briefly? I simply call update_in_place() with delete stub from VIO_erase() if the head record version is marked with the same transaction number. I.e. the same logic used as

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

On Fri, May 23, 2014 at 3:03 AM, Paul Beach pbe...@ibphoenix.com wrote: - Any other suggestion? Drop dialect 1 support. Allow dialect 1 to have access to BIGINT fields. For what little it's worth, a) Dialect 1 did include 64bit integers at one time. VAX's had a native 64 bit

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

On Jun 23, 2014, at 3:57 PM, Nikolay Samofatov nikolay.samofa...@red-soft.biz wrote: Some records for a join can be read before a transaction is committed, and some after. Same with EXISTS. It can see different set of commits from the one when main row was read. You can see partial

Re: [Firebird-devel] Meaning of incarnation

Mark, In various places of the Firebird wire protocol and the Firebird sources the term 'incarnation' is used. What does this mean? For cross-version compatibilty, most objects have a version number, sometimes called incarnation. Objects that have not changed will be zero. At least

Re: [Firebird-devel] dtype_packed

On Aug 5, 2014, at 5:50 AM, Dmitry Yemanov firebi...@yandex.ru wrote: 05.08.2014 12:19, Mark Rotteveel wrote: it seems that dtype_packed is also known in COBOL (and SAP) for a BCD (binary coded decimal). dtype_packed really seems to be a packed decimal, however it's not used by

Re: [Firebird-devel] New Interface

On Aug 12, 2014, at 1:11 PM, Jim Starkey j...@jimstarkey.net wrote: My position is that the external interface (the API) should remain y-valve and handle oriented, extended as needed. An interface for export engine semantics, however, has different requirements and can and should be

Re: [Firebird-devel] Error messages how-to

On Aug 12, 2014, at 1:17 PM, Jim Starkey j...@jimstarkey.net wrote: Sigh. There used to be database based system to create and edit messages and generate header and message files. Very handy using a database to develop a database system. Please lets not get into the moral and

Re: [Firebird-devel] Hiding source code of procedures and triggers will not work in FB 3

Anyone who's followed the support list for a decade or so knows that developers frequently ask how they can protect the source of their procedures. And, likewise, that the answer is that the esssence of the procedure is the BLR and must be readable to be used, so the best option is to mask the

[Firebird-devel] Thought about constraint declarations for V4

When we decided not to validate constraints on declaration, our reasoning was that computations and database access were expensive and any decent application programmer or DBA would always validate constraints before declaring them and control access to the constrained items until the constraint

[Firebird-devel] Indexes - things to think about for V

If, in Firebird 4, you're going to look at indexes, I have four suggestions. 1) Indexes with large keys An index key that's a significant fraction of the page size leads to inefficient indexes (or infinite depth), so rules about index size aren't just the revenge of database management system

[Firebird-devel] Indexes - things to think about for V

If, in Firebird 4, you're going to look at indexes, I have four suggestions. 1) Indexes with large keys An index key that's a significant fraction of the page size leads to inefficient indexes (or infinite depth), so rules about index size aren't just the revenge of database management system

Re: [Firebird-devel] Struct declarations

On Nov 29, 2014, at 2:44 PM, Stuart Simon stuart...@gmail.com wrote: I am writing a research paper that involves the Firebird source code. I have found the Firebird Internals Reference, but it dates from 2009. My questions: Are the struct declarations still the same? Where could I find

Re: [Firebird-devel] Fields in data pages

On Nov 30, 2014, at 6:35 PM, Stuart Simon stuart...@gmail.com wrote: OK, but version numbers tell me nothing. What I am looking for is an explanation of how Firebird (the package) can tell which bytes belong to which fields. Somehow Firebird must be able to tell the difference between

Re: [Firebird-devel] Fields in data pages

sorrry, late tired. first name 20, not 23 Cheers, Ann On Nov 30, 2014, at 8:38 PM, Ann Harrison aharri...@nimbusdb.com wrote: On Nov 30, 2014, at 6:35 PM, Stuart Simon stuart...@gmail.com wrote: OK, but version numbers tell me nothing. What I am looking for is an explanation

Re: [Firebird-devel] Fields in data pages

Simon, Not to be rude or anything, but does FirstAID Extractor decrypt all types of BLOBs? Firebird, like InterBase, has a mechanism for translation among blob formats called blob filters. There is a filter that translates the RDB$DESCRIPTOR format to a readable format. Isql, the

Re: [Firebird-devel] Odp: 255 contexts limit

On Feb 1, 2015, at 3:13 PM, liviusliv...@poczta.onet.pl liviusliv...@poczta.onet.pl wrote: P.S. I do not know how context are counted? Every data input source is a separate context. Every table in join? Every input stream - so a self join has more contexts than tables. this is one

Re: [Firebird-devel] RDB$RELATIONS.RDB$SYSTEM_FLAG

On Thu, Jan 8, 2015 at 10:27 AM, Dimitry Sibiryakov s...@ibphoenix.com wrote: What were supposed to be tables/views with system flag 1? As far as I know, the only value used was 2, which QLI used for its tables of procedures and aliases. Cheers, Ann

Re: [Firebird-devel] Time to update our headers.

Jim wrote: MPL should never be used for Firebird code. It gives specific rights to Netscape. And another several interesting and valuable lessons of history. It's not true that he had to talk me out of GPL. I knew that the goal of open source InterBase was to provide tools for future

Re: [Firebird-devel] Time to update our headers.

On Mar 14, 2015, at 8:00 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: I have skimmed the MPL 1.0, 1.1 and 2.0 but as far as I can tell it never assigns specific rights to Netscape or Mozilla. Could you point out where it does this? In 1.0, the problems come in section 6. I haven't

Re: [Firebird-devel] usage privileges

On Mar 29, 2015, at 8:58 AM, Alex Peshkoff peshk...@mail.ru wrote: Currently access to sequences/generators and exceptions is not limited, i.e. user not granted explicitly any rights can access sequences and exceptions. I wonder - who added that privileges in such way? Is it WIP or a

Re: [Firebird-devel] Time to update our headers.

I wrote: My recollection is that the IPL was worked out among Paul, me, Dale Fuller, and a few others. The original Mozilla licenses gave ownership rights to Netscape. We changed it to Inprise and its successors. When Firebird launched as an independent entity, we (same crowd, minus

Re: [Firebird-devel] Time to update our headers.

On Mar 5, 2015, at 8:38 AM, marius adrian popa map...@gmail.com wrote: Ok understand , What i ask is that new code to be under MPL 2.0 without any changes to the license text like they did in the libreoffice case http://cgit.freedesktop.org/libreoffice/core/tree/COPYING.MPL This will

Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation

On Mar 5, 2015, at 11:26 AM, liviusliv...@poczta.onet.pl liviusliv...@poczta.onet.pl wrote: Hi, It is usefull for testing purposes. Consider monitoring what actually is in some table from other connection or software before some long task has finished. Nothing is in a table until

Re: [Firebird-devel] Time to update our headers.

On Mar 5, 2015, at 12:07 PM, Paul Beach pbe...@ibphoenix.com wrote: 05.03.2015 16:13, Dimitry Sibiryakov wrote: We are talking about sources (particularly headers), no?.. I mean that if you are going to update headers to a new license URL, it would be better if it is official

Re: [Firebird-devel] Dropping index on domain change?

On Jul 1, 2015, at 9:34 AM, Dmitry Yemanov firebi...@yandex.ru wrote: 01.07.2015 13:49, Vlad Khorsun wrote: Not sure what you mean by same? Let's say I change it from smallint to int. All kind of numbers have the same representation in index keys. Except BIGINT, IIRC. Which was a

Re: [Firebird-devel] Preventing error code collision

remember ever having seen an error code with the bit 30 (warning) or 31 (info) set. Or is it used somewhere internally as an in-band channel? Looks like something planned at the past (before Firebird) but never used... 27.07.2015 1:24, Ann Harrison wrote: Firebird

Re: [Firebird-devel] Preventing error code collision

On Sun, Jul 26, 2015 at 5:15 PM, Vlad Khorsun hv...@users.sourceforge.net wrote: Or is there a reason to ignore those higher bits for the facility and code? I have no idea why ENCODE_ISC_MSG written in this way. CLASS_MASK seems to not be used anywhere, or at least I can't remember

Re: [Firebird-devel] optional SET TERM

> On Oct 15, 2015, at 9:59 AM, Dimitry Sibiryakov wrote: > > 15.10.2015 15:51, marius adrian popa wrote: >> In InterBase 7 is changed so procedure and trigger programming language to >> no longer >> require the use of SET TERM > > IMHO, this is unnecessary complication

Re: [Firebird-devel] Altering collation of field

On Wed, Sep 23, 2015 at 5:25 AM, Jiří Činčura wrote: > Nobody? > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > On Wed, Sep 16, 2015, at 12:28, Jiří Činčura wrote: > > Hi *, > > > > there's currently no way of altering collation of field in 2.5.4, right? > > I checked

Re: [Firebird-devel] Feature request & discussion for V4 (same as for V3)

On Mon, Apr 11, 2016 at 7:40 AM, Dimitry Sibiryakov wrote: > 11.04.2016 13:28, Dmitry Yemanov wrote: > > But it can be made possible. The question is whether it's worth it. > >While bug with orphan index nodes is living in the engine - index only > scan is > impossible

Re: [Firebird-devel] Feature request & discussion for V4 (same as for V3)

On Fri, Apr 8, 2016 at 5:54 AM, Molnár Attila wrote: > > > *O* > *ptimizations*- IS NOT NULL should use index. It is equivalent with > >= min_value or <= max_value based on index direction > Histograms and clustered indexes (if they're being considered) could help here to

Re: [Firebird-devel] BLR contexts limit

On Thu, Mar 24, 2016 at 7:52 AM, liviuslivius wrote: > > > I'm not sure I get you here. How number of columns does relate to number > > of contexts? > > > > this is because Array DML(in Delphi) use execute block with parameters > and all parameters/variables are

Re: [Firebird-devel] RFC: Tablespaces

On Wed, Mar 2, 2016 at 4:23 PM, Dmitry Yemanov wrote: > > When we speak about tablespaces, it usually means that the database > consists of multiple files and different database object are stored in > different files. Each such file is named within a database and called a >

Re: [Firebird-devel] RFC: Tablespaces

On Wed, Mar 2, 2016 at 4:51 PM, 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. > > Interesting idea. I'm not quite sure how it

Re: [Firebird-devel] RFC: Tablespaces

On Thu, Mar 3, 2016 at 1:02 PM, Jim Starkey wrote: > > >> Non-goals: > >> > ... > >> 2. Store blobs in other than the table's data space. > > Why not allow blobs to be separated from regular data ? > > OK, reasonable question. Obviously they could, but it would

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

On Jan 18, 2017, at 11:17 AM, Gerhard S (JIRA) wrote: > > Insert NULL into identity column with auth generated value > -- > > Key: CORE-5460 > URL:

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5460) Insert NULL into identity column with auth generated value

> On Jan 19, 2017, at 1:46 AM, Dmitry Yemanov <firebi...@yandex.ru> wrote: > > 19.01.2017 00:51, Ann Harrison wrote: >> >> In what universe does that make sense? The field is NOT NULL. You're >> storing NULL in it. That's an error. > > I'd say

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

> On Nov 22, 2016, at 7:26 PM, Leyne, Sean wrote: > > >> SQL> >> SQL> select * from v; >> >> A >> == >> Statement failed, SQLSTATE = 22001 >> arithmetic exception, numeric overflow, or string truncation -string right >> truncation >> SQL> >> >> >> As you can

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

It's been a long time, but I think that's an ancient behavior that Jim and I argued about many years ago. Maybe even in Rdb$ELN, InterBase's ancestor. Unless my memory fails me (again) the internal format rectifier doesn't go through all intermediate formats, it just converts from the stored

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5538) Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)

This is far from a simple request and would require fundamental changes to gbak. Gbak is a logical dump of database contents that when restored creates a new database. What would a restore of a partial backup create? A partial database? An overwritten old database? What benefit would this

Re: [Firebird-devel] Detecting a parameter is DB_KEY

> On May 25, 2017, at 8:13 AM, Mark Rotteveel wrote: > >>> How can I find out if a parameter is a DB_KEY? > > I'm implementing JDBC ROWID support in Jaybird Does it matter that the ID is not consistent except within a transaction? Cheers, Ann

Re: [Firebird-devel] Detecting a parameter is DB_KEY

> On May 30, 2017, at 5:06 PM, Mark Rotteveel wrote: > > BTW: isc_dpb_dbkey_scope=1 should extend it to session/connection scope At some cost in garbage collection and an extra transaction start. Cheers, Ann

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

> On Sep 2, 2019, at 6:26 AM, Alex Peshkoff via Firebird-devel > > When first pool-enabled classes were added to firebird ~15 years ago Double that - of course there weren’t classes thirty years ago. Cheers, Ann Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Inserts and FKs

Cheers, Ann > On Sep 6, 2019, at 8:24 AM, Mark Rotteveel wrote: > >> On 6-9-2019 01:46, Carlos H. Cantu wrote: >> I understand that there are other scenarios where the currently FK >> behavior is correct and makes sense, for example, in the case of >> avoiding deleting a master record

Re: [Firebird-devel] Power efficient userspace waiting with the umwait x86 instructions

> On Sep 16, 2019, at 7:50 AM, Roman Simakov wrote: > > Hi, > > I guess it would be interesting alternative for spinlock > (https://kernelnewbies.org/Linux_5.3) > 1.6. Power efficient userspace waiting with the umwait x86 instructions > > More description is here: >

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

> On Sep 7, 2019, at 8:58 AM, Karol Bieniaszewski > wrote: > > You have right, there is a bug and the big one! > I suppose that index of Foreign Key is not validated by existence of value in > the record itself and its (the record version) transaction numer is not > compared to snapshot

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6190) gbak does not do sweep unless sweep threshold exceeded

On Sat, Nov 16, 2019 at 4:08 PM T J C (JIRA) wrote: gbak does not do sweep unless sweep threshold exceeded > > > I had understoon that a backup would reset the Oldest Interesting > Transaction (OIT) as well as > the Oldest Snapshot (OST) and had set the sweep interval to zero, and was > doing

Re: [Firebird-devel] Introduction of EXTENDED TIME/TIMESTAMP WITH TIME ZONE?

Re: [Firebird-devel] ODP: Modern C++: constexpr

> On Jun 17, 2020, at 12:52 PM, Adriano dos Santos Fernandes > wrote: > > There were UDR examples I wrote with master/slave terms and I'll change > them. For what little it’s worth, this is not a new discussion. When the VAX was being developed (1980) there was a move to eliminate violent

Re: [Firebird-devel] Commit (un)certainity

>It is documented that successful return from function send() for TCP > doesn't > mean successful delivery of data to the target host, mere put them into > socket > buffer. >If op_commit is sent but network error appear during waiting for > response > there can be two cases: >1)

[Firebird-devel] [FB-Tracker] Created: (CORE-3588) More detail in message wrong page type

Environment: All Reporter: Ann Harrison Priority: Trivial Twenty years ago, concise error messages made some sense, but diagnosing the wrong page type errors would be much easier if Firebird said expected Index Page, encountered Data Page rather than expected n encountered m