DateAdd(): change input argument from INT to BIGINT
Key: CORE-4310
URL: http://tracker.firebirdsql.org/browse/CORE-4310
Project: Firebird Core
Issue Type: Improvement
Co
All,
We had this topic raising from time to time, resulted in CORE-1488. So
far there was no appropriate discussion and hence no decision made,
although one might argue that the optimizer should be clever enough to
make hints unnecessary. The PGSQL guys share the same opinion, BTW ;-)
As for m
More info with firebirdsql.org download links on
http://blog.cincura.net/233434-ado-net-provider-for-firebird-4-1-0-0-is-ready/
.
Changes in tracker:
http://tracker.firebirdsql.org/secure/ReleaseNote.jspa?version=10583&styleName=Text&projectId=10003
.
JC
--
Jiri {x2} Cincura (x2develop.com foun
Dmitry Yemanov писал(а) в своём письме Thu, 02 Jan
2014 15:55:57 +0400:
>
> This makes it necessary to allow the FIRST ROWS mode when it's needed.
> I'm proposing the following:
>
> 1) FIRST ROWS mode is implicitly used when the FIRST / ROWS clause is in
> game. Also, FIRST ROWS mode is implic
Provileges
--
Key: CORE-4311
URL: http://tracker.firebirdsql.org/browse/CORE-4311
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.5.2, 2.1.5, 2.5.1, 2.1.4, 2.5.0, 2.1.3, 2.1.2, 2.1.
On 2-1-2014 12:55, Dmitry Yemanov wrote:
> The good question is how Firebird behaves now from this point of view.
> Mostly it uses the ALL ROWS approach, and the underlying cost based
> optimization algorithms also deal with complete stream cardinalities.
> There are some heuristics based deviation
On 1/2/2014 8:10 AM, Simonov Denis wrote:
> Dmitry Yemanov писал(а) в своём письме Thu, 02 Jan
> 2014 15:55:57 +0400:
>
>
>> This makes it necessary to allow the FIRST ROWS mode when it's needed.
>> I'm proposing the following:
>>
>> 1) FIRST ROWS mode is implicitly used when the FIRST / ROWS clau
02.01.2014 21:43, Mark Rotteveel wrote:
>
> It would be interesting to know which is better for performance, given
> isc_dsql_fetch, a FIRST (x) ROWS might perform better when small fetch
> sizes are used.
What do you mean by "small fetch sizes"? If it's about incomplete fetch,
i.e. only few row
