yql/essentials/tests/sql/suites/blocks/variant_item_struct_double_optional.yql


1
2
3
4
5
6
7
8
9
10
11

$structVariantType = Variant<a: Optional<Int32>, b: Optional<Int32>>;

$optionalData = [
    <|variantValue: Just(Variant(Just(1), "a", $structVariantType))|>,
    <|variantValue: Just(Variant(Nothing(Int32?), "a", $structVariantType))|>,
    <|variantValue: Nothing(OptionalType($structVariantType))|>,
    <|variantValue: Just(Variant(Just(2), "b", $structVariantType))|>,
    <|variantValue: Just(Variant(Nothing(Int32?), "b", $structVariantType))|>,
];

SELECT Yql::VariantItem(variantValue) AS item FROM as_table($optionalData);