Re: [Firebird-devel] Local tables

Den 2022-03-15 kl. 15:37, skrev Adriano dos Santos Fernandes: On 15/03/2022 11:23, Alex Peshkoff via Firebird-devel wrote: Very interesting - but other name for them should be used. It's too easy to loose difference between LT & LTT that are absolutely different things. Maybe just "DECLARE TAB

Re: [Firebird-devel] INT64 and index keys

Den 2022-02-15 kl. 16:10, skrev Vlad Khorsun: 15.02.2022 15:20, Dmitry Yemanov wrote: ... I can think of two ways to proceed: 1) Keep rebuilding the index every time the type is changed. Cast all column values into the new format before storing keys into the index. Forget about being scale-

Re: [Firebird-devel] Tablespaces proposal

Den 2021-10-12 kl. 14:05, skrev Dmitry Yemanov: 12.10.2021 13:36, Kjell Rilbe wrote: Support for many page sizes requires changes in page cache management and should be considered together. I don't see it as "must have" feature, btw. That's the feature that our DB wou

Re: [Firebird-devel] Tablespaces proposal

Den 2021-10-11 kl. 21:07, skrev Dimitry Sibiryakov: Roman Simakov wrote 11.10.2021 20:23: > Note: *MAIN* - is a name of the basic database file.    Please, use *DEFAULT* for default (main) tablespace at "main" database file.     It is much more consistent with SQL and allows to avoid

Re: [Firebird-devel] Tablespaces proposal

Den 2021-10-12 kl. 08:09, skrev Roman Simakov: пн, 11 окт. 2021 г. в 23:03, Vlad Khorsun >: 11.10.2021 21:23, Roman Simakov wrote: > пн, 11 окт. 2021 г. в 18:42, Vlad Khorsun mailto:hv...@optima.com.ua>

Re: [Firebird-devel] Tablespaces proposal

Den 2021-10-11 kl. 17:41, skrev Vlad Khorsun: 11.10.2021 15:17, Roman Simakov wrote: Here is the second version of the proposal. It's taken into account all agreements we made during discussion and we'll do it in this way if there are no objections. PROPOSAL===

Re: [Firebird-devel] Tablespaces proposal

Den 2021-10-07 kl. 10:56, skrev Molnár Attila: "Tablespaces has meaning for large databases only that don't fit into single storage (terrabytes)." That is not true. It has meaning whatever the programmers meant to use it. It might not be about read performance, but e.g. logical data serparatio

Re: [Firebird-devel] Charset of plugin configuration parameters

Den 2021-04-19 kl. 17:52, skrev Alex Peshkoff via Firebird-devel: On 4/19/21 6:43 PM, Dimitry Sibiryakov wrote:  In my own recent config parsers I separate ANSI files from UTF-8 files by BOM and handle them accordingly but I use Unicode for internal processing which Firebird doesn't. Telli

Re: [Firebird-devel] Incorrect description in README.instsvc.txt

Den 2020-07-20 kl. 12:49, skrev Kjell Rilbe: The README.instsvc.txt file needs to be corrected at least at lines 10 and 23-25. Found line 85 too. Kjell <>Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Incorrect description in README.instsvc.txt

