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

2011-03-31 Thread Adriano dos Santos Fernandes
On 31-03-2011 10:44, alexpeshk...@users.sourceforge.net wrote: Revision: 52620 http://firebird.svn.sourceforge.net/firebird/?rev=52620view=rev Author: alexpeshkoff Date: 2011-03-31 13:44:22 + (Thu, 31 Mar 2011) Log Message: --- Remove reference counting where

Re: [Firebird-devel] Reference counters in API

2011-04-01 Thread Adriano dos Santos Fernandes
On 01-04-2011 07:14, Alex Peshkoff wrote: On 03/31/11 19:13, Adriano dos Santos Fernandes wrote: On 31-03-2011 07:49, Alex Peshkoff wrote: People would like to detach a parent and not care about statements created but unfreed for this attachment. If they do not call addRef for statements

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-03 Thread Adriano dos Santos Fernandes
On 03-04-2011 14:59, Thomas Steinmaurer wrote: Hello, any ideas why inserting 1 million records with a GUID primary key using the built-in GEN_UUID() function takes WAY longer than with an integer primary key. My finding: I ran a VERY simple test case on Firebird 2.5 SuperClassic on a

Re: [Firebird-devel] FB3. CREATE OR ALTER TRIGGER

2011-04-04 Thread Adriano dos Santos Fernandes
On 04-04-2011 13:37, Kovalenko Dmitry wrote: Hi SQL Script set transaction; create table TEST_36187 (ID INTEGER); create trigger BI_TEST_36187 for TEST_36187 before insert as declare variable x integer; begin select count(*) from TEST_36187 into :x; end; CREATE OR ALTER trigger

Re: [Firebird-devel] Reference counters in API

2011-04-08 Thread Adriano dos Santos Fernandes
On 08-04-2011 11:25, Vlad Khorsun wrote: 08.04.2011 15:42, Vlad Khorsun wrote: Thanks. But, if this is true : In 64 bit mode, there is only one calling convention for each operating system then we have no problem with interfaces despite of compiler\language on x64 systems. Yep, if

Re: [Firebird-devel] Faster restore

2011-04-08 Thread Adriano dos Santos Fernandes
On 08-04-2011 01:45, Dmitry Yemanov wrote: 08.04.2011 5:57, Adriano dos Santos Fernandes wrote: I do have some raw ideas to make batching on the message and request API, changing fetch to not return 100/101 but count of messages, and make possible to use input messages where is truly many

[Firebird-devel] SQLDA/SQLVAR (not XSQLDA/XSQLVAR)

2011-04-10 Thread Adriano dos Santos Fernandes
All, Our functions dealing with XSQLDA/XSQLVAR has a dialect parameter. When dialect is 0, the structures are interpreted as SQLDA/SQLVAR. These structs are a legacy version with less items. They declarations are not present in ibase.h at least since 2.0. I want to remove them. Objections?

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

2011-04-11 Thread Adriano dos Santos Fernandes
On 11-04-2011 04:19, Alex Peshkoff wrote: On 04/09/11 19:44, Adriano dos Santos Fernandes wrote: On 09-04-2011 08:58, Vlad Khorsun wrote: On 08-04-2011 13:43, alexpeshk...@users.sourceforge.net wrote: Revision: 52693 http://firebird.svn.sourceforge.net/firebird/?rev=52693view=rev

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

2011-04-11 Thread Adriano dos Santos Fernandes
On 11-04-2011 12:09, Dmitry Yemanov wrote: 11.04.2011 18:04, Alex Peshkoff wrote: Telling true, inability to extend XSQLDA in backward compatible way was always obvious for everyone here. Only partially true. It's designed to be backward compatible and I don't see why it cannot work. The

Re: [Firebird-devel] Reference counters in API

2011-04-12 Thread Adriano dos Santos Fernandes
On 12-04-2011 06:02, marius adrian popa wrote: ps:we really need a really good c++ for flamerobin and other c++ toolkits :qt/wx How can i test the new api ? there is some doc or samples somewhere ? I'll soon publish some tests at https://github.com/asfernandes/fbstuff. Adriano

[Firebird-devel] BLOBs in DSQL

