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

2011-04-01 Thread Dimitry Sibiryakov
01.04.2011 11:00, Kjell Rilbe wrote: Good idea, but what if the user later turns out to have been wrong? How to handle it? It will be his/her problem. Restore backup. 01.04.2011 11:03, Dmitry Yemanov wrote: I'm against this. But feel free to keep arguing :-) If user has a

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

2011-04-08 Thread Dimitry Sibiryakov
08.04.2011 18:50, Adriano dos Santos Fernandes wrote: On 08-04-2011 13:43, alexpeshk...@users.sourceforge.net wrote: Log Message: --- Use interface IBlrMessage instead passing C++ class pointer to API interface's functions I'm *very* against this *undiscussed* change. Weren't

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

2011-04-13 Thread Dimitry Sibiryakov
13.04.2011 11:45, Geoff Worboys wrote: More seriously. Yes I know there are important security considerations BUT I thought perhaps people were overlooking what I see as the biggest potential advantage of the request. Just because it is a risk does not take away the potential for advantage.

Re: [Firebird-devel] Aliases

2011-04-15 Thread Dimitry Sibiryakov
15.04.2011 15:08, Woody wrote: However, it would be useful, IMO, to have an alias for directories so that conceptually, you could separate entire functionalities. For instance, the main databases reside in an alias directory called MainDataDir. Backups could be performed to the BackupDataDir.

Re: [Firebird-devel] BLOBs in DSQL

2011-04-17 Thread Dimitry Sibiryakov
17.04.2011 20:03, Adriano dos Santos Fernandes wrote: Comments? Great! Can it also automatically engage BLOB filters if BLOB subtypes differ? -- SY, SD. -- Benefiting from Server Virtualization: Beyond

Re: [Firebird-devel] Charset and collations

2011-04-19 Thread Dimitry Sibiryakov
19.04.2011 13:30, Nikita Konyuchenko wrote: Any suggestions? Always use UTF8 and you won't miss. -- SY, SD. -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use

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

2011-04-27 Thread Dimitry Sibiryakov
27.04.2011 15:33, Kjell Rilbe wrote: Step 2 may be a big problem for 24/7 servers 24/7 systems should not be based on a single server, so, while one node is performing classic backup-restore or suggested procedure, all users can be served by other node(s). -- SY, SD.

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

2011-04-27 Thread Dimitry Sibiryakov
27.04.2011 21:01, Mercea Paul wrote: Is Firebird server cluster ready? I mean for this scenario with multiple server without replication but cluster ! It sounds like you refuse to call shared-nothing architecture a cluster... -- SY, SD.

Re: [Firebird-devel] Shared page cache

2011-05-09 Thread Dimitry Sibiryakov
09.05.2011 18:27, Leyne, Sean wrote: - shadow - not tested I would like to propose that support for database Shadow be completely dropped in v3 I disagree. Shadow is the only method for synchronous replication in Firebird now. Before of dropping it, a replacement should be proposed. --

Re: [Firebird-devel] Shared page cache

2011-05-09 Thread Dimitry Sibiryakov
09.05.2011 18:48, Leyne, Sean wrote: I disagree. Shadow is the only method for synchronous replication in Firebird now. Synchronous replication on a single server is not replication. Don't forget about NFS and iSCSI(?). -- SY, SD.

Re: [Firebird-devel] Shared page cache

2011-05-10 Thread Dimitry Sibiryakov
10.05.2011 9:40, Vlad Khorsun wrote: As long as it keeps launching one process per connection, there's no difference between SharedCache being true or false, as there will always be only one Database/Attachment pair per process. Sure Isn't the cache shared between processes? --

Re: [Firebird-devel] Messages (using boost)

2011-06-17 Thread Dimitry Sibiryakov
17.06.2011 18:19, Adriano dos Santos Fernandes wrote: FB_MESSAGE(Message, (FB_SMALLINT, smallInt0) (FB_INTEGER, integer0) (FB_BIGINT, bigInt0) (FB_SCALED_BIGINT(3), bigInt3) (FB_VARCHAR(10), str10) ) Comments? With GPRE you

Re: [Firebird-devel] DECIMAL field on-disk encoding