Hi, Working on a fresh install of FB 3.0.6 and reading README.instsvc.txt. On line 10 it says that the binaries must be placed in "the /bin directory beneath your Firebird root directory.". But there is not bin folder. The binaries are placed directly in the RootDirectory (C:\Program Files\F

Re: [Firebird-devel] Installing the ICU Files under Windows

Den 2020-04-28 kl. 15:59, skrev Adriano dos Santos Fernandes: On 28/04/2020 10:55, Tony Whyman wrote: Because my understanding is that the ICU is the source of the time zone database and will have to be updated every time a time zone changes or there are changes to the dates for daylight savings

[Firebird-devel] [FB-Tracker] Created: (CORE-6202) External table file names not transliterated to OS character set

Components: Engine Affects Versions: 3.0.4 Environment: Windows 64 bit with OS character set Windows-1252 Reporter: Kjell Rilbe Priority: Minor It seems that the file name specified for an external table is sent to the operating system's file opera

[Firebird-devel] Is there interest in our tool to export Excel to FB external table?

ut in somewhat unexpected ways. It's also in Swedish at the moment, so that would need some work. Regards, Kjell Rilbe <>Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] String escapes for codepoints

Den 2019-09-25 kl. 18:05, skrev Mark Rotteveel: > On 25-9-2019 10:11, Kjell Rilbe wrote: >> The suggested could be used to write characters >> using the literal's encoding directly. E.g. För UTF-8 literal, the >> character Ö could be written as '\xC3\xB6', and

Re: [Firebird-devel] String escapes for codepoints

Den 2019-09-25 kl. 13:45, skrev Dimitry Sibiryakov: > 25.09.2019 11:52, Kjell Rilbe wrote: >> Most Unicode characaters are not available on most keyboards. For >> example, I have a Swedish keyboard. To enter a "Φ" (U+03A6), I will need >> to find it in Windows char

Re: [Firebird-devel] String escapes for codepoints

Den 2019-09-25 kl. 11:35, skrev Dimitry Sibiryakov: > 25.09.2019 10:11, Kjell Rilbe wrote: >>   It would be a >> lot more useful with an ability to specify the character codepoint >> inside a string literal, and have that codepoint automatically encoded >> into the

Re: [Firebird-devel] String escapes for codepoints

Den 2019-09-24 kl. 17:03, skrev Dimitry Sibiryakov: > 24.09.2019 16:27, Kjell Rilbe wrote: >> The built-in function ASCII_CHAR(n) seems to only accept integers 0..255 >> and not have any character set support whatsoever. > >   ASCII (which this function has in name) define o

[Firebird-devel] (no subject)

Hi, The built-in function ASCII_CHAR(n) seems to only accept integers 0..255 and not have any character set support whatsoever. Are there any plans to add support for character set awareness, presumably under a new function name? For example: char_from_code(n, character_set_name) As a workaro

[Firebird-devel] Tracker self signed cert?

Trying to connect to https://tracker.firebirdsql.org, I get a cert warning MOZILLA_PKIX_ERROR_SELF_SIGNED_CERT. Is this as intended? Mvh, Kjell <>Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6073) Corruption risk on drop table with non exclusive connection

Components: Engine Affects Versions: 3.0.4, 2.5.8 Environment: Any, as far as I understand. Reporter: Kjell Rilbe Priority: Critical I have once suffered database corruption due to dropping tables when other users were working with the same database. IBSurgeon

Re: [Firebird-devel] Transliteration problem with table locks?

Den 2018-09-18 kl. 17:43, skrev Mark Rotteveel: On 18-9-2018 17:33, Alex Peshkoff via Firebird-devel wrote: Look like a bug. At least I do not see any place where engine transliterates TPB in the code. On the other hand not sure was this particular bug caused by this or with given connection pa

[Firebird-devel] Login with mixed case fails

Hi, In FB 3.0.3 it's possible to create a user with mixed case like this in isql: create user "MixedCaseName" password '***'; After that, I create a database in isql, referencing the already defined alias 'MyDB': create database 'MyDB' user "MixedCaseName" password '***' page_size 4096 set n

[Firebird-devel] Transliteration problem with table locks?

nicode -> UTF8, and then UTF8 all the way, right? Is this a bug, and would that bug be most likely in .NET FirebirdClient or in the FB engine? (I.e. where should I report it?) Regards, Kjell Rilbe <>Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Commits visible in our main page.

I use TortoiseGit:, which seems to be something along the same lines: https://code.google.com/p/tortoisegit/ Kjell Rilbe Telefon: 08-761 06 55 Mobil: 0733-44 24 64 DataDIA AB Ulvsundavägen 106 168 67 Bromma www.datadia.se <http://www.datadia.se> 08-514 905 90 Företagskontakt.se <

Re: [Firebird-devel] Firebird 3 memory manager

Kjell Rilbe skrev: Vlad Khorsun skrev: In a similar vein, if Firebird is still using the venerable Quick Sort that a coded more or less straight from Knuth, Volume 2, in 1984, see Bentley & McIlroy's "Engineering a Sort Function" for a must faster version. If anyone is inte

Re: [Firebird-devel] Firebird 3 memory manager

also be done using a recursive call to the sorting algorithm. Maybe someone with time and the appropriate skills could do the math to find the theoretical properties of such an algorithm and also try it out in practice? Regards, Kjell -- DataDIA logotyp Kjell Rilbe Telefon: 08-761 06 55 Mobil

Re: [Firebird-devel] New Interface (OT: Apache MQ)

Den 2014-08-13 13:56 skrev Adriano dos Santos Fernandes såhär: > On 13/08/2014 08:24, Alex Peshkoff wrote: >> Is this syntax Delphi-compatible? >> :-) >> I've wrote that I've used to work with Pascal >25 years ago. For example >> I've used objects cause they are just present in language docs before

