Re: [Firebird-devel] Connecting to Firebird 3

2012-04-19 Thread Dmitry Yemanov
19.04.2012 12:59, Claudio Valderrama C. wrote: Do we really need to keep it? We surely don't want all the existing Jaybird installations to stop working. Dmitry -- For Developers, A Lot Can Happen In A Second.

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-19 Thread Dmitry Yemanov
19.04.2012 12:02, Mark Rotteveel wrote: Ok, that sounds relatively easy. What is the hashing algorithm, and where in the Firebird sources can I find its implementation? Something derived from DES, AFAIK. See ENC_crypt(), located in /src/jrd/ (pre-FB3) or in /src/common/ (trunk). Dmitry

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Dmitry Yemanov
18.04.2012 21:55, Mark Rotteveel wrote: I just installed Firebird 3 from the Windows x64 zip kit, but I am unable to authenticate using FlameRobin, or using Jaybird. What fbclient version is loaded by FlameRobin? In the conf file I have uncommented: AuthClient = Srp, Win_Sspi, Legacy_Auth

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Dmitry Yemanov
19.04.2012 0:07, Mark Rotteveel wrote: It looks like Jaybird uses an authentication mechanism that is no longer supported with Firebird 3: Hex dump from wireshark for both Jaybird (fails) and Flamerobin (succeeds) is attached. Most obvious thing I notice that Jaybird sends the password in

Re: [Firebird-devel] Firebird 3 on windows 2000

2012-04-18 Thread Dmitry Yemanov
19.04.2012 9:12, Jaison wrote: Is Firebird 3 not supported on Windows 2000? I don't remember what decision has been made in this regard, but I'd expect WinXP being the supported minimum. It seems none of the binaries are working on windows 2000. What is the reported error? Dmitry

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Dmitry Yemanov
17.04.2012 14:53, Claudio Valderrama C. wrote: Ok, I would like to create a type. If typedef ULONG TxnType; is too awkward, suggest something better. TxnId or txn_id_t or something like that. Dmitry -- Better than

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Dmitry Yemanov
17.04.2012 14:20, Vlad Khorsun wrote: TraNumber tra_number; From another side, it's isc_info_tra_id in API, TRANSACTION_ID in context variables and MON$TRANSACTION_ID in the monitoring tables :-) As for me, both Id and Number are acceptable as suffixes. Just please don't make it

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Dmitry Yemanov
17.04.2012 16:34, Claudio Valderrama C. wrote: Ok, let's use TxnNumber or TraNumber; should I define it in JRD? As I see, this definition will be only useful for JRD, unless some of you insist that I put it in fb_types.h. JRD should be okay. Second, following the same reasoning, should I

Re: [Firebird-devel] Transaction type

2012-04-16 Thread Dmitry Yemanov
16.04.2012 15:38, Dimitry Sibiryakov wrote: Not related if system transaction is never passed to these functions. 0 ~0 Dmitry -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and

[Firebird-devel] [FB-Tracker] Created: (CORE-3817) Forced database shutdown does not work if non-zero delay was specified

2012-04-14 Thread Dmitry Yemanov (JIRA)
Type: Bug Components: Engine Affects Versions: 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0 Environment: Classic and SuperClassic only Reporter: Dmitry Yemanov There are two visible issues: 1) Any kind of shutdown attempt

Re: [Firebird-devel] Pipelining

2012-04-13 Thread Dmitry Yemanov
13.04.2012 18:34, marius adrian popa wrote: In Firebird 3.x you can write your own protocol, this is what i understand from the pluggable architecture In your wishes, perhaps. While it might be doable, we are not going to replace everything with plugins. Dmitry

Re: [Firebird-devel] Pipelining

2012-04-13 Thread Dmitry Yemanov
13.04.2012 20:21, Alex Peshkoff wrote: It's only half-unrelated with pluggable architecture. One can write: 1. Network redirector implementing new protocol, which is provider and therefore plugin. True. 2. Network server which is using yValve as any other application. But the network

Re: [Firebird-devel] Transaction type

2012-04-13 Thread Dmitry Yemanov
Claudio, Hello, for a long time I've been thinking in creating a TxnType (or whatever name) to hold the type of a transaction, so it could be changed for experimentation in the future. This type would be ULONG for now (although I found some cases where we still use SLONG). We have *a lot* of

