SIMILAR TO does not return result when invalid pattern is used (with two
adjacent special characters that should be escaped but aren't)
---
Key:
internal Firebird consistency check (Incorrect snapshot deallocation - too few
slots)
-
Key: CORE-5930
URL: http://tracker.firebirdsql.org/browse/CORE-5930
Project:
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
>>- 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
>>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
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;