[Firebird-devel] Firebird 3.0 Release Candidate 1 is available for testing

2015-11-09 Thread Dmitry Yemanov
page: http://www.firebirdsql.org/en/firebird-3-0-0-rc1/ Release Notes: http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_RC1-ReleaseNotes.pdf -- Dmitry Yemanov -- Presto, an open source distributed SQL qu

[Firebird-devel] [FB-Tracker] Created: (CORE-4982) Server crashes during "select from procedure" if exception is thrown while backing out the current savepoint

2015-10-29 Thread Dmitry Yemanov (JIRA)
URL: http://tracker.firebirdsql.org/browse/CORE-4982 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2, 2.5.4, 2.5.3 Update 1, 2.1.7, 3.0 Beta 1, 2.5.3, 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Reporter: Dmit

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4982) Server crashes during "select from procedure" if exception is thrown while backing out the current savepoint

2015-10-29 Thread Dmitry Yemanov
29.10.2015 14:00, Dimitry Sibiryakov wrote: > Do you have testcase? Yes: /qa/oltp-emul/ ;-) > I wonder if Avalerion where savepoint backout was completely reworked is > affected too. If it can throw from inside VIO_verb_cleanup(), then it is. Dmitry

Re: [Firebird-devel] Firebird 2.5.4 - Trace API - CREATE TRIGGER not captured including RDB$GET_CONTEXT

2015-10-20 Thread Dmitry Yemanov
20.10.2015 18:37, Alex Peshkoff wrote: > Thomas, please add an item to the tracker with this sample. > IMHO filter should not be applied to the whole body of a trigger, only > to it's name. AFAIK, filters are applied to the whole SQL text and this is by design. I don't see why DDL statements

Re: [Firebird-devel] Firebird 3 - Embedded deployment - Secure database login

2015-10-19 Thread Dmitry Yemanov
20.10.2015 00:18, Thomas Steinmaurer wrote: > > with Firebird 3, what are the capabilities to disallow unwanted users to > open my database? > > I thought perhaps preparing a database pointing to itself as security > database might be an option (MON$DATABASE.MON$SEC_DATABASE=Self), but > this

Re: [Firebird-devel] -m switch

2015-10-15 Thread Dmitry Yemanov
15.10.2015 09:21, Helen Borrie wrote: > > Where is this? It's not in Fb3 Beta2 config file... Current trunk. It was changed between Beta 2 and RC1. Dmitry -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] -m switch

2015-10-15 Thread Dmitry Yemanov
15.10.2015 10:01, Helen Borrie wrote: > > When can we expect to get snapshots? Currently the Windows snapshots > are just the Examples sub-tree or, in the case of the PDB kits, just > fbclient and engine12 dlls. They were OK a fews days back. Maybe the build became broken, I will verify in a

Re: [Firebird-devel] -m switch

2015-10-15 Thread Dmitry Yemanov
15.10.2015 10:16, Dmitry Yemanov wrote: > >> When can we expect to get snapshots? Currently the Windows snapshots >> are just the Examples sub-tree or, in the case of the PDB kits, just >> fbclient and engine12 dlls. > > They were OK a fews days back. Maybe

Re: [Firebird-devel] -m switch

2015-10-14 Thread Dmitry Yemanov
14.10.2015 15:02, Dimitry Sibiryakov wrote: > > Since operation mode is now configured in config file, does firebird.exe > still require > -m switch to be multi-threaded? No. Dmitry -- Firebird-Devel mailing list,

Re: [Firebird-devel] -m switch

2015-10-14 Thread Dmitry Yemanov
15.10.2015 04:43, Helen Borrie wrote: > > Classic & Superclassic: SharedCache=0, SharedDatabase=1 > So - what configuration parameter distinguishes Superclassic from > Classic? # # Settings for Architecture Configuration # # #

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Dmitry Yemanov
09.10.2015 19:11, Paul Vinkenoog wrote: > > So all in all, it's probably best to keep it as you have it now: 'Use of > external file at location /path/to/filename.ext is not allowed by server > configuration' This gets my vote. Dmitry

Re: [Firebird-devel] CORE-4881