2011-04-17 Thread Adriano dos Santos Fernandes
Hi! It's allowed to use XSQLVAR (or blr messages) between different types like number-varchar (or vice-versa) but it's not allowed to use different types when one of them is a blob. DSQL moves data using MOVD_move, which do it like a client move. This was ok before, cause DSQL was not part of

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 27/04/2011 19:28, Support List wrote: I am doing a new major release of IB Objects soon and I want to get confirmation of some things before I finalize it. I have some scenarios that I would like to know what to do about. There are a total of 9 possible combinations of 3 aspects. Aspect

Re: [Firebird-devel] Firebird 2.5 on Freebsd 8.2

2011-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2011 10:22, Leonardo M. Ramé wrote: Hi, I installed FB 2.5 on FreeBSD 8.2 AMD64, and found that fb_smp_server doesn't start because of the libraries libicu* requiered are version 38 and the server has installed version 46. This is what I get when starting fb_smp_server:

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Adriano dos Santos Fernandes
On 29/04/2011 04:11, Geoff Worboys wrote: As far as I can tell it is still required to use isc_dsql_execute_immediate to perform a CREATE DATABASE (if I've missed any relevant API change in the release notes please forgive me, I did look). Could also be done with isc_create_database. So

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-29 Thread Adriano dos Santos Fernandes
On 29/04/2011 09:00, Geoff Worboys wrote: Adriano dos Santos Fernandes wrote: Could also be done with isc_create_database. The IB6 API documentation notes this as: The isc_create_database( ) method is not currently supported from user applications. It is for internal use only. Use

Re: [Firebird-devel] Semantics of release

2011-05-16 Thread Adriano dos Santos Fernandes
On 16/05/2011 14:12, Vlad Khorsun wrote: On 16/05/2011 13:33, Vlad Khorsun wrote: So, if code calls attach\release - this is bug, as for me, and i see no reasons to write code in this way intentionally. I consider at as very bad practice as it could lead to the inexpected side effects (such

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Adriano dos Santos Fernandes
On 17/05/2011 08:27, Vlad Khorsun wrote: What about the following - we always pass status vector to release(). I'm sorry but i against it. addRef\release is and well known pair and its usage also well known. I see no good reason to change it. More, if we need to change it, then we use it

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Adriano dos Santos Fernandes
On 17/05/2011 04:05, Alex Peshkoff wrote: In FB2.5 yValve did not need any more MT-safeness except provided by atomic counters and some helper locks like hanlers' map RwLock. Initially I've planned to keep same approach for FB3. But I did not review latest Adriano's changes from this POV. I

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Adriano dos Santos Fernandes
On 17-05-2011 19:58, Vlad Khorsun wrote: PS: There is a paper (http://www.aristeia.com/Papers/DDJ_Jul_Aug_2004_revised.pdf) from Scott Meyers and Andrei Alexandrescu showing even or volatile usage in base classes are wrong. Unfortunately it's down. With MSVC we are safe as we use

Re: [Firebird-devel] Problems in upgradeInterface

2011-05-24 Thread Adriano dos Santos Fernandes
On 24/05/2011 07:46, Alex Peshkoff wrote: On 05/23/11 16:27, Adriano dos Santos Fernandes wrote: On 23/05/2011 09:21, Alex Peshkoff wrote: Yes of cause. I agree with all this words - but mentioned cache will anyway remain always empty in fbclient of FB3. And I do not say it must

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

2011-06-17 Thread Adriano dos Santos Fernandes
On 17/06/2011 13:30, Dimitry Sibiryakov wrote: 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

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

2011-06-17 Thread Adriano dos Santos Fernandes
On 17/06/2011 13:30, Dimitry Sibiryakov wrote: With GPRE you don't even need to care about types, it will get it automatically from DB, so - what's the point to change one preprocessor for another? Let me also say something which may be not clear. These messages struct/blr could be

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

2011-07-27 Thread Adriano dos Santos Fernandes
On 27/07/2011 08:40, Alex Peshkoff wrote: On 07/27/11 15:11, Tony Whyman wrote: 6. Just in time compilation of the embedded procedure on first use (after create/alter) into a shared library/DLL which is then effectively a dynamically generated UDF library. A JIT approach is important because

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

2011-07-27 Thread Adriano dos Santos Fernandes
On 27/07/2011 10:00, Jim wrote: Of course, an alternative, as Alex Peshkoff mentioned: If we vote for speed, the best choice will be use of precompiled libraries - like with UDFs. And like UDFs we leave it to sysadmin - not DBA. ... we could just trust sysadmins to only upload proper code -

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

2011-07-27 Thread Adriano dos Santos Fernandes
On 27/07/2011 10:08, Dimitry Sibiryakov wrote: 27.07.2011 15:05, Alex Peshkoff wrote: BTW, how is it solved in Java? There is no pointers in Java, AFAIK. Sure. The language don't allow such malicious things. And the Java plugin security works like a Java applet running in your browser.

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

2011-07-27 Thread Adriano dos Santos Fernandes
On 27/07/2011 10:57, Roman Rokytskyy wrote: And the Java plugin security works like a Java applet running in your browser. It's by default configured to allows nothing that can danger the machine. But say you need to access the network, you put a record in the java security database saying

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

2011-07-27 Thread Adriano dos Santos Fernandes
On 27/07/2011 10:43, Sergey Mereutsa wrote: Hello Adriano, AdSF Sure. The language don't allow such malicious things. Yes, but JVM is written by humans, and errare humanum est ;-) As long there is no current serious public know vulnerability in a years-old technology, I'd say it's secure.

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

2011-07-27 Thread Adriano dos Santos Fernandes
On 27/07/2011 11:16, Roman Rokytskyy wrote: Oh, so you have implemented a proper security manager for the Java ESPs? You are great man! :) It was difficult and initially was failing only in Linux. But after changes it worked ok as far as I can test. Will it accept also a default security

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

2011-08-28 Thread Adriano dos Santos Fernandes
On 28-08-2011 11:51, Dimitry Sibiryakov wrote: 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

[Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-28 Thread Adriano dos Santos Fernandes
All, After I bought a new machine, I reinstalled Ubuntu in new HDD with ext4 filesystem. While the new machine has much better CPU than the old one, I noticed the build being very slow where Firebird was creating databases. I found that mounting the ext4 partition with barrier=0 parameter

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 06:27, Paul Reeves wrote: On Monday 29 August 2011 at 11:05 marius adrian popa wrote: you are not the only one that observed db/vm performance issues with ext4 maybe you need to mount it with data=writeback

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 06:05, marius adrian popa wrote: On Mon, Aug 29, 2011 at 1:14 AM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: All, After I bought a new machine, I reinstalled Ubuntu in new HDD with ext4 filesystem. While the new machine has much better CPU than the old one, I

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 10:13, Paul Reeves wrote: On Monday 29 August 2011 at 14:25 Michael Weissenbacher wrote: But if barriers are needed just to make journal commits safe on the disk with write cache turned on this seems to be not directly related with firebird databases - write cache ON will anyway

Re: [Firebird-devel] Performance of FW databases on ext4 filesystem

2011-08-29 Thread Adriano dos Santos Fernandes
On 29/08/2011 10:24, Paul Reeves wrote: On Monday 29 August 2011 at 13:35 Alexander Peshkov wrote: Tested CREATE DATABASE on my old box. To avoid disk fragmentation effects database was always created on new shining partition. I've found different results doing a large db restore. ext4 came

Re: [Firebird-devel] Firebird terribly slow on Ubuntu 10.04 - ext4

2011-08-30 Thread Adriano dos Santos Fernandes
On 30-08-2011 18:27, Fulvio Senore wrote: Now I have installed Ubuntu 10.04 LTS 64 bit in my laptop, formatting the disk partitions with the ext4 file system. When I use the same program to open my catalog, it takes about 23 seconds. That is in incredibly long time and I really cannot

Re: [Firebird-devel] Stored procedures in other languages interface

2011-09-19 Thread Adriano dos Santos Fernandes
On 19/09/2011 06:48, Jiri Cincura wrote: On Mon, Sep 19, 2011 at 10:39 AM, Alex Peshkoffpeshk...@mail.ru wrote: ; this is how the data are pumped into the method (so it can be further pumped by plugin into method); this is how you can return value/resultset; etc. Here I do not understand

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

2011-10-10 Thread Adriano dos Santos Fernandes
On 10/10/2011 06:48, Vlad Khorsun wrote: Seems conditional triggers have sence only for external (non-PSQL) triggers. Moreover, only when the call is cost (like Java, but not for C++). Adriano -- All the data

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

2011-10-10 Thread Adriano dos Santos Fernandes
On 10/10/2011 07:43, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Adriano dos Santos Fernandes
On 25/10/2011 07:56, Paul Reeves wrote: On Tuesday 25 October 2011 at 11:12 marius adrian popa wrote: In other words: if you use Ext3 and you note performance regressions with this release, try disabling barriers (barriers=0 mount option). I can understand doing this for routine desktop work.

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

2011-11-14 Thread Adriano dos Santos Fernandes
On 14-11-2011 05:31, Vlad Khorsun wrote: My doubt is that we will write more pages than necessary. Imagine small cache (CS) and set of actively modifying pages. Currently we will write them one-by-one when new buffer is required. You offer to write, say, 2 pages at time and replace

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

2011-11-14 Thread Adriano dos Santos Fernandes
On 14-11-2011 04:54, Alex Peshkoff wrote: So, it's just a fact of allow it with the new API. And then there must be a way to libraries uses bits of the new API mixed with old one. May be I do not understand what you mean here... Why mix? Because then previously written application would

Re: [Firebird-devel] Trace - Character set in output

2011-11-15 Thread Adriano dos Santos Fernandes
On 14-11-2011 20:09, Vlad Khorsun wrote: Hello, I have the following character set (ISO88591) information in the trace output: 2011-10-27T20:58:16.5210 (920:00D4DA30) COMMIT_TRANSACTION fbtm_unittest.fdb (ATT_2, FBTM:NONE, ISO88591, TCPv4:127.0.0.1)

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Adriano dos Santos Fernandes
On 17/11/2011 09:19, Alex Peshkoff wrote: On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: On 17/11/2011 07:52, Dmitry Yemanov wrote: The only way to guarantee ordered writes is to flush individual pages and this is what FW=ON does. Or to flush group of independent pages at once, like

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

2011-11-21 Thread Adriano dos Santos Fernandes
On 21/11/2011 16:45, Frank Ingermann wrote: Hi, Am 19.11.2011 01:04, schrieb Vlad Khorsun: Because standard prohibits any kind of aggregates in recursive CTE members. So this would mean option b) is correct: b) [ ] window functions are not supposed to work in the child select

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

2011-11-28 Thread Adriano dos Santos Fernandes
On 28/11/2011 11:03, Thomas Steinmaurer wrote: - Changing the owner of database objects, which hold the owner information and everything additional needed for the conversion (e.g. SQL privileges etc ...) This doesn't appear to be a daily task that requires special support from the engine,

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

2011-11-28 Thread Adriano dos Santos Fernandes
On 28/11/2011 16:22, Leyne, Sean wrote: Adriano, select char_length( SUBSTRING(col1 from 1 for 20)) from tbl_test returns 20 so I was expecting index to work. workaround CREATE INDEX IDX1 ON tbl_test COMPUTED BY (CAST(SUBSTRING(col1 from 1 for 20) as varchar(20))) This issue

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

2011-11-29 Thread Adriano dos Santos Fernandes
On 29-11-2011 18:28, Claudio Valderrama C. wrote: -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Martes, 29 de Noviembre de 2011 6:41 I believe it's better to have a system package with functions able to do that, instead of continue

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

2011-11-29 Thread Adriano dos Santos Fernandes
On 29-11-2011 05:56, Dmitry Yemanov wrote: 28.11.2011 23:08, Adriano dos Santos Fernandes wrote: No. It happens with large varchar column. So it turns back to my question: can we describe a column with a length we know will fit and will have no side effects other than just being described

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

2011-11-30 Thread Adriano dos Santos Fernandes
On 30/11/2011 14:52, Björn Reimer wrote: The discussion about removing sources or not makes little sense for me. It is possible with fb 2.5 and prior and should be possible in future versions as this feature is used. If you don't like it don't use it. I wonder if these people who is

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

2011-11-30 Thread Adriano dos Santos Fernandes
On 30/11/2011 16:05, Carlos H. Cantu wrote: AdSF With BLR + debug_info it's very possible (and easy) to reconstruct AdSF sources. And better, you don't even need to read the sources in the AdSF original format style, but in the style you you want it! Probably not, So as I suppose. but

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

2011-11-30 Thread Adriano dos Santos Fernandes
On 16-11-2011 22:39, Frank Ingermann wrote: Hi all, i'm trying to combine the new Window functions in Fb3 with recursive CTEs to get a _defined_ ordering of the recursive child records in the result set. The recursive problem is fixed, in fact it was a problem of window functions with

Re: [Firebird-devel] The new Firebird OO API

2011-12-02 Thread Adriano dos Santos Fernandes
On 02/12/2011 05:26, Pierre Y. wrote: Hi, I advanced a bit more with this new API but I just absolutely don't see how to deal with FbMessage. What is it ? How do I have to use it to access (or send ?) data ?

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

2011-12-04 Thread Adriano dos Santos Fernandes
On 04-12-2011 13:17, Jesus Garcia wrote: The engine does what is possible and tries to catch the 'alien exception'. You must do your part and write a correct UDF, testing them before in non-production environment. Adriano I know it, and is not me, is firebird. I try To test everything,

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

2011-12-04 Thread Adriano dos Santos Fernandes
On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote: On 16-11-2011 22:39, Frank Ingermann wrote: Hi all, i'm trying to combine the new Window functions in Fb3 with recursive CTEs to get a _defined_ ordering of the recursive child records in the result set. The recursive problem

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

2011-12-07 Thread Adriano dos Santos Fernandes
On 07/12/2011 07:31, Alex Peshkoff wrote: On 12/05/11 04:23, Geoff Worboys wrote: So the power example would become: declare external function dPower double precision by descriptor, double precision by descriptor, double precision by descriptor, integer by descriptor returns parameter 3

Re: [Firebird-devel] CORE-3073 and downgrades

2011-12-09 Thread Adriano dos Santos Fernandes
On 09/12/2011 16:34, Vlad Khorsun wrote: CORE-3073 [1] requires special BLR verb meaning get the default value of a field. There is request to expose the same functionality in SQL too, but doesn't matter here. These cascade triggers are system triggers but are backed-up and restored. If we

Re: [Firebird-devel] CORE-3073 and downgrades

2011-12-09 Thread Adriano dos Santos Fernandes
On 09/12/2011 16:50, Vlad Khorsun wrote: On 09/12/2011 16:34, Vlad Khorsun wrote: CORE-3073 [1] requires special BLR verb meaning get the default value of a field. There is request to expose the same functionality in SQL too, but doesn't matter here. These cascade triggers are system

Re: [Firebird-devel] Using the Firebird 3.0 API with Delphi

2011-12-12 Thread Adriano dos Santos Fernandes
On 12/12/2011 11:34, Alex Peshkoff wrote: On 12/12/11 15:43, Pierre Y. wrote: Hi All, Thanks to Vlad, we achieved the translation of the FB3 OO API in UIB Components for Delphi. You can checkout the code from SourceForge repository : https://uib.svn.sourceforge.net/svnroot/uib/trunk

[Firebird-devel] UUIDs

2011-12-15 Thread Adriano dos Santos Fernandes
All, CORE-3238 is the problem related to UUIDs version and reserved bytes which we're not respecting. Note that in Windows, we generate UUIDs with a WinAPI function so it generates correct numbers, but in POSIX we just generate random data. 1) So from a POV, we may say our GEN_UUID is correct

Re: [Firebird-devel] UUIDs

2011-12-15 Thread Adriano dos Santos Fernandes
On 15/12/2011 15:04, Leyne, Sean wrote: Adriano, CORE-3238 is the problem related to UUIDs version and reserved bytes which we're not respecting. Note that in Windows, we generate UUIDs with a WinAPI function so it generates correct numbers, but in POSIX we just generate random data. 1)

Re: [Firebird-devel] UUIDs

2011-12-15 Thread Adriano dos Santos Fernandes
On 15/12/2011 16:46, Leyne, Sean wrote: Note that in Windows, we generate UUIDs with a WinAPI function so it generates correct numbers, but in POSIX we just generate random data. For Windows users this binary representation is also wrong now, cause reserved bits is not documented in it. You

Re: [Firebird-devel] Reason for slow CREATE DATABASE in FB 3 (Linux)

2011-12-15 Thread Adriano dos Santos Fernandes
On 15-12-2011 18:11, Vlad Khorsun wrote: As I said before, ext4 performance with FW=ON is much slower than ext3, but I now found something new. I've verified that with FB 2.5, TCS times was ok (0s - 3s), and only with FB 3 they are very bad (first test takes 16s, then 12s, 8s, 7s, 7s, etc)

Re: [Firebird-devel] Reason for slow CREATE DATABASE in FB 3 (Linux)

2011-12-16 Thread Adriano dos Santos Fernandes
On 16/12/2011 05:24, Vlad Khorsun wrote: So now we're spending time while the database is not even completely created. While we can restore previous behavior (put FW ON flag at header page when database is created but create db file with this flag switched off) i prefer to ask - are we

Re: [Firebird-devel] UUIDs

2011-12-16 Thread Adriano dos Santos Fernandes
On 16/12/2011 06:08, Mark Rotteveel wrote: On Thu, 15 Dec 2011 15:14:20 -0200, Adriano dos Santos Fernandes adrian...@gmail.com wrote: There is no UUID binary representation in the RFC. There it's just a formated string. Yes there is a binary representation defined in http://www.ietf.org

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

2011-12-20 Thread Adriano dos Santos Fernandes
On 20/12/2011 06:57, Alex Peshkoff wrote: connect: client's public key, login and database name = server accept: server's public key and salt = client attach: client's proof = server response: success if client's proof == server's proof What I would like to know is that if there is a way

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

2011-12-20 Thread Adriano dos Santos Fernandes
On 20/12/2011 08:19, Alex Peshkoff wrote: On 12/20/11 13:54, Adriano dos Santos Fernandes wrote: On 20/12/2011 06:57, Alex Peshkoff wrote: connect: client's public key, login and database name = server accept: server's public key and salt = client attach: client's proof = server

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

2011-12-20 Thread Adriano dos Santos Fernandes
On 20/12/2011 11:20, Alex Peshkoff wrote: I wonder is it possible to change windows installer to initialize security database. Next, for ZIP install people will have to run gsec first time manually. Are this changes OK for us? I don't think it is, specially for zip. I think bind the server

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

2011-12-20 Thread Adriano dos Santos Fernandes
On 20/12/2011 11:41, Alex Peshkoff wrote: On 12/20/11 17:26, Adriano dos Santos Fernandes wrote: On 20/12/2011 11:20, Alex Peshkoff wrote: I wonder is it possible to change windows installer to initialize security database. Next, for ZIP install people will have to run gsec first time

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

2012-01-01 Thread Adriano dos Santos Fernandes
On 01-01-2012 15:11, Jesús García wrote: I think the question is if it is neccesary and good for Firebird, and if the pros of having transactions id of 64bits are better that the cons of not having it. From my POV using 32 bits id is an important restriction in the engine, and i would

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Adriano dos Santos Fernandes
Firebird needs what is called definers right in Oracle (as opposed to our invokers rights). External routines should work like internals one. What matters is the routine declaration, definers/invokers rights. Adriano

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Adriano dos Santos Fernandes
On 03/01/2012 10:30, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] Firebird Uptime/SLA (was: Firebird Transaction ID limit solution)

