blob: d0e0e9c822ddc2d5f2e9c498d38cbc2c67f416c8 [file] [log] [blame]
-- This file is automatically generated. You should know what you did if you want to edit this
-- !sql --
k bigint Yes true \N
v variant Yes false \N NONE
v.nested.a array<text> Yes false \N NONE
v.nested.aaa array<text> Yes false \N NONE
v.nested.ax1111 array<text> Yes false \N NONE
v.nested.axxxb array<tinyint> Yes false \N NONE
v.nested.ba array<text> Yes false \N NONE
v.nested.baaa array<text> Yes false \N NONE
v.nested.ddsss array<smallint> Yes false \N NONE
v.nested.mmm array<text> Yes false \N NONE
v.nested.nested.a array<text> Yes false \N NONE
v.nested.nested.aaa array<text> Yes false \N NONE
v.nested.nested.ax1111 array<text> Yes false \N NONE
v.nested.nested.axxxb array<tinyint> Yes false \N NONE
v.nested.nested.ba array<text> Yes false \N NONE
v.nested.nested.ddsss array<smallint> Yes false \N NONE
v.nested.nested.xx array<tinyint> Yes false \N NONE
v.nested.nested.xxxy111 array<tinyint> Yes false \N NONE
v.nested.nested.yyyxxxx array<text> Yes false \N NONE
v.nested.xx array<tinyint> Yes false \N NONE
v.nested.xxxy111 array<tinyint> Yes false \N NONE
v.nested.yyy array<text> Yes false \N NONE
v.nested.yyyxxxx array<text> Yes false \N NONE
v.nested.zzz11 array<text> Yes false \N NONE
v.not nested smallint Yes false \N NONE
v.not nested2.llll tinyint Yes false \N NONE
v.xx tinyint Yes false \N NONE
-- !sql --
1 {"xx":10}
2 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
3 {"xx":10}
4 {"nested":[{"baaa":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
5 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
6 {"nested":[{"mmm":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
7 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
8 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
9 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
10 {"xx":10}
11 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
12 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
13 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
14 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
15 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
16 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
17 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
18 {"xx":10}
19 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
20 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
21 {"nested":[{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
22 {"nested":[{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10},{"zzz11":"123333"}]}
23 {"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
24 {"xx":10}
25 {"nested":{"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}}
26 {"xx":10}
27 {"nested":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}}
28 {"nested":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
-- !sql --
1 {"xx":10}
2 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
3 {"xx":10}
4 {"nested":[{"baaa":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
5 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
6 {"nested":[{"mmm":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
7 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
8 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
9 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
10 {"xx":10}
11 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
12 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
13 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
14 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
15 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
16 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
17 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
18 {"xx":10}
19 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
20 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
21 {"nested":[{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
22 {"nested":[{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10},{"zzz11":"123333"}]}
23 {"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
24 {"xx":10}
25 {"nested":{"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}}
26 {"xx":10}
27 {"nested":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}}
28 {"nested":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
101 {"nested101":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
102 {"nested102":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
103 {"nested103":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
104 {"nested104":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
105 {"nested105":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
106 {"nested106":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
107 {"nested107":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
108 {"nested108":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
109 {"nested109":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
110 {"nested110":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
111 {"nested111":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
112 {"nested112":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
113 {"nested113":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
114 {"nested114":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
115 {"nested115":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
116 {"nested116":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
117 {"nested117":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
118 {"nested118":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
119 {"nested119":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
120 {"nested120":{"nested":[{"yyyxxxx":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]},"not nested":1024,"not nested2":{"llll":123}}
-- !sql --
201 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
202 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
203 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
204 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
205 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
206 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
207 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
208 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
209 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
210 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
-- !sql --
201 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
-- !sql --
2049 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2050 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2051 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2052 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2053 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2054 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2055 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2056 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2057 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
2058 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
-- !sql --
201 {"k1":1,"k2":"some","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
-- !sql --
2049 {"k1":1,"k2":"what","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
-- !sql --
4097 {"k1":1,"k2":"nested","k3":[1234],"k4":1.1,"k5":[[123]],"nested1":{"nested2":[{"a":10,"b":1.1,"c":"1111"}]}}
-- !sql --
1 {"xx":10}
2 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
3 {"xx":10}
4 {"nested":[{"baaa":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
5 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
6 {"nested":[{"mmm":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
7 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
8 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
9 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
10 {"xx":10}
-- !sql --
[]
[{"ba":"11111"}, {"a":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
[]
[{"baaa":"11111"}, {"ax1111":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
[{"ba":"11111"}, {"a":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
[{"mmm":"11111"}, {"ax1111":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
[{"ba":"11111"}, {"a":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
[{"yyy":"11111"}, {"ax1111":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
[{"yyy":"11111"}, {"ax1111":"1111"}, {"axxxb":100,"xxxy111":111}, {"aaa":"11","ddsss":1024}, {"xx":10}]
-- !explode_sql --
19 10
-- !explode_sql --
1 {"callLimit":3,"number":"02124713252","type":"HOME"}
1 {"callLimit":5,"number":"5550219210","type":"GSM"}
-- !sql --
2 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
4 {"nested":[{"baaa":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
5 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
6 {"nested":[{"mmm":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
7 {"nested":[{"ba":"11111"},{"a":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
8 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
9 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
11 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
12 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
13 {"nested":[{"yyy":"11111"},{"ax1111":"1111"},{"axxxb":100,"xxxy111":111},{"aaa":"11","ddsss":1024},{"xx":10}]}
-- !explode_sql --
-- !explode_sql --
19 10
-- !explode_sql --
2 10