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

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

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

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

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.

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

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.

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

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

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

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 in an WIN125

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

[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

[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

[Firebird-devel] Transliteration problem with table locks?

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 http://xn

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) will not be

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 staying list for indexes

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

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

, what are the plans for the plan clause? Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Rapidly troubleshoot

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 clause? Explicit planning is still used by some

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

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 -- -- Kjell Rilbe DataDIA AB E-post

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

'); I assume attribute identifiers can be quoted as usual? creat user x password 'y' attributes (Weird Named Attribute %! = 'The Value'); Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

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

-- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Rapidly troubleshoot problems before they affect your business. Most IT organizations

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 to do something like this: alter user

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

why it's beneficial in various contexts to have them compatible, but there are other ways to achieve 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

Re: [Firebird-devel] Complex String Decoding

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

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

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

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

, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel . -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

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

-- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free

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

? 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 effectiveness. Reduce network

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

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 and maximize team effectiveness. Reduce

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, The most simple requirement - just write UDF (or in FB3

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

? 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 effectiveness. Reduce network

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

for in queries would execute as fast as the left join but without the duplication problem. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

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 described here remain unexplained, and since

[Firebird-devel] Weird query results - bug?

-- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

data from these three systems into a new fourth system? And back? And what is the purpose of this fourth system, in case it's relevant for us to suggest solutions? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 M

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

. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Monitor your physical, virtual and cloud infrastructure from

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

. An easier one will break existing applications as they will start calculating different numbers for the same queries. If it's not too complicated to describe (it's just out of curiosity...), then please what is the proper solution? Kjell -- -- Kjell Rilbe

Re: [Firebird-devel] subselects in head

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-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

Re: [Firebird-devel] Restore improvements?

. 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 event will cover all

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 AB E-post: kj...@datadia.se

Re: [Firebird-devel] Restore improvements?

-- -- 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 event will cover all the ways today's security and threat landscape

Re: [Firebird-devel] Connecting to Firebird 3

-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-761 06 55 Mobil: 0733-44 24 64

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

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 opinion... Kjell -- -- Kjell Rilbe DataDIA AB E-post:kjell.ri

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

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 sounds like a tool

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

, 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 -- -- Kjell Rilbe DataDIA AB E-post: kj

Re: [Firebird-devel] gbak improvement

%, 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-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

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. cva...@usa.net wrote: -Original Message- From: Kjell Rilbe [mailto:kjell.ri...@datadia.se] Sent: Martes, 06 de Marzo de 2012 6:55 Isn't it about time to drop support for dialect

Re: [Firebird-devel] gbak improvement

-- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 attachment: kjell_rilbe.vcf-- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use

Re: [Firebird-devel] gbak improvement

restore anyway? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 attachment: kjell_rilbe.vcf-- Virtualization Cloud Management Using

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

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

. 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 and tools to simplify cross-platform

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

-- -- 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 and tools to simplify cross-platform app development. Create new or port

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 difficult to find an effective way

Re: [Firebird-devel] Compliance

-- -- 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 and tools to simplify cross-platform app development. Create new or port

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

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

for suggestion 4. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need

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 overhead. - No additional disk space

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 cycle on demand?.. Pros: - No overhead

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

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 -- RSA(R) Conference 2012 Save $700 by Nov 18 Register

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 limitation automatically, but a problem

Re: [Firebird-devel] Lock error in CCH

access only, and only with two or more processes connected to the same database? Thanks, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

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

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

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

. Has this been improved since FB 2.1? Any future plans? Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Special Offer

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

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 -- EMC VNX: the world's

[Firebird-devel] Shadow files

-- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile

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 ever raised I will vote against. OK

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

this: delete from t_huge t where id in (select id from t_tiny) Better plan? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- EditLive

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.firebirdsql.org/browse/CORE

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

IN (:Item1, :Item2, :Item3) Or dynamically build your in list using string manipulation in your client app. Or use a temporary table. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

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

to me. Is it? If yes, is it already known, or should I report it? A workaround: update Temp set New = '0001-01-01'; After that it seems to work. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se mailto:kjell%40datadia.se Telefon: 08-761 06

[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

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

specifying if it should be available for browsing or not (default = no). Those marked as available for browsing could be accessible via an API function for that specific purpose. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

to be. How is this feature related to upcoming support for schemas? I expect there's a potential overlap... Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

Den 2011-04-13 12:55 skrev Kjell Rilbe såhär: I might suggest that the alias config that's already present could be augmented with a flag for each alias specifying if it should be available for browsing or not (default = no). Those marked as available for browsing could be accessible via

Re: [Firebird-devel] Changing charset/collation for fields and domains

Den 2011-04-01 09:47 skrev Dmitry Yemanov såhär: 01.04.2011 11:19, Kjell Rilbe wrote: I'm not sure I made much sense... Tell me, does the standard specify anything regarding datatype change features? If so, what does it say? It allows to alter a string column to a string one of the non

Re: [Firebird-devel] Changing charset/collation for fields and domains

clause alter column data type clause ::= SET DATA TYPEdata type Where can I find this doc? Does it say anything about restrictions for the new data type depending on old one, actual data content, etc? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj

Re: [Firebird-devel] Changing charset/collation for fields and domains

to save time on commit?.. Good idea, but what if the user later turns out to have been wrong? How to handle it? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64

Re: [Firebird-devel] Changing charset/collation for fields and domains

tables. Last time I had to update all records, two indexed columns, it took 6-7 hours. Not something I'd want to do unless absolutely necessary... Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64