[#CORE-5986] Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}

Firebird Core

Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}

Created: 17/Jan/19 02:24 PM Updated: 16/Feb/19 05:05 PM

Component/s:

None

Affects Version/s:

3.0.4, 4.0 Beta 1

Fix Version/s:

4.0 Beta 1, 3.0.5

Issue Links:

Relate

This issue is related to:

CORE-5988 Improve optimizer to consider index usage for IS DISTINCT FROM with boolean fields

QA Status:

Done successfully

Description

« Hide

- NULL IS {FALSE | TRUE} should be FALSE, but Firebird gives NULL

- NULL IS NOT {FALSE | TRUE} should be TRUE, but Firebird gives NULL

All

Comments

Change History

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Mark Rotteveel added a comment - 17/Jan/19 03:13 PM

For reference ISO-9075-2:2016 section 6.39 <boolean value expression>, table 15 Truth table for the IS boolean operator.

It might be worthwhile to add an explicit test for those truth tables.

[ Permalink | « Hide ]

Mark Rotteveel added a comment - 17/Jan/19 03:15 PM

Note: recent snapshots of Firebird 4 also exhibit the wrong behavior