2012-01-03 Thread Adriano dos Santos Fernandes
Just throwing another thing: Isn't some form of journaling expected to appear in Firebird, as I've heard in the past? If yes, the journal could be used to consolidade old transaction in one and implement the thing about adjusting the transaction number and making it overlap as I said

Re: [Firebird-devel] Warning

2012-01-23 Thread Adriano dos Santos Fernandes
On 23-01-2012 06:57, Claudio Valderrama C. wrote: Adriano, I get a warning about non-standard extension: nameless struct or union. struct Guid { enum Style { STYLE_NBACKUP, // Format introduced with nbackup STYLE_BROKEN, // Format introduced in

Re: [Firebird-devel] no database triggers switch for qli

2012-01-23 Thread Adriano dos Santos Fernandes
On 20-01-2012 08:02, Claudio Valderrama C. wrote: -Original Message- From: Frank Schlottmann-Gödde [mailto:fr...@schlottmann-goedde.de] Sent: Jueves, 19 de Enero de 2012 12:35 Thank you, I had the impression that all qli-switches where one letter switches, but I'm happy with -nod.

Re: [Firebird-devel] no database triggers switch for qli

2012-01-23 Thread Adriano dos Santos Fernandes
On 23-01-2012 20:25, Adriano dos Santos Fernandes wrote: On 23-01-2012 19:55, Claudio Valderrama C. wrote: But now TCS (and all others programs calling QLI like it) don't work: - qli: ignoring unknown switch -n v2.5 or v3? I tried only v3. Actually, a test had this different outputs

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3741) RDB$INDICES information stored inconsistently after a CREATE INDEX

2012-01-30 Thread Adriano dos Santos Fernandes
On 28-01-2012 00:50, Claudio Valderrama C. wrote: -Original Message- From: Mark Rotteveel (JIRA) [mailto:trac...@firebirdsql.org] Sent: Viernes, 27 de Enero de 2012 13:45 RDB$UNIQUE_FLAG is 1 for a unique index, but NULL for non-unique (I would expect 0) RDB$INDEX_INACTIVE is NULL

Re: [Firebird-devel] Firebird RLE of two repeating bytes

2012-02-01 Thread Adriano dos Santos Fernandes
On 01-02-2012 09:35, Norman Dunbar wrote: PS. One day I'll finish decoding the internals and finish the manual! Thanks for reading so far. You're manual is very great. I'm able to read (kind of) table data based only on it (didn't even looked at FB sources). Adriano

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

