Opened 7 years ago

Closed 7 years ago

#1706 closed defect (fixed)

unexpected null values behavior in condensers

Reported by: Dimitar Misev Owned by: Dimitar Misev
Priority: major Milestone: 9.6
Component: qlparser Version: development
Keywords: Cc: Vlad Merticariu
Complexity: Medium

Description

The result of a condenser applied on an array with nulls can accidentally be a null in further operations.

E.g. (queries below):

testNull is an array of 5 elements, all 1, null value is 2.
add_cells(testNull[0:1]) is 2. add_cells(testNull[0:1]) + 1 is still 2.
The result of the condenser shouldn't be considered a null.

Queries to reproduce:

./rasql —user rasadmin —passwd rasadmin -q 'create collection testNull GreySet1'

./rasql —user rasadmin —passwd rasadmin -q 'insert into testNull values marray x in [0:4] values 1c'

./rasql —user rasadmin —passwd rasadmin -q 'update testNull set testNull assign null values [2:2]'

./rasql -q 'select add_cells(a[0:1]) from testNull a' —out string

./rasql -q 'select add_cells(a[0:1])+1 from testNull a' —out string

Change History (1)

comment:1 by Dimitar Misev, 7 years ago

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