[#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:

Adriano dos Santos Fernandes made changes - 17/Jan/19 02:25 PM

Field	Original Value	New Value
Assignee		Adriano dos Santos Fernandes [ asfernandes ]
Affects Version/s		3.0.4 [ 10863 ]

[ 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

Mark Rotteveel made changes - 17/Jan/19 03:15 PM

Affects Version/s

4.0 Beta 1 [ 10750 ]

Adriano dos Santos Fernandes made changes - 18/Jan/19 03:04 PM

Link

This issue is related to CORE-5988 [ CORE-5988 ]

Adriano dos Santos Fernandes made changes - 19/Jan/19 08:55 PM

Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		4.0 Beta 1 [ 10750 ]
Fix Version/s		3.0.5 [ 10885 ]
Resolution		Fixed [ 1 ]

Pavel Zotov made changes - 16/Feb/19 05:05 PM

Status	Resolved [ 5 ]	Resolved [ 5 ]
QA Status	No test	Done successfully

Pavel Zotov made changes - 16/Feb/19 05:05 PM

Status

Resolved [ 5 ]

Closed [ 6 ]