regression-test/data/variant_p0/predefine/load.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !sql --
1	1	{"a":{"b":{"c":123456,"d":11.111}},"dcm":123.456000000,"dt":"2021-01-01 00:00:00","ip":"127.0.0.1","ss":"199991111"}
2	2	{"a":{"b":{"c":678910,"d":22.222}},"dcm":456.123000000,"dt":"2022-01-01 11:11:11","ip":"127.0.0.1","ss":"29999111"}
3	3	{"dcm":789.123000000,"dt":"2025-01-01 11:11:11","ip":"127.0.0.1"}
4	4	{"a":{"b":{"c":678910,"d":33.222}}}
5	5	\N
6	6	\N
7	7	{"xxx":12345}
8	8	{"yyy":111.111}
9	2	{"a":{"b":{"c":678910,"d":22.222}},"dcm":456.123000000,"dt":"2022-01-01 11:11:11","ip":"127.0.0.1","ss":"29999111"}
10	1	{"a":{"b":{"c":123456,"d":11.111}},"dcm":123.456000000,"dt":"2021-01-01 00:00:00","ip":"127.0.0.1","ss":"199991111"}
11	4	{"a":{"b":{"c":678910,"d":33.222}}}
12	3	{"dcm":789.123000000,"dt":"2025-01-01 11:11:11","ip":"127.0.0.1"}

-- !sql --
127.0.0.1
127.0.0.1
127.0.0.1
127.0.0.1
127.0.0.1
127.0.0.1

-- !sql --
123.456000000
123.456000000

-- !sql --
123.456000000
456.123000000
789.123000000
\N
\N
\N
\N
\N
456.123000000
123.456000000
\N
789.123000000

-- !sql --
2022-01-01 11:11:11
2022-01-01 11:11:11

-- !sql --
2022-01-01 11:11:11
2022-01-01 11:11:11

-- !sql --
2	2	{"a":{"b":{"c":678910,"d":22.222}},"dcm":456.123000000,"dt":"2022-01-01 11:11:11","ip":"127.0.0.1","ss":"29999111"}
9	2	{"a":{"b":{"c":678910,"d":22.222}},"dcm":456.123000000,"dt":"2022-01-01 11:11:11","ip":"127.0.0.1","ss":"29999111"}

-- !sql --
1	1	{"a":{"b":{"c":123456,"d":11.111}},"dcm":123.456000000,"dt":"2021-01-01 00:00:00","ip":"127.0.0.1","ss":"199991111"}
2	2	{"a":{"b":{"c":678910,"d":22.222}},"dcm":456.123000000,"dt":"2022-01-01 11:11:11","ip":"127.0.0.1","ss":"29999111"}
3	3	{"dcm":789.123000000,"dt":"2025-01-01 11:11:11","ip":"127.0.0.1"}
9	2	{"a":{"b":{"c":678910,"d":22.222}},"dcm":456.123000000,"dt":"2022-01-01 11:11:11","ip":"127.0.0.1","ss":"29999111"}
10	1	{"a":{"b":{"c":123456,"d":11.111}},"dcm":123.456000000,"dt":"2021-01-01 00:00:00","ip":"127.0.0.1","ss":"199991111"}
12	3	{"dcm":789.123000000,"dt":"2025-01-01 11:11:11","ip":"127.0.0.1"}

-- !sql --
1	{"predefine_col1":1024}
2	{"predefine_col2":1.11111}
3	{"predefine_col3":"11111.00000"}
4	{"predefine_col4":"2020-01-01-01"}
5	{"PREDEFINE_COL1":1024}
6	{"PREDEFINE_COL2":1.11111}
7	{"PREDEFINE_COL3":"11111.00000"}
8	{"PREDEFINE_COL4":"2020-01-01-01"}

