index
:
ydb
add-upcoming-event-1
alexv-smirnov-patch-1
alexv-smirnov1
blinkov-patch-1
docs-dont-link-to-archived-go-sdk
docs-drop-unused-files
docs-gtm
docs-quickstart-add-mkdir
docs-yfm-link
fix-header-ident-bloom
get_cmakelists2
license-year-2023
mai
main
readme-linkedin-link
readme-links-update
readme-social-update
roadmap
stable-22-2
stable-22-4
stable-22-5
stable-23-1
stable-23-2
stable-23-3
Mirror of YDB github repos
about
summary
refs
log
tree
commit
diff
stats
log msg
author
committer
range
path:
root
/
yql
/
essentials
/
tests
/
sql
/
suites
/
window
Mode
Name
Size
-rw-r--r--
agg_factory.sql.txt
59
log
stats
plain
blame
-rw-r--r--
all_columns_hide_window_special_ones.sql
241
log
stats
plain
blame
d---------
current
860
log
stats
plain
-rw-r--r--
default.cfg
40
log
stats
plain
blame
-rw-r--r--
distinct_over_window.cfg
20
log
stats
plain
blame
-rw-r--r--
distinct_over_window.sql
659
log
stats
plain
blame
-rw-r--r--
distinct_over_window_full_frames.cfg
20
log
stats
plain
blame
-rw-r--r--
distinct_over_window_full_frames.sql
725
log
stats
plain
blame
-rw-r--r--
distinct_over_window_struct.sql
1347
log
stats
plain
blame
d---------
empty
192
log
stats
plain
d---------
full
1498
log
stats
plain
d---------
generic
742
log
stats
plain
-rw-r--r--
input.txt
166
log
stats
plain
blame
-rw-r--r--
input2.txt
420
log
stats
plain
blame
-rw-r--r--
input3.txt
369
log
stats
plain
blame
-rw-r--r--
input4.txt
369
log
stats
plain
blame
-rw-r--r--
input5.txt
1170
log
stats
plain
blame
-rw-r--r--
input_intersect.txt
614
log
stats
plain
blame
-rw-r--r--
input_intersect_with_holes.txt
621
log
stats
plain
blame
-rw-r--r--
input_optkey1.txt
177
log
stats
plain
blame
-rw-r--r--
input_optkey1.txt.attr
169
log
stats
plain
blame
-rw-r--r--
input_optkey2.txt
190
log
stats
plain
blame
-rw-r--r--
input_optkey2.txt.attr
170
log
stats
plain
blame
-rw-r--r--
input_tutorial_users.txt
525
log
stats
plain
blame
d---------
lagging
192
log
stats
plain
d---------
leading
192
log
stats
plain
-rw-r--r--
lib1.sql.txt
175
log
stats
plain
blame
d---------
mixed
88
log
stats
plain
-rw-r--r--
multiaggr_subq.sql.txt
294
log
stats
plain
blame
-rw-r--r--
null_type.sql
599
log
stats
plain
blame
-rw-r--r--
p_int32.json
4
log
stats
plain
blame
-rw-r--r--
presort_window_order_by_table.sql
269
log
stats
plain
blame
-rw-r--r--
presort_window_partition_by_mem.sql
152
log
stats
plain
blame
-rw-r--r--
presort_window_partition_by_table.sql
180
log
stats
plain
blame
d---------
rank
307
log
stats
plain
-rw-r--r--
row_number_no_part_from_subq.sql
140
log
stats
plain
blame
-rw-r--r--
row_number_no_part_multi_input.sql
440
log
stats
plain
blame
-rw-r--r--
row_number_to_map.sql
542
log
stats
plain
blame
-rw-r--r--
row_number_to_map_multiple.sql
389
log
stats
plain
blame
-rw-r--r--
row_number_to_map_noncompact.sql
181
log
stats
plain
blame
-rw-r--r--
session1.txt
655
log
stats
plain
blame
-rw-r--r--
session1.txt.attr
241
log
stats
plain
blame
-rw-r--r--
table_funcs_spec_win_func.sqlx
147
log
stats
plain
blame
-rw-r--r--
table_funcs_spec_with_win_func.sqlx
142
log
stats
plain
blame
-rw-r--r--
udaf_no_merge.sql
284
log
stats
plain
blame
-rw-r--r--
udaf_window.cfg
35
log
stats
plain
blame
-rw-r--r--
udaf_window.sql
1345
log
stats
plain
blame
-rw-r--r--
udaf_with_def_value.sql
1656
log
stats
plain
blame
-rw-r--r--
win_aggregate_check01.sqlx
681
log
stats
plain
blame
-rw-r--r--
win_aggregate_check02.sqlx
680
log
stats
plain
blame
-rw-r--r--
win_by_all_aggregate.cfg
78
log
stats
plain
blame
-rw-r--r--
win_by_all_aggregate.sql
1290
log
stats
plain
blame
-rw-r--r--
win_by_all_avg_interval.sql
418
log
stats
plain
blame
-rw-r--r--
win_by_all_percentile_interval.sql
758
log
stats
plain
blame
-rw-r--r--
win_by_simple.sql
144
log
stats
plain
blame
-rw-r--r--
win_expr_bounds.cfg
47
log
stats
plain
blame
-rw-r--r--
win_expr_bounds.sql
258
log
stats
plain
blame
-rw-r--r--
win_extract_members.sql
485
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func.sql
258
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_no_part.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_no_part.sql
225
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_no_part_sorted.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_no_part_sorted.sql
220
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_sort.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_sort.sql
248
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_sort_desc.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_aggr_4func_sort_desc.sql
253
log
stats
plain
blame
-rw-r--r--
win_func_aggr_hist.cfg
47
log
stats
plain
blame
-rw-r--r--
win_func_aggr_hist.sql
254
log
stats
plain
blame
-rw-r--r--
win_func_aggr_stat.cfg
32
log
stats
plain
blame
-rw-r--r--
win_func_aggr_stat.sql
312
log
stats
plain
blame
-rw-r--r--
win_func_aggr_with_qualified_all.cfg
20
log
stats
plain
blame
-rw-r--r--
win_func_aggr_with_qualified_all.sql
269
log
stats
plain
blame
-rw-r--r--
win_func_aggr_with_qualified_all_no_simple_columns.cfg
20
log
stats
plain
blame
-rw-r--r--
win_func_aggr_with_qualified_all_no_simple_columns.sql
285
log
stats
plain
blame
-rw-r--r--
win_func_auto_arg.sql
422
log
stats
plain
blame
-rw-r--r--
win_func_auto_arg_selective_rank.sql
415
log
stats
plain
blame
-rw-r--r--
win_func_auto_arg_two_sort.sql
400
log
stats
plain
blame
-rw-r--r--
win_func_cume_dist.sql
141
log
stats
plain
blame
-rw-r--r--
win_func_cume_dist_ansi.sql
155
log
stats
plain
blame
-rw-r--r--
win_func_first_last.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_first_last.sql
331
log
stats
plain
blame
-rw-r--r--
win_func_first_last_over_nonopt.sql
498
log
stats
plain
blame
-rw-r--r--
win_func_first_last_rev.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_first_last_rev.sql
330
log
stats
plain
blame
-rw-r--r--
win_func_first_last_with_part.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_first_last_with_part.sql
599
log
stats
plain
blame
-rw-r--r--
win_func_in_lib.cfg
46
log
stats
plain
blame
-rw-r--r--
win_func_in_lib.sql
91
log
stats
plain
blame
-rw-r--r--
win_func_into_udf.cfg
33
log
stats
plain
blame
-rw-r--r--
win_func_into_udf.sql
174
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_opt.cfg
49
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_opt.sql
533
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_worm.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_worm.sql
498
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_worm_with_part.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_worm_with_part.sql
597
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_worm_with_part_other.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_lead_lag_worm_with_part_other.sql
586
log
stats
plain
blame
-rw-r--r--
win_func_mutable_resource.sql
176
log
stats
plain
blame
-rw-r--r--
win_func_nth_value.sql
391
log
stats
plain
blame
-rw-r--r--
win_func_ntile.sql
138
log
stats
plain
blame
-rw-r--r--
win_func_on_cloned_source.sql
215
log
stats
plain
blame
-rw-r--r--
win_func_order_by_udf_empty_rank.cfg
20
log
stats
plain
blame
-rw-r--r--
win_func_order_by_udf_empty_rank.sql
308
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by.sql
422
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_compl.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_compl.sql
655
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_list_names.cfg
34
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_list_names.sql
756
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_list_names_order_prefix.cfg
34
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_list_names_order_prefix.sql
673
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_with_having.sqlx
424
log
stats
plain
blame
-rw-r--r--
win_func_over_group_by_with_where.sqlx
403
log
stats
plain
blame
-rw-r--r--
win_func_part_by_expr.cfg
34
log
stats
plain
blame
-rw-r--r--
win_func_part_by_expr.sql
338
log
stats
plain
blame
-rw-r--r--
win_func_part_by_expr_new.sql
274
log
stats
plain
blame
-rw-r--r--
win_func_percent_rank.sql
168
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_all.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_all.sql
329
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_opt_all.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_opt_all.sql
324
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_opt_part.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_opt_part.sql
438
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_part.cfg
40
log
stats
plain
blame
-rw-r--r--
win_func_rank_by_part.sql
443
log
stats
plain
blame
-rw-r--r--
win_func_rank_with_order_by_aggr_key.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_rank_with_order_by_aggr_key.sql
111
log
stats
plain
blame
-rw-r--r--
win_func_spec_with_part.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_spec_with_part.sql
431
log
stats
plain
blame
-rw-r--r--
win_func_special.cfg
29
log
stats
plain
blame
-rw-r--r--
win_func_special.sql
324
log
stats
plain
blame
-rw-r--r--
win_func_with_group_by.sqlx
170
log
stats
plain
blame
-rw-r--r--
win_func_with_struct_access.sql
454
log
stats
plain
blame
-rw-r--r--
win_func_with_struct_access_full_access.sql
461
log
stats
plain
blame
-rw-r--r--
win_fuse_window.sql
925
log
stats
plain
blame
-rw-r--r--
win_group_peephole.sql
372
log
stats
plain
blame
-rw-r--r--
win_inline_spec.sql
299
log
stats
plain
blame
-rw-r--r--
win_lead_in_mem.sql
294
log
stats
plain
blame
-rw-r--r--
win_multiaggr.sql
260
log
stats
plain
blame
-rw-r--r--
win_multiaggr_library.cfg
107
log
stats
plain
blame
-rw-r--r--
win_multiaggr_library.sql
188
log
stats
plain
blame
-rw-r--r--
win_multiaggr_list.sql
236
log
stats
plain
blame
-rw-r--r--
win_multiaggr_tuple.sql
238
log
stats
plain
blame
-rw-r--r--
win_over_few_partitions.cfg
34
log
stats
plain
blame
-rw-r--r--
win_over_few_partitions.sql
401
log
stats
plain
blame
-rw-r--r--
win_over_few_partitions_other.cfg
34
log
stats
plain
blame
-rw-r--r--
win_over_few_partitions_other.sql
434
log
stats
plain
blame
-rw-r--r--
win_over_joined.cfg
41
log
stats
plain
blame
-rw-r--r--
win_over_joined.sql
168
log
stats
plain
blame
-rw-r--r--
win_peephole.sql
358
log
stats
plain
blame
-rw-r--r--
win_peephole_double_usage.sql
248
log
stats
plain
blame
-rw-r--r--
win_with_as_table.sql
201
log
stats
plain
blame
-rw-r--r--
win_with_cur_row.cfg
34
log
stats
plain
blame
-rw-r--r--
win_with_cur_row.sql
266
log
stats
plain
blame
-rw-r--r--
yql-14179.sql
151
log
stats
plain
blame
-rw-r--r--
yql-14277.sql
473
log
stats
plain
blame
-rw-r--r--
yql-14479.sql
241
log
stats
plain
blame
-rw-r--r--
yql-14738.sql
275
log
stats
plain
blame
-rw-r--r--
yql-15636.sql
676
log
stats
plain
blame
-rw-r--r--
yql-18879.sql
1186
log
stats
plain
blame