2012-02-01 Thread Adriano dos Santos Fernandes
On 01-02-2012 12:46, Dmitry Yemanov wrote: 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

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

2012-02-02 Thread Adriano dos Santos Fernandes
On 02-02-2012 08:34, Alex Peshkoff wrote: Looks like that when introducing cursors people wanted to follow some standard that existed that time. But from today POV this commands look useless and should better be removed - specially if they cause problems with engine stability. But probably

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

2012-02-13 Thread Adriano dos Santos Fernandes
On 13-02-2012 13:33, Dmitry Yemanov wrote: * For all datatypes other than SQL_VARYING, it is first storing byteArray size and then overwriting that with the byteArray, so actually storing that size first is unnecessary, right? I'm not sure I understand you here. * Is 0x20 (space) the

Re: [Firebird-devel] gbak improvement

2012-02-23 Thread Adriano dos Santos Fernandes
On 23/02/2012 10:50, Nick Upson wrote: Hi, before putting this idea into the trackers I wanted to make sure its not totally crazy. When gbak finishes the actual data part of the restore it then creates all the indexes, could it do that in parallel based on the number of processors

Re: [Firebird-devel] SF.net SVN: firebird:[54042] firebird/trunk/builds/posix

2012-02-24 Thread Adriano dos Santos Fernandes
It was me who added these sed usages to makefiles, to let build work after header files removal. Some time later, I discovered gcc -MP: - This option instructs CPP to add a phony target for each dependency other than the main file, causing each to depend on nothing. These dummy

