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

2011-06-10 Thread Pavel Cisar
. Classic and SuperClassic work with very small FB cache (to conserve memory and lower IPC traffic to synchronize them between FB processes/threads). best regards Pavel Cisar IBPhoenix -- EditLive Enterprise is the world's

Re: [Firebird-devel] Conversion of CVS to Subversion

2012-07-16 Thread Pavel Cisar
that could be imported into svn (at least it was the way it works back then) via SourceForge shell service. Just make shure the import ADDs, not REPLACE the old repository :) It's also good to take full svn backup (not chekout) before merge. best regards Pavel Cisar IBPhoenix

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

2012-10-31 Thread Pavel Cisar
for long time as Firebird reborn version (new ODS, new API, new architecture etc.) and a potential deal-breaker for legacy stuff. best regards Pavel Cisar IBPhoenix Dne 31.10.2012 10:02, Dmitry Yemanov napsal(a): Sorry, I had intended to write: That said, I'm NOT against the idea in general

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

2012-10-31 Thread Pavel Cisar
Dne 31.10.2012 11:46, Lester Caine napsal(a): Pavel Cisar wrote: b) If we will announce the removal of dialect 1 support now, users of dialect 1 planning to switch to FB 3.0 will have at least 1.5 years to adapt their applications (for early adoption) and about 5-7 years as final deadline

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

2012-10-31 Thread Pavel Cisar
Dne 31.10.2012 11:40, Dimitry Sibiryakov napsal(a): 31.10.2012 11:36, Pavel Cisar wrote: So negative impact would be to very small fraction of FB users, while positive impact would affect the rest. Could you tell more about this positive impact?.. For example: 1. Cleaner code - less

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

2012-10-31 Thread Pavel Cisar
Dne 31.10.2012 12:26, Alex Peshkoff napsal(a): On 10/31/12 15:03, Pavel Cisar wrote: Let me answer. As a minimum - shared pages cache and i.e. better SMP support. But only if you need both of them at the same time, individually they're provided by pre-3.0 versions. Anyway, this is just

[Firebird-devel] Upgrade of Firebird project to new Allura platform

2012-12-12 Thread Pavel Cisar
will change. best regards Pavel Cisar -- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more

Re: [Firebird-devel] Upgrade of Firebird project to new Allura platform

