github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/window.ref.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  17:
    42  -----------------
    43  SELECT
    44  	sum(
    45  		a
    46  	) OVER w,
    47  	avg(b) OVER (
    48  		PARTITION BY
    49  			c
    50  		ORDER BY
    51  			d
    52  		ROWS
    53  			e PRECEDING
    54  	),
    55  	min(f) OVER (
    56  		ORDER BY
    57  			g
    58  		RANGE
    59  			BETWEEN
    60  				UNBOUNDED PRECEDING
    61  			AND
    62  				h FOLLOWING EXCLUDE TIES
    63  	)
    64  FROM
    65  	t
    66  WINDOW
    67  	w AS (
    68  		PARTITION BY
    69  			i
    70  		GROUPS
    71  			BETWEEN
    72  				j PRECEDING
    73  			AND
    74  				CURRENT ROW EXCLUDE NO OTHERS
    75  	)
    76  
    77  18:
    78  ------------------
    79  SELECT
    80  	sum(a) OVER w,
    81  	avg(b) OVER (
    82  		PARTITION BY
    83  			c
    84  		ORDER BY
    85  			d
    86  		ROWS
    87  			e PRECEDING
    88  	),
    89  	min(f) OVER (
    90  		ORDER BY
    91  			g
    92  		RANGE
    93  			BETWEEN
    94  				UNBOUNDED PRECEDING
    95  			AND
    96  				h FOLLOWING EXCLUDE TIES
    97  	)
    98  FROM
    99  	t
   100  WINDOW
   101  	w AS (
   102  		PARTITION BY
   103  			i
   104  		GROUPS
   105  			BETWEEN
   106  				j PRECEDING
   107  			AND
   108  				CURRENT ROW EXCLUDE NO OTHERS
   109  	)
   110  
   111  50:
   112  --------------------------------------------------
   113  SELECT
   114  	sum(a) OVER w,
   115  	avg(b) OVER (
   116  		PARTITION BY c ORDER BY d ROWS e PRECEDING
   117  	),
   118  	min(f) OVER (
   119  		ORDER BY
   120  			g
   121  		RANGE
   122  			BETWEEN
   123  				UNBOUNDED PRECEDING
   124  			AND
   125  				h FOLLOWING EXCLUDE TIES
   126  	)
   127  FROM
   128  	t
   129  WINDOW
   130  	w AS (
   131  		PARTITION BY
   132  			i
   133  		GROUPS
   134  			BETWEEN
   135  				j PRECEDING
   136  			AND
   137  				CURRENT ROW EXCLUDE NO OTHERS
   138  	)
   139  
   140  61:
   141  -------------------------------------------------------------
   142  SELECT
   143  	sum(a) OVER w,
   144  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   145  	min(f) OVER (
   146  		ORDER BY
   147  			g
   148  		RANGE
   149  			BETWEEN
   150  				UNBOUNDED PRECEDING
   151  			AND
   152  				h FOLLOWING EXCLUDE TIES
   153  	)
   154  FROM
   155  	t
   156  WINDOW
   157  	w AS (
   158  		PARTITION BY
   159  			i
   160  		GROUPS
   161  			BETWEEN
   162  				j PRECEDING
   163  			AND
   164  				CURRENT ROW EXCLUDE NO OTHERS
   165  	)
   166  
   167  65:
   168  -----------------------------------------------------------------
   169  SELECT
   170  	sum(a) OVER w,
   171  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   172  	min(f) OVER (
   173  		ORDER BY
   174  			g
   175  		RANGE
   176  			BETWEEN
   177  				UNBOUNDED PRECEDING
   178  			AND
   179  				h FOLLOWING EXCLUDE TIES
   180  	)
   181  FROM
   182  	t
   183  WINDOW
   184  	w AS (
   185  		PARTITION BY
   186  			i
   187  		GROUPS
   188  			BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS
   189  	)
   190  
   191  68:
   192  --------------------------------------------------------------------
   193  SELECT
   194  	sum(a) OVER w,
   195  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   196  	min(f) OVER (
   197  		ORDER BY
   198  			g
   199  		RANGE
   200  			BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES
   201  	)
   202  FROM
   203  	t
   204  WINDOW
   205  	w AS (
   206  		PARTITION BY
   207  			i
   208  		GROUPS
   209  			BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS
   210  	)
   211  
   212  81:
   213  ---------------------------------------------------------------------------------
   214  SELECT
   215  	sum(a) OVER w,
   216  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   217  	min(f) OVER (
   218  		ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES
   219  	)
   220  FROM
   221  	t
   222  WINDOW
   223  	w AS (
   224  		PARTITION BY
   225  			i
   226  		GROUPS
   227  			BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS
   228  	)
   229  
   230  83:
   231  -----------------------------------------------------------------------------------
   232  SELECT
   233  	sum(a) OVER w,
   234  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   235  	min(f) OVER (
   236  		ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES
   237  	)
   238  FROM
   239  	t
   240  WINDOW
   241  	w AS (
   242  		PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS
   243  	)
   244  
   245  86:
   246  --------------------------------------------------------------------------------------
   247  SELECT
   248  	sum(a) OVER w,
   249  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   250  	min(f) OVER (
   251  		ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES
   252  	)
   253  FROM
   254  	t
   255  WINDOW
   256  	w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS)
   257  
   258  91:
   259  -------------------------------------------------------------------------------------------
   260  SELECT
   261  	sum(a) OVER w,
   262  	avg(b) OVER (PARTITION BY c ORDER BY d ROWS e PRECEDING),
   263  	min(f) OVER (ORDER BY g RANGE BETWEEN UNBOUNDED PRECEDING AND h FOLLOWING EXCLUDE TIES)
   264  FROM
   265  	t
   266  WINDOW
   267  	w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS)
   268  
   269  164:
   270  --------------------------------------------------------------------------------------------------------------------------------------------------------------------
   271  SELECT
   272  	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)
   273  FROM
   274  	t
   275  WINDOW
   276  	w AS (PARTITION BY i GROUPS BETWEEN j PRECEDING AND CURRENT ROW EXCLUDE NO OTHERS)
   277  
   278  264:
   279  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   280  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)