2015-09-21 Thread Dmitry Yemanov
21.09.2015 09:08, Simonov Denis wrote: >> 1. Can a string literal really be 64Kb if, internally, it is converted >> to varchar? Yes, it can. Internally our varchars allow strings up to 64KB, but this is not always respected in other layers, hence the official limit of 32KB (for the safety

Re: [Firebird-devel] CORE-4881

2015-09-21 Thread Dmitry Yemanov
21.09.2015 12:33, Dimitry Sibiryakov wrote: >> but presumably the xsqlda can carry them? > > Currently - not because XSQLVAR.sqllen is a signed short int. And AFAIU nobody promised it could. "Cannot be assigned to anything but a blob" includes the output message/parameter, i.e. such a literal

Re: [Firebird-devel] Firebird 3.0 GDS32.dll compatibility

2015-09-17 Thread Dmitry Yemanov
17.09.2015 11:13, Virgo Pärna wrote: > I tried to test Firebird 3.0 with older software and I discovered, that > GDS32.DLL generated from Firebird 3.0 beta 2 does not work correctly > with programs using BDE INTRBASE drivers to connect to Firebird server > (both Firebird 2.5.4 server and Firebird

Re: [Firebird-devel] instsvc and ServerMode

2015-09-17 Thread Dmitry Yemanov
17.09.2015 17:38, Paul Reeves wrote: > Out of interest - why do you think the cpl applet must die? Because most users don't use it. And those who rarely do (newbies, I suppose) spam our tracker with "not working in Win7", "not working in Win8", now probably "not working in Win10" ;-)

Re: [Firebird-devel] instsvc and ServerMode

2015-09-17 Thread Dmitry Yemanov
17.09.2015 16:51, Paul Reeves wrote: > > I'm wondering what to do about instsvc and ServerMode on windows. Previously > instsvc was able to switch between the different architectures because all it > had to do was update the registry with the name of the relevant executable > and add the -m switch

Re: [Firebird-devel] firebird.msg

2015-09-16 Thread Dmitry Yemanov
16.09.2015 12:04, Paul Reeves пишет: > > I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be around > 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta releases of Fb > 3 it is also around 150Mb. You surely meant KB, not MB ;-) Just checked the last (tonight's)

Re: [Firebird-devel] 2.5.5 release

2015-09-11 Thread Dmitry Yemanov
11.09.2015 11:25, Jiří Činčura wrote: > > is there some ETA for 2.5.5? I'm hitting CORE-4759 in last few days. Within a month. v3 RC1 is of a top priority, v2.5.5 will follow right after. Dmitry -- Firebird-Devel

Re: [Firebird-devel] Firebird database on virtual file system

2015-08-31 Thread Dmitry Yemanov
31.08.2015 19:49, Геннадий Забула wrote: > Maybe I put it wrong. > I want to use firebird database file that itself embedded to an image > of a filesystem. Let's assume that I already have a parser for images. > I don't get it about extraction tables to file system and SQLite. > Maybe this link

Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Dmitry Yemanov
21.08.2015 14:05, Jiří Činčura wrote: Is there a way to somewhat get a number of connections to given database that's always (or in some predefined interval, known in advance) up to date? Selecting from mon$attachments gets sometimes stale data even after few seconds. Maybe there's some

Re: [Firebird-devel] Accessing log file via service_mgr

2015-08-19 Thread Dmitry Yemanov
19.08.2015 16:09, Jiří Činčura wrote: When accessing log file via service_mgr and the log file is not there (as it's normal after fresh installation) Firebird returns operating system directive fopen failed. Shouldn't it just create an new file and return empty string? I may agree that

Re: [Firebird-devel] Accessing log file via service_mgr

2015-08-19 Thread Dmitry Yemanov
19.08.2015 20:39, Jiří Činčura wrote: As for me I prefer existing behavior - if file is missing it should better be reported. Then I believe the installer and zip packages should contain already this file. Empty. Then when the file is really not there, we can claim it's missing. This

Re: [Firebird-devel] Accessing log file via service_mgr

2015-08-19 Thread Dmitry Yemanov
19.08.2015 19:51, Alex Peshkoff wrote: As for me I prefer existing behavior - if file is missing it should better be reported. Why? Missing log file is not an error from the Firebird POV. In the ideal world it may even be the expected thing (no error happened since the beginning of time).

Re: [Firebird-devel] SQLSTATE difference between server and embedded

2015-08-18 Thread Dmitry Yemanov
18.08.2015 12:24, Jiří Činčura wrote: When I'm trying to get SQLSTATE in case of error I find isc_arg_sql_state (if any) and I read the string. That works fine for server. For embedded the isc_arg_sql_state is there, but the string is null. Is that expected behavior of embedded? No, it's

Re: [Firebird-devel] SQLSTATE difference between server and embedded

2015-08-18 Thread Dmitry Yemanov
18.08.2015 19:36, Геннадий Забула wrote: fb_sqlstate() returns expected string. What is expected string? Looking at the code I'd say it cannot return anything better than HY000. Dmitry -- Firebird-Devel mailing

Re: [Firebird-devel] Location of null-vector of row data

2015-08-01 Thread Dmitry Yemanov
01.08.2015 12:23, Mark Rotteveel wrote: I am reviewing the pull request https://github.com/FirebirdSQL/jaybird/pull/3 I am trying to find where in the Firebird code the null-vector for the rowdata (on fetch or execute) is used to see if it is big or little endian, but I can't seem to find

Re: [Firebird-devel] Location of null-vector of row data

2015-08-01 Thread Dmitry Yemanov
01.08.2015 12:31, Mark Rotteveel wrote: By the looks of it is little endian, right (or at least: the equivalent of http://docs.oracle.com/javase/8/docs/api/java/util/BitSet.html#valueOf-byte:A- )? Yes, looks perfectly matching BitSet.valueOf(byte[]). Dmitry

Re: [Firebird-devel] Insecure hashing and encryption in Firebird 3

2015-07-28 Thread Dmitry Yemanov
27.07.2015 17:07, Jim Starkey wrote: Question: Does Firebird detect, report, and shutdown repetitive attacks on passwords? Yes, it does (in single-process architectures). Dmitry -- Firebird-Devel mailing list, web

Re: [Firebird-devel] Parsing fbtrace.conf

2015-07-28 Thread Dmitry Yemanov
28.07.2015 20:12, Paul Reeves wrote: Of course, there is another related question - what is the correct behaviour? I know a lot of config file parsers are written to parse to the end and whichever values are set last are the values used. For example postfix is specifically designed to allow

Re: [Firebird-devel] Preventing error code collision

2015-07-25 Thread Dmitry Yemanov
25.07.2015 15:16, Vlad Khorsun wrote: To prevent collisions with future error codes in Firebird, I'd like to know if using codes below 3 would be sufficient to prevent collision, or would it be better to follow the same formal rules as used inside Firebird to generate error codes (eg

Re: [Firebird-devel] Maximum length of string literals

2015-07-16 Thread Dmitry Yemanov
15.07.2015 19:03, Adriano dos Santos Fernandes wrote: Looking again, Ivan Přenosil may be right and string literals up to 64K byte-length *may* be safe, as descriptors uses USHORT and internal calculations ULONG. At the same time, columns, parameters and everything else should be

Re: [Firebird-devel] Firebird 3, execution modes

2015-07-15 Thread Dmitry Yemanov
15.07.2015 12:41, Alex Peshkoff wrote: On 07/15/2015 12:20 AM, Claudio Valderrama C. wrote: same as the strange need of using sysdba to add sysdba to complete the command: gsec -add sysdba -pw masterkey -user sysdba Alex may say that one sysdba is the embedded admin and the other is the

Re: [Firebird-devel] windows installer and authentication

2015-07-14 Thread Dmitry Yemanov
13.07.2015 16:07, Paul Reeves wrote: Obviously I am missing something huge here - if we don't provide legacy authentication how and where do we create sysdba? The same way (gsec?) and the same location (security3.fdb). Just use the Srp plugin instead of LegacyAuth. Dmitry

Re: [Firebird-devel] Problems with fresh install and gsec

2015-07-12 Thread Dmitry Yemanov
12.07.2015 04:19, Carlos H. Cantu wrote: Ok, I tried it with lastest snapshot. It works if I start firebird.exe with -a, but it fails if I start it with -a -m: It should be run with Firebird being *not started*. Dmitry

Re: [Firebird-devel] Problems with fresh install and gsec

2015-07-11 Thread Dmitry Yemanov
12.07.2015 00:08, Carlos H. Cantu wrote: I'm trying to test FB 3 Beta2... using the zip-kit and also the installer of Beta2, since both gave me problems due to missing \programdata\firebird directory. This was already fixed. GSEC add sysdba -pw masterkey An error occurred while attempting

Re: [Firebird-devel] Firebird 3 problem with inserting string to blob

2015-07-07 Thread Dmitry Yemanov
08.07.2015 00:09, Ivan Přenosil wrote: In FB2, FB2.5, FB3-Beta1, FB3-31661 it was possible to directly insert 50k long text into blob field: CREATE TABLE Tab (B BLOB SUB_TYPE TEXT); INSERT INTO Tab (B) VALUES (' ... 50k ...'); However, in FB3-Beta2 and latest snapshot FB3-31925 it raises

Re: [Firebird-devel] 3.0 Beta 2 absent fbembed.dll

2015-07-07 Thread Dmitry Yemanov
07.07.2015 12:51, Геннадий Забула wrote: There is no embedded version of a firebird server in the Beta 2 packages (x86|x64). Will it be added in RC? Or it's support is discontinued? Please read the release notes carefully. Former fbembed.dll is now replaced with fbclient.dll + engine12.dll.

[Firebird-devel] Firebird 3.0 Beta 2 release is available for testing

2015-07-03 Thread Dmitry Yemanov
://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Beta2-ReleaseNotes.pdf -- Dmitry Yemanov -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Dmitry Yemanov
01.07.2015 13:49, Vlad Khorsun wrote: Not sure what you mean by same? Let's say I change it from smallint to int. All kind of numbers have the same representation in index keys. Except BIGINT, IIRC. Dmitry --

Re: [Firebird-devel] employee db build broken

2015-07-01 Thread Dmitry Yemanov
24.06.2015 11:50, Paul Reeves wrote: The 64-bit windows build of the employee db is broken. Can you confirm that the issue is gone now? Dmitry -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud

Re: [Firebird-devel] Differences between triggers

2015-06-28 Thread Dmitry Yemanov
Helen, This question makes me curious as to whether INSERT OR UPDATE and UPDATE OR INSERT are actually processed in exactly the same way, or does the order affect the execution logic? i.e., if INSERT is the first operator, does the engine attempt INSERT and perform UPDATE if the key is

Re: [Firebird-devel] Regular Expression Library

2015-06-11 Thread Dmitry Yemanov
10.06.2015 21:03, Adriano dos Santos Fernandes wrote: At a first look, boost.regex is the library who can do it. It's templatized and works with iterators and traits for customization. It has integration with ICU and MFC strings, so this is useful to understand how to customize it. Is it

Re: [Firebird-devel] Problem with MERGE

2015-06-10 Thread Dmitry Yemanov
10.06.2015 23:28, Claudio Valderrama C. wrote: I would like to be able to know that I'm dealing with MERGE or any other statement that can lead to an update and/or insert. Adding inserts+updates+deletes is not a problem (indeed, it's simpler code), but it's a departure of the traditional

Re: [Firebird-devel] Problem with MERGE

2015-06-09 Thread Dmitry Yemanov
09.06.2015 13:11, Dimitry Sibiryakov wrote: ISQL would better always report Rows affected as a sum of all three components of info response: inserts+updates+deletes. Sounds as a good short-term solution. Does anyone see problems with this approach? Dmitry

Re: [Firebird-devel] Problem with MERGE

2015-06-09 Thread Dmitry Yemanov
09.06.2015 07:13, Claudio Valderrama C. wrote: Ideas? We could add a new info tag to return the internal ROWS_AFFECTED value, so that ISQL would not need to rely on separate I/U/D counters. Given that ISQL already uses the new API, maybe we could even surface such an info request directly

Re: [Firebird-devel] Problem with MERGE

2015-06-09 Thread Dmitry Yemanov
09.06.2015 15:23, Simonov Denis wrote: We could add a new info tag to return the internal ROWS_AFFECTED value, so that ISQL would not need to rely on separate I/U/D counters. Then also add context variables to obtain these counters Any good example why you would need them in PSQL? Dmitry

Re: [Firebird-devel] Plan natrual is this related to CORE-4809?

2015-06-01 Thread Dmitry Yemanov
01.06.2015 12:22, liviuslivius wrote: i do not know if this is related to CORE-4809 or should i report this as new ticket in tracker? for query SELECT * FROM RDB$RELATION_FIELDS RF left join RDB$RELATIONS R on R.RDB$FIELD_ID+0 = RF.RDB$FIELD_POSITION WHERE

Re: [Firebird-devel] Plan natrual is this related to CORE-4809?

2015-06-01 Thread Dmitry Yemanov
01.06.2015 12:48, liviuslivius wrote: This is somewhere in tracker or this should not go to the tracker? Feel free to add a ticket. And when this is planned to be supported - in FB3 Beta 2 or after FB3 release? Not in Beta 2 for sure. Dmitry

Re: [Firebird-devel] Moving Jaybird auto-commit implementation into Firebird

2015-05-31 Thread Dmitry Yemanov
31.05.2015 12:33, Dimitry Sibiryakov wrote: Prepared statements are not bound to a transaction, they (and I believe their existence locks) exists till explicitly unprepared/freed or connection ends. Existence locks are bound to *both* statement and transaction lifetime. Dmitry

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:53, Mark Rotteveel wrote: I'd also like to know when isc_tpb_autocommit was introduced. Somewhen before Firebird was created. Dmitry -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:29, Mark Rotteveel wrote: To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? I'm not aware of any place. I'd especially like to know at which point the commit is executed, and

Re: [Firebird-devel] Windows snapshot builds corrupted

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:42, Mark Rotteveel wrote: I just tried to download http://web.firebirdsql.org/download/snapshot_builds/win/3.0/Firebird-3.0.0.31845-0_x64.7z and the archive is only 3 MB (previous snapshot I downloaded was 7 MB). Unpacking gives an error that archive is corrupted. Another

Re: [Firebird-devel] Moving Jaybird auto-commit implementation into Firebird

2015-05-30 Thread Dmitry Yemanov
29.05.2015 17:10, Maxim Smyatkin wrote: - we create a procedure P using a table T. - the P states its interest in the T (while looking for P's dependencies); - transaction commits the changes with retaining flag and forgets to say that it isn't interested in the T anymore; Externally (for

Re: [Firebird-devel] Resolved: (CORE-4760) Can not create user with non-ascii (multi-byte) characters in it's name

2015-05-06 Thread Dmitry Yemanov
Alex et al, I didn't follow all the details of this discussion, but this is how I see the things: 1) I don't think non-ASCII user/role names ever worked reliably and we never recommended using them. So if someone used them, they should be prepared for troubles. And this is OK (more or less)

Re: [Firebird-devel] Semantics of field [NOT] NULL flag based on domains

2015-03-31 Thread Dmitry Yemanov
31.03.2015 13:41, Alex Peshkoff wrote: According to SQL specification: Let C be a column of a base table T. C is known not nullable if and only if _at least one_ of the following is true: some conditions — C is based on a domain that has a domain constraint that is not deferrable and

Re: [Firebird-devel] Semantics of field [NOT] NULL flag based on domains

2015-03-31 Thread Dmitry Yemanov
31.03.2015 07:20, Adriano dos Santos Fernandes wrote: Currently there is inconsistencies in fields [NOT] NULL flag on its (field) flag does not matches the domain. Use CONNECT or CREATE DATABASE to specify a database SQL create database 'z.fdb'; SQL create domain d1n integer not null; SQL

Re: [Firebird-devel] Retrieving plan using new mon$explained_plan field (FB3 beta )

2015-03-18 Thread Dmitry Yemanov
18.03.2015 22:37, Robbert-Jan wrote: If I execute this scenario (using FlameRobin and WI-T3.0.0.31369 Firebird 3.0 Beta 1): - start transaction - execute query 1: SELECT * FROM Table1 - execute query 2: SELECT * FROM Table2 - execute query 3: SELECT * FROM Table3 - execute query 4: SELECT

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Dmitry Yemanov
17.03.2015 23:08, liviusliv...@poczta.onet.pl wrote: iValue integer not null, sValue Smallint not null, iValue2 integer not null, iValue3 integer not null ($CC, $BB, $AA, $11, 0, 0, $DD, $33, 0, 0, 0, 0, $DD, $CC, $BB, $22, 0, 0, 0, 0, $DD, $CC, $BB, $22, 0, 0, 0, 0, 0,

Re: [Firebird-devel] Firebird 3 snapshot not contain Employee.fdb and more..

2015-03-16 Thread Dmitry Yemanov
16.03.2015 10:58, liviuslivius wrote: snapshot of Firebird3 not conatain employee.fdb and also full script for it IIRC, it was temporarily disabled one day due to Windows build issues and supposedly forgotten to be enabled back. I will check. Dmitry

Re: [Firebird-devel] Explained plan limited size also in MON$STATEMENTS?

2015-03-14 Thread Dmitry Yemanov
14.03.2015 02:03, liviusliv...@poczta.onet.pl wrote: I read that to get unlimited text of explained plan i should look into TMP$STATEMENTS but i got limited text in MON$EXPLAINED_PLAN in MON$STATEMENTS for some big query it end after 14 808 bytes as Select Expression - nothing more

Re: [Firebird-devel] Retrieving plan using new mon$explained_plan field (FB3 beta )

2015-03-14 Thread Dmitry Yemanov
14.03.2015 15:38, Robbert-Jan wrote: I’m trying to retrieve the explain plan of the last prepared query, using the mon$explained_plan field, introduced in FB3 beta. I used: SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id = CURRENT_TRANSACTION Wrong. You should use

Re: [Firebird-devel] Explained plan Range Scan difference between partial match and lower/upper bound

2015-03-12 Thread Dmitry Yemanov
12.03.2015 16:13, liviuslivius wrote: i only have question with this: CREATE TABLE XXX ( A INTEGER, B INTEGER, C INTEGER, D INTEGER, E INTEGER ); CREATE INDEX IXA_XXX__ALL ON XXX(A, B, C, D, E); SELECT * FROM XXX X WHERE X.A=5 AND X.B=6 AND X.C6

Re: [Firebird-devel] Explained plan Range Scan difference between partial match and lower/upper bound

2015-03-12 Thread Dmitry Yemanov
12.03.2015 17:37, liviuslivius wrote: SELECT * FROM XXX X WHERE X.A = 12 AND X.B = 1 ORDER BY X.A, X.B, X.C, X.D, X.E PLAN (X ORDER IXA_XXX__ALL) Select Expression - Filter - Table XXX as X Access By ID - Index IXA_XXX__ALL Range

Re: [Firebird-devel] Explained plan Range Scan difference between partial match and lower/upper bound

2015-03-12 Thread Dmitry Yemanov
12.03.2015 15:13, liviuslivius wrote: is possible to extend this to show Range Scan (lower bound: 1/1, upper bound: 1/1) + (partial match: 1/2) like Range Scan (partial match: 1/2, lower bound: 1/1, upper bound: 1/1) e.g. compound index CREATE INDEX INDEX_NAME AAA ON XXX(A, B);

Re: [Firebird-devel] Release date for 2.5.4

2015-03-11 Thread Dmitry Yemanov
11.03.2015 23:32, Rudolf Grauberger wrote: there is already a rough plan when the 2.5.4 version to be published? This month. Dmitry -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Dmitry Yemanov
10.03.2015 15:56, Omacht András wrote: why do you need several working directory? Using git is very cheap to switch between branches, it is not necessary to make local copies. I don't see much sense to create a branch every time I have an idea to play with. Maybe a half of them end nowhere,

Re: [Firebird-devel] Commits visible in our main page.

2015-03-10 Thread Dmitry Yemanov
10.03.2015 15:30, Michal Kubecek wrote: However, there is seldom need for multiple working directories. Right now I have five working directories for the same B2_5_Release branch, each with different uncommitted changes. I don't see how it can be avoided. Dmitry

Re: [Firebird-devel] Explained plan Access By ID

2015-03-09 Thread Dmitry Yemanov
09.03.2015 14:13, liviuslivius wrote: what is Access By ID in explained plan? Why ID? - Filter - Table ZLEC_FAKT as ZF Access By ID ID = internal record identifier (number). Better publicly known as DBKEY, although DBKEY is actually a wider term, as it includes

Re: [Firebird-devel] Explained plan Range Scan difference between partial match and lower/upper bound

2015-03-09 Thread Dmitry Yemanov
09.03.2015 17:06, liviuslivius wrote: what is the difference between Index ROZLICZENIE_FK1 Range Scan (lower bound: 1/1, upper bound: 1/1) When you see lower/upper bound: N/M, this is a less/greater/between scan. Each boundary condition may use N of M segments. Index RODZAJ_DZIAL_FK Range

Re: [Firebird-devel] Commits visible in our main page.

2015-03-05 Thread Dmitry Yemanov
05.03.2015 23:53, Claudio Valderrama C. wrote: People, maybe you're going to say that this would be ugly, but at www.firebirdsql.org after the PROJECT NEWS I would like to see information about latest commits, maybe this whole page inside a frame:

Re: [Firebird-devel] Time to update our headers.

2015-03-05 Thread Dmitry Yemanov
05.03.2015 15:38, marius adrian popa wrote: Ok understand, what i ask is that new code to be under MPL 2.0 What is our benefit? This will simplify the license understanding Nope, it will only complicate understanding. Old modules have to remain IPLed/IDPLed, so actually we'll be claiming

Re: [Firebird-devel] Time to update our headers.

2015-03-05 Thread Dmitry Yemanov
05.03.2015 18:03, Dimitry Sibiryakov wrote: I just wonder why this product is on third-party site instead of firebirdsql.org. Huh? http://www.firebirdsql.org/en/initial-developer-s-public-license-version-1-0 Dmitry

[Firebird-devel] [FB-Tracker] Created: (CORE-4704) Generator/exception permissions get corrupted after backup/restore

2015-03-04 Thread Dmitry Yemanov (JIRA)
Components: GBAK Affects Versions: 3.0 Beta 1, 3.0 Alpha 2, 3.0 Alpha 1 Reporter: Dmitry Yemanov USAGE permissions granted to generators and/or exceptions can be lost after backup/restore, their appropriate ACLs appear to be reused by some other objects (e.g. tables

Re: [Firebird-devel] READ UNCOMMITTED implementation

2015-03-04 Thread Dmitry Yemanov
04.03.2015 10:12, marius adrian popa wrote: Seems that we need F111-01 implemented https://github.com/rowland/fb/issues/42 Over my dead body. Dmitry -- Dive into the World of Parallel Programming The Go Parallel

Re: [Firebird-devel] Proposal of new feature: Event triggers

2015-02-26 Thread Dmitry Yemanov
26.02.2015 18:03, Dimitry Sibiryakov wrote: IIRC, tests by Pavel Zotov shown that using of context variables is, actually, slower that reading from a single row table. Wrong, at least for FB3. Dmitry -- Dive into

Re: [Firebird-devel] Proposal of new feature: Event triggers

2015-02-26 Thread Dmitry Yemanov
26.02.2015 16:55, Adriano dos Santos Fernandes wrote: For example, there is example UDR who waits for an event, blocking the calling. I don't think Carlos wants to block the caller. Also, if the caller dies, notifications will be lost until someone notices that and reconnects and restarts

Re: [Firebird-devel] Proposal of new feature: Event triggers

2015-02-26 Thread Dmitry Yemanov
26.02.2015 17:18, Carlos H. Cantu wrote: When any user changes some sensitive config data, I would like that all the attachments to refresh its session context variables, to reflect the new values. How fast do you need them to refresh? Immediately is a wrong asnwer, as events are

Re: [Firebird-devel] Provider objects has different semantics than y-valve objects

2015-02-25 Thread Dmitry Yemanov
23.02.2015 13:36, Vlad Khorsun wrote: A solution must be to pass a parameter to destroy methods specifying if they should release or not the object. Must be ? I don't think so. I'm not ready to point to correct solution right now, but additional parameter is not a solution, as for me. I

Re: [Firebird-devel] create sequence options

2015-02-25 Thread Dmitry Yemanov
25.02.2015 18:55, Dimitry Sibiryakov wrote: Are options for CREATE/ALTER SEQUENCE clause have to be position-fixed by standard or it is allowed to write CREATE SEQUENCE aaa INCREMENT BY 222 START WITH 666? The standard allows flexible positioning of the clauses. Dmitry

Re: [Firebird-devel] Recore level compresion imroovement

2015-02-22 Thread Dmitry Yemanov
22.02.2015 20:19, Slavomir Skopalik wrote: I was made litle improovement in record level compresion. Motivation: - significant dabase grow increase after switch to UTF8 Analysis: - I was found inefficient algoritmus for compressing zeroes - I was found, that some control char values are

Re: [Firebird-devel] Possible response on the asynchronous port (event connection)

2015-02-22 Thread Dmitry Yemanov
22.02.2015 15:10, Mark Rotteveel wrote: I am reimplementing the event handling in Jaybird, and the current (old) implementation on the asynchronous port (event connection) processes the operations: op_dummy, op_exit, op_disconnect, op_event and op_response I'd like to know two things: 1)

Re: [Firebird-devel] FB3 snapshots on Windows are not builded.

2015-02-15 Thread Dmitry Yemanov
15.02.2015 11:03, liviusliv...@poczta.onet.pl wrote: Today the same - only examples in Firebird-3.0.0.31644-0_x64.7z Fixed now, thanks. Dmitry -- Dive into the World of Parallel Programming. The Go Parallel

Re: [Firebird-devel] Inconsistent exception handling

2015-02-07 Thread Dmitry Yemanov
07.02.2015 13:27, Alex Peshkoff wrote: I.e. if we decide to go this way we should do this with all catch blocks which is a change not differing much in volume of changes from changing tdbb_status_vector to something capable to store unlimited length vectors. True. But I don't suggest to do

Re: [Firebird-devel] Inconsistent exception handling

2015-02-07 Thread Dmitry Yemanov
07.02.2015 13:27, Alex Peshkoff wrote: I do not see too big trouble with full checks of string args. But what about keeping legacy dup check present in ERR_post()? Taking into an account that string once made permanent will remain the same per thread suppose it will be enough for most cases.

[Firebird-devel] Inconsistent exception handling

2015-02-06 Thread Dmitry Yemanov
All, Historically, exception handling looked this way at the JRD level: try { tdbb-tdbb_status_vector = user_status; } catch (const Exception ex) { return error(user_status); } Errors were raised via ERR_post() which *appends* to tdbb_status_vector and then throws. Errors were reposted

Re: [Firebird-devel] FB3 snapshots on Windows are not builded.

2015-02-04 Thread Dmitry Yemanov
04.02.2015 13:36, Dmitry Yemanov wrote: FB3 snapshots on Windows are not builded. The archives at http://web.firebirdsql.org/download/snapshot_builds/win/3.0/ only examples without binaries. Fixed now. Dmitry

Re: [Firebird-devel] FB3 snapshots on Windows are not builded.

2015-02-04 Thread Dmitry Yemanov
04.02.2015 12:37, Simonov Denis wrote: FB3 snapshots on Windows are not builded. The archives at http://web.firebirdsql.org/download/snapshot_builds/win/3.0/ only examples without binaries. Windows builds are broken. I've removed the invalid snapshot builds from the download area. Dmitry

Re: [Firebird-devel] 255 contexts limit

2015-02-01 Thread Dmitry Yemanov
01.02.2015 18:58, liviusliv...@poczta.onet.pl пишет: Is some plan for extend this? Not in v3. Dmitry -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in

Re: [Firebird-devel] 255 contexts limit

2015-01-31 Thread Dmitry Yemanov
01.02.2015 02:08, liviusliv...@poczta.onet.pl пишет: max 255 contexts allowed like in select: select (select field from XXX where ...), (select field from XXX where ...), (select field from XXX where ...), (select field from XXX where ...), (select field from XXX where

Re: [Firebird-devel] [PATCH] Casting errors

2014-12-22 Thread Dmitry Yemanov
22.12.2014 11:26, Alexey Pavlov wrote: ping? Applied, but I cannot validate compilation at the moment. Dmitry -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge

Re: [Firebird-devel] [PATCH] Cobol interface

2014-12-19 Thread Dmitry Yemanov
19.12.2014 11:34, Alexpux wrote: Looking into Cobol module I see there are lot of this such things. Also maybe need there replace deprecated procedures like «isc_interprete». IIRC, Cobol support exists for 32-bits only, so all these issues are just annoying warnings that never appear in

Re: [Firebird-devel] [PATCH] Cobol interface

2014-12-19 Thread Dmitry Yemanov
19.12.2014 10:05, Alexpux wrote: Next patch works for me. Applied. Dmitry -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards

Re: [Firebird-devel] [PATCH] Cobol interface

2014-12-17 Thread Dmitry Yemanov
18.12.2014 10:47, Alexey Pavlov wrote: -*(ISC_ULONG *)arg_vector[-1].a_address = (ISC_ULONG)p; - +*(uintptr_t *)arg_vector[-1].a_address = (uintptr_t)p; So far our practice is to favor FB-specific typedefs instead of system ones. U_IPTR should be used here instead of uintptr_t. Dmitry

Re: [Firebird-devel] Fixing database to use it with changed ICU version.

2014-12-11 Thread Dmitry Yemanov
11.12.2014 15:32, Alex Peshkoff wrote: I've almost finished with SQL command fixing database to make it usable with ICU version not matching one with which database was created. This helps in a cases like one described in http://tracker.firebirdsql.org/browse/CORE-4571 . With mentioned

Re: [Firebird-devel] Fixing database to use it with changed ICU version.

2014-12-11 Thread Dmitry Yemanov
11.12.2014 16:39, Alex Peshkoff wrote: I like ALTER DATABASE RESET ICU or even ALTER DATABASE RESET INTERNATIONAL IMHO it's no big use explicitly setting VERSION here What string do you mean here - no idea. [VERSION] string meant to explicitly specify ICU version to use (from multiple

Re: [Firebird-devel] Fixing database to use it with changed ICU version.

2014-12-11 Thread Dmitry Yemanov
11.12.2014 17:42, Alex Peshkoff wrote: Have you ever seen in gstat -h? :) BTW, is it really about database creation? IIRC, ICU version is stored in collation specific attributes. If one creates one ICU collation, then upgrade ICU and create another collation - wouldn't he/she be in the same

Re: [Firebird-devel] Fixing database to use it with changed ICU version.

2014-12-11 Thread Dmitry Yemanov
11.12.2014 18:32, Adriano dos Santos Fernandes wrote: Copy back and forth and rebuilding indexes every time? A database created with incompatible (at least different) ICU version simply cannot be accessed on the other host. This was my experience with FB3 before Beta. I had to ask for a

Re: [Firebird-devel] Tackling CORE-4526 (OFFSET FETCH)

2014-12-09 Thread Dmitry Yemanov
09.12.2014 22:01, Mark Rotteveel wrote: Dmitry, can you resolve the ticket for me? Done. Dmitry -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your

Re: [Firebird-devel] FB3 and .Net provider

2014-12-07 Thread Dmitry Yemanov
07.12.2014 23:17, liviusliv...@poczta.onet.pl wrote: I can connect to FB3 from flamerobin and from Delphi applications. Using which fbclient version? But i can not from .Net from VS 2013 by .Net provider It could be either misconfigured server (ServerAuth) or the same protocol issue as

Re: [Firebird-devel] Wrong version number of Firebird?

2014-12-07 Thread Dmitry Yemanov
08.12.2014 10:26, liviuslivius wrote: what chappened with version number of firebird 3? I have current snapshot (2014-12-08) 3.0.0.25042 and from (2014-10-30) 3.0.0.30703 as you can see older version have bigger version number. The script failed this night. Will be investigated. Dmitry

<    2   3   4   5   6   7   8   9   10   11   >