[Firebird-devel] [FB-Tracker] Created: (CORE-4421) simplify usage of regex for matching, replacing n-th match

2014-05-06 Thread Karol Bieniaszewski (JIRA)
simplify usage of regex for matching, replacing n-th match -- Key: CORE-4421 URL: http://tracker.firebirdsql.org/browse/CORE-4421 Project: Firebird Core Issue Type: New Feature

[Firebird-devel] BUGCHECK 290

2014-05-06 Thread Dimitry Sibiryakov
Hello, All. When EXE_verb_cleanup() re-throw any error as BUGCHECK(290), it loose all information about original error. IMHO, it is not good because it makes diagnostic harder. Should I create a ticket in tracker? -- WBR, SD.

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-06 Thread Dmitry Yemanov
05.05.2014 20:13, Jim Starkey wrote: AFAIR, int64 integers are not converted into double, they're compressed using their native format. If so, it's a bug. The purpose of the index encoding is that all numbers have the same representation, based on actual value rather than declaration. It

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-06 Thread Dimitry Sibiryakov
06.05.2014 10:28, Dmitry Yemanov wrote: Decreasing the scale is allowed and should work fine, AFAIU. Shouldn't it be contrary?.. If in table is value 1.234 and scale is changed from 3 to 2, this value will be displayed as 1.23, but cannot be found by eq. Vice versa it works: value 1.23

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-06 Thread Dmitry Yemanov
06.05.2014 12:35, Dimitry Sibiryakov wrote: Decreasing the scale is allowed and should work fine, AFAIU. Shouldn't it be contrary?.. If in table is value 1.234 and scale is changed from 3 to 2, this value will be displayed as 1.23, but cannot be found by eq. Vice versa it works: value

[Firebird-devel] [FB-Tracker] Reopened: (CORE-2349) False Invalid SQLDA error

2014-05-06 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-2349: Reopened to backport fix into v2.1.6 False Invalid SQLDA error ---

Re: [Firebird-devel] BUGCHECK 290

2014-05-06 Thread Dimitry Sibiryakov
06.05.2014 10:54, Dmitry Yemanov wrote: I believe we don't need a bugcheck there at all. Transaction should be invalidated and the original error rethrown. AFAICS further DML operations are allowed in invalidated transaction. Shouldn't ROLLBACK to be the only permitted action? -- WBR,

[Firebird-devel] Running firebird.exe as application

2014-05-06 Thread Mark Rotteveel
I have been having some problems running Firebird 3 correctly from a zip-kit (as Super Server). After much trial-and-error it looks like when running as an application, that I need to start Firebird.exe with -a -m (instead of only -a as documented in \docs\install_windows_manually.txt). I have

Re: [Firebird-devel] Running firebird.exe as application

2014-05-06 Thread Dimitry Sibiryakov
06.05.2014 20:32, Mark Rotteveel wrote: So: what is the meaning of -m, and why is it necessary? It stand for multi-threaded. Without it firebird.exe works in classic mode and spawn separate processes for each connection. -- WBR, SD.

Re: [Firebird-devel] Running firebird.exe as application

2014-05-06 Thread Dmitry Yemanov
06.05.2014 22:32, Mark Rotteveel wrote: I have been having some problems running Firebird 3 correctly from a zip-kit (as Super Server). After much trial-and-error it looks like when running as an application, that I need to start Firebird.exe with -a -m (instead of only -a as documented in

Re: [Firebird-devel] Running firebird.exe as application

2014-05-06 Thread Mark Rotteveel
On 6-5-2014 20:39, Dmitry Yemanov wrote: I have been unable to find anything regarding the commandline options of firebird.exe and I only thought of -m as it is also added to the commandline of the service executable. So: what is the meaning of -m, and why is it necessary? The same as for

[Firebird-devel] Cleaning up transaction info

2014-05-06 Thread Mark Rotteveel
When Jaybird uses distributed transactions, it adds information on the Xid (the distributed transaction id) in the call to isc_prepare. When the transaction is limbo-ed by destroying the connection, another connection can recover that by performing a reconnect and then either committing or

[Firebird-devel] FYI: Interesting approach to cache management

2014-05-06 Thread Leyne, Sean
All, I was reading details on a recent update to Apache Hadoop engine and one of the changes dealt with a change to their cache algorithm. Hadoop had a cache which used a simple LRU algorithm. As we know most LRU algorithms have the problem that hot pages can be flushed when a query which

Re: [Firebird-devel] FYI: Interesting approach to cache management

2014-05-06 Thread Dimitry Sibiryakov
06.05.2014 23:21, Leyne, Sean wrote: I also know that there has been historical discussion of changing the engine to recognize table scan/NATURAL and backup to modify the cache operation. They weren't just discussion, Firebird already work this way from the beginning. -- WBR, SD.

Re: [Firebird-devel] FYI: Interesting approach to cache management

2014-05-06 Thread Jim Starkey
My original cache management scheme used a weighted LRU where a cache hit would set the high order bit of an aging value in the BDB. Periodic aging cycles would do a right shift of the aging values, ending up with aging values that, to a large degree, represented the historical hit rate. It