/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/ |
H A D | lead_lag.test | 6 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 D | lead_lag_explain.test | 196 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 D | gpexamp_copper.inp | 10 ***************** 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 D | mcs128_window_function_lead.test | 2 # 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 D | mcs157_win_frame_lead.test | 2 # 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 D | mcs128_window_function_lead.test | 2 # 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 D | mcs157_win_frame_lead.test | 2 # 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 D | mcs128_window_function_lead.result | 6 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 D | mcs157_win_frame_lead.result | 6 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 D | mcs128_window_function_lead.result | 6 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 D | mcs157_win_frame_lead.result | 6 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 D | Macil1.vc | 57 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 D | shift.c | 7 …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 D | TableColumnSWTUtils.java | 37 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 D | lead_lag_explain.result | 3413 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 D | Unicode.h | 269 #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 D | TablesCells.trans | 133 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 D | Unicode.h | 379 #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 D | Unicode.h | 379 #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 D | Unicode.h | 379 #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 D | mkfilelist | 36 read LEAD NAME READ 38 case $LEAD in
|
/dports/astro/gpsbabel/gpsbabel-gpsbabel_1_7_0/tools/ |
H A D | mkfilelist | 36 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 D | Roles | 45 #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 D | Unicode.h | 293 #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 D | Unicode.h | 369 #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()
|