Re: [Firebird-devel] New Interface

Den 2014-08-10 12:04 skrev Dmitry Yemanov såhär: > 10.08.2014 13:55, Reinier Olislagers wrote: > >> However, apparently FB devs don't think it's important to keep it in >> sync with the C++ interface - even if third parties could submit patches >> for that. >> >> So in effect, new FB (features) wil

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

Jim Starkey skriver: > On 5/13/2014 11:24 AM, Dimitry Sibiryakov wrote: >> 13.05.2014 17:10, Jim Starkey wrote: >>> On 5/13/2014 10:59 AM, Dimitry Sibiryakov wrote: > If I'm not mistaken, these repeating index entries works as a > reference counters and > allow to stop using stay

Re: [Firebird-devel] Jobs/Scheduler

Den 2014-04-29 20:52 skrev Dalton Calford såhär: > Have a standard client/daemon such as gstat/gfix/gsec ship with > firebird that when started, it is provided with a config file or > command line specifying the database to use. > > In this way, any database could be the master database as long a

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

Den 2014-01-08 09:32 skrev Dmitry Yemanov såhär: > 08.01.2014 12:15, Kjell Rilbe wrote: > >> That said, I'd vote against "plan for/hint" if the plan clause in its >> current use is or is soon going to be deprecated. So, what are the plans >> for the plan cl

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

t;plan for/hint" if the plan clause in its current use is or is soon going to be deprecated. So, what are the plans for the plan clause? Regards, Kjell -- -- Kjell R

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

ften see suggestions to add 0 or similar to avoid using some index. This could also be achieved using plan hints: plan hint "Movies" natural or plan hint "Movies" index "SomeBetterIndex" to avoid using some less-than-optimal index on the table "Movies". I

Re: [Firebird-devel] [FB3.0.0.30805]: incorrect(?) blr_type for[SEC$USERS].[SEC$ACTIVE]

are called BLR, they do not share same codes space. If this is the general level of quality on FB source code's identifier naming, I'm worried. Suggestions: blr_boolean => blr_bool_node or blr_node_bool blr_bool => blr_bool_type or blr_type_bool Kjell -- -----

Re: [Firebird-devel] Syntax for CREATE/ALTER USER

Den 2013-12-16 12:40 skrev Dimitry Sibiryakov såhär: > 16.12.2013 12:34, Kjell Rilbe wrote: >> When you want to introduce a new fixed >> attribute, X users will complain about clashes with their already-in-use >> user defined attributes. > In this case you suggest t

Re: [Firebird-devel] Syntax for CREATE/ALTER USER

Den 2013-12-16 12:28 skrev Mark Rotteveel såhär: > On Mon, 16 Dec 2013 12:09:07 +0100, Kjell Rilbe > wrote: >> My thought exactly. I also wonder, if the general rule is to have >> "...item valuetoset..." as opposed to "...item = valuetoset...", why >&g

Re: [Firebird-devel] Syntax for CREATE/ALTER USER

fixed attribute, X users will complain about clashes with their already-in-use user defined attributes. Separating them with some keyword (agreed that "attributes" is not optimal) will solve this and also make the syntax slightly clearer imho. Kjell -- --

Re: [Firebird-devel] Syntax for CREATE/ALTER USER

that is intended for that purpose. In other words, a syntax like this would seem a bit more robust: create user x password 'y' attributes (a = 'a', b = 'b'); alter user x set password 'yy' attributes (a = 'aa', b = 'bb'); I assume attrib

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

eve database agnosticism that are probably a much better deal in the long run, e.g. "middleware" like ODBC, FireDac, etc. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ---

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

ectations, you will probably find your life easier. They've diverged. Get over it and get on with it? :-) Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Tele

Re: [Firebird-devel] Complex String Decoding

orld. Throw an error? Use some priority order? Based on... what? Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Learn the latest--Vis

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

s! Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and

Re: [Firebird-devel] Explained plan output: feedback wanted

#x27;re trying to use a tree-lika representation for something that's actually not a tree. I am currently unable to come up with a better option, but I feel some out of the box thinking would be beneficial here. Anyone? Kjell -- -- Kjell Rilbe DataDIA AB E

Re: [Firebird-devel] Explained plan output: feedback wanted

gt; personally I favor (E)#2 so far. > > Comments anyone? Other suggestions? > > > Dmitry > > -- > Get 100% visibility into Java/.NET code with AppDynamics Lite! > It's a free troubleshooting tool designed for production. &g

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