[Firebird-devel] [FB-Tracker] Reopened: (CORE-3557) AV in engine when preparing query against dropping table

2012-04-12 Thread Dmitry Yemanov (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Yemanov reopened CORE-3557: -- A new regression is found because of this change. Simple test case: create view v as select t4

Re: [Firebird-devel] BTYACC non-terminal types

2012-04-12 Thread Dmitry Yemanov
12.04.2012 14:50, Alex Peshkoff wrote: I do not like use of sed script for that. Me neither. And IIRC, it's not required for Windows builds now, unless you build the installer. If we anyway maintain own copy of btyacc - why not change it Agreed. and suggest patch to them? It's pointless,

Re: [Firebird-devel] Raising the BLR level

2012-04-12 Thread Dmitry Yemanov
11.04.2012 17:41, Adriano dos Santos Fernandes wrote: In the past, I thought about this problem, and a possibility I saw was to create a BLR prefix, saying the next BLR-rse verb would use two bytes for stream numbers instead of one. I do not know if this is a good solution, it's just a

Re: [Firebird-devel] Raising the BLR level

2012-04-10 Thread Dmitry Yemanov
11.04.2012 6:14, Claudio Valderrama C. wrote: Example of an API call? isc_compile_request, isc_transact_request, isc_dsql_*_m family. I assume that if someone wants to talk BLR v6, he should indicate that. Sure, any BLR stream starts with its version, be it on disk or at the API level. I

Re: [Firebird-devel] Events on embedded

2012-04-09 Thread Dmitry Yemanov
09.04.2012 14:19, Mark Rotteveel wrote: Are events available on embedded, and if so are there any special things you need to take care of to get them working? Of course they're available and working out of the box, without any trickery. Dmitry

Re: [Firebird-devel] Retrieving relation alias

2012-04-09 Thread Dmitry Yemanov
09.04.2012 19:26, Mark Rotteveel wrote: I notice in /jrd/why.cpp (2.5 branch) that a similar named array does not have the isc_info_sql_relation_alias entry: static const SCHAR sql_prepare_info2[] = { isc_info_sql_stmt_type, // describe_select_info isc_info_sql_select,

Re: [Firebird-devel] Retrieving relation alias

2012-04-09 Thread Dmitry Yemanov
09.04.2012 20:22, Dimitry Sibiryakov wrote: Isn't aliasname field of XSQLVAR for the relation alias name?.. It's the field alias, IIRC. Dmitry -- For Developers, A Lot Can Happen In A Second. Boundary is the first to

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Dmitry Yemanov
07.04.2012 19:45, Adriano dos Santos Fernandes wrote: It really don't expose all the engine internals. You can get it running SQL on this method. Perhaps it would be a better idea to write a SQL trigger calling the external procedure and passing the required context through. Dmitry

[Firebird-devel] [FB-Tracker] Created: (CORE-3807) Error Invalid expression in the select list can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connect

2012-04-04 Thread Dmitry Yemanov (JIRA)
Reporter: Dmitry Yemanov Simplified test case (to be executed with connection charset = UTF-8): select 'Current time is ' || cast(a.t as varchar(10)) from (select current_time t from rdb$database) a group by 'Current time is ' || cast(a.t as varchar(10)) -- ERROR: -- Invalid expression

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

2012-04-04 Thread Dmitry Yemanov
03.04.2012 11:55, Alex Peshkoff wrote: To work with encrypted database file we need a tool to encrypt database. I see 3 possible solutions for it. In all 3 cases some plugin dependent parameter may be passed to plugin. In all cases one may use decrypt instead encrypt to make 1. ALTER

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

2012-04-04 Thread Dmitry Yemanov
Claudio Valderrama C. wrote: Would it call the INF functions to get that information? I ask because obviously gfix cannot work like gstat in local mode, IE we don't expect it to be able to read the page header directly. Yes, isc_database_info() could be a solution here (if we really need a

Re: [Firebird-devel] ADO.NET provider for Firebird 2.7.5 released

2012-03-28 Thread Dmitry Yemanov
28.03.2012 17:23, Jiri Cincura wrote: The 2.7.5 version of ADO.NET provider for Firebird is ready for download. http://blog.cincura.net/232764-ado-net-provider-for-firebird-2-7-5-released/ Your blog refers to the Firebird website for download, but the website does not contain the links for

Re: [Firebird-devel] Lock manager memory 2 GB

2012-03-23 Thread Dmitry Yemanov
23.03.2012 11:13, Alex Peshkoff wrote: In trunk - definitely. What about 2.5 - not sure. May be having patch for high-end systems is better approach than commit in svn? I'd say we need to see the patch before deciding. Dmitry

Re: [Firebird-devel] Firebird 3 - Install SC as a service

2012-03-22 Thread Dmitry Yemanov
22.03.2012 12:29, Thomas Steinmaurer wrote: = Does that mean: We have a single executable in Firebird 3. When -m is used, this means a single server process and the SharedCache, SharedDatabase parameters controll whether it's SS or SC. When -m is not used, then it's one process per

Re: [Firebird-devel] Firebird 3 - Install SC as a service

2012-03-22 Thread Dmitry Yemanov
22.03.2012 12:34, Alex Peshkoff wrote: Probably small change in help text - SS or SC - will be useful. Before doing that, we need to decide whether the former SuperClassic will be the documented option or just some internal stuff for easier debugging etc, as FB3 is intended to make it mostly

Re: [Firebird-devel] Firebird 3 - Install SC as a service

2012-03-22 Thread Dmitry Yemanov
22.03.2012 13:00, Thomas Steinmaurer wrote: * Under the assumption that SS as a single-process model with it's shared cache supports SMP (I think this was a primarly goal) in 3.0 like SC in 2.5, I don't see a reason to offer SC in 3.0 at all (at least the SC terminology; which already shows

Re: [Firebird-devel] Firebird 3 (Build: 29857) - Multiple attachments to the same database fails

2012-03-20 Thread Dmitry Yemanov
20.03.2012 12:12, Thomas Steinmaurer wrote: Is this a known issue? http://firebird.1100200.n4.nabble.com/Fb-3-cannot-get-additional-connections-td4413326.html Dmitry -- This SF email is sponsosred by: Try Windows

Re: [Firebird-devel] Firebird 3 - Querying MON$DATABASE freezes server

2012-03-20 Thread Dmitry Yemanov
20.03.2012 13:22, Dmitry Yemanov wrote: Not for me (in both modes). It seems I see it now, sorry. Will have a look and report back. Dmitry -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click

[Firebird-devel] [FB-Tracker] Created: (CORE-3792) Performance of batch inserts is degraded

2012-03-20 Thread Dmitry Yemanov (JIRA)
: 2.5.1 Reporter: Dmitry Yemanov Batch insert operations causing the table to grow (new data pages to be allocated) are likely to perform noticably slower than expected (up to 50%), especially in the FW=ON mode. This is a regression introduced after fixing CORE-3468. -- This message

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

2012-03-18 Thread Dmitry Yemanov
18.03.2012 11:59, Kjell Rilbe wrote: 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? The links has been added, sorry for inconvenience. Atom

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

2012-03-17 Thread Dmitry Yemanov
17.03.2012 19:44, marius adrian popa wrote: I have announced here for the comments, Maybe Adriano or others can share their comments about the core improvements :) It was mostly an info for end users (those who's interested). Once it gets closer to the implementation, it will be discussed

Re: [Firebird-devel] csb_repeat's csb_flags in exe.h

2012-03-10 Thread Dmitry Yemanov
Claudio, People, what's the difference between const int csb_modify = 64; // we are processing a modify combined with const int csb_erase = 256; // we are processing an erase and the single flag const int csb_update = 1024;

Re: [Firebird-devel] FLAG_EMBEDDED

2012-03-10 Thread Dmitry Yemanov
Claudio, Hello, can someone comment on the usefulness of this flag, please? class dsql_req : public pool_allocdsql_type_req { static const unsigned FLAG_EMBEDDED = 0x02; It's only used in dsql.cpp, inside DSQL_execute() if ((SSHORT) in_msg_type ==

[Firebird-devel] ANN: Firebird 2.0.7 Release Candidate is available

2012-03-09 Thread Dmitry Yemanov
The Firebird Project team is happy to announce that the v2.0.7 release candidate kits for Linux, Windows and Mac OS X platforms are ready for testing. The download page: http://www.firebirdsql.org/en/firebird-2-0-7-rc1/ Enjoy the testing and please don't hesitate to report the found

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dmitry Yemanov
06.03.2012 10:46, Alex Peshkoff wrote: And taking into an account that we do not support ODS 12 in current engine - do we need to keep support of old BLR versions? I see 2 ways for old BLR to arrive in ODS12 database. First of all - when old database is restored. May be we should learn gbak

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Dmitry Yemanov
06.03.2012 15:05, Alex Peshkoff wrote: Also want to agree, but I remember there were some real reasons (unfortunately do not remember them) making people stay with dialect1. May be somebody remembers that reasons? Lack of precisions bigger than 18 in NUMERIC/DECIMAL and, even more important,

Re: [Firebird-devel] Fb 3 - cannot get additional connections?

2012-02-23 Thread Dmitry Yemanov
24.02.2012 11:26, Martijn Tonies wrote: The message is I get using Windows authentication is: I/O error during CreateFile (open) operation for file E:\TEMP\FB3TEST.FDBError while trying to open fileThe process cannot access the file because it is being used by another process. I'm using

Re: [Firebird-devel] Visually tricky code

2012-02-22 Thread Dmitry Yemanov
22.02.2012 6:27, Claudio Valderrama C. wrote: I think that playing here with streamList vs this-streamList is a recipe for misreading the code and making mistakes: This is why I prefer to prefix all member variables with m_, e.g. m_streamList. Others may surely disagree with the chosen syntax

Re: [Firebird-devel] negative values performance info

2012-02-18 Thread Dmitry Yemanov
18.02.2012 16:54, Björn Reimer wrote: Current memory = -507.368.239 Max memory = -466.997.327 Memory buffers = 20.480 Fetches from cache = -1.256.613.653 Historically, all performance counters were 32-bit. Later, they were enhanced to represent 64-bit values. Firebird 2.5 could report

Re: [Firebird-devel] isc_info_firebird_version without database handle

2012-02-18 Thread Dmitry Yemanov
18.02.2012 23:33, Jiri Cincura wrote: can I somehow ask for isc_info_firebird_version without database handle? I'd like to know it before processing op_attach. You can use the service manager and ask it for isc_info_svc_server_version. Dmitry

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-18 Thread Dmitry Yemanov
15.02.2012 20:01, Mark Rotteveel wrote: Does SQL_VARYING require the sqllen to be updated as well, or can that be left as it was originally set by isc_dsql_describe_bind? I'd say it should correspond to the real data. You're not required to use isc_dsql_describe_bind(), after all. Dmitry

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

2012-02-13 Thread Dmitry Yemanov
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 of a build parameter. I can agree with

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

2012-02-13 Thread Dmitry Yemanov
13.02.2012 14:13, Vlad Khorsun wrote: Imagine x64 CS server and x32 embedded apps at the same time. They must share the same lock table... It was never possible. 64-bit lock table is incompatible with 32-bit one and it has different version number in the header. Dmitry

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

2012-02-13 Thread Dmitry Yemanov
13.02.2012 13:45, Alex Peshkoff wrote: I'm not really sure this is strictly required for v2.x. We surely must add an overflow protection, here I agree. A check in shared memory grow code should do a trick. Sure. But if it would be possible to have ULONG offsets instead of SLONG, it would

Re: [Firebird-devel] CORE-3701 / JDBC-233 help needed

2012-02-13 Thread Dmitry Yemanov
11.02.2012 20:49, Mark Rotteveel wrote: * Is the size being allocated for SQL_TEXT right? It is allocating sqllen + 1 and null-terminating it, while looking at the Interbase 6 ApiGuide they are always allocating sqllen and not null-terminating You don't have to null-terminate it, sqllen is

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

2012-02-12 Thread Dmitry Yemanov
13.02.2012 11:39, Alex Peshkoff wrote: The simplest part of the task. Just make them offset_t - very logical name for offsets :-) It depends on what headers you include. For example, our own offset_t defined in File.h is always 64-bit :-) Certainly, a lot of places where lock size is

[Firebird-devel] [FB-Tracker] Created: (CORE-3758) Backport into v2.1.5

2012-02-09 Thread Dmitry Yemanov (JIRA)
Backport into v2.1.5 Key: CORE-3758 URL: http://tracker.firebirdsql.org/browse/CORE-3758 Project: Firebird Core Issue Type: Sub-task Reporter: Dmitry Yemanov -- This message is automatically generated

Re: [Firebird-devel] CORE-2422 in 2.1 branch

2012-02-09 Thread Dmitry Yemanov
09.02.2012 17:58, Thomas Steinmaurer wrote: Splitting temp destinations into e.g. RAM disk and if this is exhausted to regular disk is getting more and more popular, but due to CORE-2422, So far nobody has proved that this approach is better than adjusting TempCacheLimit. this doesn't seem

Re: [Firebird-devel] CORE-2422 in 2.1 branch

2012-02-09 Thread Dmitry Yemanov
09.02.2012 20:58, Leyne, Sean wrote: What Thomas is looking to define is a setup where an RAM would be the first device for the temp results (to enable much faster processing -- RAM disk has 100x IO of even an SSD!!), with any excess falling to an SSD or HDD. The approach/setup is

Re: [Firebird-devel] MON$STATEMENTS.MON$STATE = 2?

2012-02-03 Thread Dmitry Yemanov
03.02.2012 14:10, Thomas Steinmaurer wrote: what's the meaning of 2 for MON$STATEMENTS.MON$STATE? STALLED. I.e. an interval between client fetches from the open cursor. Priorly this state was reported as ACTIVE because the query is alive and running but the CPU time is not spent by the engine

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Dmitry Yemanov
31.01.2012 2:12, Adriano dos Santos Fernandes wrote: There is two obscure SQL commands called READ BLOB and WRITE BLOB. The idea behind these commands is to make blob read/write using the cursor (fetch/insert) API. Why they exist is not something I know, maybe it predates blob API functions?

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

2012-01-23 Thread Dmitry Yemanov
18.01.2012 15:20, Alex Peshkoff wrote: We have plans to make it possible to grant and revoke rights to create new database objects (tables, procedures, generators, etc.). The implementation is more or less clear - it may be new system table or new type of ACL. But there is one DDL which does

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 16:16, Dimitry Sibiryakov wrote: 03.01.2012 13:11, Dmitry Yemanov wrote: I believe that the internal UDR queries should work exactly like EXECUTE STATEMENT WITH CALLER PRIVILEGES. I would prefer fine-grained rights instead of bunch... Could you elaborate? Dmitry

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 17:25, Alex Peshkoff wrote: I believe that the internal UDR queries should work exactly like EXECUTE STATEMENT WITH CALLER PRIVILEGES. Dunno however whether its already the case or still in the pipeline. Why only caller privileges? If we have external procedure, what's wrong if

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 17:40, Alex Peshkoff wrote: In EXECUTE STATEMENT certainly yes. But I do not understand why should external procedure behave like EXECUTE STATEMENT, not like any other stored procedure. We seem to have some misunderstanding :-) Both UDRs and EXECUTE STATEMENTs deal with dynamic

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 18:09, Alex Peshkoff wrote: Definitely. I was talking about ability to grant privileges to the whole external procedure as an object :-) Me too :-) I was describing how it's going to work. Caller is an UDR, so caller privileges are privileges granted to that UDR. Dmitry

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 18:06, Vlad Khorsun wrote: Who will be the CALLER if UDR function is used in SELECT statement issued by client ? CALLER is UDR itself, so this question is meaningless for me, sorry. Dmitry -- Write once.

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 18:53, Vlad Khorsun wrote: If we speak about statements that issued by UDR - certainly. I was speaking only about statements issued by UDR, as it was the subject initiated by Dimitry Sibiryakov. But if we speak about UDR itself - what set of privileges should it have ? So far

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Dmitry Yemanov
03.01.2012 18:20, Alex Peshkoff wrote: How deep in call stack we going to propagate CALLER privileges (UDR call some SQL statement which have UDR calls embedded and so on) ? May be unlimited? No recursion is required at all. If UDP MY_PROC selects UDF MY_FUNC from table T1 and MY_FUNC in