2011-07-26 Thread Dimitry Sibiryakov
26.07.2011 14:30, Alessandro Fiorino wrote: I've been at least a bit lucky: the record structure of the data I want to recover is simple and I already found how to detect a record and decode all the other fields (a varchar which always store a 17 chars string and two integers). Don't

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Dimitry Sibiryakov
27.07.2011 13:40, Alex Peshkoff wrote: Before doing JIT, we must think about related security issues. How can we prevent pascal procedure from doing bad things with firebird runuser access rights? Leave it to DBA/sysdmin? In trade-off security vs speed Firebird used to vote for speed. --

Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?

2011-07-27 Thread Dimitry Sibiryakov
27.07.2011 15:05, Alex Peshkoff wrote: BTW, how is it solved in Java? There is no pointers in Java, AFAIK. -- SY, SD. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

2011-08-28 Thread Dimitry Sibiryakov
28.08.2011 15:52, Alex Peshkoff wrote: Certainly, we can make API look like we_do_ join a new attachment to an existing distributed transaction. To do so we just start new transaction in API call internally (need to know TPB...) and join it with existing distributed transaction. What

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Dimitry Sibiryakov
10.10.2011 12:36, Adriano dos Santos Fernandes wrote: Wrong reason, as Oracle doesn't support external triggers. Oracle SQL Reference for version 10 has other opinion: -- quote --- CREATE TRIGGER salary_check BEFORE INSERT OR UPDATE OF salary, job_id ON

Re: [Firebird-devel] Firebird 2.5.1 server crashes with Trace API

2011-10-12 Thread Dimitry Sibiryakov
12.10.2011 23:28, Thomas Steinmaurer wrote: I would love being able to give you a reproduceable test case with the trace api command-line utilities, but I can't. Any pointers are much appreciated, because currently, FBTM can't be used against 2.5.1.

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

2011-10-19 Thread Dimitry Sibiryakov
19.10.2011 14:59, Thomas Steinmaurer wrote: As you can see, the role name (NONE) is missing from the connect information and the user name is in lower case. Just letting you know, perhaps this shall be changed to be consistent. I wonder if attempted user name and password can be added to

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

2011-10-19 Thread Dimitry Sibiryakov
19.10.2011 15:23, Mark Rotteveel wrote: Storing it could be a potential security breach. But a great advantage for DBA on support. But, as Alex already said, it is impossible. -- SY, SD. -- All the data

[Firebird-devel] CORE-432

2011-10-25 Thread Dimitry Sibiryakov
Hello, All. Why CORE-432 was closed with resolution Won't fix? I would like to see information about field names in input XSQLDA fields. Should I create duplicate ticket as a feature request? -- SY, SD. --

Re: [Firebird-devel] news from kernel 3.1

2011-10-26 Thread Dimitry Sibiryakov
26.10.2011 8:58, Alex Peshkoff wrote: Probably I've missed some details. Capacitor present on HDD is really enough only for making sector's writes atomic. A solution with capacitor to save cache somewhere requires additional flash RAM - in that case not too big capacitor is enough to save

Re: [Firebird-devel] news from kernel 3.1

2011-10-26 Thread Dimitry Sibiryakov
26.10.2011 11:05, Ted Miglautsch wrote: The problem with using the energy from rotating to write data is as you remove the energy the rotation slows so it is not possible to write as the disk slows down. It is hard, but I don't see a technical problem in synchronizing write frequency with

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-29 Thread Dimitry Sibiryakov
29.11.2011 9:01, Dmitry Yemanov wrote: Frank has shown a somewhat similar one: it's a more or less common practice to empty/nullify the RDB$***_SOURCE columns. So perhaps, unless some good alternative can be offered, we could still allow modifications of particular columns that are known to

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-29 Thread Dimitry Sibiryakov
29.11.2011 9:48, Dmitry Yemanov wrote: 29.11.2011 12:35, Vlad Khorsun wrote: While i agree with you about SUBSTRING, i think the much better solution will be to allow to index COMPUTED BY columns. It allows to not compare potentially complex expressions at optimize time and to not write

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-30 Thread Dimitry Sibiryakov
30.11.2011 9:08, Thomas Steinmaurer wrote: Or more object type bound, e.g.: ALTER TABLE ... CHANGE OWNER TO ... ALTER VIEW ... CHANGE OWNER TO ... etc.. ALTER PROCEDURE ... DROP SOURCE; I have no idea if the SQL standard suggests here something. I agree with changing owner, but

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-30 Thread Dimitry Sibiryakov
30.11.2011 12:17, Alex Peshkoff wrote: BLR remains. Weren't you going to get rid of it someday?.. Btw, I also do not like practice of dropping the sources. People use it as a kind of protection for the database. This protection is not efficient. But if users need that feature I can better

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-30 Thread Dimitry Sibiryakov
30.11.2011 12:27, Carlos H. Cantu wrote: APDROP SOURCE OF [procedure name|trigger name|*] +1 May I suggest to borrow a term from Oracle and add clause WRAPPED to CREATE or ALTER? I.e create wrapped procedure as ... or create procedure aaa wrapped as It would make migration

