[Firebird-devel] [FB-Tracker] Created: (CORE-5931) SIMILAR TO does not return result when invalid pattern is used (with two adjacent special characters that should be escaped but aren't)

2018-09-30 Thread Pavel Zotov (JIRA)
SIMILAR TO does not return result when invalid pattern is used (with two adjacent special characters that should be escaped but aren't) --- Key:

[Firebird-devel] [FB-Tracker] Created: (CORE-5930) internal Firebird consistency check (Incorrect snapshot deallocation - too few slots)

2018-09-30 Thread Mark Rotteveel (JIRA)
internal Firebird consistency check (Incorrect snapshot deallocation - too few slots) - Key: CORE-5930 URL: http://tracker.firebirdsql.org/browse/CORE-5930 Project:

Re: [Firebird-devel] Error java.sql.SQLException: internal Firebird consistency check (Incorrect snapshot deallocation - too few slots) [SQLState:XX000, ISC error code:335544333]

2018-09-30 Thread Mark Rotteveel
On 29-9-2018 22:21, Vlad Khorsun wrote: 29.09.2018 19:14, Mark Rotteveel wrote: ... Do I need to create a ticket for this, or is this a known problem?   Yes, create a ticket please. Done: CORE-5930 I included both problems into that one ticket as I think they are the same. Mark -- Mark

[Firebird-devel] ODP: ODP: User-defined aggregate functions

2018-09-30 Thread Karol Bieniaszewski
>>- A clause to ignore null input values. If used, engine will filter out null >>input and not pass to the routine. >> This need to declare what.parameters shluld be considered I have thinked more about this and i can not imagine how this can work with function which have more then one

[Firebird-devel] ODP: User-defined aggregate functions

2018-09-30 Thread Karol Bieniaszewski
>>I think four adjustments makes the initial syntax better: >>- Allow usage of more than one input parameter. Maybe even zero would be >>allowed. ok >> Instead of have special semantics for empty data source, declare the >> constant to be returned for it, say: >> create aggregate

[Firebird-devel] ODP: ODP: ODP: User-defined aggregate functions

2018-09-30 Thread Karol Bieniaszewski
Hi, >From optimization POV one more system var should be provided Agg_result_needed true when engine need result of calculation false if not. sample with avg: create aggregate function custom_avg (i double precision) returns double precision as     declare accumulated double precision = 0;