able length for views? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Minimize network downtime and maximize team effect

Re: [Firebird-devel] (Double) Metaphone?

g that on the feature list might be good marketing wise and perhaps a rather small development effort? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -

Re: [Firebird-devel] (Double) Metaphone?

Den 2013-04-03 09:29 skrev Alex Peshkoff såhär: > On 04/03/13 11:23, Kjell Rilbe wrote: >> Den 2013-04-03 09:09 skrev Alex Peshkoff såhär: >>> On 04/03/13 01:44, Thomas Beckmann wrote: >>>> Second: I'd like to have this like a plugin architecture, >>>

Re: [Firebird-devel] (Double) Metaphone?

mming is easier than defining "rules"? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Minimize network downtime a

Re: [Firebird-devel] (Double) Metaphone?

uot;, because I would just love this feature. But in the real world I think the development time should be put to better use. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -

Re: [Firebird-devel] Optmizer vs IN (sub-select)

tes if the referenced table (the lookup table) contains multiple records with a matching Bar value. I think the idea is that the improved optimization for in queries would execute as fast as the left join but without the duplication problem. Kjell -- --

Re: [Firebird-devel] Weird query results - bug?

Den 2013-01-22 08:12 skrev Alex Peshkoff såhär: > On 01/21/13 00:38, Kjell Rilbe wrote: >> Hi, >> >> I've asked this on the support list, but got no solutions or >> explanations. I was able to get the data I needed with an exists query, >> but the results

[Firebird-devel] Weird query results - bug?

Firebird 2.1, WI-V2.1.4.18393 on Windows Server 2008 64 bit. Notes from replies on the support list: - ECO_ID is a primary key and not nullable. - The plan show no indices are used so I assume index corruption could not be the issue. Kjell -- -- Kjell Rilbe D

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

progress or not. And it was on FB 2.0 I believe. So, perhaps this is totally irrelevant, but just maybe it's a little alert that nbackup might have some problems. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mo

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

lease what is the "proper solution"? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Everyone hates slow websites. So do we. Make your web apps faster with

Re: [Firebird-devel] subselects in head

Den 2012-10-23 13:16 skrev Frank såhär: > On 23/10/12 11:21, Kjell Rilbe wrote: >> Den 2012-10-23 10:32 skrev Frank såhär: >>> select R1.RDB$RELATION_NAME >>> from RDB$RELATION_FIELDS F1 >>> join RDB$RELATIONS R1 on F1.RDB$RELATION_NAME = R1.RDB$

Re: [Firebird-devel] subselects in head

s utterly pointless. R2 and F2 are not correlated and so the subquery will return all F2 records paired with all R2 records. I think it's a typo and that the subquery's join condition should refer to R2, not R1. Kjell -- -- Kjell Rilbe DataDIA AB E-

Re: [Firebird-devel] Restore improvements?

created in a single transaction. Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Live Security Virtual Conference Exclusive live

Re: [Firebird-devel] Restore improvements?

ot; or something, but that would mean a 50% decrease in execution time. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Live Security Virtu

Re: [Firebird-devel] Restore improvements?

Den 2012-09-11 10:04 skrev Thomas Steinmaurer såhär: > ~ 100% improvement in execution time. Impressive! I'm all for any change with such a huge performance improvement! :o) Sorry, couldn't resist. Kjell -- ------ Kjell Rilbe DataDIA

Re: [Firebird-devel] Connecting to Firebird 3

-with-the-rainbow-tables-what-you-need-to-know-about-s.html I've also seen mention of Rfc2898, which seems to be a good option for password hashes. Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-7

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

Kjell Rilbe skriver: Dmitry Yemanov skriver: Also possible as a secondary option, let's just decide what's better - keep polluting GFIX with new features or create new command-line tools for the every new feature (or a set of features). From a user perspective, "gfix" s

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

Claudio Valderrama C. skriver: -Original Message- From: Kjell Rilbe [mailto:kjell.ri...@datadia.se] Sent: Miércoles, 04 de Abril de 2012 6:56 From a user perspective, "gfix" sounds like a tool to fix problems with the database, so I'd vote to either change the name to

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

x problems with the database, so I'd vote to either change the name to something more generic, e.g. "gset" or "gconfig" or "gtool" (why "g" by the way?), or to keep its feature set within the area of "fixing problems". Just my humble op

Re: [Firebird-devel] Generic thoughts about the Firebird network performance