[Firebird-devel] UDR triggers, identify transaction

2011-12-01 Thread Dimitry Sibiryakov
Hello, All. Let's say I defined few UDR triggers and I need to keep rather big array of shared information bound to a transaction. What is the best (fastest) way to do it? If I have to organize my own storage, I need to identify the transaction. Is ITransaction pointer got from

[Firebird-devel] Firebird client package in Ubuntu 11.04

2011-12-02 Thread Dimitry Sibiryakov
Hello, All. I wonder: why libfbclient2 package has in dependencies ICU? I wanted to install client only, but had to download 7MB of needless crap. -- SY, SD. -- All the data continuously generated in your

Re: [Firebird-devel] Firebird client package in Ubuntu 11.04

2011-12-02 Thread Dimitry Sibiryakov
02.12.2011 13:04, Thomas Steinmaurer wrote: I then installed 2.5.0 on 11.04 via the project TAR ball and since that, everything works fine. Right, but the project's TAR also doesn't offer client-only install and has the same 7MB in size. -- SY, SD.

Re: [Firebird-devel] Firebird client package in Ubuntu 11.04

2011-12-03 Thread Dimitry Sibiryakov
03.12.2011 0:21, Damyan Ivanov wrote: libfbclient depends on firebird2.5-common, which depends on ICU because if libfbintl. If the client doesn't need fbintl, then I guess I can move it in the -server-common package. Of course client doesn't need fbintl. fbintl is a server-only thing. --

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 10:28, Jesus Garcia wrote: why instead crush the engine when an exception is raised, the engine would catch it and write in the log the error? How??? How the engine catch an alien exception? Could you show the method working in MSVC and GCC? -- SY, SD.

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 17:26, Jesus Garcia wrote: an exception not catched in my app, would not restart my computer. But it will make OS to close your application harshly. Exactly as it is done with Firebird. -- SY, SD.

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 17:51, Jesus Garcia wrote: but i Only have had responses like learn more, learn to write udf, etc Because every programmer know that exceptions can hardly pass boundaries of DLL. Now it is time for you to learn it too. -- SY, SD.

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 18:07, Jesus Garcia wrote: you say can hardly not can't. Right. But I'm not going to describe how many stars must have right positions to allow that. -- SY, SD. -- All the data continuously

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Dimitry Sibiryakov
07.12.2011 11:15, Adriano dos Santos Fernandes wrote: Even if it is written in different language?.. Could you provide example engine handling exception raised in Delphi UDR?.. Could you provide example of UDR in Delphi at all?.. I expect the Delphi people will work on it. No way,

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Dimitry Sibiryakov
07.12.2011 11:40, Vlad Khorsun wrote: No way, I'm afraid. I'm quite good in Delphi, but I have no idea how to convert C++ classes to Delphi classes. I can help. I would prefer to leave this task to the author of the API. Just to make him to think twice next time. -- SY,

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-14 Thread Dimitry Sibiryakov
Speed is one of the most important feature so i think it should be pushed again and again :) If you have some ideas please send them to the list even if they are in Delphi (Pseudo Code) Currently work with BLOBs is slow. I'd suggest to merge packets for open_blob-get_segment-close_blob

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-14 Thread Dimitry Sibiryakov
14.12.2011 18:00, Dmitry Yemanov wrote: This implicitly suggests that a bigger value of the network packet could improve the performance even more, perhaps down to the MySQL's almost three seconds. Only for massive fetches. Performance of big number of small queries cannot be improved

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-14 Thread Dimitry Sibiryakov
14.12.2011 18:24, Dmitry Yemanov wrote: They won't perform worse either. And I was replying to the example where MySQL was faster in fetching rows. Yes. But it was rather artificial example which you can hardly find in real applications. On the other hand, if you remove overhead of

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-14 Thread Dimitry Sibiryakov
14.12.2011 18:46, Dmitry Yemanov wrote: I'd say they will crash (on non-Intel platforms) instead. If you access raw values right in network buffer - yes. But if you use utils from memory_routines.h it won't happen. -- SY, SD.

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Dimitry Sibiryakov
16.12.2011 13:40, Carlos H. Cantu wrote: there is plenty of time for testing. It is not actually about testing, but rather practical usability. API can work without any glitch, but don't provide some functions that are required for real usage. As an example - API for trace plugins which

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Dimitry Sibiryakov
16.12.2011 14:17, Thomas Steinmaurer wrote: Define wider.;-) Anybody outside of core development team. -- SY, SD. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-20 Thread Dimitry Sibiryakov
20.12.2011 11:16, Dmitry Yemanov wrote: The new auth protocol will not truncate the longer password but the legacy one will, AFAIU. In this case there is no security breath: if a malefactor has got truncated password by bruteforcing legacy hash, it is useless. -- SY, SD.

