Test lateral-join-crash.Bug-6613.sql (id fe8055a86502) (err)
lateral-join-crash.Bug-6613.stable.out.FILTERED 2019-09-12 11:10:44.261313846 +0200lateral-join-crash.Bug-6613.test.out.FILTERED 2019-09-12 11:10:44.262313837 +0200
1 Statistics about stdout of test 'lateral-join-crash.Bug-6613` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stdout of test 'lateral-join-crash.Bug-6613` in directory 'sql/test/BugTracker-2018`: 1
2 170 lines, 847 words, 2303 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 3 lines, 12 words, 103 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 170 lines, 847 words, 2303 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 3 lines, 12 words, 103 chars in lines not matching '^$|^(\| |)#` 3
4 # 209 lines, 1080 words, 4322 chars in all lines 4 ! 4 # 35 lines, 164 words, 1446 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
25 25 25 25
26 # 00:28:47 > 26 ! 26 Ready. 26
27 # 00:28:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13250" "--port=34098" 27 ! 27 27
28 # 00:28:47 > 28 ! 28 # 11:10:34 > 28
+ 29 # 11:10:34 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-14791" "--port=30704" 29
+ 30 # 11:10:34 > 30
29 29 31 31
..................
#insert into segments values (1,1,1),(9,
33 [ 2 ] 33 35 [ 2 ] 35
34 #select t.* from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; 34 ! 36 36
35 % .t # table_name 35 ! 37 # 11:10:44 > 37
36 % value # name 36 ! 38 # 11:10:44 > "Done." 38
37 % int # type 37 ! 39 # 11:10:44 > 39
38 % 2 # length 38 -
39 [ 1 ] 39 -
40 [ 2 ] 40 -
41 [ 9 ] 41 -
42 [ 10 ] 42 -
43 [ 11 ] 43 -
44 [ 12 ] 44 -
45 [ 13 ] 45 -
46 [ 14 ] 46 -
47 [ 15 ] 47 -
48 [ 16 ] 48 -
49 [ 17 ] 49 -
50 [ 18 ] 50 -
51 [ 1 ] 51 -
52 [ 2 ] 52 -
53 [ 9 ] 53 -
54 [ 10 ] 54 -
55 [ 11 ] 55 -
56 [ 12 ] 56 -
57 [ 13 ] 57 -
58 [ 14 ] 58 -
59 [ 15 ] 59 -
60 [ 16 ] 60 -
61 [ 17 ] 61 -
62 [ 18 ] 62 -
63 #select t.value, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; 63 -
64 % .t, sys.s, sys.s # table_name 64 -
65 % value, distance, speed # name 65 -
66 % int, int, int # type 66 -
67 % 2, 1, 1 # length 67 -
68 [ 1, 1, 1 ] 68 -
69 [ 2, 1, 1 ] 69 -
70 [ 9, 1, 1 ] 70 -
71 [ 10, 1, 1 ] 71 -
72 [ 11, 1, 1 ] 72 -
73 [ 12, 1, 1 ] 73 -
74 [ 13, 1, 1 ] 74 -
75 [ 14, 1, 1 ] 75 -
76 [ 15, 1, 1 ] 76 -
77 [ 16, 1, 1 ] 77 -
78 [ 17, 1, 1 ] 78 -
79 [ 18, 1, 1 ] 79 -
80 [ 1, 9, 9 ] 80 -
81 [ 2, 9, 9 ] 81 -
82 [ 9, 9, 9 ] 82 -
83 [ 10, 9, 9 ] 83 -
84 [ 11, 9, 9 ] 84 -
85 [ 12, 9, 9 ] 85 -
86 [ 13, 9, 9 ] 86 -
87 [ 14, 9, 9 ] 87 -
88 [ 15, 9, 9 ] 88 -
89 [ 16, 9, 9 ] 89 -
90 [ 17, 9, 9 ] 90 -
91 [ 18, 9, 9 ] 91 -
92 #select * from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1); 92 -
93 % sys.s, sys.s, sys.s, . # table_name 93 -
94 # sys.s, sys.s, sys.s, .L2 # table_name 94 -
95 % meter, distance, speed, value # name 95 -
96 % int, int, int, int # type 96 -
97 % 1, 1, 1, 2 # length 97 -
98 [ 1, 1, 1, 1 ] 98 -
99 [ 1, 1, 1, 2 ] 99 -
100 [ 1, 1, 1, 9 ] 100 -
101 [ 1, 1, 1, 10 ] 101 -
102 [ 1, 1, 1, 11 ] 102 -
103 [ 1, 1, 1, 12 ] 103 -
104 [ 1, 1, 1, 13 ] 104 -
105 [ 1, 1, 1, 14 ] 105 -
106 [ 1, 1, 1, 15 ] 106 -
107 [ 1, 1, 1, 16 ] 107 -
108 [ 1, 1, 1, 17 ] 108 -
109 [ 1, 1, 1, 18 ] 109 -
110 [ 9, 9, 9, 1 ] 110 -
111 [ 9, 9, 9, 2 ] 111 -
112 [ 9, 9, 9, 9 ] 112 -
113 [ 9, 9, 9, 10 ] 113 -
114 [ 9, 9, 9, 11 ] 114 -
115 [ 9, 9, 9, 12 ] 115 -
116 [ 9, 9, 9, 13 ] 116 -
117 [ 9, 9, 9, 14 ] 117 -
118 [ 9, 9, 9, 15 ] 118 -
119 [ 9, 9, 9, 16 ] 119 -
120 [ 9, 9, 9, 17 ] 120 -
121 [ 9, 9, 9, 18 ] 121 -
122 #select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; 122 -
123 % .t, sys.s, sys.s # table_name 123 -
124 % value, distance, speed # name 124 -
125 % int, int, int # type 125 -
126 % 2, 1, 1 # length 126 -
127 [ 1, 1, 1 ] 127 -
128 [ 2, 1, 1 ] 128 -
129 [ 9, 1, 1 ] 129 -
130 [ 10, 1, 1 ] 130 -
131 [ 11, 1, 1 ] 131 -
132 [ 12, 1, 1 ] 132 -
133 [ 13, 1, 1 ] 133 -
134 [ 14, 1, 1 ] 134 -
135 [ 15, 1, 1 ] 135 -
136 [ 16, 1, 1 ] 136 -
137 [ 17, 1, 1 ] 137 -
138 [ 18, 1, 1 ] 138 -
139 [ 1, 9, 9 ] 139 -
140 [ 2, 9, 9 ] 140 -
141 [ 9, 9, 9 ] 141 -
142 [ 10, 9, 9 ] 142 -
143 [ 11, 9, 9 ] 143 -
144 [ 12, 9, 9 ] 144 -
145 [ 13, 9, 9 ] 145 -
146 [ 14, 9, 9 ] 146 -
147 [ 15, 9, 9 ] 147 -
148 [ 16, 9, 9 ] 148 -
149 [ 17, 9, 9 ] 149 -
150 [ 18, 9, 9 ] 150 -
151 #select t.meter, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t(meter); 151 -
152 % .t, sys.s, sys.s # table_name 152 -
153 % meter, distance, speed # name 153 -
154 % int, int, int # type 154 -
155 % 2, 1, 1 # length 155 -
156 [ 1, 1, 1 ] 156 -
157 [ 2, 1, 1 ] 157 -
158 [ 9, 1, 1 ] 158 -
159 [ 10, 1, 1 ] 159 -
160 [ 11, 1, 1 ] 160 -
161 [ 12, 1, 1 ] 161 -
162 [ 13, 1, 1 ] 162 -
163 [ 14, 1, 1 ] 163 -
164 [ 15, 1, 1 ] 164 -
165 [ 16, 1, 1 ] 165 -
166 [ 17, 1, 1 ] 166 -
167 [ 18, 1, 1 ] 167 -
168 [ 1, 9, 9 ] 168 -
169 [ 2, 9, 9 ] 169 -
170 [ 9, 9, 9 ] 170 -
171 [ 10, 9, 9 ] 171 -
172 [ 11, 9, 9 ] 172 -
173 [ 12, 9, 9 ] 173 -
174 [ 13, 9, 9 ] 174 -
175 [ 14, 9, 9 ] 175 -
176 [ 15, 9, 9 ] 176 -
177 [ 16, 9, 9 ] 177 -
178 [ 17, 9, 9 ] 178 -
179 [ 18, 9, 9 ] 179 -
180 #select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t(meter); 180 -
181 % .t, sys.s, sys.s # table_name 181 -
182 % meter, distance, speed # name 182 -
183 % int, int, int # type 183 -
184 % 2, 1, 1 # length 184 -
185 [ 1, 1, 1 ] 185 -
186 [ 2, 1, 1 ] 186 -
187 [ 9, 1, 1 ] 187 -
188 [ 10, 1, 1 ] 188 -
189 [ 11, 1, 1 ] 189 -
190 [ 12, 1, 1 ] 190 -
191 [ 13, 1, 1 ] 191 -
192 [ 14, 1, 1 ] 192 -
193 [ 15, 1, 1 ] 193 -
194 [ 16, 1, 1 ] 194 -
195 [ 17, 1, 1 ] 195 -
196 [ 18, 1, 1 ] 196 -
197 [ 1, 9, 9 ] 197 -
198 [ 2, 9, 9 ] 198 -
199 [ 9, 9, 9 ] 199 -
200 [ 10, 9, 9 ] 200 -
201 [ 11, 9, 9 ] 201 -
202 [ 12, 9, 9 ] 202 -
203 [ 13, 9, 9 ] 203 -
204 [ 14, 9, 9 ] 204 -
205 [ 15, 9, 9 ] 205 -
206 [ 16, 9, 9 ] 206 -
207 [ 17, 9, 9 ] 207 -
208 [ 18, 9, 9 ] 208 -
209 #rollback; 209 -
210 210 -
211 # 00:28:47 > 211 -
212 # 00:28:47 > "Done." 212 -
213 # 00:28:47 > 213 -
214 214 40 40