EXTRACT
from NULL
date
In 1.0.0, EXTRACT from a NULL
date would crash the server.Fixed in 1.0.2.
Internal functions and directives
Conditional statements and loops
Changing the nullability of a domain
Testing for NULL and equality in practice
Firebird Null Guide: NULL behaviour and pitfalls in Firebird SQL
EXTRACT
from NULL
dateIn 1.0.0, EXTRACT from a NULL
date would crash the server.Fixed in 1.0.2.
FIRST
and SKIP
with NULL
argumentFIRST
and SKIP
crash a Firebird 1.5.n or lower server if given a NULL
argument.Fixed in 2.0.
LIKE
with NULL
escapeUsing LIKE
with a NULL
escape character would crash the server.Fixed in 1.5.1.