2012-12-15 Thread Pavel Cisar
Mark, Core upgrade is already finished, now it migrates code repositories (don't know how long it will take as ours are huge). Project developers should get an automatic e-mail when it's done. I'll forward it here too for others. Pavel Dne 15.12.2012 12:30, Mark Rotteveel napsal(a): At

Re: [Firebird-devel] Upgrade of Firebird project to new Allura platform

2012-12-15 Thread Pavel Cisar
Dne 15.12.2012 12:50, Mark Rotteveel napsal(a): Yes, I just received an e-mail that the migration was done and that it now started on the repositories. I guess that will take a while. That e-mail says That means that you and any other developers should do a fresh checkout using the new

[Firebird-devel] Fwd: SourceForge Repo Clone Complete

2012-12-16 Thread Pavel Cisar
Původní zpráva Předmět:SourceForge Repo Clone Complete Datum: Sun, 16 Dec 2012 12:20:34 + Od: SourceForge.net noreply+project-upgr...@in.sf.net Přeposláno - Komu: nore...@in.sf.net Komu: nore...@in.sf.net Your cloned repository code in project

Re: [Firebird-devel] Firebird new release is needed

2013-03-18 Thread Pavel Cisar
Alex, Dne 15.3.2013 14:08, Alex Peshkoff napsal(a): Pavel, why do you think we need QA after with the single one-line patch? IMO check for installability (avoid network errors) is enough. The main reason for releasing that versions is avoiding QA and long release notes cycle. (yes, we need

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

2013-04-05 Thread Pavel Cisar
Hi, Dne 5.4.2013 08:04, Dmitry Yemanov napsal(a): All, I'd like to propose some ways to convert DBKEY into a human-readable form but still be able to quickly (without a full table scan) access the record via its human-readable DBKEY. Primarily, it could be used to report a unique id of the

[Firebird-devel] Firebird 3.0 Alpha 1 issues

2013-07-01 Thread Pavel Cisar
. Once any service is started, isc_service_query starts to work properly. Other isc_service_query items except isc_info_svc_running work fine, for example query for isc_info_svc_server_version. best regards Pavel Cisar IBPhoenix

Re: [Firebird-devel] Firebird 3.0 Alpha 1 issues

2013-07-03 Thread Pavel Cisar
are regressions. Dne 1.7.2013 15:33, Dmitry Yemanov napsal(a): 01.07.2013 17:14, Pavel Cisar wrote: 1. cursor.rowcount (isc_dsql_sql_info with isc_info_sql_records) returns 1 instead expected 6 cur.execute('select * from project') self.assertEqual(cur.rowcount,0) cur.fetchone

Re: [Firebird-devel] Firebird 3.0 Alpha 1 issues

2013-07-04 Thread Pavel Cisar
Dne 3.7.2013 20:30, Alex Peshkov napsal(a): 03.07.2013 19:04, Pavel Cisar пишет: Hi, Well, I have discovered that 3.0 Linux installation script doesn't install FB as server ??? May be default connection is embedded? Yes, it's embedded. I'm ok with it if i would know

[Firebird-devel] FB 3.0 New API missing in alpha1?

2013-07-05 Thread Pavel Cisar
Hi all, I can't find Provider.h in Alpha1 Linux package. It's intentional (new API not ready for testing) or not (packaging error)? best regards Pavel Cisar IBPhoenix -- This SF.net email is sponsored by Windows

Re: [Firebird-devel] Fb3 daily build and test broken

2014-11-24 Thread Pavel Cisar
Hi, I'd gladly look into it, but I can't test it. It works for 2.5.3 and I can't install latest 3.0 as there is no 64-bit Linux build, and Alpha 2 doesn't work on my openSUSE 13.1 (problem with icu). best regards Pavel Dne 24.11.2014 v 10:13 Philippe Makowski napsal(a): The bug is in Python

[Firebird-devel] Literals in CASE expression

2016-01-05 Thread Pavel Cisar
ndard here really doesn't work in our favor in this particular case. My personal vote is for relaxing the rules and use VARCHAR. What is your opinion? best regards Pavel Cisar IBPhoenix -- Firebird-Devel mailing

Re: [Firebird-devel] GitHub

2016-03-14 Thread Pavel Cisar
Dmitry, For qa we only need these projects: https://github.com/firebirdsql/qa-fbtest (qa tools) https://github.com/firebirdsql/qa-repository (formerly fbt-repository - this is repository with tests and other data used by qa tools) https://github.com/firebirdsql/oltp-emul "benchmark" is very

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Pavel Cisar
Hi, May I suggest to add isc_info_* code to query the backup GUID via isc_database_info()? Parsing gstat output for it is very awful. New nbackup switches and options should be also handled by services API. best regards Pavel Cisar IBPhoenix

Re: [Firebird-devel] How an RDB$ index can be rebuilt in 3.0 ?

2016-05-19 Thread Pavel Cisar
Hi, An RDB$INDEX_* is typically an automatically created one for constraint. So you have to identify the constraint, drop it and then recreate it. best regards Pavel Cisar IBPhoenix Dne 18.5.2016 v 21:03 Pavel Zotov napsal(a): > This question arised while discussion of CORE-5242. V

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Pavel Cisar
Hi, that's very neat idea. +1 best regards Pavel Cisar IBPhoenix Dne 18.8.2016 v 12:04 liviuslivius napsal(a): > If i can start general discussion.. > > do you really use such feature in real systems? > I saw this in MSSQL environment and what was advice of DBA when someone reac

Re: [Firebird-devel] User-defined aggregate functions

2018-10-01 Thread Pavel Cisar
ray, percent represented by string (number of # in fixed count of chars, as literal string etc.), they could produce hashes, JSON packets, URI path names etc. best regards Pavel Cisar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Replication: declarative control

2019-02-21 Thread Pavel Cisar
Hi, Generally, I like the DDL approach more than using the configuration file. Additional benefit to ones listed is possibility to create various front-ends for replication configuration / integration of such functionality into existing Firebird management tools. Comments to specific

Re: [Firebird-devel] Replication: declarative control

2019-02-21 Thread Pavel Cisar
Hi, Dne 21. 02. 19 v 11:15 Dimitry Sibiryakov napsal(a): 21.02.2019 10:46, Pavel Cisar wrote: It's tempting, but I see potential for problems. If we would allow multiple sets & filters at master node, there is no need to have them at replica. And if replica would have different definit

[Firebird-devel] What is the cause for isc_login_changed errror?

2019-02-13 Thread Pavel Cisar
Hi all, could anyone explain me what may cause the isc_login_changed error in FB 3 for non-sysdba users? (login works ok for sysdba) It's raised in server.cpp: ServerAuth->accept() best regards Pavel Cisar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/li

Re: [Firebird-devel] What is the cause for isc_login_changed errror?

2019-02-13 Thread Pavel Cisar
Alex, problem solved, it was a configuration issue after all. Sorry for false alarm. regards Pavel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] What is the cause for isc_login_changed errror?

2019-02-13 Thread Pavel Cisar
Sorry, can you explain better. I wonder what configuration caused an error. Wrong order of authentication methods for client and server, along with WireCrypt parameters. We would detect that earlier if some sneaky weasel would not play with the config behind our back. regards Pavel

[Firebird-devel] Introducing Firebird Butler

2019-01-31 Thread Pavel Cisar
We are pleased to announce a significant extension of the Firebird project to a whole new area. Starting in February 2019, alongside the core (Fierbird database system) and database drivers, a completely new division called Firebird Butler is integrated into the project. The purpose of the

[Firebird-devel] New API and scrollable cursors

2020-04-27 Thread Pavel Cisar
here. Did I do something wrong and there are some additional requirements for DSQL scrollable cursors other than scrollable flag? Or is the impression that this feature is not actually implemented really true? BTW, I work with FB 3.0.4 from OpenSuSE Tumbleweed best regards Pavel Cisar Firebird-Devel mailing

Re: [Firebird-devel] New API and scrollable cursors

2020-04-27 Thread Pavel Cisar
Dne 27. 04. 20 v 15:31 Dmitry Sibiryakov napsal(a): 27.04.2020 15:23, Pavel Cisar wrote: Or is the impression that this feature is not actually implemented really true?   Yes it is true though should work in embedded mode. Well, I can confirm that IT WORKS *ONLY* in embedded mode. Could

Re: [Firebird-devel] New API and scrollable cursors

2020-04-27 Thread Pavel Cisar
Dne 27. 04. 20 v 18:09 Dmitry Yemanov napsal(a): 27.04.2020 17:34, Pavel Cisar wrote: The remote protocol support was simply forgotten because nobody asked for that for years. Mea culpa, I was too busy with the replication stuff. Obviously, not so many people use the new API... and even

[Firebird-devel] FB 3 & 4, new API and the ARRAY type

2020-04-22 Thread Pavel Cisar
API). best regards Pavel Cisar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB 3 & 4, new API and the ARRAY type

2020-04-22 Thread Pavel Cisar
Dne 22. 04. 20 v 13:57 Jiří Činčura napsal(a): Although I don't disagree with what you said Pavel, I would support deprecation of arrays in FB4 (in fact I would support removal of arrays in FB4 and late-to-the-party deprecation in FB3, but that ship has probably sailed). I wouldn't bother

Re: [Firebird-devel] FB 3 & 4, new API and the ARRAY type

2020-04-22 Thread Pavel Cisar
Adriano, Dne 22. 04. 20 v 14:02 Adriano dos Santos Fernandes napsal(a): It's perfectly possible to call fb_get_database_handle and fb_get_transaction_handle to go from new API to legacy API. Wonderful! But it's a shame that these functions and their existence is kept as well hidden secret,

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
Dne 08. 07. 20 v 21:13 Mark Rotteveel napsal(a): On 08-07-2020 20:16, Pavel Cisar wrote: As I said, CET is a zone that has a DST rule, that means that - for example - on 2020-01-01, 12:30 CET is 11:30 UTC, while at 2020-06-02,  12:30 CET (== 12:30 CEST) is 10:30 UTC. CET is NOT a zone

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
MArk, Dne 08. 07. 20 v 20:51 Mark Rotteveel napsal(a): Says who? Why 2020-01-01 and not other date? Because Firebird uses it does not make it right, it just make it consistent with Firebird. Also mind that DTS is just one from possible time shifts for timezone. Yes, Firebird says so.

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
Adriano, Obviously the problem is in impedance mismatch between ICU and other systems that use IANA timezone database (notably POSIX, can't speak for Windows). This is then moved to programming languages that typically use OS services to handle timezone information, and not ICU (which is just

[Firebird-devel] Crazy about time/timestamp with timezone

2020-07-08 Thread Pavel Cisar
Hi all, I'm trying to implement support for FB 4 TIME/TIMESTAMP WITH TIMEZONE in new Python driver, and I'm constantly hitting a stone wall with it. The TZ support in standard datetime Python module is nice, smart and flexible, but builtin support does not supports complex TZ with time

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
Mark, Dne 09. 07. 20 v 13:47 Mark Rotteveel napsal(a): Again, it's not correct, it's just consistent/invariant across calendar. Please explain exactly which aspects are not correct according to you. If the goal is to produce a consistent value at a named zone, this is the only way to do

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
Adriano, Dne 09. 07. 20 v 16:39 Adriano dos Santos Fernandes napsal(a): Storage apart, it still requires conversions to TIMESTAMP, comparations, etc work, so a base date is anyway required. Conversion to TIMESTAMP without providing the exact date explicitly is meaningless (as anomalies are

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
Dne 09. 07. 20 v 15:54 Adriano dos Santos Fernandes napsal(a): If OS is configured with deprecated time zone, it will return deprecated time zone name. I don't have my system configured to use deprecated time zone name. My /etc/localtime is a symlink to /usr/share/zoneinfo/Europe/Prague

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-08 Thread Pavel Cisar
Dne 08. 07. 20 v 15:32 Mark Rotteveel napsal(a): TIME WITH TIMEZONE is pointless. It sort off works for "naive" TZ that does not have things like summer time and other time shifts based on date. The pytz library does not even allow you to create time with such tz. The dateutil does, but the

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-08 Thread Pavel Cisar
Mark, I use iUtil Dne 08. 07. 20 v 17:44 Mark Rotteveel napsal(a): The thing is, TIME WITH TIME ZONE for named time zone should be considered at 2020-01-01, so the relevant DST rule for that date is in effect. Says who? Why 2020-01-01 and not other date? Because Firebird uses it does not

Re: [Firebird-devel] Crazy about time/timestamp with timezone

2020-07-09 Thread Pavel Cisar
Adriano, Dne 09. 07. 20 v 17:32 Adriano dos Santos Fernandes napsal(a): I prefer to base implementations on standard + competitors + common sense. So far from the standard pieces, Firebird follow standard. From the extensions pieces, Firebird follow competitor who implement same extensions,

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

2020-06-17 Thread Pavel Cisar
Dne 17. 06. 20 v 2:57 Leyne, Sean napsal(a): If much larger projects than ours can make these changes, I don't see why we shouldn't be doing the same. When I was a kid and came up with such classic "Bandwagon Fallacy", my mother asked me "If others would go and jump off the cliff, does

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

2020-06-17 Thread Pavel Cisar
Adriano, Dne 17. 06. 20 v 18:52 Adriano dos Santos Fernandes napsal(a): You like or not, the market will do things and specifically about replication, the terms where being changed already and will advance. There is no dispute that terminology evolves and if there are terms that are more

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

2020-06-17 Thread Pavel Cisar
Sean, Dne 17. 06. 20 v 17:09 Leyne, Sean napsal(a): Time to perform a simple search and replace!?!! If the terms being discussed were "commie", "chink", "pollack", "spik" "n.gg.r" would they be any less problematic? More argument fallacies? C'mon! I'm sure you can do better. Would we be

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

2020-06-16 Thread Pavel Cisar
Dne 16. 06. 20 v 21:13 Leyne, Sean napsal(a): we may have black list instead white list like now. As always better is to have both black + white. Even better would be "Allow" or "Allowed" and "Deny" or "Denied" terminology. Sean P.S.The same applies to the terms "master/slave"

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

2020-06-18 Thread Pavel Cisar
Dne 18. 06. 20 v 14:27 Mark Rotteveel napsal(a): Depending on the context, other usable terms to replace master could be     agency     hive     primary     conductor     captain     schemer     guide Oh dear! Master is a "title" linked to top authority and professionalism in

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

2020-06-18 Thread Pavel Cisar
Sean, Dne 18. 06. 20 v 0:15 Leyne, Sean napsal(a): 18.06.2020 00:00, Leyne, Sean wrote: "they" is also accepted as a singular, although it seems ungrammatical. Ok, thanks. BTW, when you start your search-and-replace work, don't forget to find substitutions for "owner", "invalid",

Re: [Firebird-devel] FB 4, iUtil and new interface in general

2020-06-15 Thread Pavel Cisar
Alex, Dne 15. 06. 20 v 16:20 Alex Peshkoff via Firebird-devel napsal(a): On 2020-06-11 19:56, Pavel Cisar wrote: Adriano, Dne 11. 06. 20 v 16:38 Adriano dos Santos Fernandes napsal(a): 2. Strange things with iUtil in FB 4. a) Why methods getDecFloat16, getDecFloat34 and getInt128 require

Re: [Firebird-devel] Bug in cloop

2020-06-10 Thread Pavel Cisar
Vlad, As these files are generated and should be used as is, you can safely use variant a) best regards Pavel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Bug in cloop

2020-06-10 Thread Pavel Cisar
Hi, The Firebird.pas file generated by cloop contained wrong interface VERSIONs. While this issue was fixed in interface definitions (by Alex if I'm not mistaken), interface implementations still contains obviously wrong version numbers. Example from Firebird 4 Beta 2 Firebird.pas file:

[Firebird-devel] FB 4, iUtil and new interface in general

2020-06-11 Thread Pavel Cisar
Hi, The Firebird 4 is the first version that has "evolved" interfaces. This bring to table some important questions... 1. What is the official policy for evolution of interfaces? Will their version change every time they change, even if the change replaces "development" version like beta

Re: [Firebird-devel] FB 4, iUtil and new interface in general

2020-06-11 Thread Pavel Cisar
Adriano, Dne 11. 06. 20 v 16:38 Adriano dos Santos Fernandes napsal(a): 2. Strange things with iUtil in FB 4. a) Why methods getDecFloat16, getDecFloat34 and getInt128 require iStatus parameter? I expected that these methods should be "safe" like iMaster.getUtilInterface() and thus should not

Re: [Firebird-devel] FB 4, iUtil and new interface in general

2020-06-12 Thread Pavel Cisar
Hi, Dne 11. 06. 20 v 19:00 Dimitry Sibiryakov napsal(a): > 11.06.2020 18:56, Pavel Cisar wrote: >> It would be a little bit unfortunate if we will end with 50+ method >> iUtil interface in FB 6, thought. > >I hope that before that time someone come with "very new AP

Re: [Firebird-devel] FB 4, iUtil and new interface in general

2020-06-12 Thread Pavel Cisar
?), but guess that engine could use fully internal transaction for that. regards Pavel Dne 12. 06. 20 v 9:05 Vlad Khorsun napsal(a): 12.06.2020 9:52, Pavel Cisar wrote: 2. The statement prepare requires active transaction although it's not bound to one.   The same as ISC API. And this is fully

