github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/window.align-only.golden (about) 1 1: 2 - 3 SELECT 4 sum( 5 a 6 ) OVER w, 7 avg( 8 b 9 ) OVER ( 10 PARTITION BY 11 c 12 ORDER BY 13 d 14 ROWS 15 e PRECEDING 16 ), 17 min( 18 f 19 ) OVER ( 20 ORDER BY 21 g 22 RANGE 23 BETWEEN 24 UNBOUNDED PRECEDING 25 AND 26 h FOLLOWING EXCLUDE TIES 27 ) 28 FROM 29 t 30 WINDOW 31 w AS ( 32 PARTITION BY 33 i 34 GROUPS 35 BETWEEN 36 j PRECEDING 37 AND 38 CURRENT ROW EXCLUDE NO OTHERS 39 ) 40 41 11: 42 ----------- 43 SELECT sum( 44 a 45 ) OVER w, 46 avg( 47 b 48 ) OVER ( 49 PARTITION BY 50 c 51 ORDER BY 52 d 53 ROWS 54 e PRECEDING 55 ), 56 min( 57 f 58 ) OVER ( 59 ORDER BY 60 g 61 RANGE 62 BETWEEN 63 UNBOUNDED PRECEDING 64 AND 65 h FOLLOWING EXCLUDE TIES 66 ) 67 FROM t 68 WINDOW w AS ( 69 PARTITION BY 70 i 71 GROUPS 72 BETWEEN 73 j PRECEDING 74 AND 75 CURRENT ROW EXCLUDE NO OTHERS 76 ) 77 78 18: 79 ------------------ 80 SELECT sum( 81 a 82 ) OVER w, 83 avg( 84 b 85 ) OVER ( 86 PARTITION BY 87 c 88 ORDER BY 89 d 90 ROWS 91 e PRECEDING 92 ), 93 min( 94 f 95 ) OVER ( 96 ORDER BY g 97 RANGE BETWEEN 98 UNBOUNDED PRECEDING 99 AND 100 h FOLLOWING EXCLUDE TIES 101 ) 102 FROM t 103 WINDOW w AS ( 104 PARTITION BY 105 i 106 GROUPS 107 BETWEEN 108 j PRECEDING 109 AND 110 CURRENT ROW EXCLUDE NO OTHERS 111 ) 112 113 20: 114 -------------------- 115 SELECT sum( 116 a 117 ) OVER w, 118 avg(b) OVER ( 119 PARTITION BY 120 c 121 ORDER BY 122 d 123 ROWS 124 e PRECEDING 125 ), 126 min(f) OVER ( 127 ORDER BY g 128 RANGE BETWEEN 129 UNBOUNDED PRECEDING 130 AND 131 h FOLLOWING EXCLUDE TIES 132 ) 133 FROM t 134 WINDOW w AS ( 135 PARTITION BY 136 i 137 GROUPS 138 BETWEEN 139 j PRECEDING 140 AND 141 CURRENT ROW EXCLUDE NO OTHERS 142 ) 143 144 21: 145 --------------------- 146 SELECT sum(a) OVER w, 147 avg(b) OVER ( 148 PARTITION BY 149 c 150 ORDER BY 151 d 152 ROWS 153 e PRECEDING 154 ), 155 min(f) OVER ( 156 ORDER BY g 157 RANGE BETWEEN 158 UNBOUNDED PRECEDING 159 AND 160 h FOLLOWING EXCLUDE TIES 161 ) 162 FROM t 163 WINDOW w AS ( 164 PARTITION BY 165 i 166 GROUPS 167 BETWEEN 168 j PRECEDING 169 AND 170 CURRENT ROW EXCLUDE NO OTHERS 171 ) 172 173 22: 174 ---------------------- 175 SELECT sum(a) OVER w, 176 avg(b) OVER ( 177 PARTITION BY c 178 ORDER BY d 179 ROWS e PRECEDING 180 ), 181 min(f) OVER ( 182 ORDER BY g 183 RANGE BETWEEN 184 UNBOUNDED PRECEDING 185 AND 186 h FOLLOWING EXCLUDE TIES 187 ) 188 FROM t 189 WINDOW w AS ( 190 PARTITION BY i 191 GROUPS BETWEEN 192 j PRECEDING 193 AND 194 CURRENT ROW EXCLUDE NO OTHERS 195 ) 196 197 40: 198 ---------------------------------------- 199 SELECT sum(a) OVER w, 200 avg(b) OVER ( 201 PARTITION BY c 202 ORDER BY d 203 ROWS e PRECEDING 204 ), 205 min(f) OVER ( 206 ORDER BY g 207 RANGE BETWEEN 208 UNBOUNDED PRECEDING 209 AND 210 h FOLLOWING EXCLUDE TIES 211 ) 212 FROM t 213 WINDOW w AS ( 214 PARTITION BY i 215 GROUPS BETWEEN j PRECEDING 216 AND CURRENT ROW EXCLUDE NO OTHERS 217 ) 218 219 44: 220 -------------------------------------------- 221 SELECT sum(a) OVER w, 222 avg(b) OVER ( 223 PARTITION BY c 224 ORDER BY d 225 ROWS e PRECEDING 226 ), 227 min(f) OVER ( 228 ORDER BY g 229 RANGE BETWEEN UNBOUNDED PRECEDING 230 AND h FOLLOWING EXCLUDE TIES 231 ) 232 FROM t 233 WINDOW w AS ( 234 PARTITION BY i 235 GROUPS BETWEEN j PRECEDING 236 AND CURRENT ROW EXCLUDE NO OTHERS 237 ) 238 239 50: 240 -------------------------------------------------- 241 SELECT sum(a) OVER w, 242 avg(b) OVER ( 243 PARTITION BY c ORDER BY d ROWS e PRECEDING 244 ), 245 min(f) OVER ( 246 ORDER BY g 247 RANGE BETWEEN UNBOUNDED PRECEDING 248 AND h FOLLOWING EXCLUDE TIES 249 ) 250 FROM t 251 WINDOW w AS ( 252 PARTITION BY i 253 GROUPS BETWEEN j PRECEDING 254 AND CURRENT ROW EXCLUDE NO OTHERS 255 ) 256 257 64: 258 ---------------------------------------------------------------- 259 SELECT sum(a) OVER w, 260 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 261 min(f) OVER ( 262 ORDER BY g 263 RANGE BETWEEN UNBOUNDED PRECEDING 264 AND h FOLLOWING EXCLUDE TIES 265 ) 266 FROM t 267 WINDOW w AS ( 268 PARTITION BY i 269 GROUPS BETWEEN j PRECEDING 270 AND CURRENT ROW EXCLUDE NO OTHERS 271 ) 272 273 73: 274 ------------------------------------------------------------------------- 275 SELECT sum(a) OVER w, 276 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 277 min(f) OVER ( 278 ORDER BY g 279 RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 280 ) 281 FROM t 282 WINDOW w AS ( 283 PARTITION BY i 284 GROUPS BETWEEN j PRECEDING 285 AND CURRENT ROW EXCLUDE NO OTHERS 286 ) 287 288 74: 289 -------------------------------------------------------------------------- 290 SELECT sum(a) OVER w, 291 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 292 min(f) OVER ( 293 ORDER BY g 294 RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 295 ) 296 FROM t 297 WINDOW w AS ( 298 PARTITION BY i 299 GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 300 ) 301 302 81: 303 --------------------------------------------------------------------------------- 304 SELECT sum(a) OVER w, 305 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 306 min(f) OVER ( 307 ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 308 ) 309 FROM t 310 WINDOW w AS ( 311 PARTITION BY i 312 GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 313 ) 314 315 83: 316 ----------------------------------------------------------------------------------- 317 SELECT sum(a) OVER w, 318 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 319 min(f) OVER ( 320 ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 321 ) 322 FROM t 323 WINDOW w AS ( 324 PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS 325 ) 326 327 89: 328 ----------------------------------------------------------------------------------------- 329 SELECT sum(a) OVER w, 330 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 331 min(f) OVER ( 332 ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES 333 ) 334 FROM t 335 WINDOW w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS) 336 337 94: 338 ---------------------------------------------------------------------------------------------- 339 SELECT sum(a) OVER w, 340 avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), 341 min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES) 342 FROM t 343 WINDOW w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS) 344 345 167: 346 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- 347 SELECT sum(a) OVER w, avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES) 348 FROM t 349 WINDOW w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS) 350 351 264: 352 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 353 SELECT sum(a) OVER w, avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING), min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES) FROM t WINDOW w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS)