Issue Details (XML | Word | Printable)

Key: CORE-5986
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
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:

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: Ascending order - Click to sort in descending order
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.

Mark Rotteveel added a comment - 17/Jan/19 03:15 PM
Note: recent snapshots of Firebird 4 also exhibit the wrong behavior