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
Operations

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:
Relate
 

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
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 ]
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

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 ]