Throughout the documentation there are many notes how patricular types of nulls
are handled, e.g. in function
or arguments descriptions. This section provides a list of some general rules
which occasionally may differ between GDBase and the original SQLite.
- adding anything to NULL gives NULL
- multiplying NULL by zero gives NULL
- NULL-s are distinct in a UNIQUE column
- all NULLs in SELECT DISTINCT are treated as one
-
any instance of 'NaN' or '+/-infinity' in the data is changed into NULL before counting
any statistics.
-
any instance of '+/-infinity' saved to a GDBase table is stored as NULL.