-- !sql --
1	{"array_boolean":[1, 0, 1],"array_date":["2021-01-01", "2022-01-01", "2023-01-01"],"array_datetime":["2021-01-01 00:00:00", "2022-01-01 00:00:00", "2023-01-01 00:00:00"],"array_datetimev2":["2021-01-01 00:00:00", "2022-01-01 00:00:00", "2023-01-01 00:00:00"],"array_datev2":["2021-01-01", "2022-01-01", "2023-01-01"],"array_decimal":[1.100000000, 2.200000000, 3.300000000],"array_float":[1.111110000],"array_int":[1, 2, 3],"array_ipv4":["127.0.0.1", "172.0.1.1"],"array_ipv6":["ffff:ffff:ffff:ffff:ffff:ffff:ffff:fffe"],"array_string":["a", "b", "c"],"boolean_":1,"date_":"2022-01-01","datetime_":"2022-01-01 11:11:11","datetimev2_":"2022-01-01 11:11:11.999999","datev2_":"2022-01-01","decimal_":188118222.011121920,"float_":128.111000000,"int_":11111122,"ipv4_":"127.0.0.1","ipv6_":"ffff:ffff:ffff:ffff:ffff:ffff:ffff:fffe","string_":"12111222113","varchar_":"hello world"}
2	{"array_boolean":[1, 0, 1, 0, 1],"array_date":["2021-01-01", "2022-01-01", "2023-01-01"],"array_datetime":["2021-01-01 00:00:00", "2022-01-01 00:00:00", "2023-01-01 00:00:00"],"array_datetimev2":["2021-01-01 00:00:00", "2022-01-01 00:00:00", "2023-01-01 00:00:00"],"array_datev2":["2021-01-01", "2022-01-01", "2023-01-01"],"array_decimal":[1.100000000, 2.200000000, 3.300000000],"array_float":[2.222220000],"array_int":[1, 2, 3],"array_ipv4":["127.0.0.1", "172.0.1.1"],"array_ipv6":["ffff:ffff:ffff:ffff:ffff:ffff:ffff:fffe"],"array_string":["a", "b", "c"],"boolean_":1,"date_":"2022-01-01","datetime_":"2022-01-01 11:11:11","datetimev2_":"2022-01-01 11:11:11.999999","datev2_":"2022-01-01","decimal_":219911111111.011121933,"float_":1.111111111,"ipv4_":"127.0.0.1","ipv6_":"ffff:ffff:ffff:ffff:ffff:ffff:ffff:fffe","string_":"12111222113","varchar_":"world hello"}
3	{"array_datetimev2":["2021-01-01 00:00:00", "2022-01-01 00:00:00", "2023-01-01 00:00:00"],"array_int":[1, 2, 3],"array_string":["a", "b", "c"],"boolean_":1,"date_":"2022-01-01","decimal_":219911111111.011121933,"float_":1.111111111,"ipv4_":"127.0.0.1","varchar_":"world hello"}
4	{"array_datetimev2":["2021-01-01 00:00:00", "2022-01-01 00:00:00", "2023-01-01 00:00:00"],"array_int":[1, 2, 3],"array_string":["a", "b", "c"],"ext_1":1.111111,"ext_2":"this is an extra field","ext_3":[1, 2, 3],"float_":1.111111111,"ipv4_":"127.0.0.1","varchar_":"world hello"}

-- !sql --
101	{"a":1}	{"dcm":1111111.000000000}	\N
102	{"a":1}	{"dcm":1111111.000000000}	{"dcm":1111111.000000000}
103	{"a":1}	{"dcm":1111111.000000000}	{"dt":"2021-01-01 11:11:11"}

-- !sql --
1	{"nested":[{"a":123,"b":"456"}]}
1	{"nested":[{"a":123,"b":"456"}]}
1	{"nested":[{"a":123,"b":"456"}]}
1	{"nested":[{"a":123,"b":"456"}]}
1	{"nested":[{"a":123,"b":"456"}]}

-- !sql --
[{"a":123,"b":"456"}]
[{"a":123,"b":"456"}]
[{"a":123,"b":"456"}]
[{"a":123,"b":"456"}]
[{"a":123,"b":"456"}]

-- !sql --
\N
\N
\N
\N
\N

-- !sql --
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}
{"auto_type":"jsonb"}

-- !sql_arr_null_1 --
3	{"array_decimal":[null, 2.200000000, 3.300000000, 4.400000000]}

-- !sql_arr_null_2 --
1	{"array_decimal":[1.100000000, 2.200000000, 3.300000000, null]}
2	{"array_decimal":[1.100000000, 2.200000000, null, 4.400000000]}
3	{"array_decimal":[null, 2.200000000, 3.300000000, 4.400000000]}
4	{"array_decimal":[1.100000000, null, 3.300000000, 4.400000000]}
5	{"array_decimal":[1.100000000, 2.200000000, 3.300000000, 4.400000000]}

-- !sql --
{"a.b.c":"int","db":"double","dcm":"decimal128i","dt":"datetimev2"}
\N

-- !sql --
{"a.b.c":"int","db":"double","dcm":"decimal128i","dt":"datetimev2"}