Re: [Firebird-devel] Partitioning (was: Tablespaces proposal)

2021-10-13 Thread Pavel Cisar
backup/restore must be paired with proper database design and partitioning to make it work properly, but it's certainly a nice tool for handling long-living databases and historic data management. best regards Pavel Cisar Firebird-Devel mailing list, web interface at https://lists.sourcefor

[Firebird-devel] Plans for 4.0.1

2021-12-01 Thread Pavel Cisar
Hi all, would be 4.0.1 released in December, January or later? regards Pavel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] New development re. "contracted" collations and new QA

2022-01-03 Thread Pavel Cisar
Hi all, I'd like inform you about new developments regarding: a) performance issues with partial key lookup with "contracted" collations. We've got sponsor to implement Adriano's solution using 3.0.8 code as primary target. The development and testing should happen in next three months. If

[Firebird-devel] RFC: Fix for issue 6915

2021-11-02 Thread Pavel Cisar
ou can see, we were not able to reach final decision which approach should be used as either solution does not have majority or authoritative support. It's very unfortunate, as this issue is critical for (at least) one major Firebird user, so we need to select one and implement it as soon as po

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Pavel Cisar
Hi, Dne 04. 11. 21 v 16:56 Karol Bieniaszewski napsal(a): „The main reason why this "removal of trailing partial contraction" was done is to achieve behavior "consistent" with search/evaluation in other software (like text editors etc.), so (for example) STARTING WITH "C" or LIKE "C%" will

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Pavel Cisar
Hi, Dne 05. 11. 21 v 12:54 Alex Peshkoff via Firebird-devel napsal(a): Pavel - how this SHOULD be in firebird from big clients POV? STARTING WITH "HROC" should return only HROCENI or HROCH too? They prefer that "C" should NOT match "CH" (which is also how Oracle and SQLServer do it). Fact

