Home
last modified time | relevance | path

Searched refs:LEAD (Results 1 – 25 of 920) sorted by relevance

12345678910>>...37

/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/
H A Dlead_lag.test6 SELECT LEAD(6, 0) OVER ();
7 SELECT LEAD(NULL, 0) OVER ();
10 SELECT LEAD(6, 1) OVER ();
11 SELECT LEAD(NULL, 1) OVER ();
14 SELECT LEAD(6, 1, 7) OVER ();
15 SELECT LEAD(NULL, 1, 7) OVER ();
255 LEAD(d, 2) OVER w le2,
260 LEAD(d, 2) OVER w le2,
456 LEAD(i,2) OVER w le2,
586 SELECT LEAD(a,2) over w1, LEAD(a,1) OVER w1 FROM t1e WINDOW w1 as ();
[all …]
H A Dlead_lag_explain.test196 LEAD(d, 2) OVER w le2,
201 LEAD(d, 2) OVER w le2,
206 LEAD(d, 2) OVER w le2,
211 LEAD(d, 2) OVER w le2,
216 LEAD(d, 2) OVER w le2,
221 LEAD(d, 2) OVER w le2,
226 LEAD(d, 2) OVER w le2,
231 LEAD(d, 2) OVER w le2,
237 LEAD(d, 2) OVER w le2,
242 LEAD(d, 2) OVER w le2,
[all …]
/dports/science/fasthenry/fasthenry-3.0wr/examples/
H A Dgpexamp_copper.inp10 ***************** LEAD #33 *****************
18 ***************** LEAD #34 *****************
26 ***************** LEAD #35 *****************
29 ***************** LEAD #36 *****************
37 ***************** LEAD #37 *****************
45 ***************** LEAD #38 *****************
53 ***************** LEAD #39 *****************
56 ***************** LEAD #40 *****************
64 ***************** LEAD #41 *****************
72 ***************** LEAD #42 *****************
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs128_window_function_lead.test2 # Test LEAD() Window Function
17 SELECT a, b, LEAD(a) OVER(ORDER BY a) lead_value FROM t1;
18 SELECT a, b, LEAD(b) OVER(ORDER BY b DESC) lead_value FROM t1;
19 SELECT a, b, LEAD(a) OVER(ORDER BY b) lead_value FROM t1;
20 SELECT a, b, LEAD(b) OVER(ORDER BY a DESC) lead_value FROM t1;
21 SELECT a, b, LEAD(b, 0) OVER(ORDER BY a DESC) lead_value FROM t1;
22 SELECT a, b, LEAD(b, -1) OVER(ORDER BY a DESC) lead_value FROM t1;
23 SELECT a, b, LEAD(b, 2) OVER(ORDER BY a DESC) lead_value FROM t1;
25 SELECT a, b, LEAD(b) OVER w lead_value FROM t1 WINDOW w AS (ORDER BY b);
38 SELECT a, b, LEAD(a) OVER(PARTITION BY b) lead_value FROM t1;
[all …]
H A Dmcs157_win_frame_lead.test2 # Test LEAD() Window Frame
17 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_value …
18 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_value …
19 SELECT a, b, LEAD(b, 2) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM t…
20 SELECT a, b, LEAD(b, 0) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM t…
21 SELECT a, b, LEAD(b, -1) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) lead_val…
23 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_v…
24 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_v…
25 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM…
26 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM…
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs128_window_function_lead.test2 # Test LEAD() Window Function
17 SELECT a, b, LEAD(a) OVER(ORDER BY a) lead_value FROM t1;
18 SELECT a, b, LEAD(b) OVER(ORDER BY b DESC) lead_value FROM t1;
19 SELECT a, b, LEAD(a) OVER(ORDER BY b) lead_value FROM t1;
20 SELECT a, b, LEAD(b) OVER(ORDER BY a DESC) lead_value FROM t1;
21 SELECT a, b, LEAD(b, 0) OVER(ORDER BY a DESC) lead_value FROM t1;
22 SELECT a, b, LEAD(b, -1) OVER(ORDER BY a DESC) lead_value FROM t1;
23 SELECT a, b, LEAD(b, 2) OVER(ORDER BY a DESC) lead_value FROM t1;
25 SELECT a, b, LEAD(b) OVER w lead_value FROM t1 WINDOW w AS (ORDER BY b);
38 SELECT a, b, LEAD(a) OVER(PARTITION BY b) lead_value FROM t1;
[all …]
H A Dmcs157_win_frame_lead.test2 # Test LEAD() Window Frame
17 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_value …
18 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_value …
19 SELECT a, b, LEAD(b, 2) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM t…
20 SELECT a, b, LEAD(b, 0) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM t…
21 SELECT a, b, LEAD(b, -1) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) lead_val…
23 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_v…
24 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_v…
25 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM…
26 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM…
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs128_window_function_lead.result6 SELECT a, b, LEAD(a) OVER(ORDER BY a) lead_value FROM t1;
17 SELECT a, b, LEAD(b) OVER(ORDER BY b DESC) lead_value FROM t1;
28 SELECT a, b, LEAD(a) OVER(ORDER BY b) lead_value FROM t1;
39 SELECT a, b, LEAD(b) OVER(ORDER BY a DESC) lead_value FROM t1;
50 SELECT a, b, LEAD(b, 0) OVER(ORDER BY a DESC) lead_value FROM t1;
61 SELECT a, b, LEAD(b, -1) OVER(ORDER BY a DESC) lead_value FROM t1;
72 SELECT a, b, LEAD(b, 2) OVER(ORDER BY a DESC) lead_value FROM t1;
83 SELECT a, b, LEAD(a) OVER w lead_value FROM t1 WINDOW w AS (ORDER BY a DESC);
94 SELECT a, b, LEAD(b) OVER w lead_value FROM t1 WINDOW w AS (ORDER BY b);
215 SELECT a, b, LEAD(a) OVER(PARTITION BY b) lead_value FROM t1;
[all …]
H A Dmcs157_win_frame_lead.result6 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_value …
17 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_value …
28 SELECT a, b, LEAD(b, 2) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM t…
39 SELECT a, b, LEAD(b, 0) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM t…
50 SELECT a, b, LEAD(b, -1) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) lead_val…
61 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_v…
72 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_v…
83 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM…
94 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM…
105 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) lead_va…
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs128_window_function_lead.result6 SELECT a, b, LEAD(a) OVER(ORDER BY a) lead_value FROM t1;
17 SELECT a, b, LEAD(b) OVER(ORDER BY b DESC) lead_value FROM t1;
28 SELECT a, b, LEAD(a) OVER(ORDER BY b) lead_value FROM t1;
39 SELECT a, b, LEAD(b) OVER(ORDER BY a DESC) lead_value FROM t1;
50 SELECT a, b, LEAD(b, 0) OVER(ORDER BY a DESC) lead_value FROM t1;
61 SELECT a, b, LEAD(b, -1) OVER(ORDER BY a DESC) lead_value FROM t1;
72 SELECT a, b, LEAD(b, 2) OVER(ORDER BY a DESC) lead_value FROM t1;
83 SELECT a, b, LEAD(a) OVER w lead_value FROM t1 WINDOW w AS (ORDER BY a DESC);
94 SELECT a, b, LEAD(b) OVER w lead_value FROM t1 WINDOW w AS (ORDER BY b);
215 SELECT a, b, LEAD(a) OVER(PARTITION BY b) lead_value FROM t1;
[all …]
H A Dmcs157_win_frame_lead.result6 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_value …
17 SELECT a, b, LEAD(b) OVER(ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_value …
28 SELECT a, b, LEAD(b, 2) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM t…
39 SELECT a, b, LEAD(b, 0) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM t…
50 SELECT a, b, LEAD(b, -1) OVER(ORDER BY b ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) lead_val…
61 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) lead_v…
72 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) lead_v…
83 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) lead_value FROM…
94 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) lead_value FROM…
105 SELECT a, b, LEAD(a) OVER(ORDER BY b DESC ROWS BETWEEN 1 PRECEDING AND UNBOUNDED FOLLOWING) lead_va…
[all …]
/dports/games/vavoom/vavoom-1.33/progs/common/linespec/
H A DMacil1.vc57 LEAD ABCD 6 A_Wander
61 LEAD AABBCCDD 3 A_Chase
64 LEAD E 2 A_FaceTarget
65 LEAD F 2 Bright A_ShootGun
66 LEAD E 1 A_SentinelRefire
69 LEAD Y 3
70 LEAD Y 3 A_Pain
/dports/devel/R-cran-data.table/data.table/src/
H A Dshift.c7 …enum {LAG, LEAD/*, SHIFT, CYCLIC*/} stype = LAG; // currently SHIFT maps to LAG and CYCLIC is unim… in shift() enumerator
24 else if (!strcmp(CHAR(STRING_ELT(type, 0)), "lead")) stype = LEAD; in shift()
49 if ((stype == LAG && kd[j] >= 0) || (stype == LEAD && kd[j] < 0)) { in shift()
82 if ((stype == LAG && kd[j] >= 0) || (stype == LEAD && kd[j] < 0)) { in shift()
103 if ((stype == LAG && kd[j] >= 0) || (stype == LEAD && kd[j] < 0)) { in shift()
124 if ((stype == LAG && kd[j] >= 0) || (stype == LEAD && kd[j] < 0)) { in shift()
142 if ((stype == LAG && kd[j] >= 0) || (stype == LEAD && kd[j] < 0)) { in shift()
159 if ((stype == LAG && kd[j] >= 0) || (stype == LEAD && kd[j] < 0)) { in shift()
/dports/net-p2p/vuze/vuze-5.7.4.0_2/org/gudy/azureus2/ui/swt/views/table/utils/
H A DTableColumnSWTUtils.java37 swt = SWT.LEAD; in convertColumnAlignmentToSWT()
41 swt = SWT.LEAD; in convertColumnAlignmentToSWT()
53 if ((align & SWT.LEAD) != 0) { in convertSWTAlignmentToColumn()
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dlead_lag_explain.result3413 LEAD(d, 2) OVER w le2,
3471 LEAD(d, 2) OVER w le2,
3529 LEAD(d, 2) OVER w le2,
3586 LEAD(d, 2) OVER w le2,
3643 LEAD(d, 2) OVER w le2,
3700 LEAD(d, 2) OVER w le2,
3757 LEAD(d, 2) OVER w le2,
3814 LEAD(d, 2) OVER w le2,
3872 LEAD(d, 2) OVER w le2,
3931 LEAD(d, 2) OVER w le2,
[all …]
/dports/www/firefox-legacy/firefox-52.8.0esr/js/src/vm/
H A DUnicode.h269 #define CHECK_RANGE(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ argument
270 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \
292 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToUpperCaseNonBMPTrail() argument
293 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToUpperCaseNonBMPTrail()
304 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToLowerCaseNonBMPTrail() argument
305 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToLowerCaseNonBMPTrail()
/dports/textproc/po4a/po4a-0.65/t/fmt/asciidoc/
H A DTablesCells.trans133 a|THIS CELL IS PREFIXED WITH AN `A`, SO THE PROCESSOR HONORS THE `LEAD` STYLE ON THE FOLLOWING PARA…
135 [.LEAD]
136 I AM A PARAGRAPH STYLED WITH THE LEAD ATTRIBUTE.
137 |THIS CELL *IS NOT* PREFIXED WITH AN `A`, SO THE PROCESSOR DOES NOT HONOR THE `LEAD` STYLE ON THE F…
139 [.LEAD]
140 I AM A PARAGRAPH STYLED WITH THE LEAD ATTRIBUTE.
/dports/www/firefox-esr/firefox-91.8.0/js/src/util/
H A DUnicode.h379 #define CHECK_RANGE(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ argument
380 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) return true;
395 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToUpperCaseNonBMPTrail() argument
396 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToUpperCaseNonBMPTrail()
405 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToLowerCaseNonBMPTrail() argument
406 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToLowerCaseNonBMPTrail()
/dports/www/firefox/firefox-99.0/js/src/util/
H A DUnicode.h379 #define CHECK_RANGE(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ argument
380 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) return true;
395 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToUpperCaseNonBMPTrail() argument
396 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToUpperCaseNonBMPTrail()
405 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToLowerCaseNonBMPTrail() argument
406 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToLowerCaseNonBMPTrail()
/dports/mail/thunderbird/thunderbird-91.8.0/js/src/util/
H A DUnicode.h379 #define CHECK_RANGE(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ argument
380 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) return true;
395 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToUpperCaseNonBMPTrail() argument
396 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToUpperCaseNonBMPTrail()
405 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToLowerCaseNonBMPTrail() argument
406 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToLowerCaseNonBMPTrail()
/dports/astro/gpsbabel14/gpsbabel-1.4.4/tools/
H A Dmkfilelist36 read LEAD NAME READ
38 case $LEAD in
/dports/astro/gpsbabel/gpsbabel-gpsbabel_1_7_0/tools/
H A Dmkfilelist36 read LEAD NAME READ
38 case $LEAD in
/dports/devel/py-opengrok-tools/opengrok-1.3.16/ext/SampleRazorRepository/Repository/OpenGrokSample/RAZOR_UNIVERSE/Tables/
H A DRoles45 #LEAD jones, smith, brown, martin
46 #LEAD phil, fred, steve, jane
47 #LEAD donna, mary
50 #LEAD = jones, smith, brown, martin, phil, fred, steve, jane, donna, mary
/dports/lang/spidermonkey60/firefox-60.9.0/js/src/util/
H A DUnicode.h293 #define CHECK_RANGE(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ argument
294 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) return true;
309 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToUpperCaseNonBMPTrail() argument
310 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToUpperCaseNonBMPTrail()
319 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToLowerCaseNonBMPTrail() argument
320 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToLowerCaseNonBMPTrail()
/dports/lang/spidermonkey78/firefox-78.9.0/js/src/util/
H A DUnicode.h369 #define CHECK_RANGE(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ argument
370 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) return true;
385 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToUpperCaseNonBMPTrail() argument
386 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToUpperCaseNonBMPTrail()
395 #define CALC_TRAIL(FROM, TO, LEAD, TRAIL_FROM, TRAIL_TO, DIFF) \ in ToLowerCaseNonBMPTrail() argument
396 if (lead == LEAD && trail >= TRAIL_FROM && trail <= TRAIL_TO) \ in ToLowerCaseNonBMPTrail()

12345678910>>...37