Re: [Firebird-devel] Default setting for legacy secure plugin in firebird3

2011-12-20 Thread Dimitry Sibiryakov
20.12.2011 11:25, Alex Peshkoff wrote: please agree that if one knows first 8 chars it's much simpler to guess/bruteforce/etc. the rest. As a man who don't use meaningless passwords, I have to agree. -- SY, SD.

Re: [Firebird-devel] Initializing security database for first use

2011-12-21 Thread Dimitry Sibiryakov
21.12.2011 12:59, Alex Peshkoff wrote: And what about ZIP - may I ask, how does it work now? I've thought that people at least need to register themselves windows service after opening archive. Am I wrong? For regular users - no, but developers used to use FB server in application mode.

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

2011-12-27 Thread Dimitry Sibiryakov
27.12.2011 19:17, Leyne, Sean wrote: That type of solution is not what I would define as a cluster. As you wish. But the rest of world consider this kind of system to be called a shared-nothing cluster. -- SY, SD.

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

2011-12-27 Thread Dimitry Sibiryakov
27.12.2011 22:17, Leyne, Sean wrote: I should have said: That type of solution is not what immediately comes to mind for me, since I see a shared disk solution (using redundant SAN storage) to be much easier to implement for FB. Unfortunately, shared-storage cluster doesn't solve

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

2011-12-29 Thread Dimitry Sibiryakov
29.12.2011 20:41, Jesus Garcia wrote: Would not be better, instead of that, If transaction id is equal To 0, no transaction, else transaction. There is transaction number zero. As now there is a problem with transactionid and heavy loaded systems, that could solve in a little the

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

2012-01-01 Thread Dimitry Sibiryakov
01.01.2012 14:06, Dmitry Yemanov wrote: Disk speed was always the issue, it doesn't increase that fast as CPU/memory speed. So the on-disk size always matters quite a lot. CPU speed also has stopped growing. -- SY, SD.

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

2012-01-01 Thread Dimitry Sibiryakov
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. - No code change. Cons: - DBA with brain is required. --

Re: [Firebird-devel] Initializing security database for first use

2012-01-02 Thread Dimitry Sibiryakov
02.01.2012 1:38, Steve Friedl wrote: On Sun, Jan 01, 2012 at 08:14:56PM -0400, W O wrote: Right, but it take more time for type them and the probability of mistakes grows. Sure, but if long passwords are allowed, people have a choice as to their own tradeoff of security -vs- convenience.

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

2012-01-02 Thread Dimitry Sibiryakov
01.01.2012 23:43, Kjell Rilbe wrote: 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

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

2012-01-02 Thread Dimitry Sibiryakov
02.01.2012 14:46, Jesus Garcia wrote: he problem is not downtime is how much downtime. Backup and restore is so much downtime. Not more downtime that simple restore after complete server destruction by flood or plane crash. -- SY, SD.

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

2012-01-02 Thread Dimitry Sibiryakov
02.01.2012 16:10, Mark Rotteveel wrote: Could you stop with the absurd comparisons? One is normal maintenance and the other is (extreme) disaster recovery which are in no way comparable. But downtime is downtime. Customers don't care about its reason, do they?.. -- SY, SD.

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dimitry Sibiryakov
03.01.2012 13:25, Adriano dos Santos Fernandes wrote: Firebird needs what is called definers right in Oracle (as opposed to our invokers rights). But not for UDR. External libraries can be substituted/hacked. Giving them all definer's rights is insecure. -- SY, SD.

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dimitry Sibiryakov
03.01.2012 13:35, Adriano dos Santos Fernandes wrote: They could not, if newbies are not DBA(ing). Heh! And they called me sarcastic when I said that DBA requires a brain... -- SY, SD. -- Write once. Port to

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

