--- In firebird-support@yahoogroups.com, Richard Wesley <hawkfish@...>
wrote:

>
>
> On May 22, 2006, at 16:39, Adam wrote:
>
> > Thanks for the reminder. I neglected to consider NULL. My only excuse
> > is that in my requirement, I am dealing with a not NULL field. In any
> > case, EXTRACT returns NULL if the field is NULL, so that logic is not
> > required. NULL + 1 is also NULL.
>
> Is this a change for FB2? TFB p160 warns about EXTRACT(NULL).

It does say that, hmmm.

The behaviour I describe is FB 1.5(.3 Classic on WinXP through iSQL).
There is nothing that I have seen in the FB 2 release notes that
indicates any change in behaviour for Extract.

I don't imagine it would crash on null by design, the function in
1.5.3 behaves as I would expect with respect to null. Perhaps it was
an issue with an older version of Firebird.

Here we go:

Bug # 538201
fixed by Claudio Valderrama
(1.5) Crash with extract from null as date.

FB 1.5 release notes p132.

Adam