Re: [Firebird-devel] Password encoding

2012-03-01 Thread Adriano dos Santos Fernandes
On 01/03/2012 12:29, Dimitry Sibiryakov wrote: 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.

Re: [Firebird-devel] Password encoding

2012-03-01 Thread Adriano dos Santos Fernandes
On 01/03/2012 13:26, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2012 07:14, Claudio Valderrama C. wrote: -Original Message- From: Kjell Rilbe [mailto:kjell.ri...@datadia.se] Sent: Martes, 06 de Marzo de 2012 6:55 Isn't it about time to drop support for dialect 1? Yes. But I'm sure there will be objections. I'd say the world moves forward

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2012 06:55, Kjell Rilbe wrote: 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 old version of FB. Completely agreed. Adriano

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2012 16:01, Leyne, Sean wrote: This is why BroadView hasn't made the move from Dialect 1. The numeric rules imposed by Dialect 3 would have required a huge amount of re-coding and testing to ensure that our calculations/reports generated the expected results. BTW, unless I have

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Adriano dos Santos Fernandes
On 06/03/2012 16:37, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] FLAG_EMBEDDED

2012-03-10 Thread Adriano dos Santos Fernandes
On 10-03-2012 11:05, Dmitry Yemanov wrote: Elegant, but for this task, I just can test the original condition in the second place and avoid a flag that doesn't have presence in any other place of the code. I mean, if (in_msg_type != MAX_USHORT) { request-execute(...); } What am I

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Adriano dos Santos Fernandes
On 07-04-2012 12:02, Dimitry Sibiryakov wrote: Hello, All. How in external DDL trigger get context variables, such as OBJECT_NAME and SQL_TEXT? From the const IRoutineMetadata* metadata parameter of makeTrigger... But note, triggers wasn't adapted for the new scheme of messages

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Adriano dos Santos Fernandes
On 07-04-2012 12:29, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Adriano dos Santos Fernandes
On 07-04-2012 16:14, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Adriano dos Santos Fernandes
On 07-04-2012 18:03, Dimitry Sibiryakov wrote: 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. Why not? You must be able to receive the blob

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Adriano dos Santos Fernandes
On 07-04-2012 18:50, Adriano dos Santos Fernandes wrote: On 07-04-2012 18:39, Dimitry Sibiryakov wrote: 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