re ;-) Our lists are for development, not speculations. I'd like to subscribe to your blog, being a FB user (app/system devel). I'm a bit "dumb" as to blogs/rss, but I see no subscription link on your blog site. How can I get an RSS feed from your blog? Kjell -- ---

Re: [Firebird-devel] gbak improvement

7;re wrong, but I was wondering. If CPU usage is already ~99%, doesn't that mean that it's already using all cores to the max? Or did you mean cpu usage is ~99% on the single core that's executing the restore? Kjell -- -- Kjell Rilbe DataDIA AB E

Re: [Firebird-devel] Raising the BLR level

Den 2012-03-06 11:07 skrev Mark Rotteveel såhär: > On Tue, 6 Mar 2012 07:14:44 -0300, "Claudio Valderrama C." > > wrote: >>> -Original Message- >>> From: Kjell Rilbe [mailto:kjell.ri...@datadia.se] >>> Sent: Martes, 06 de Marzo de 2012 6:5

Re: [Firebird-devel] Raising the BLR level

ning: if you really want to stay at dialect 1, then fine with me, but then live with the implications, e.g. staying with an old version of FB. Kjell -- -- Kjell Rilbe DataDIA AB E-p

Re: [Firebird-devel] gbak improvement

cess, but isn't this the case during restore anyway? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 <>-- Virtualization &

Re: [Firebird-devel] gbak improvement

Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 <>-- Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but

Re: [Firebird-devel] Timeout records - an idea for a feature

ik skriver: Queues that are specific for time, like Task Queues that can start for example at 10:00:25 pm but no longer then 10:05:40 pm that day . Let's say you have 5,000 tasks like that on queue. Each of them in different time scale and period. Cron is not the answer. Would you run your task

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

logging updates in a separate file, and then bring the consolidated master up to date again. If this is very difficult, perhaps there's no point - devel resources better spent elsewhere. But if it would be a fairly simple task...? Kjell -- -- Kjell R

Re: [Firebird-devel] Compliance

ven though that would not, apparently, be backwards compatible. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Write once. Port to many. G

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

Den 2012-01-03 21:11 skrev Dimitry Sibiryakov såhär: > 03.01.2012 21:04, Kjell Rilbe wrote: >> What's needed is, in principle, a task that reads through ALL record >> versions, and for each one with transaction id< OIT, change it to OIT - >> 1. When it has done tha

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

Den 2012-01-01 21:31 skrev Kjell Rilbe såhär: > 3. Stay at 32 bit id:s but somehow "compact" all id:s older than OIT(?) > into OIT-1. Allow id:s to wrap around. > Pros: > - No extra disk space. > - Probably rather simple code changes for id usage. > Cons: > - May be

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

ot;5" will stay there forever, regardless of the OIT. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Write once. Port to many. Get the SDK

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3715) EXTRACT(YEAR_FOR_WEEK from '2012-01-01')

that has four or more days on the new year. This seems to contradict what Pierre wrote above. There are also other historical numbering schemes, and I believe the US has a different numbering scheme. A parameter to control desired numbering scheme would be required. Kjell -- ---

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

Den 2012-01-01 23:47 skrev Lester Caine såhär: > Dimitry Sibiryakov wrote: >> 01.01.2012 21:31, Kjell Rilbe wrote: >>>> So far, these are the suggestions I've seen >> Hey, how about my suggestion leave everything as is and perform >> backup-restore cyc

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

Den 2012-01-01 23:25 skrev Dimitry Sibiryakov såhär: > 01.01.2012 21:31, Kjell Rilbe wrote: >> So far, these are the suggestions I've seen > Hey, how about my suggestion leave everything as is and perform > backup-restore cycle on > demand?.. > > Pros: > - No

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

head to that of suggestion 4, then I see no reason to go for suggestion 4. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -

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

able in the current record format, that could be used for this purpose? Or how are such flag bits encoded? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon:

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

At least I was under the impression that the snag is not the size and space it takes on disk, but rather that the trans id type is used in so many places that the change is high risk. So, if it's to be changed at all, make sure the change is large enough for a long time. Kjell --

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

Den 2011-11-13 12:13 skrev Dimitry Sibiryakov såhär: > 13.11.2011 12:09, Kjell Rilbe wrote: >>> Іncrease table name and field name size above 32 symbols for support ORM >>> frameworks sach as Ruby on Rails >> Would be much appreciated, yes. ECO handle's the li

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

ains. Very annoying. At least this was the case last time i checked (2.1 I believe). Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ---

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3654) count query causes error