[Firebird-devel] Remote protocol backward compatibility

2012-01-03 Thread Dmitry Yemanov
All, Would there be any objections if we remove the support for protocol versions less than 10? It means that fbclient would not connect to pre-v6 versions of InterBase and fbserver would not accept connections from pre-v6 versions of gds32. All Firebird versions would still be supported, as

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

2012-01-01 Thread Dmitry Yemanov
01.01.2012 14:34, Kjell Rilbe wrote: Are there unused flag bits available in the current record format, that could be used for this purpose? Or how are such flag bits encoded? We have 7 or 8 bits (out of 16) currently available. Dmitry

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

2012-01-01 Thread Dmitry Yemanov
01.01.2012 16:48, Jesus Garcia wrote: Is not better use 64 bits integer?. In the near future computers speed, hdd speeds, etc. will increase, and transaction id of 64 bits overhead will affect less and less to performance. Disk speed was always the issue, it doesn't increase that fast as

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

2011-12-31 Thread Dmitry Yemanov
31.12.2011 17:57, Alexander Peshkov wrote: This will make each version of the record (not the record- but EACH version of it) 4 bytes longer. Not strictly necessary. We could use a variable-length encoding for txn ids longer than 32 bits and mark such records with a new flag. It would add

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

2011-12-14 Thread Dmitry Yemanov
14.12.2011 20:02, Carlos H. Cantu wrote: Vlad, 06/12/2010 16:24:51: could you edit firebird.conf at both client and server hosts and set TcpRemoteBufferSize = 32700 ? ok, much better (but still worse than MySQL): [06/12/2010 16:27:47] Opening FB Query and fetching all data () [06/12/2010

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

2011-12-14 Thread Dmitry Yemanov
14.12.2011 21:09, Dimitry Sibiryakov wrote: Only for massive fetches. Performance of big number of small queries cannot be improved this way. They won't perform worse either. And I was replying to the example where MySQL was faster in fetching rows. Dmitry

[Firebird-devel] [FB-Tracker] Created: (CORE-3686) Incorrect (zero) values are reported for acquire blocks and mutex wait counters in the fb_lock_print output

2011-12-05 Thread Dmitry Yemanov (JIRA)
://tracker.firebirdsql.org/browse/CORE-3686 Project: Firebird Core Issue Type: Bug Components: Engine, LOCK_PRINT Affects Versions: 2.5.1, 2.5.0, 3.0 Initial Environment: SuperServer and SuperClassic Reporter: Dmitry Yemanov When accessing the lock table

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

2011-11-30 Thread Dmitry Yemanov
30.11.2011 12:08, Thomas Steinmaurer wrote: Or more object type bound, e.g.: ALTER TABLE ... CHANGE OWNER TO ... ALTER VIEW ... CHANGE OWNER TO ... +1, although I'd prefer SET instead of CHANGE. And I believe that CREATE OR ALTER should miss this clause. Dmitry

Re: [Firebird-devel] soureforge.net

2011-11-30 Thread Dmitry Yemanov
30.11.2011 12:24, Mark Rotteveel wrote: Is it able to discern between 32 and 64 bit? Unfortunately, not. On Windows Vista 64 bit (using Firefox 32 bit though) I get the suggestion to download the Firebird 32 bit package. This is the lesser evil. You know that 32-bit builds can work in both

Re: [Firebird-devel] soureforge.net

2011-11-30 Thread Dmitry Yemanov
30.11.2011 12:44, Alex Peshkoff wrote: Who knows which evil is lesser... If one downloads 32-bit build for 64-bit OS, he can always stay with it even not knowing that 64 builds exist. But at least it will work fine for him, even being possibly a bit slower than the x64 build. And those who

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

2011-11-29 Thread Dmitry Yemanov
28.11.2011 23:51, Helen Borrie wrote: Here's another one: the COMMENT syntax for loading varchar text into RDB$DESCRIPTION. 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

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

2011-11-29 Thread Dmitry Yemanov
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 exactly same expressions in every query

Re: [Firebird-devel] soureforge.net

2011-11-29 Thread Dmitry Yemanov
30.11.2011 11:37, Dmitry Yemanov wrote: So the reason is elsewhere. Found it. SF has an ability to set the default download for the every major platform (Win/Lin/Mac/etc). This option was left empty for the server binaries but set for the .NET provider packages. I have it fixed now

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-17 Thread Dmitry Yemanov
17.11.2011 4:39, Frank Ingermann wrote: a) [ ] file it as a bug - this _should_ work! This would get my vote, as it works fine (and returns rows in the expected order) in PGSQL. Dmitry -- All the data continuously

