Re: [Firebird-devel] Reference counters in API

2011-03-31 Thread Kjell Rilbe
eft it for VS, .Net and C# now though). Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 <>-- Create and publish websites with

Re: [Firebird-devel] Reference counters in API

2011-03-31 Thread Kjell Rilbe
ility, it is in people's minds very tightly coupled with COM. This is not good. FB is not a COM object and shouldn't be. Ever. Please. ;-) I think QueryInterface and IUnkown would confuse more than help. Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kjell.r

Re: [Firebird-devel] Reference counters in API

2011-03-31 Thread Kjell Rilbe
sleading: http://en.wikipedia.org/wiki/IUnknown Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 <>-- Create and publish websites with WebMatrix

Re: [Firebird-devel] Reference counters in API

2011-03-31 Thread Kjell Rilbe
ot; is not that important, because very few people will do that, and those who do probably know how to do it anyway. It's possible that my judgement is wrong here, of course. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri..

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

2011-04-01 Thread Kjell Rilbe
the data has to be at least validated to not require a transliteration, or a transliteration should happen automatically. Also, indices that need to be rebuilt must also be rebuilt automatically. I'm not sure I made much sense... Tell me, does the standar

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

2011-04-01 Thread Kjell Rilbe
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

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

2011-04-01 Thread Kjell Rilbe
| > | > | > | > | > | > | > | > > ::= > SET DATA TYPE Where can I find this doc? Does it say anything about restrictions for the new depending on old one, actual data content, etc? Kjell -- --

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

2011-04-01 Thread Kjell Rilbe
se NOVALIDATE for users > who are sure > that validation is unnecessary and want 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

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

2011-04-01 Thread Kjell Rilbe
with two 150 million record 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 0

Re: [Firebird-devel] Window functions in V2.5 branch

2011-04-02 Thread Kjell Rilbe
ly great for OLAP/DWH > environments and V3 is far away from being ready for production use. In case "we" want some extra feature pre 3.0, maybe it would be better to release those as 2.6? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.

Re: [Firebird-devel] SF.net SVN: firebird:[52693] firebird/trunk/src

2011-04-11 Thread Kjell Rilbe
Delphi does. But I doubt it's possible to do the other way around: tell a compiler to pad/align to N bytes. So, perhaps the most compatible way is to use packed structs everywhere. On the other hand, this will probably induce a performance hit - that's why alignment is used at all. K

Re: [Firebird-devel] SF.net SVN: firebird:[52693] firebird/trunk/src

2011-04-11 Thread Kjell Rilbe
Den 2011-04-11 10:44 skrev Alex Peshkoff såhär: > On 04/11/11 11:35, Kjell Rilbe wrote: >> 2. If I'm not mistaken most languages support a "packed" directive that >> tells the compiler to not align/pad the struct. Delphi does. But I doubt >> it's po

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

2011-04-13 Thread Kjell Rilbe
uld 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 an API function for that specific purpose. Kjell -- ------ Kjell Rilbe DataDIA AB E-

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

2011-04-13 Thread Kjell Rilbe
in all databases as suggested by Jim a few minutes ago. But I'm against that - it makes it more complicated than it has to be. How is this feature related to upcoming support for schemas? I expect there's a potential overlap... Kjell -- -

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

2011-04-13 Thread Kjell Rilbe
use manner, I assume most users will be quite happy with it. Is the services API usually exposed in such component sets? Kjell -- ------ Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761

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

2011-04-13 Thread Kjell Rilbe
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

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

2011-04-13 Thread Kjell Rilbe
Den 2011-04-13 14:24 skrev Alex Peshkoff såhär: > On 04/13/11 16:02, Kjell Rilbe wrote: >> 3. The conf could include a GUID for each alias, allowing apps to find >> their alias(es) in a more precise way than by name. > > And where do they arrive from in text file, edited by

Re: [Firebird-devel] discussion about real fix for CORE-2348

2011-04-27 Thread Kjell Rilbe
perhaps it would be enough to force all users out for just a second or two. This is not something that would have to be done very often so may be acceptable. Also, I note that on large databases, step 1 and 4 might take days to execute. Problem? Kjell -- -

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

2011-04-28 Thread Kjell Rilbe
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" = '

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

2011-05-02 Thread Kjell Rilbe
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 -- -

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

2011-06-04 Thread Kjell Rilbe
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

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

2011-06-10 Thread Kjell Rilbe
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-3518) Wrong selection of driving table for DELETE FROM T_HUGE WHERE EXISTS(SELECT * FROM T_TINY ...)

2011-06-12 Thread Kjell Rilbe
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] SQL SERVER 2008 R2 Linked Server Error 8152

2011-06-20 Thread Kjell Rilbe
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

[Firebird-devel] Shadow files

2011-08-08 Thread Kjell Rilbe
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] Shadow files

2011-08-08 Thread Kjell Rilbe
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

Re: [Firebird-devel] Shadow files

2011-08-08 Thread Kjell Rilbe
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

2011-08-09 Thread Kjell Rilbe
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] [SPAM 5] Firebird 2.5.1 release candidate kits

2011-08-24 Thread Kjell Rilbe
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 -

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

2011-08-29 Thread Kjell Rilbe
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] Trace data for unauthorized attach database event

2011-10-19 Thread Kjell Rilbe
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,

Re: [Firebird-devel] Lock error in CCH

2011-11-06 Thread Kjell Rilbe
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] [FB-Tracker] Created: (CORE-3654) count query causes error

2011-11-07 Thread Kjell Rilbe
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] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

2011-11-13 Thread Kjell Rilbe
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-3659) Іncrease table name and field name size above 32 symbols