2012-01-03 Thread Dimitry Sibiryakov
03.01.2012 18:51, Leyne, Sean wrote: - a data port utility which would allow for data to be ported from a live database to a new database while live is active but would need a finalization step where the live database is shutdown to apply the final data changes and add FK constraints.

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

2012-01-03 Thread Dimitry Sibiryakov
03.01.2012 20:37, Leyne, Sean wrote: As for the FKs, I see the tool as being a some which needs to have the maximum performance. If you are going to move whole database at once - yes. Fortunately, in most cases it is not necessary. -- SY, SD.

Re: [Firebird-devel] Remote protocol backward compatibility

2012-01-05 Thread Dimitry Sibiryakov
05.01.2012 12:35, Alex Peshkoff wrote: When I checked it on interbase server some time ago protocol 10 was supported. But connection with fbclient to Interbase XE fail. -- SY, SD. -- Ridiculously easy VDI. With

[Firebird-devel] Read-write access to plugin config

2012-01-16 Thread Dimitry Sibiryakov
Hello, All. I see in IConfig methods to read config entries only. Does it mean that plugin cannot change own configuration or I missed something? -- SY, SD. -- RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400

Re: [Firebird-devel] Read-write access to plugin config

2012-01-17 Thread Dimitry Sibiryakov
17.01.2012 10:30, Alex Peshkoff wrote: As another option everyone is free to write configuration tool for his plugin with any features wanted. There is one little problem: this tool has to be run on the server by user with enough rights. In some cases it is hard. -- SY, SD.

Re: [Firebird-devel] Read-write access to plugin config