Re: [Firebird-devel] External DDL triggers

2012-04-07 Thread Adriano dos Santos Fernandes
On 07-04-2012 18:54, Dimitry Sibiryakov wrote: 07.04.2012 23:50, Adriano dos Santos Fernandes wrote: This function is a client-function that does its works running other functions. This function is not part of the provider API, and currently don't work with new API objects. So, how can

[Firebird-devel] BTYACC non-terminal types

2012-04-11 Thread Adriano dos Santos Fernandes
The BTYACC %type(s) has been a PITA to maintain. You have to switch between file places which makes things very sad to maintain. I propose this syntax change using small sed script (attached with some examples) Then each type will be directly set on the rule. So instead of: %type int32Val

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

2012-04-12 Thread Adriano dos Santos Fernandes
On 12/04/2012 08:36, Dmitry Yemanov wrote: 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. It's also used in make_all.bat to generate ibase.h. If we anyway

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

2012-04-12 Thread Adriano dos Santos Fernandes
On 12/04/2012 14:46, Dmitry Yemanov wrote: 12.04.2012 18:44, Adriano dos Santos Fernandes wrote: It's also used in make_all.bat to generate ibase.h. OK, this makes it less of a problem. Let's say it turns out to be a bad idea... We will loose nothing. We'd then regenerate it and commit

Re: [Firebird-devel] Backport CORE-2697

2012-04-18 Thread Adriano dos Santos Fernandes
On 18/04/2012 14:12, Mark Rotteveel wrote: I was just looking at an old ticket for Jaybird (JDBC-94) which is actually caused by a bug / deficiency in Firebird (see CORE-2697). This was fixed for Firebird 3.0 in 2009. I was wondering if this fix can also be backported to Firebird 2.5? Looks

Re: [Firebird-devel] CORE-3829

2012-05-09 Thread Adriano dos Santos Fernandes
It's a duplicate problem of CORE-3611. I commented in that ticket: I'm fixing this only in 3.0 cause I'm not very sure of unintended regressions. Anyone could review the fix? Patch for 2.5 is attached. Adriano diff --git a/src/dsql/pass1.cpp b/src/dsql/pass1.cpp index fa6d6eb..c948c1d

  1   2   3   4   5   6   7   8   9   10   >