Re: [Firebird-devel] Still on the ext4 slowness...

2011-11-17 Thread Dmitry Yemanov
17.11.2011 12:59, Philippe Makowski wrote: I really wonder if we can't get MaxUnflushedWrites or something like that under Linux too I would be curious to do same test with this parameter under Linux It works for all platforms, you just need to uncomment and set it up in firebird.conf.

Re: [Firebird-devel] Firebird 2.5.2 release time frame?

2011-11-17 Thread Dmitry Yemanov
17.11.2011 13:49, Thomas Steinmaurer wrote: the previously reported bug in the Trace API is a bit nasty for customers how are extensively using the Trace stuff. I wonder if there is some kind of time frame for releasing 2.5.2 available, because for people coming from 2.1, they can't download

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Dmitry Yemanov
17.11.2011 14:14, Adriano dos Santos Fernandes wrote: Or to flush group of independent pages at once, like I proposed. Sure. I was speaking about the current code only. Dmitry -- All the data continuously generated

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Dmitry Yemanov
17.11.2011 15:37, Vlad Khorsun wrote: And, note, most heavy case (flush on commit) is already optimized. With FW=ON, it's optimized only for better write order (less HDD head movements). But AFAIU we're talking here about batched writes instead of singleton writes. Dmitry

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

2011-11-16 Thread Dmitry Yemanov
17.11.2011 11:26, Alex Peshkoff wrote: And one more interesting line: open(./fb_init, O_RDWR|O_CREAT|O_LARGEFILE, 0600) = 7 Why is _SHARED_ file opened in CWD? It should go to /tmp/firebird. Because he explicitly sets FIREBIRD_LOCK to CWD before running ISQL :-) Dmitry

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

