Unnest(null) should yield a row

Description

Per discussion with , splitting this from PLFM-6206.

Given:

c1

c2

c3

1

a

null

2

b

['a','b']

select c1,c2,c3,unnest(c3) as c4 from synxxx returns:

c1

c2

c3

c4

2

b

['a','b']

a

2

b

['a','b']

b

My contention is that it should return:

c1

c2

c3

c4

1

a

null

null

2

b

['a','b']

a

2

b

['a','b']

b

Note: it's not clear to me what the 'standard' is... PGSQL does it the same way we have now I think.
However, the workarounds (to include the missing row) seem to be more complicated than to simply
exclude the extra rows if not wanted(with a where clause)...

Environment

None

Assignee

Ziming Dong

Reporter

Xavier Schildwachter

Labels

None

Validator

Xavier Schildwachter

Development Area

Data Curation / Metadata

Release Version History

None

Components

Sprint

Priority

Major
Configure