Opened 10 years ago

Closed 9 years ago

#877 closed defect (fixed)

Modulo operation does not respect null values

Reported by: Veranika Liaukevich Owned by: Dimitar Misev
Priority: major Milestone: 9.1.x
Component: catalogmgr Version: development
Keywords: Cc: Dimitar Misev
Complexity: Medium

Description

Modulo division interprets nulls as regular values.
Definition of the collection:

typedef marray <char, 2> NullValueArrayTest;
typedef set <NullValueArrayTest> null values [5:7] NullValueSetTest;

Values (the third value is null):

$ rasql  -q 'select csv(x) from values as x' --out string --quiet
{1},{2},{5}

Modulo operation:

$ rasql  -q 'select csv( mod(x, 2) ) from values as x' --out string --quiet
{1},{0},{1}

The correct output should be:

{1}, {0}, {5} 

Change History (3)

comment:1 by Dimitar Misev, 9 years ago

Milestone: 9.2

comment:2 by Dimitar Misev, 9 years ago

Milestone: 9.29.1.x

Patch submitted.

comment:3 by Dimitar Misev, 9 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.