search

microsoft / ODBC-Specification

Microsoft ODBC Specification
Other
121 stars 40 forks source link

UNNEST operator and variants #51

Closed jduo closed 7 years ago

jduo commented 7 years ago

What is the behavior when using the UNNEST operator with a variant, where it might be a collection-type on some rows, but not others?

Also, how does UNNEST behave if the collection being unnested does not have a fixed type (perhaps it is an array of variants)?

matthew-wozniczka commented 7 years ago

How about if the collection being unnested is NULL? Does it behave the same as if it were an empty collection?

mikepizzo commented 7 years ago

Added:

"If the type of the collection is variant, or the Unnest operator references a dynamic column of an open type, then the Unnest operator returns null for rows in which the column is not defined."