2011-11-14 Thread Dmitry Yemanov
14.11.2011 23:15, Damyan Ivanov wrote: # session 1 $ FIREBIRD=. FIREBIRD_LOCK=. isql-fb dbd-firebird-test.fdb Database: dbd-firebird-test.fdb SQL # session 2, from another terminal, running in the same working # directory FIREBIRD=. FIREBIRD_LOCK=. isql-fb dbd-firebird-test.fdb # hangs

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

2011-11-14 Thread Dmitry Yemanov
15.11.2011 2:11, Thomas Steinmaurer wrote: I guess the same applies to MON$IO_STATS.MON$PAGE_FETCHES? If so, isn't comparing MON$PAGE_READS with MON$PAGE_FETCHES a bit misleading if one wants to check to possibly increase the database page buffers? I bet you're thinking about the cache hit

Re: [Firebird-devel] Lock error in CCH

2011-11-06 Thread Dmitry Yemanov
06.11.2011 3:01, Vlad Khorsun wrote: Running CORE-3650 test-case in different isql embedded sessions with SharedCache and SharedDatabase, I had (one time) a hang and a crash. The crash happened after the first command. I ran it in session1, session2, session1, etc (or some variant). This is

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

2011-11-06 Thread Dmitry Yemanov
07.11.2011 11:23, Thomas Steinmaurer wrote: With all the discussion, is it worth to create a JIRA issue for this feature request? I don't mind :-) Dmitry -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now

