[Firebird-devel] ADO.NET provider 5.10.0.0

More info: https://www.tabsoverspaces.com/233641-ado-net-provider-5-10-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing

24.08.2017 23:34, livius wrote: However i see that context limit is "the same" for the single query Is this really plan for Firebird4 or it is postponed? It will be removed in the next Alpha/Beta release. Dmitry --

Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing

Hi, first i must thank you for great work :) I really wait for frame in window funcion, longer indentifiers and bigger database page size. And i test this intensively. However i see that context limit is "the same" for the single query Is this really plan for Firebird4 or it is postponed?

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

>> Here's the plan: >> PLAN HASH (EMTD NATURAL, JOIN (SORT (DR DR NATURAL), EWR INDEX >> (IDX_EWR_SENT_A_TEMP))) > Post a tracker entry to have it fixed. Or create an index for joining. This suggests that the issue is JOINing based on a NATURAL scan of the related table. Correct? {Trying to

[Firebird-devel] [FB-Tracker] Created: (CORE-5598) block size exceeds implementation restriction at JStatement::openCursor

block size exceeds implementation restriction at JStatement::openCursor --- Key: CORE-5598 URL: http://tracker.firebirdsql.org/browse/CORE-5598 Project: Firebird Core Issue

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

> Post a tracker entry to have it fixed. Or create an index for joining. Done http://tracker.firebirdsql.org/browse/CORE-5598. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

Post a tracker entry to have it fixed. Or create an index for joining.Dmitry18:35, 24 августа 2017 г., "Jiří Činčura" : What is the plan? I suspect some hardcoded limit for the hash join  algorithm has been reached. Do you see HASH in the plan?Here's the plan:PLAN HASH (EMTD

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

> What is the plan? I suspect some hardcoded limit for the hash join > algorithm has been reached. Do you see HASH in the plan? Here's the plan: PLAN HASH (EMTD NATURAL, JOIN (SORT (DR DR NATURAL), EWR INDEX (IDX_EWR_SENT_A_TEMP))) Could I somehow confirm it's this? And more importantly how can

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

24.08.2017 17:50, Jiří Činčura wrote: I have a query that on one particular database throws: 2017-08-24T16:29:11.5140 (2704:01620040) ERROR AT JStatement::openCursor I:\DOWNLOADS\BI2.FDB (ATT_16, SYSDBA:NONE, NONE, TCPv6:::1/51084)

Re: [Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

Hmm, if I change the last join to use "on cast(EMTD.F_EMT_VALUE as varchar(377) character set utf8) = cast(EWR.F_EWR_TYPE as varchar(377) character set utf8)" it works (378 fails again). 377 doesn't ring a bell for me to run over some limit. Wondering how is it working on other databases. --

[Firebird-devel] block size exceeds implementation restriction at JStatement::openCursor

Hi, I have a query that on one particular database throws: 2017-08-24T16:29:11.5140 (2704:01620040) ERROR AT JStatement::openCursor I:\DOWNLOADS\BI2.FDB (ATT_16, SYSDBA:NONE, NONE, TCPv6:::1/51084)

[Firebird-devel] [FB-Tracker] Created: (CORE-5597) Failing isc_que_events causes that other operations with DB on same handle are blocked

Failing isc_que_events causes that other operations with DB on same handle are blocked -- Key: CORE-5597 URL: http://tracker.firebirdsql.org/browse/CORE-5597

Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing

Hi All, Thank you for all who worked on it, tested it, documented it, etc.! :-) Gabor -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot

[Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing

Firebird Project announces the first Alpha release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing. This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird