>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) op_comm
> 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 a
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 ni
> 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:
> https://lwn.net/Articles/
> On Sep 9, 2019, at 9:45 AM, Vlad Khorsun wrote:
>
> 07.09.2019 19:35, Ann Harrison wrote:
> ...
>> It's also an old bug, probably dating to the implementation of foreign keys
>> in
>> InterBase.
>> ...it's certainly legitimate.
>
> So
> 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 numbe
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 wit
> 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
https://lists.sourceforge.ne
> 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
--
> 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
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 f
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
> On Jan 19, 2017, at 1:46 AM, Dmitry Yemanov 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 it depends. What
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: http://tracker.firebirdsql.org/browse/CORE-5460
>
> 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 see.. there is no error unti
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 completely.
>
Without
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 detect cases where
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 counted as contexts
>
> PS. after
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 require
> either storing sma
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 would work ... new blobs should
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
> tablespace.
>
It's p
> 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 of isql's parser. I'd
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 all the possible d
Looks like something planned at the past (before Firebird) but
> never used...
> >
> >27.07.2015 1:24, Ann Harrison wrote:
> > Firebird was based on InterBase which was based on Rdb/ELN, an
> implementation of DEC's [standard(!)] relational
> > interface. As part
On Sun, Jul 26, 2015 at 5:15 PM, Vlad Khorsun
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
> > ever having s
> On Jul 1, 2015, at 9:34 AM, Dmitry Yemanov 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 mista
> On Mar 29, 2015, at 8:58 AM, Alex Peshkoff 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 bug that requ
> On Mar 14, 2015, at 8:00 AM, Mark Rotteveel 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 checked 1.1. V2.0
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
> On Mar 5, 2015, at 8:38 AM, marius adrian popa 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 simplify t
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, minu
> On Mar 5, 2015, at 12:07 PM, Paul Beach 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 project's si
> On Mar 5, 2015, at 11:26 AM, "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 it is committed, s
> On Feb 1, 2015, at 3:13 PM,
> 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 context
> (SELECT FIRST 1 SKIP 30 Field_X FROM TAB
On Thu, Jan 8, 2015 at 10:27 AM, Dimitry Sibiryakov
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
--
Sorry to revert to an old question, but nobody seems to have asked this
question...
> On Dec 25, 2014, at 10:18 AM, Dimitry Sibiryakov wrote:
>
> Ok, let me simplify the question:
>
> I've created an engine that cannot work with databases, created by standard
> engine.
> Standard engine
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 util
sorrry, late tired. first name 20, not 23
Cheers,
Ann
> On Nov 30, 2014, at 8:38 PM, Ann Harrison wrote:
>
>
>
>> On Nov 30, 2014, at 6:35 PM, Stuart Simon wrote:
>>
>> OK, but version numbers tell me nothing. What I am looking for is an
>> explanati
> On Nov 30, 2014, at 6:35 PM, Stuart Simon 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
> the following
> On Nov 29, 2014, at 2:44 PM, Stuart Simon 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
> them (or their C
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 de
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 de
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 wa
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
On Aug 22, 2014, at 4:54 AM, "Lukas Eder (JIRA)"
wrote:
>
> Support SQL Standard OFFSET .. FETCH instead of Informix FIRST .. SKIP or
> rather unique ROWS .. TO clause
For the little it's worth, Firebird's FIRST predates Informix's, not to mention
the (verbose and ugly) standard.
Cheers,
A
> On Aug 12, 2014, at 1:17 PM, Jim Starkey 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 political issues of re
> On Aug 12, 2014, at 1:11 PM, Jim Starkey 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
> encapsulated
> On Aug 5, 2014, at 5:50 AM, Dmitry Yemanov 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 Firebird since
>
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
> On Jun 23, 2014, at 3:57 PM, Nikolay Samofatov
> 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 commits in results, even
On Fri, May 23, 2014 at 3:03 AM, Paul Beach 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 integer
On Mon, May 19, 2014 at 12:29 PM, Dimitry Sibiryakov wrote:
> :
> > 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 in
> VIO_m
On Mon, May 19, 2014 at 11:47 AM, Dimitry Sibiryakov wrote:
>
> 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,
Ann
---
On Sat, May 10, 2014 at 3:03 AM, Molnár Attila 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 should cr
On Thu, Apr 3, 2014 at 2:06 PM, Claudio Valderrama C. wrote:
>
>
>
> 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
> remember.
On Tue, Mar 11, 2014 at 9:47 AM, marius adrian popa wrote:
> 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 Architect at MySQL
On Mon, Jan 13, 2014 at 3:52 PM, Andrzej Hunt 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 metadata and struc
On Tue, Jan 7, 2014 at 3:45 PM, Mark Rotteveel wrote:
>
> With the SQL Server syntax optimizing for retrieval of the first 150
> rows is done with:
>
> SELECT ...
> FROM someTable
> ...
> OPTION (FAST 150)
>
> It also contains an interesting option (OPTIMIZE FOR) for 'helping' the
> optimizer dec
Dmitry,
> > Right. And if you want to give the optimizer a hint that it should choose
> > the second plan, change the query like this:
> >
> > select first 100 * from MOVIES where COMMENTS like '%yacht% order
> > by NAME;
> >
> > If you think your client may want more than a million rows, i
On Sun, Jan 5, 2014 at 3:39 AM, Alex wrote:
> O
> >
> > I thought we would allow PASS as a shortcut for PASSWORD.
>
> Can you provide a sample where shortcuts are present in SQL? It's
> trivial to add PASS shortcut, but for me it looks like something out of
> SQL style.
>
BIN (Binary), DEC (Deci
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
On Fri, Jan 3, 2014 at 5:26 AM, Mark Rotteveel wrote:
>
>
> ...case where isc_dsql_fetch is
> used with a small fetch size in comparison toe the entire result set.
>
> I assume the current optimization is:
> Client: execute query
> Server materializes all rows
> Client: fetch size=1
> (wait until
On Wed, Nov 13, 2013 at 4:01 AM, Dimitry Sibiryakov wrote:
> 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 implementation i
On Tue, Sep 10, 2013 at 5:23 PM, Vlad Khorsun
wrote:
>
> >
> > First, thanks for the details (BTW, is there a link for the spec)
>
> AFAIR, SQL standard is not free, so there is no link for free download
> (known
> to me). I have draft versions of SQL 2003 and SQL 2008, but i don't
> remember
On Tue, Sep 3, 2013 at 5:04 AM, Dimitry Sibiryakov 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
> module should be
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)" wrote:
> computed field has null value inside BI trigger
> ---
On Aug 31, 2013, at 4:55 AM, Mark Rotteveel 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, and digits --
On Aug 22, 2013, at 7:37 AM, "Pavel Zotov (JIRA)"
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 version12.0
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 us
On Fri, Apr 5, 2013 at 12:59 PM, Dmitry Yemanov wrote:
>
> > But variable length for views?
>
> DBKEY for views is a fake, it does not exist as a standalone physical
> concept. So I ignore views in this thread, they're completely outside
> the intended semantics of this proposal.
>
> Perhaps the
On Fri, Apr 5, 2013 at 11:34 AM, Doug Chamberlin
wrote:
>
>> 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 think that's the int
> > 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 approa
On Thu, Apr 4, 2013 at 3:29 PM, Sergey Mereutsa 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,
> when data i
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 t
On Sat, Feb 16, 2013 at 8:38 AM, marius adrian popa wrote:
> Are there some tasks in or around Firebird that could be submitted? I
> believe there are many students out there who would love to join in the
> DBMS project and learn about DB internals.
Probably true.
>
>
> Some of the ideas :
>
>
On Mon, Jan 28, 2013 at 11:42 AM, Dimitry Sibiryakov wrote:
> 28.01.2013 17:27, Thomas Steinmaurer wrote:
> > How does the engine know when to garbage collect an index
> > entry?
>
>When list of record references in it is empty.
>
> -
Expanding again, when Firebird garbage collects a record v
On Sun, Jan 27, 2013 at 3:23 PM, Dimitry Sibiryakov wrote:
> 27.01.2013 21:17, Thomas Steinmaurer wrote:
> > Is Firebird able here to serve the result here out of the index or does
> > it need to lookup data by following the index key to the row data?
>
>There is no data in index. And no infor
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
Sean,
> Let's assume that the cache is full of dirty pages before the start of the
> sweep.
>
> The sweep would end up reading all of the pages in the database.
>
No, not quite, but close. It wouldn't read old TIPs. It might not read
some blob pages if the blobs were staying, and similarly dat
On Sat, Jan 5, 2013 at 6:12 AM, Dimitry Sibiryakov 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 writes (wh
On Sat, Jan 5, 2013 at 5:35 AM, Dimitry Sibiryakov 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 complete garbage
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 2
On Mon, Nov 19, 2012 at 11:51 AM, Dalton Calford
wrote:
> 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 produces a text file cont
On Mon, Nov 19, 2012 at 11:41 AM, Alex Peshkoff 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 - none of the du
On Mon, Nov 19, 2012 at 11:22 AM, Dimitry Sibiryakov wrote:
>
> > Gbak is not equivalent to the MySQL or Postgres dumps which produce a
> series of insert
> > statements that can be edited.
>
>I wonder how they manage big BLOBs?
Badly.
Ann
---
On Sat, Nov 17, 2012 at 3:36 AM, Dmitry Yemanov 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 experience, people
On Thu, Nov 1, 2012 at 3:59 AM, Mark Rotteveel wrote:
>
> I am not familiar with exact nature of the precision issues with NUMERIC
> and DECIMAL calculations, but didn't that also follow the SQL spec (and if
> not: shouldn't we correct it?
Borland interpreted the SQL Standard to say that the i
On Thu, Nov 1, 2012 at 9:32 AM, Dimitry Sibiryakov 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 1/3 (base 10) pr
On Thu, Nov 1, 2012 at 5:00 AM, Dmitry Yemanov wrote:
> 01.11.2012 11:43, marius adrian popa wrote:
>
> > And the quad is gone
>
> Not really. What has gone is the quad specific arithmetics.
> The data type itself remains and I doubt it can be wiped out completely,
> as AFAIK sometimes it's used
Dmitry,
> Can we conclude that no client app existing these days should be able to
> deal with blr_quad / dtype_quad?
>
Unless somebody is running a 20 year old app on a Vax ...
>
> This sounds as a good cleanup possibility.
>
> I guess. Since it wasn't used for the new 64 bit integers...
Ann
On Wed, Oct 31, 2012 at 6:51 AM, Mark Rotteveel wrote:
>
> 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, there was support
On Mon, Aug 13, 2012 at 11:15 AM, arnaud le roy 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 question
there, p
On Mon, Mar 5, 2012 at 6:25 PM, Claudio Valderrama C.
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,
On Wed, Apr 4, 2012 at 8:26 AM, Kjell Rilbe 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
On Wed, Apr 4, 2012 at 6:42 AM, Dmitry Yemanov wrote:
>
> > 2. gfix -encrypt {-cryptpar} 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.
>
> No DPB hackery, please. G
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
other
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
Nick,
>
> When gbak finishes the actual data part of the restore it then creates all
> the indexes, could it do that in parallel based on the number of processors
> available.
> It seems daft that I have to wait for each index to be built, one at a time,
> when the server has several processors do
Olivier,
>
>
> Read this {fe 44} for minus 2 followed by 44.
> But the question remains open, I still do not get why 'DD' becomes 02 44 44
> and not FE 44.
>
I think that case of a doubled letter is larger only if the doubled
letter is either the end of the string or immediately precedes a
strin
1 - 100 of 122 matches
Mail list logo