2012-01-17 Thread Dimitry Sibiryakov
17.01.2012 10:46, Alex Peshkoff wrote: What about on server - ti depend upon implementation. I can suggest 2 simple methods to do it remotely: - share disk with configuration file and access it over the wire, - write simple web management tool and access it from your favorite browser (like

Re: [Firebird-devel] Granting access to DDL operator CREATE DATABASE

2012-01-18 Thread Dimitry Sibiryakov
18.01.2012 13:18, Alex Peshkoff wrote: But I do not like an idea of making SQL command (GRANT CREATE DATABASE TO SomeUser) dependent upon authentication plugins behavior. But you don't mind SQL command CREATE USER to be dependent on plugin, do you?.. -- SY, SD.

Re: [Firebird-devel] Engine crashes repeatedly when lock table exceeds 2 gigabyte limit

2012-02-13 Thread Dimitry Sibiryakov
13.02.2012 9:06, Dmitry Yemanov wrote: 13.02.2012 11:51, Nikolay Samofatov wrote: Taking into an account that most of users do not need2Gb of lock table, 64-bit offsets (at least for 2.5) should better remain tunable build parameter, turned off by default. Great idea, BTW. I haven't thought

Re: [Firebird-devel] Engine crashes repeatedly when lock table exceeds 2 gigabyte limit

2012-02-13 Thread Dimitry Sibiryakov
13.02.2012 11:37, Alex Peshkoff wrote: Later we have plans to have pluggable lock manager, making it possible to tune installation. I don't like the idea to put whole responsibility to DBA because it is hard to predict when such tuning may be required. How about keep 32bits offset, but

Re: [Firebird-devel] Crypt level configuration

2012-02-21 Thread Dimitry Sibiryakov
21.02.2012 13:13, Alex Peshkoff wrote: What I want to advice - should we have separate crypt level setting for client and server in firebird.conf? Why to use on client parameter in config file at all? Client library always had problems with finding it which may lead to unexpected raw

Re: [Firebird-devel] Visually tricky code

2012-02-22 Thread Dimitry Sibiryakov
22.02.2012 3:27, Claudio Valderrama C. wrote: Or do people prefer the code as it's now? Comments, please. When in the past I fixed variable shadowing warnings caused by such code, I also meet a couple of bugs where wrong variables were used. So, I think that such code must die. -- SY,

Re: [Firebird-devel] Timeout records - an idea for a feature - Email found in subject

2012-02-22 Thread Dimitry Sibiryakov
22.02.2012 11:05, ik wrote: Sorry, but I do not understand the difference. Can't you add such task to a Server Manager ? Just one problem: there is no Server Manager for Firebird. -- SY, SD. -- Virtualization

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

2012-02-22 Thread Dimitry Sibiryakov
22.02.2012 14:49, ik wrote: I think that at least task scheduler such as the databases I mentioned above have, can help a lot in this case, even if we do not have the tmeout record feature. As a developer you, probably, know, that there is no point to invent a wheel and duplicate already

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

2012-02-22 Thread Dimitry Sibiryakov
22.02.2012 15:13, ik wrote: And some data tasks require to act according to time rules. Such as?.. At the moment, for doing this, you constantly require a daemon and not a cron based program to constantly access the database and change data. For example?.. Wouldn't it be better if

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

2012-02-22 Thread Dimitry Sibiryakov
22.02.2012 18:32, ik wrote: 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 . I never heard about such queries. Could you provide a practical example? How would you go with that ? I would go back to

[Firebird-devel] Password encoding

2012-03-01 Thread Dimitry Sibiryakov
Hello, All. Because password encryption method is going to be changed in 3.0, isn't it too late to suggest to convert password into UTF-8 before encryption? Imagine two user environments on Linux, one has locale win1251 and another utf-8. Password, containing non-Latin symbols,

Re: [Firebird-devel] Password encoding

2012-03-01 Thread Dimitry Sibiryakov
01.03.2012 16:27, Alex Peshkoff wrote: That's nightmare:-) But something like KOI-8 is quite possible. Even more possible win1251 in Windows GUI vs cp866 in console. -- SY, SD. -- Virtualization Cloud

Re: [Firebird-devel] Password encoding

2012-03-01 Thread Dimitry Sibiryakov
01.03.2012 16:55, Dalton Calford wrote: Why not have all password connections use a single default encoding regardless of the overall codepage that is in use? The problem is not in the password itself, but in typing it on keyboard. -- SY, SD.

Re: [Firebird-devel] Password encoding

2012-03-01 Thread Dimitry Sibiryakov
01.03.2012 17:17, Adriano dos Santos Fernandes wrote: I understand a problem, but please talk about the solution you're proposing. What is the moment(s) a password should be converted, and from what to UTF8? Sorry, but I don't have a solution for this problem. I would say that password

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dimitry Sibiryakov
06.03.2012 10:55, Kjell Rilbe wrote: I'm sure there will be objections. I'd say the world moves forward - if you don't want it to, that's your problem - live with it! Meaning: if you really want to stay at dialect 1, then fine with me, but then live with the implications, e.g. staying with an

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dimitry Sibiryakov
06.03.2012 10:30, Alex Peshkoff wrote: On 03/06/12 13:06, Dimitry Sibiryakov wrote: 06.03.2012 10:03, Alex Peshkoff wrote: Does it mean that in dialect 1 we keep old limits like number of streams? It means that you keep old limits for applications which use old BLR dialects

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dimitry Sibiryakov
06.03.2012 20:31, Adriano dos Santos Fernandes wrote: So, add a new datatype NUMBER(x, y) who does BCD arithmetics like it's done in Oracle. What this data type will change? What will be result of 1/3 for this data type? If 0, it won't be different from DECIMAL. If 0.(3), how much 3 will

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dimitry Sibiryakov
06.03.2012 20:54, Adriano dos Santos Fernandes wrote: It will be 0.333... (up to the maximum NUMBER scale precision). The thing is that for operations like addition, subtraction, NUMBER will work like NUMERIC (i.e., it's results are more precise than DOUBLE). In this case much easier is to

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dimitry Sibiryakov
06.03.2012 21:27, Leyne, Sean wrote: select 2 * 1.001 from rdb$database = 2.000 This is just a display artefact. Precision of double is enough to keep 11 significant digits. -- SY, SD. -- Keep Your

Re: [Firebird-devel] Raising the BLR level

2012-03-07 Thread Dimitry Sibiryakov
07.03.2012 10:03, Alex Peshkoff wrote: At least for today dialect 1 means blr 4, dialect 3 means blr 5. Suppose this can be reworked, but far not trivially. Weren't there plans to exclude BLR from chain SQL-BLR-EXE at all?.. -- SY, SD.

Re: [Firebird-devel] Raising the BLR level

2012-03-07 Thread Dimitry Sibiryakov
07.03.2012 10:14, Alex Peshkoff wrote: Some related questions are raised: If we talk only about BLR generated and executed inside of server, I would say generate BLR6 always for any SQL dialect, but with BLR generated or interpreted in client library there is a matter of compatibility

Re: [Firebird-devel] Password encoding

2012-03-07 Thread Dimitry Sibiryakov
07.03.2012 16:41, Alex Peshkoff wrote: Therefore the question is - does server-side encoding also fit in to that 'as_server_ can see it'? I would say that if you use unicode routines for file I/O you won't miss. -- SY, SD.

Re: [Firebird-devel] Password encoding

2012-03-10 Thread Dimitry Sibiryakov
10.03.2012 12:08, Alexander Peshkov wrote: in a form as server sees them BTW, I strongly believe that when the doc writer typed it as server sees it, (s)he mean only drive letter and patch, but not encoding. Particularly because native English speakers used to have no idea about

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

2012-04-04 Thread Dimitry Sibiryakov
04.04.2012 12:42, Dmitry Yemanov wrote: 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). If the feature is available via Services API, fbsvcmgr already exists. -- SY, SD.

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

2012-04-04 Thread Dimitry Sibiryakov
04.04.2012 16:38, Adriano dos Santos Fernandes wrote: If encryption detects (at start or after it) that database is in backup mode, it stops its activity and the next-page-to-encrypt will not advance. At merge time, if database is in encrypting state, delta may be merged and encrypted, and

[Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
Hello, All. How in external DDL trigger get context variables, such as OBJECT_NAME and SQL_TEXT? -- SY, SD. -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You.

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
07.04.2012 17:23, Adriano dos Santos Fernandes wrote: From the const IRoutineMetadata* metadata parameter of makeTrigger... Could you be a little more specific?.. I don't see in IRoutineMetadata anything like getContextVariable(). -- SY, SD.

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
07.04.2012 21:12, Dmitry Yemanov wrote: Perhaps it would be a better idea to write a SQL trigger calling the external procedure and passing the required context through. It is loosing whole point of external triggers. The same way an ordinary triggers can call UDFs. -- SY, SD.

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
07.04.2012 22:44, Adriano dos Santos Fernandes wrote: You can have a single external trigger able to read all table columns. In the context you're probably using it (replication), that's much better. You don't need to write (generate / regenerate) specific triggers for each table. For DML

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
07.04.2012 22:44, Adriano dos Santos Fernandes wrote: You can have a single external trigger able to read all table columns. And, BTW, no: I can't read BLOBs and arrays with current interface. -- SY, SD. -- For

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
07.04.2012 23:09, Adriano dos Santos Fernandes wrote: Why not? You must be able to receive the blob id in the C++ code, and calling blob functions using the current transaction get its contents. Yep, I see BLOB function in IAttachment, but where are array functions? -- SY, SD.

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
07.04.2012 23:35, Adriano dos Santos Fernandes wrote: Yep, I see BLOB function in IAttachment, but where are array functions? There too... getSlice, setSlice... What is function to substitute isc_array_lookup_bounds()? -- SY, SD.

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dimitry Sibiryakov
08.04.2012 0:00, Adriano dos Santos Fernandes wrote: 2) Use fb_get_database_handle and fb_get_transaction_handle to retrieve the legacy handles and use them with the ibase function. isc_gen_sdl() is not documented. -- SY, SD.

Re: [Firebird-devel] Transaction type

2012-04-16 Thread Dimitry Sibiryakov
16.04.2012 13:21, Alex Peshkoff wrote: I.e. with transaction ID use of ~0 as special condition should be OK. Doesn't internal transaction have id 0? -- SY, SD. -- For Developers, A Lot Can Happen In A Second.

Re: [Firebird-devel] Transaction type

2012-04-16 Thread Dimitry Sibiryakov
16.04.2012 14:45, Claudio Valderrama C. wrote: Alex wrote ~0 instead of 0, did you notice it? Oops, my fault. :((( -- SY, SD. -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Dimitry Sibiryakov
17.04.2012 12:53, Claudio Valderrama C. wrote: Ok, I would like to create a type. If typedef ULONG TxnType; is too awkward, suggest something better. Because it is not a transaction itself, but only it's id, I would suggest tid_t... -- SY, SD.

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Dimitry Sibiryakov
17.04.2012 12:12, Alex Peshkoff wrote: It can get out from jrd in at least 2 cases - in system context variable and in monitoring tables. Also in the results of isc_transaction_info and isc_database_info. -- SY, SD.

  1   2   3   4   5   6   7   8   9   10   >