| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !sql_desc_1 -- |
| k bigint Yes true \N |
| v variant<PROPERTIES ("variant_max_subcolumns_count" = "10")> Yes false \N NONE |
| v.nested.a array<tinyint> Yes false \N NONE |
| v.nested.b array<text> Yes false \N NONE |
| v.nested.c array<double> Yes false \N NONE |
| |
| -- !sql_0 -- |
| 1 {"nested":[{"a":1,"c":1.1}, {"b":"1"}]} |
| |
| -- !sql_1 -- |
| [1, null] |
| |
| -- !sql_2 -- |
| [null, "1"] |
| |
| -- !sql_3 -- |
| [1.1, null] |
| |
| -- !sql_4 -- |
| [{"a":1,"c":1.1}, {"b":"1"}] |
| |
| -- !sql_8 -- |
| [1, null] 2 |
| |
| -- !sql_9 -- |
| [null, 1] 2 |
| |
| -- !sql_10 -- |
| [1, null] 2 |
| |
| -- !sql_11 -- |
| ["1", null] 2 |
| |
| -- !sql_12 -- |
| [null, "1"] 2 |
| |
| -- !sql_13 -- |
| ["1.1", null] 2 |
| |
| -- !sql_14 -- |
| [1, null] 2 |
| |
| -- !sql_15 -- |
| [null, 1] 2 |
| |
| -- !sql_16 -- |
| [1.1, null] 2 |
| |
| -- !sql_desc_2 -- |
| k bigint Yes true \N |
| v variant<PROPERTIES ("variant_max_subcolumns_count" = "10")> Yes false \N NONE |
| v.nested.a array<double> Yes false \N NONE |
| v.nested.b array<json> Yes false \N NONE |
| v.nested.c array<double> Yes false \N NONE |
| |
| -- !sql_0 -- |
| 1 {"nested":[{"a":1,"c":1.1}, {"b":"1"}]} |
| 2 {"nested":[{"a":2.5,"b":123.1}]} |
| |
| -- !sql_1 -- |
| [1, null] |
| [2.5] |
| |
| -- !sql_2 -- |
| [null, "1"] |
| [123.1] |
| |
| -- !sql_3 -- |
| [1.1, null] |
| \N |
| |
| -- !sql_4 -- |
| [{"a":1,"c":1.1}, {"b":"1"}] |
| [{"a":2.5,"b":123.1}] |
| |
| -- !sql_8 -- |
| [1, null] 2 |
| [2] 1 |
| |
| -- !sql_9 -- |
| [null, 1] 2 |
| [123] 1 |
| |
| -- !sql_10 -- |
| [1, null] 2 |
| \N \N |
| |
| -- !sql_11 -- |
| ["1", null] 2 |
| ["2.5"] 1 |
| |
| -- !sql_12 -- |
| [null, "1"] 2 |
| ["123.1"] 1 |
| |
| -- !sql_13 -- |
| ["1.1", null] 2 |
| \N \N |
| |
| -- !sql_14 -- |
| [1, null] 2 |
| [2.5] 1 |
| |
| -- !sql_15 -- |
| [null, 1] 2 |
| [123.1] 1 |
| |
| -- !sql_16 -- |
| [1.1, null] 2 |
| \N \N |
| |
| -- !sql_0 -- |
| 1 {"nested":[{"a":1,"c":1.1}, {"b":"1"}]} |
| 2 {"nested":[{"a":2.5,"b":123.1}]} |
| |
| -- !sql_1 -- |
| [1, null] |
| [2.5] |
| |
| -- !sql_2 -- |
| [null, "1"] |
| [123.1] |
| |
| -- !sql_3 -- |
| [1.1, null] |
| [null] |
| |
| -- !sql_4 -- |
| [{"a":1,"c":1.1}, {"b":"1"}] |
| [{"a":2.5,"b":123.1}] |
| |
| -- !sql_8 -- |
| [1, null] 2 |
| [2] 1 |
| |
| -- !sql_9 -- |
| [null, 1] 2 |
| [123] 1 |
| |
| -- !sql_10 -- |
| [1, null] 2 |
| [null] 1 |
| |
| -- !sql_11 -- |
| ["1", null] 2 |
| ["2.5"] 1 |
| |
| -- !sql_12 -- |
| [null, "1"] 2 |
| ["123.1"] 1 |
| |
| -- !sql_13 -- |
| ["1.1", null] 2 |
| [null] 1 |
| |
| -- !sql_14 -- |
| [1, null] 2 |
| [2.5] 1 |
| |
| -- !sql_15 -- |
| [null, 1] 2 |
| [123.1] 1 |
| |
| -- !sql_16 -- |
| [1.1, null] 2 |
| [null] 1 |
| |
| -- !sql_desc_4 -- |
| k bigint Yes true \N |
| v variant<PROPERTIES ("variant_max_subcolumns_count" = "10")> Yes false \N NONE |
| v.nested.a array<json> Yes false \N NONE |
| v.nested.b array<json> Yes false \N NONE |
| v.nested.c array<text> Yes false \N NONE |
| |
| -- !sql_0 -- |
| 1 {"nested":[{"a":1,"b":1.1}, {"a":"1","b":"1","c":"1"}]} |
| |
| -- !sql_1 -- |
| [1, "1"] |
| |
| -- !sql_2 -- |
| [1.1, "1"] |
| |
| -- !sql_3 -- |
| [null, "1"] |
| |
| -- !sql_4 -- |
| [{"a":1,"b":1.1}, {"a":"1","b":"1","c":"1"}] |
| |
| -- !sql_8 -- |
| [1, 1] 2 |
| |
| -- !sql_9 -- |
| [1, 1] 2 |
| |
| -- !sql_10 -- |
| [null, 1] 2 |
| |
| -- !sql_11 -- |
| ["1", "1"] 2 |
| |
| -- !sql_12 -- |
| ["1.1", "1"] 2 |
| |
| -- !sql_13 -- |
| [null, "1"] 2 |
| |
| -- !sql_14 -- |
| [1, 1] 2 |
| |
| -- !sql_15 -- |
| [1.1, 1] 2 |
| |
| -- !sql_16 -- |
| [null, 1] 2 |
| |
| -- !sql_desc_5 -- |
| k bigint Yes true \N |
| v variant<PROPERTIES ("variant_max_subcolumns_count" = "10")> Yes false \N NONE |
| v.nested.a array<json> Yes false \N NONE |
| v.nested.b array<json> Yes false \N NONE |
| v.nested.c array<json> Yes false \N NONE |
| |
| -- !sql_0 -- |
| 1 {"nested":[{"a":1,"b":1.1}, {"a":"1","b":"1","c":"1"}]} |
| 2 {"nested":[{"a":1,"c":1.1}]} |
| |
| -- !sql_1 -- |
| [1, "1"] |
| [1] |
| |
| -- !sql_2 -- |
| [1.1, "1"] |
| \N |
| |
| -- !sql_3 -- |
| [null, "1"] |
| [1.1] |
| |
| -- !sql_4 -- |
| [{"a":1,"b":1.1}, {"a":"1","b":"1","c":"1"}] |
| [{"a":1,"c":1.1}] |
| |
| -- !sql_8 -- |
| [1, 1] 2 |
| [1] 1 |
| |
| -- !sql_9 -- |
| [1, 1] 2 |
| \N \N |
| |
| -- !sql_10 -- |
| [null, 1] 2 |
| [1] 1 |
| |
| -- !sql_11 -- |
| ["1", "1"] 2 |
| ["1"] 1 |
| |
| -- !sql_12 -- |
| ["1.1", "1"] 2 |
| \N \N |
| |
| -- !sql_13 -- |
| [null, "1"] 2 |
| ["1.1"] 1 |
| |
| -- !sql_14 -- |
| [1, 1] 2 |
| [1] 1 |
| |
| -- !sql_15 -- |
| [1.1, 1] 2 |
| \N \N |
| |
| -- !sql_16 -- |
| [null, 1] 2 |
| [1.1] 1 |
| |
| -- !sql_0 -- |
| 1 {"nested":[{"a":1,"b":1.1}, {"a":"1","b":"1","c":"1"}]} |
| 2 {"nested":[{"a":1,"c":1.1}]} |
| |
| -- !sql_1 -- |
| [1, "1"] |
| [1] |
| |
| -- !sql_2 -- |
| [1.1, "1"] |
| [null] |
| |
| -- !sql_3 -- |
| [null, "1"] |
| [1.1] |
| |
| -- !sql_4 -- |
| [{"a":1,"b":1.1}, {"a":"1","b":"1","c":"1"}] |
| [{"a":1,"c":1.1}] |
| |
| -- !sql_8 -- |
| [1, 1] 2 |
| [1] 1 |
| |
| -- !sql_9 -- |
| [1, 1] 2 |
| [null] 1 |
| |
| -- !sql_10 -- |
| [null, 1] 2 |
| [1] 1 |
| |
| -- !sql_11 -- |
| ["1", "1"] 2 |
| ["1"] 1 |
| |
| -- !sql_12 -- |
| ["1.1", "1"] 2 |
| [null] 1 |
| |
| -- !sql_13 -- |
| [null, "1"] 2 |
| ["1.1"] 1 |
| |
| -- !sql_14 -- |
| [1, 1] 2 |
| [1] 1 |
| |
| -- !sql_15 -- |
| [1.1, 1] 2 |
| [null] 1 |
| |
| -- !sql_16 -- |
| [null, 1] 2 |
| [1.1] 1 |
| |