Re: [Firebird-devel] RFC: Fix for issue 6915

2021-11-04 Thread Pavel Cisar
Mama mia, here we go again. I have no intention to get sucked even deeper into this endless discussion. I'm fighting covid right now and really don't feel fit for it. In fact, I personally don't care HOW this will be fixed, as long as it WOULD be fixed in some timely manner, which is

[Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-10 Thread Pavel Cisar
Hi all, our test suite contains many tests that depend on specific server configuration settings (mostly related to security, encryption, pools, timeouts, transactions etc.). As these configuration requirements may contradict each other, it's not possible to create single firebird.conf that

[Firebird-devel] Status of 3.0.10

2022-04-13 Thread Pavel Cisar
, but as 3.0.9 release was rushed ahead of schedule, this was deferred to 3.0.10. regards Pavel Cisar IBPhoenix Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-10 Thread Pavel Cisar
Hi, Dne 09. 08. 22 v 17:02 Alex Peshkoff via Firebird-devel napsal(a): *Pavel & Pavel!* I understand you have some problems with testing system due to unablity to create self-security database remotely. But I do not understand how could as solution be suggested not to check credetioals at

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-09 Thread Pavel Cisar
Hi, Dne 09. 08. 22 v 6:33 Alex Peshkoff via Firebird-devel napsal(a): Why this restriction exists ? Because login / password to be validated in the database that does not exist yet. Therefore password check fails and you can't attach to server. Without connection to server it's hard to

[Firebird-devel] [FB-Tracker] Created: (CORE-3449) Wrong or missing IS NULL optimization (regression)

2011-04-22 Thread Pavel Cisar (JIRA)
Affects Versions: 2.5.0 Reporter: Pavel Cisar Test case: /* prepare */ create table tmp_tbl1 (fld1 integer, fld2 integer, fld3 integer); create index tmp_tbl1_fld123 on tmp_tbl1(fld1, fld2, fld3); create index tmp_tbl1_fld2 on tmp_tbl1(fld2); commit; set term ^; create or alter

[Firebird-devel] [FB-Tracker] Created: (CORE-3450) Inefficient optimization (regression)

2011-04-22 Thread Pavel Cisar (JIRA)
Reporter: Pavel Cisar Test case: /* INIT */ create table tmp_tbl1 (fld1 integer, fld2 integer, fld3 integer); create index tmp_tbl1_fld1 on tmp_tbl1(fld1); create index tmp_tbl1_fld2 on tmp_tbl1(fld2); commit; create table tmp_tbl2 (fld1 integer, fld2 integer); create index

[Firebird-devel] [FB-Tracker] Created: (CORE-3451) Query with SP doesn't accept explicit plan

2011-04-22 Thread Pavel Cisar (JIRA)
Reporter: Pavel Cisar Priority: Minor Test query for CORE-3450 doesn't accept explicit execution plan. select t2.fld1 from tmp_tbl2 t2 join tmp_tbl1 t1 on t1.fld1=t2.fld1 join tmp_sp1 on tmp_sp1.fld1=t1.fld2 join tmp_tbl3 t3 on t3.fld1=t1.fld3 where t2.fld2=2 PLAN JOIN (JOIN

[Firebird-devel] [FB-Tracker] Created: (PYFB-9) Support for streamed BLOBs

2011-12-21 Thread Pavel Cisar (JIRA)
Support for streamed BLOBs -- Key: PYFB-9 URL: http://tracker.firebirdsql.org/browse/PYFB-9 Project: Firebird driver for Python Issue Type: New Feature Reporter: Pavel Cisar Assignee: Pavel

[Firebird-devel] [FB-Tracker] Created: (PYFB-11) Support for Firebird ARRAY datatype

2011-12-21 Thread Pavel Cisar (JIRA)
Support for Firebird ARRAY datatype --- Key: PYFB-11 URL: http://tracker.firebirdsql.org/browse/PYFB-11 Project: Firebird driver for Python Issue Type: New Feature Reporter: Pavel Cisar

[Firebird-devel] [FB-Tracker] Created: (PYFB-8) Support for Firebird EVENTS

2011-12-21 Thread Pavel Cisar (JIRA)
Support for Firebird EVENTS --- Key: PYFB-8 URL: http://tracker.firebirdsql.org/browse/PYFB-8 Project: Firebird driver for Python Issue Type: New Feature Reporter: Pavel Cisar Assignee: Pavel

[Firebird-devel] [FB-Tracker] Created: (PYFB-12) Support for Trace Service

2011-12-21 Thread Pavel Cisar (JIRA)
Support for Trace Service - Key: PYFB-12 URL: http://tracker.firebirdsql.org/browse/PYFB-12 Project: Firebird driver for Python Issue Type: Improvement Reporter: Pavel Cisar Assignee: Pavel

[Firebird-devel] [FB-Tracker] Created: (CORE-3867) Outdated error message

2012-06-13 Thread Pavel Cisar (JIRA)
, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0, 2.1.5 Reporter: Pavel Cisar Priority: Minor Error message for unsupported feature (335544378): ARRAY comparison erroneously state that: BLOB and array data types are not supported for compare operation. BLOB comparison is supported

[Firebird-devel] [FB-Tracker] Created: (CORE-3942) Restore from gbak backup using service doesn't report an error

2012-10-02 Thread Pavel Cisar (JIRA)
Components: GBAK Affects Versions: 2.5.1 Reporter: Pavel Cisar When database exists and isc_spb_res_create instead isc_spb_res_replace is specified, restore using service doesn't report any error, just silently does nothing. Although not confirmed, could it be a general issue

[Firebird-devel] [FB-Tracker] Created: (CORE-4578) INPUT file not properly closed

2014-10-15 Thread Pavel Cisar (JIRA)
Environment: Windows XP Reporter: Pavel Cisar Attachments: test_case.zip This is regression from previous versions. File used as input for isql commands can't be deleted before isql session ends. Users executing isql scripts that use temporary command input files (typically created

[Firebird-devel] [FB-Tracker] Created: (CORE-4642) Can't connect to database without path from CWD when DatabaseAccess is restricted

2014-12-19 Thread Pavel Cisar (JIRA)
Core Issue Type: Bug Components: Engine Affects Versions: 2.5.3 Update 1, 2.5.3 Environment: Firebird Classic, local/embedded access on Linux Reporter: Pavel Cisar Priority: Minor When DatabaseAccess configuration option is set

[Firebird-devel] [FB-Tracker] Created: (CORE-5078) "Invalid BLOB ID" error

2016-01-20 Thread Pavel Cisar (JIRA)
3 Update 1, 2.5.3, 2.5.2 Reporter: Pavel Cisar After we switched couple columns from big varchar to blob one customer reported 'Invalid BLOB ID' error. Unfortunately we were not able to notice any pattern to explain what could be causing it thus we were not able to create test case fr

[Firebird-devel] [FB-Tracker] Created: (CORE-5201) Return result code 1 when restore fails on activating and creating deferred user index

2016-04-20 Thread Pavel Cisar (JIRA)
: Firebird Core Issue Type: New Feature Components: GBAK Reporter: Pavel Cisar When restore fails to activate (and recreate) deferred index (typically due to insufficient temporary disk space), gbak returns FAIL result code (1) only when failed index is related

[Firebird-devel] [FB-Tracker] Created: (CORE-5354) Incorrect line number is shown in call stack

2016-09-22 Thread Pavel Cisar (JIRA)
Reporter: Pavel Cisar Sample code below demonstrates incorrect line number in call stack. Commenting out 'first 5' in another 'select' statement above (in the code block which is not even executed) fixes the line number shown in call stack. (removing works the same as commenting out) Some stored

[Firebird-devel] [FB-Tracker] Created: (CORE-5406) Wrong comparison of value with control character

2016-11-25 Thread Pavel Cisar (JIRA)
Reporter: Pavel Cisar When column contains trailing control character (#13) then result of comparison depends on the presence of index on this column. Script to reproduce: CREATE TABLE T ( PK integer primary key, C1 CHAR(10), C2 VARCHAR(10) ); INSERT INTO T (PK, C1, C2

[Firebird-devel] [FB-Tracker] Created: (CORE-5617) Limit for Event table size

2017-09-19 Thread Pavel Cisar (JIRA)
Beta 1 Reporter: Pavel Cisar Event table can grow without limits. This may lead to crash or server may hang, especially when badly written application registers interest to events in uncontrolled way (quick loop etc.). Engine should prevent this situation by imposing a hard limit

[Firebird-devel] [FB-Tracker] Created: (CORE-5812) Extending varchar domain leaves old smaller size in PSQL BLR

2018-05-03 Thread Pavel Cisar (JIRA)
Versions: 2.5.8 Environment: First detected on this env: WI-V2.5.7.27050 Firebird 2.5 classic windows 10 Reporter: Pavel Cisar Consistently reproducible test case: create domain dmn varchar(1); commit; create table tbl(fld dmn); commit; set term ^; create procedure sp

[Firebird-devel] [FB-Tracker] Created: (CORE-5731) 'type of column' error message improvements

2018-01-31 Thread Pavel Cisar (JIRA)
Reporter: Pavel Cisar after misspelling table in 'type of column' declaration error message begins with 'column does not exists', thus developers start looking for problems in wrong place (columns), and it may take a while to spot real error (table), e.g.: set term ^ ; create or alter

[Firebird-devel] [FB-Tracker] Created: (CORE-6074) Trace configuration sensitive to format

2019-06-03 Thread Pavel Cisar (JIRA)
: 3.0.4 Reporter: Pavel Cisar Priority: Minor This configuration is considered as wrong (silently does nothing): database { enabled = true log_connections = true } while this one works fine: database { enabled = true log_connections = true } It's possible

[Firebird-devel] [FB-Tracker] Created: (CORE-6075) Trace configuration is not validated on session start

2019-06-03 Thread Pavel Cisar (JIRA)
: Engine Affects Versions: 3.0.4 Reporter: Pavel Cisar Priority: Critical The trace configuration that is part of "start trace" API call is not parsed/validated on input. The configuration is parsed when other attachment will have something to trace and detect

[Firebird-devel] [FB-Tracker] Created: (CORE-6095) Extend trace record for COMMIT/ROLLBACK RETAINING to allow cjaing of transaction ids

2019-07-04 Thread Pavel Cisar (JIRA)
: Firebird Core Issue Type: Improvement Affects Versions: 4.0 Beta 1, 3.0.4, 2.5.8 Reporter: Pavel Cisar After commit\rollback retaining transaction has a new number (but only when there are any changes to the database). This significantly complicates analysis of trace

[Firebird-devel] [FB-Tracker] Created: (CORE-6101) Conversion error on CASE using computed column

2019-07-16 Thread Pavel Cisar (JIRA)
Affects Versions: 3.0.4 Environment: Firebird-3.0.4.33054_0_x64 Windows 10 / Windows Server 2016 Reporter: Pavel Cisar Here is reproducible test: create table test_table_01 ( id int, get_temp_i computed by ((cast (64 as int))), fld2 int ); commit; insert

[Firebird-devel] [FB-Tracker] Created: (CORE-6499) Regression: gstat with switch -t executed via services fails with "found unknown switch" error

2021-02-26 Thread Pavel Cisar (JIRA)
/CORE-6499 Project: Firebird Core Issue Type: Bug Affects Versions: 4.0 RC 1, 3.0.7 Reporter: Pavel Cisar Found via firebird-driver that uses new OO API. When gstat is executed via services, the -t switch is passed via SPB tag COMMAND_LINE (105) followed