window.diff
text/x-patch
Filename: window.diff
Type: text/x-patch
Part: 2
662c662 < select x, lag(x, 1) over (order by x), lead(x, 3) over (order by x) --- > select x, lag(x, 1) ignore nulls over (order by x), lead(x, 3) ignore nulls over (order by x) 681c681 < last_value(ten) over (partition by four order by ten) --- > last_value(ten) ignore nulls over (partition by four order by ten) 709c709 < last_value(ten) over (partition by four order by ten range between unbounded preceding and current row) --- > last_value(ten) ignore nulls over (partition by four order by ten range between unbounded preceding and current row) 737c737 < last_value(ten) over (partition by four order by ten range between unbounded preceding and unbounded following) --- > last_value(ten) ignore nulls over (partition by four order by ten range between unbounded preceding and unbounded following) 765c765 < last_value(ten/4) over (partition by four order by ten/4 range between unbounded preceding and current row) --- > last_value(ten/4) ignore nulls over (partition by four order by ten/4 range between unbounded preceding and current row) 793c793 < last_value(ten/4) over (partition by four order by ten/4 rows between unbounded preceding and current row) --- > last_value(ten/4) ignore nulls over (partition by four order by ten/4 rows between unbounded preceding and current row) 938c938 < SELECT first_value(unique1) over (ORDER BY four rows between current row and 2 following exclude current row), --- > SELECT first_value(unique1) ignore nulls over (ORDER BY four rows between current row and 2 following exclude current row), 955c955 < SELECT first_value(unique1) over (ORDER BY four rows between current row and 2 following exclude group), --- > SELECT first_value(unique1) ignore nulls over (ORDER BY four rows between current row and 2 following exclude group), 972c972 < SELECT first_value(unique1) over (ORDER BY four rows between current row and 2 following exclude ties), --- > SELECT first_value(unique1) ignore nulls over (ORDER BY four rows between current row and 2 following exclude ties), 989c989 < SELECT last_value(unique1) over (ORDER BY four rows between current row and 2 following exclude current row), --- > SELECT last_value(unique1) ignore nulls over (ORDER BY four rows between current row and 2 following exclude current row), 1006c1006 < SELECT last_value(unique1) over (ORDER BY four rows between current row and 2 following exclude group), --- > SELECT last_value(unique1) ignore nulls over (ORDER BY four rows between current row and 2 following exclude group), 1023c1023 < SELECT last_value(unique1) over (ORDER BY four rows between current row and 2 following exclude ties), --- > SELECT last_value(unique1) ignore nulls over (ORDER BY four rows between current row and 2 following exclude ties), 1159,1161c1159,1161 < SELECT first_value(unique1) over w, < nth_value(unique1, 2) over w AS nth_2, < last_value(unique1) over w, unique1, four --- > SELECT first_value(unique1) ignore nulls over w, > nth_value(unique1, 2) ignore nulls over w AS nth_2, > last_value(unique1) ignore nulls over w, unique1, four 1631,1633c1631,1633 < select first_value(salary) over(order by salary range between 1000 preceding and 1000 following), < lead(salary) over(order by salary range between 1000 preceding and 1000 following), < nth_value(salary, 1) over(order by salary range between 1000 preceding and 1000 following), --- > select first_value(salary) ignore nulls over(order by salary range between 1000 preceding and 1000 following), > lead(salary) ignore nulls over(order by salary range between 1000 preceding and 1000 following), > nth_value(salary, 1) ignore nulls over(order by salary range between 1000 preceding and 1000 following), 1649,1650c1649,1650 < select last_value(salary) over(order by salary range between 1000 preceding and 1000 following), < lag(salary) over(order by salary range between 1000 preceding and 1000 following), --- > select last_value(salary) ignore nulls over(order by salary range between 1000 preceding and 1000 following), > lag(salary) ignore nulls over(order by salary range between 1000 preceding and 1000 following), 1666c1666 < select first_value(salary) over(order by salary range between 1000 following and 3000 following --- > select first_value(salary) ignore nulls over(order by salary range between 1000 following and 3000 following 1668,1669c1668,1669 < lead(salary) over(order by salary range between 1000 following and 3000 following exclude ties), < nth_value(salary, 1) over(order by salary range between 1000 following and 3000 following --- > lead(salary) ignore nulls over(order by salary range between 1000 following and 3000 following exclude ties), > nth_value(salary, 1) ignore nulls over(order by salary range between 1000 following and 3000 following 1686c1686 < select last_value(salary) over(order by salary range between 1000 following and 3000 following --- > select last_value(salary) ignore nulls over(order by salary range between 1000 following and 3000 following 1688c1688 < lag(salary) over(order by salary range between 1000 following and 3000 following exclude group), --- > lag(salary) ignore nulls over(order by salary range between 1000 following and 3000 following exclude group), 1704c1704 < select first_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > select first_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1706c1706 < last_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following), --- > last_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following), 1722c1722 < select first_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > select first_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1724c1724 < last_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > last_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1741c1741 < select first_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > select first_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1743c1743 < last_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > last_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1760c1760 < select first_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > select first_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1762c1762 < last_value(salary) over(order by enroll_date range between unbounded preceding and '1 year'::interval following --- > last_value(salary) ignore nulls over(order by enroll_date range between unbounded preceding and '1 year'::interval following 1781,1782c1781,1782 < first_value(y) over w, < last_value(y) over w --- > first_value(y) ignore nulls over w, > last_value(y) ignore nulls over w 1801,1802c1801,1802 < first_value(y) over w, < last_value(y) over w --- > first_value(y) ignore nulls over w, > last_value(y) ignore nulls over w 1821,1822c1821,1822 < first_value(y) over w, < last_value(y) over w --- > first_value(y) ignore nulls over w, > last_value(y) ignore nulls over w 1841,1842c1841,1842 < first_value(y) over w, < last_value(y) over w --- > first_value(y) ignore nulls over w, > last_value(y) ignore nulls over w 2001c2001 < select x, last_value(x) over (order by x::smallint range between current row and 2147450884 following) --- > select x, last_value(x) ignore nulls over (order by x::smallint range between current row and 2147450884 following) 2010c2010 < select x, last_value(x) over (order by x::smallint desc range between current row and 2147450885 following) --- > select x, last_value(x) ignore nulls over (order by x::smallint desc range between current row and 2147450885 following) 2019c2019 < select x, last_value(x) over (order by x range between current row and 4 following) --- > select x, last_value(x) ignore nulls over (order by x range between current row and 4 following) 2028c2028 < select x, last_value(x) over (order by x desc range between current row and 5 following) --- > select x, last_value(x) ignore nulls over (order by x desc range between current row and 5 following) 2037c2037 < select x, last_value(x) over (order by x range between current row and 4 following) --- > select x, last_value(x) ignore nulls over (order by x range between current row and 4 following) 2046c2046 < select x, last_value(x) over (order by x desc range between current row and 5 following) --- > select x, last_value(x) ignore nulls over (order by x desc range between current row and 5 following) 2073c2073 < select id, f_float4, first_value(id) over w, last_value(id) over w --- > select id, f_float4, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2091c2091 < select id, f_float4, first_value(id) over w, last_value(id) over w --- > select id, f_float4, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2109c2109 < select id, f_float4, first_value(id) over w, last_value(id) over w --- > select id, f_float4, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2127c2127 < select id, f_float4, first_value(id) over w, last_value(id) over w --- > select id, f_float4, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2145c2145 < select id, f_float4, first_value(id) over w, last_value(id) over w --- > select id, f_float4, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2163c2163 < select id, f_float4, first_value(id) over w, last_value(id) over w --- > select id, f_float4, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2168c2168 < select id, f_float8, first_value(id) over w, last_value(id) over w --- > select id, f_float8, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2186c2186 < select id, f_float8, first_value(id) over w, last_value(id) over w --- > select id, f_float8, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2204c2204 < select id, f_float8, first_value(id) over w, last_value(id) over w --- > select id, f_float8, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2222c2222 < select id, f_float8, first_value(id) over w, last_value(id) over w --- > select id, f_float8, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2240c2240 < select id, f_float8, first_value(id) over w, last_value(id) over w --- > select id, f_float8, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2258c2258 < select id, f_float8, first_value(id) over w, last_value(id) over w --- > select id, f_float8, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2263c2263 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2281c2281 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2299c2299 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2307c2307 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2325c2325 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2343c2343 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2361c2361 < select id, f_numeric, first_value(id) over w, last_value(id) over w --- > select id, f_numeric, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2388c2388 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2408c2408 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2428c2428 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2433c2433 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2453c2453 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2473c2473 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2493c2493 < select id, f_time, first_value(id) over w, last_value(id) over w --- > select id, f_time, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2499c2499 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2519c2519 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2539c2539 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2544c2544 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2564c2564 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2584c2584 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2604c2604 < select id, f_timetz, first_value(id) over w, last_value(id) over w --- > select id, f_timetz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2610c2610 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2630c2630 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2650c2650 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2655c2655 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2675c2675 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2695c2695 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2715c2715 < select id, f_interval, first_value(id) over w, last_value(id) over w --- > select id, f_interval, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2721c2721 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2741c2741 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2761c2761 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2766c2766 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2786c2786 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2806c2806 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2826c2826 < select id, f_timestamptz, first_value(id) over w, last_value(id) over w --- > select id, f_timestamptz, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2832c2832 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2852c2852 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2872c2872 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2877c2877 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2897c2897 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2917c2917 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 2937c2937 < select id, f_timestamp, first_value(id) over w, last_value(id) over w --- > select id, f_timestamp, first_value(id) ignore nulls over w, last_value(id) ignore nulls over w 3253,3255c3253,3255 < select first_value(salary) over(order by enroll_date groups between 1 preceding and 1 following), < lead(salary) over(order by enroll_date groups between 1 preceding and 1 following), < nth_value(salary, 1) over(order by enroll_date groups between 1 preceding and 1 following), --- > select first_value(salary) ignore nulls over(order by enroll_date groups between 1 preceding and 1 following), > lead(salary) ignore nulls over(order by enroll_date groups between 1 preceding and 1 following), > nth_value(salary, 1) ignore nulls over(order by enroll_date groups between 1 preceding and 1 following), 3271,3272c3271,3272 < select last_value(salary) over(order by enroll_date groups between 1 preceding and 1 following), < lag(salary) over(order by enroll_date groups between 1 preceding and 1 following), --- > select last_value(salary) ignore nulls over(order by enroll_date groups between 1 preceding and 1 following), > lag(salary) ignore nulls over(order by enroll_date groups between 1 preceding and 1 following), 3288c3288 < select first_value(salary) over(order by enroll_date groups between 1 following and 3 following --- > select first_value(salary) ignore nulls over(order by enroll_date groups between 1 following and 3 following 3290,3291c3290,3291 < lead(salary) over(order by enroll_date groups between 1 following and 3 following exclude ties), < nth_value(salary, 1) over(order by enroll_date groups between 1 following and 3 following --- > lead(salary) ignore nulls over(order by enroll_date groups between 1 following and 3 following exclude ties), > nth_value(salary, 1) ignore nulls over(order by enroll_date groups between 1 following and 3 following 3308c3308 < select last_value(salary) over(order by enroll_date groups between 1 following and 3 following --- > select last_value(salary) ignore nulls over(order by enroll_date groups between 1 following and 3 following 3310c3310 < lag(salary) over(order by enroll_date groups between 1 following and 3 following exclude group), --- > lag(salary) ignore nulls over(order by enroll_date groups between 1 following and 3 following exclude group),