Re: [Firebird-devel] gfix segfault when building current trunk

2011-10-31 Thread Dmitry Yemanov
31.10.2011 22:14, Michal Kubecek wrote: when building current trunk from SVN (revision 53601) on Linux (x86_64 OpenSuSE Factory but the same was observed on i586 SLES 11 SP1 as well), the command gfix -write async security.tmp sometimes segfaults (not always, in about half of the

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Dmitry Yemanov
25.10.2011 14:03, Adriano dos Santos Fernandes wrote: 2) FW=OFF, and use fsync on COMMIT - pages will not be reordered, and when COMMIT happens they will be written to disk in order I believe this is wrong assumption. Nobody guarantees that OS will be flushing the dirty pages from the

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Dmitry Yemanov
25.10.2011 14:45, Paul Reeves wrote: The documentation in firebird.conf (v2.5) indicates that this is disabled for posix. It's disabled by default (setting = -1). But it does work if reconfigured. Dmitry -- The

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Dmitry Yemanov
25.10.2011 14:39, Philippe Makowski wrote: in fact with theses settings, FW=OFF is safer than before safe enough to be the default ? Even in the paranoid mode (MaxUnflushedWrites = 1) they still don't guarantee the write order. So, if the crash happens while the transaction is being

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

2011-10-10 Thread Dmitry Yemanov
10.10.2011 12:26, Vlad Khorsun wrote: If such clause is inside trigger code then it not affects security checks and *whole* trigger code is checked. SQL standard says something about security checks for conditional triggers ? I believe the rules are the same. In general, it's impossible to

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