newer versions of Firebird, beucase it is stricter re. ambiguity now. You've got B."id" and A."id" in the subquery, both resulting in a column named "id" in the derived table. That's what the error message means. Try giving an alias to (at least) one of them,

Re: [Firebird-devel] Lock error in CCH

teful if you would describe exactly what configurations are affected, e.g. does it affect embedded access only, and only with two or more processes connected to the same database? Thanks, Kjell -- -- Kjell Rilb

Re: [Firebird-devel] Trace data for unauthorized attach database event

Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 <>-- All the data continuously generated in your IT infrastructure contains a definitive record of customers,

[Firebird-devel] Can newer FB use index in updates with where on fk?

if the expected number of recors from the subquery is small enough and the selectivity of the fk index is low enough. Has this been improved since FB 2.1? Any future plans? Regards, Kjell --

Re: [Firebird-devel] [SPAM 5] Firebird 2.5.1 release candidate kits

release will be ready? I assume it's dependent on feedback from this RC, but based on experience etc? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -

Re: [Firebird-devel] Shadow files

Den 2011-08-09 08:54 skrev Alex Peshkoff såhär: > On 08/08/11 19:10, Dimitry Sibiryakov wrote: >> 08.08.2011 16:57, Kjell Rilbe wrote: >>> So, I ask you in the devel team: is the shadow file feature going to go >>> away or will you make sure it stays functional?

Re: [Firebird-devel] Shadow files

Den 2011-08-08 18:39 skrev Dimitry Sibiryakov såhär: > 08.08.2011 18:33, Kjell Rilbe wrote: >> This copy should be as up to date as possible, >> transaction by transaction. >> >> Are there no replicators that can do this? > > Yep. > All Firebird replicat

Re: [Firebird-devel] Shadow files

Den 2011-08-08 17:10 skrev Dimitry Sibiryakov såhär: > 08.08.2011 16:57, Kjell Rilbe wrote: >> So, I ask you in the devel team: is the shadow file feature going to go >> away or will you make sure it stays functional? > > If discussion about dropping of shadow is ev

[Firebird-devel] Shadow files

se? Regards, Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-atte

Re: [Firebird-devel] SQL SERVER 2008 R2 Linked Server Error 8152

regarding your schema and data and what you're trying to do (what data are you trying to select/update/insert...? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3518) Wrong selection of driving table for DELETE FROM T_HUGE WHERE EXISTS(SELECT * FROM T_TINY ...)

k = 89 > Fetches from cache = 4 025 225 > > Table T_HUGE is *fully* scanned (NIR = 1000'000). Optimizer ignores > cardinality of T_TINY and selects T_HUGE as driving table. I thing this is > obvious mistake. How about this: delete from t_huge t wher

Re: [Firebird-devel] File system cache vs. Firebird page cache?

xFileSystemCache may be useful for classic as well, in some situations. I haven't tried it though. Still on 2.1. Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 0

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3483) Ref to undefined TABLE ALIAS gives error message about unknown COLUMN

Den 2011-05-18 16:28 skrev Kjell Rilbe (JIRA) såhär: > Ref to undefined TABLE ALIAS gives error message about unknown COLUMN > - > > Key: CORE-3483 > URL: http://tracker.firebir

[Firebird-devel] [FB-Tracker] Created: (CORE-3483) Ref to undefined TABLE ALIAS gives error message about unknown COLUMN

Type: Bug Components: Engine Affects Versions: 2.1.3 Environment: Windows 2008 server 64 bit. Classic. Reporter: Kjell Rilbe Priority: Minor select * from "Investeringskategori" X inner join "Värdeförrådsvärde" Y on Z."ECO_ID&q

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3460) IN with string, contained multiple values

not use string parameters, such as WHERE ID IN > (:LIST_ID). Can't do it that way. Try this: SELECT FROM TABLE 1 WHERE ID IN (:Item1, :Item2, :Item3) Or dynamically build your in list using string manipulation in your client app. Or use a temporary table. Kjell -- -

[Firebird-devel] [FB-Tracker] Created: (CORE-3453) Added not null timestamp col with default causes error on select of old null records

: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.1.4 Environment: Windows Reporter: Kjell Rilbe Priority: Minor FB 2.1 using isql, connect with utf8 to a database with default charset utf8. Then try this (commits excluded

[Firebird-devel] Default for timestamp col causes error - known bug?

01-01-01' and then it complains about "19" instead, so it appears to be (at least) the century that causes problems. Seems like some kind of bug to me. Is it? If yes, is it already known, or should I report it? A workaround: update "Temp" set "New" = '

  1   2   >