[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 functio

[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 paramete

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 Ro

[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: F

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

2018-09-30 Thread Dimitry Sibiryakov
30.09.2018 4:52, Adriano dos Santos Fernandes wrote: - Instead of agg_finished, adjust SUSPEND (probably with another keyword) to somehing like: SUSPEND WHEN FETCHED DO WHEN FINISHED DO Isn't it how FETCH is used to be used: WHILE (1 = 1) DO BEGIN FETCH C INTO :RNAME; IF (ROW_

[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: COR