2011-10-10 Thread Dmitry Yemanov
10.10.2011 14:43, Dimitry Sibiryakov 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

[Firebird-devel] [FB-Tracker] Reopened: (CORE-3622) Classic: Stopping Windows Service leaves one or more instances of fb_inet_server.exe running

2011-10-07 Thread Dmitry Yemanov (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-3622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Yemanov reopened CORE-3622: -- Reopened for further discussion. I'm not really sure whether it should be treated as a bug

[Firebird-devel] [FB-Tracker] Created: (CORE-3596) Client library cannot connect to the non-ASCII host name

2011-09-12 Thread Dmitry Yemanov (JIRA)
Components: API / Client Library Affects Versions: 2.5.0 Reporter: Dmitry Yemanov Since v2.5.0 the connection string is converted into UTF8 in the Y-valve, prior to calling the providers that are expected to convert it back into the system charset if required. But it doesn't happen

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

2011-08-29 Thread Dmitry Yemanov
30.08.2011 0:44, Kjell Rilbe wrote: Has this been improved since FB 2.1? Nope. Any future plans? In FB3, perhaps. Dmitry -- Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management

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

2011-08-25 Thread Dmitry Yemanov
25.08.2011 10:36, Kjell Rilbe wrote: Any rough estimate when the next RC or final release will be ready? I assume it's dependent on feedback from this RC, but based on experience etc? Usually the next RC or final release appears after a month of public testing. Dmitry

Re: [Firebird-devel] FB3 and python

2011-08-18 Thread Dmitry Yemanov
18.08.2011 13:55, Alex Peshkoff wrote: Hi, who knows what was a reason to comment out following constants in consts_pub.h in trunk? //#define isc_info_db_SQL_dialect 62 //#define isc_dpb_SQL_dialect 63 //#define isc_dpb_set_db_SQL_dialect65 Without

Re: [Firebird-devel] Firebird undo/redo logs

2011-08-07 Thread Dmitry Yemanov
07.08.2011 18:24, Dimitry Sibiryakov wrote: 07.08.2011 16:04, Ajay Singh wrote: I need some information about the undo/redo logs which firebird keeps to support concurrent transactions. Firebird is not Oracle, it doesn't use logs to support concurrent transactions. RTFM:

Re: [Firebird-devel] reading invalid data

2011-08-01 Thread Dmitry Yemanov
01.08.2011 18:24, Elmar Haneke wrote: On FB 2.5 invalid data in Timestamp fields does raise an error (even on reading). On FB 1.5 the invalid data was stored without any problems. How can I avoid that error on reading data which has been stored by FB 1.5? You should correct those values in

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

2011-07-26 Thread Dmitry Yemanov
26.07.2011 16:00, Alessandro Fiorino wrote: Can someone point me to where can I found in the source how a DECIMAL field is encoded when saved on disk ? I need it to manually recover a broken database. It depends on its declared precision and database dialect. Also, you're unlikely to detect

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

2011-07-26 Thread Dmitry Yemanov
26.07.2011 16: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). The

<    7   8   9   10   11   12   13   >