2011-11-13 Thread Kjell Rilbe
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] [SPAM 5] Re: Firebird Transaction ID limit solution - Email found in subject

2011-12-30 Thread Kjell Rilbe
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] Firebird Transaction ID limit solution

2012-01-01 Thread Kjell Rilbe
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] Firebird Transaction ID limit solution

2012-01-01 Thread Kjell Rilbe
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

2012-01-01 Thread Kjell Rilbe
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

2012-01-01 Thread Kjell Rilbe
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] [FB-Tracker] Created: (CORE-3715) EXTRACT(YEAR_FOR_WEEK from '2012-01-01')

2012-01-03 Thread Kjell Rilbe
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

2012-01-03 Thread Kjell Rilbe
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] Firebird Transaction ID limit solution

2012-01-03 Thread Kjell Rilbe
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

2012-01-03 Thread Kjell Rilbe
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] Compliance

2012-01-03 Thread Kjell Rilbe
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] [SPAM 5] Re: Firebird Transaction ID limit solution

2012-01-03 Thread Kjell Rilbe
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] Timeout records - an idea for a feature

2012-02-22 Thread Kjell Rilbe
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] gbak improvement

2012-02-23 Thread Kjell Rilbe
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] gbak improvement

2012-02-23 Thread Kjell Rilbe
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] Raising the BLR level

2012-03-06 Thread Kjell Rilbe
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] Raising the BLR level

2012-03-06 Thread Kjell Rilbe
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] gbak improvement

2012-03-11 Thread Kjell Rilbe
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] Generic thoughts about the Firebird network performance

2012-03-18 Thread Kjell Rilbe
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] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Kjell Rilbe
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] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Kjell Rilbe
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)

2012-04-04 Thread Kjell Rilbe
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] Connecting to Firebird 3

2012-04-19 Thread Kjell Rilbe
-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] Restore improvements?

2012-09-11 Thread Kjell Rilbe
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] Restore improvements?

2012-09-11 Thread Kjell Rilbe
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?

2012-09-12 Thread Kjell Rilbe
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] subselects in head

2012-10-23 Thread Kjell Rilbe
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] subselects in head

2012-10-23 Thread Kjell Rilbe
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] Database dialect and BIGINT in metadata

2012-11-01 Thread Kjell Rilbe
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] Firebird 3, time to rename conflict names ?

2012-11-18 Thread Kjell Rilbe
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

[Firebird-devel] Weird query results - bug?

2013-01-20 Thread Kjell Rilbe
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] Weird query results - bug?

2013-01-21 Thread Kjell Rilbe
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

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

2013-01-24 Thread Kjell Rilbe
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] (Double) Metaphone?

2013-04-02 Thread Kjell Rilbe
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] (Double) Metaphone?

2013-04-03 Thread Kjell Rilbe
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?

2013-04-03 Thread Kjell Rilbe
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?

2013-04-03 Thread Kjell Rilbe
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] RFC: human-readable DBKEY

2013-04-05 Thread Kjell Rilbe
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] Explained plan output: feedback wanted

2013-08-13 Thread Kjell Rilbe
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] Explained plan output: feedback wanted

2013-08-13 Thread Kjell Rilbe
#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] Record Encoding, was Unicode UTF-16 etc

2013-09-03 Thread Kjell Rilbe
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] Complex String Decoding

2013-09-05 Thread Kjell Rilbe
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] Compatibility FB3.0 boolean and Interbase

2013-11-12 Thread Kjell Rilbe
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] Compatibility FB3.0 boolean and Interbase

2013-11-12 Thread Kjell Rilbe
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] Syntax for CREATE/ALTER USER

2013-12-16 Thread Kjell Rilbe
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] Syntax for CREATE/ALTER USER

2013-12-16 Thread Kjell Rilbe
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

2013-12-16 Thread Kjell Rilbe
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

2013-12-16 Thread Kjell Rilbe
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] [FB3.0.0.30805]: incorrect(?) blr_type for[SEC$USERS].[SEC$ACTIVE]

2014-01-01 Thread Kjell Rilbe
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] Some aspects of the optimizer hints

2014-01-07 Thread Kjell Rilbe
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] Odp: Some aspects of the optimizer hints

2014-01-08 Thread Kjell Rilbe
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] Odp: Some aspects of the optimizer hints

2014-01-08 Thread Kjell Rilbe
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] Jobs/Scheduler

2014-04-29 Thread Kjell Rilbe
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] Feature request & discussion (Reply to Planning the post v3 development)

2014-05-13 Thread Kjell Rilbe
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] New Interface

2014-08-11 Thread Kjell Rilbe
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] New Interface (OT: Apache MQ)

2014-08-13 Thread Kjell Rilbe
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] Firebird 3 memory manager

2014-09-23 Thread Kjell Rilbe
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] Firebird 3 memory manager

2014-09-23 Thread Kjell Rilbe
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] Commits visible in our main page.

2015-03-10 Thread Kjell Rilbe
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 <

[Firebird-devel] Transliteration problem with table locks?

2018-09-15 Thread Kjell Rilbe
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

[Firebird-devel] Login with mixed case fails

2018-09-16 Thread Kjell Rilbe
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

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

2018-09-18 Thread Kjell Rilbe
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] Tracker self signed cert?

2019-06-03 Thread Kjell Rilbe
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] (no subject)

2019-09-24 Thread Kjell Rilbe
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

Re: [Firebird-devel] String escapes for codepoints

2019-09-25 Thread Kjell Rilbe
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

Re: [Firebird-devel] String escapes for codepoints

2019-09-25 Thread Kjell Rilbe
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

  1   2   >