Home
last modified time | relevance | path

Searched refs:EXTRACT (Results 1 – 25 of 3244) sorted by relevance

12345678910>>...130

/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/
H A Dfunc_extract.test7 EXTRACT(DAY FROM t),
12 EXTRACT(DAY FROM d),
17 EXTRACT(DAY FROM v),
57 SELECT a, b, EXTRACT(DAY_HOUR FROM a), EXTRACT(DAY_HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(DAY_HOUR…
58 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
59 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
60 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
61 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
62 SELECT a, b, EXTRACT(MICROSECOND FROM a), EXTRACT(MICROSECOND FROM b) FROM t1 WHERE NOT (EXTRACT(MI…
69 EXTRACT(DAY FROM a) * 24 + EXTRACT(HOUR FROM a) AS dh,
[all …]
H A Dfunc_extract.result77 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
78 a b EXTRACT(DAY FROM a) EXTRACT(DAY FROM b)
79 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
80 a b EXTRACT(HOUR FROM a) EXTRACT(HOUR FROM b)
81 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
82 a b EXTRACT(MINUTE FROM a) EXTRACT(MINUTE FROM b)
83 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
99 a cidm dh EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY FROM a) EXTRACT(HOUR FROM a) EXTRACT(MINUTE FROM a)
158 b cidm dh EXTRACT(DAY_HOUR FROM b) EXTRACT(DAY FROM b) EXTRACT(HOUR FROM b) EXTRACT(MINUTE FROM b)
233EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY_MINUTE FROM a) EXTRACT(DAY_SECOND FROM a) EXTRACT(DAY_MICROSE…
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/
H A Dfunc_extract.test7 EXTRACT(DAY FROM t),
12 EXTRACT(DAY FROM d),
17 EXTRACT(DAY FROM v),
57 SELECT a, b, EXTRACT(DAY_HOUR FROM a), EXTRACT(DAY_HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(DAY_HOUR…
58 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
59 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
60 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
61 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
62 SELECT a, b, EXTRACT(MICROSECOND FROM a), EXTRACT(MICROSECOND FROM b) FROM t1 WHERE NOT (EXTRACT(MI…
69 EXTRACT(DAY FROM a) * 24 + EXTRACT(HOUR FROM a) AS dh,
[all …]
H A Dfunc_extract.result77 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
78 a b EXTRACT(DAY FROM a) EXTRACT(DAY FROM b)
79 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
80 a b EXTRACT(HOUR FROM a) EXTRACT(HOUR FROM b)
81 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
82 a b EXTRACT(MINUTE FROM a) EXTRACT(MINUTE FROM b)
83 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
99 a cidm dh EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY FROM a) EXTRACT(HOUR FROM a) EXTRACT(MINUTE FROM a)
158 b cidm dh EXTRACT(DAY_HOUR FROM b) EXTRACT(DAY FROM b) EXTRACT(HOUR FROM b) EXTRACT(MINUTE FROM b)
233EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY_MINUTE FROM a) EXTRACT(DAY_SECOND FROM a) EXTRACT(DAY_MICROSE…
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/
H A Dfunc_extract.test7 EXTRACT(DAY FROM t),
12 EXTRACT(DAY FROM d),
17 EXTRACT(DAY FROM v),
57 SELECT a, b, EXTRACT(DAY_HOUR FROM a), EXTRACT(DAY_HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(DAY_HOUR…
58 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
59 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
60 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
61 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
62 SELECT a, b, EXTRACT(MICROSECOND FROM a), EXTRACT(MICROSECOND FROM b) FROM t1 WHERE NOT (EXTRACT(MI…
69 EXTRACT(DAY FROM a) * 24 + EXTRACT(HOUR FROM a) AS dh,
[all …]
H A Dfunc_extract.result77 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
78 a b EXTRACT(DAY FROM a) EXTRACT(DAY FROM b)
79 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
80 a b EXTRACT(HOUR FROM a) EXTRACT(HOUR FROM b)
81 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
82 a b EXTRACT(MINUTE FROM a) EXTRACT(MINUTE FROM b)
83 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
99 a cidm dh EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY FROM a) EXTRACT(HOUR FROM a) EXTRACT(MINUTE FROM a)
158 b cidm dh EXTRACT(DAY_HOUR FROM b) EXTRACT(DAY FROM b) EXTRACT(HOUR FROM b) EXTRACT(MINUTE FROM b)
233EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY_MINUTE FROM a) EXTRACT(DAY_SECOND FROM a) EXTRACT(DAY_MICROSE…
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/
H A Dfunc_extract.test7 EXTRACT(DAY FROM t),
12 EXTRACT(DAY FROM d),
17 EXTRACT(DAY FROM v),
57 SELECT a, b, EXTRACT(DAY_HOUR FROM a), EXTRACT(DAY_HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(DAY_HOUR…
58 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
59 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
60 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
61 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
62 SELECT a, b, EXTRACT(MICROSECOND FROM a), EXTRACT(MICROSECOND FROM b) FROM t1 WHERE NOT (EXTRACT(MI…
69 EXTRACT(DAY FROM a) * 24 + EXTRACT(HOUR FROM a) AS dh,
[all …]
H A Dfunc_extract.result77 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
78 a b EXTRACT(DAY FROM a) EXTRACT(DAY FROM b)
79 SELECT a, b, EXTRACT(HOUR FROM a), EXTRACT(HOUR FROM b) FROM t1 WHERE NOT (EXTRACT(HOUR FROM a)<=>E…
80 a b EXTRACT(HOUR FROM a) EXTRACT(HOUR FROM b)
81 SELECT a, b, EXTRACT(MINUTE FROM a), EXTRACT(MINUTE FROM b) FROM t1 WHERE NOT (EXTRACT(MINUTE FROM …
82 a b EXTRACT(MINUTE FROM a) EXTRACT(MINUTE FROM b)
83 SELECT a, b, EXTRACT(SECOND FROM a), EXTRACT(SECOND FROM b) FROM t1 WHERE NOT (EXTRACT(SECOND FROM …
99 a cidm dh EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY FROM a) EXTRACT(HOUR FROM a) EXTRACT(MINUTE FROM a)
158 b cidm dh EXTRACT(DAY_HOUR FROM b) EXTRACT(DAY FROM b) EXTRACT(HOUR FROM b) EXTRACT(MINUTE FROM b)
233EXTRACT(DAY_HOUR FROM a) EXTRACT(DAY_MINUTE FROM a) EXTRACT(DAY_SECOND FROM a) EXTRACT(DAY_MICROSE…
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs236_extract_function.result16 t1_d EXTRACT(SECOND FROM t1_d)
22 t1_d EXTRACT(MINUTE FROM t1_d)
28 t1_d EXTRACT(HOUR FROM t1_d)
34 t1_d EXTRACT(DAY FROM t1_d)
40 t1_d EXTRACT(WEEK FROM t1_d)
46 t1_d EXTRACT(MONTH FROM t1_d)
52 t1_d EXTRACT(QUARTER FROM t1_d)
58 t1_d EXTRACT(YEAR FROM t1_d)
154 t1_dt EXTRACT(DAY FROM t1_dt)
268 t1_t EXTRACT(HOUR FROM t1_t)
[all …]
H A Dmcs220_period_add_function.result22 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 0)
28 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 1)
34 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 3)
40 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), -1)
52 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 0)
58 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 1)
64 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 3)
70 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), -1)
82 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 0)
88 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 1)
[all …]
H A Dmcs221_period_diff_function.result21 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 202011) F…
22 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 202011)
27 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 222212) F…
28 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 222212)
34 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 201001)
39 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_d), 202011) FROM…
40 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_d), 202011)
46 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_d), 222212)
52 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_t), 202211)
58 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_t), 201001)
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs236_extract_function.result16 t1_d EXTRACT(SECOND FROM t1_d)
22 t1_d EXTRACT(MINUTE FROM t1_d)
28 t1_d EXTRACT(HOUR FROM t1_d)
34 t1_d EXTRACT(DAY FROM t1_d)
40 t1_d EXTRACT(WEEK FROM t1_d)
46 t1_d EXTRACT(MONTH FROM t1_d)
52 t1_d EXTRACT(QUARTER FROM t1_d)
58 t1_d EXTRACT(YEAR FROM t1_d)
154 t1_dt EXTRACT(DAY FROM t1_dt)
268 t1_t EXTRACT(HOUR FROM t1_t)
[all …]
H A Dmcs220_period_add_function.result22 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 0)
28 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 1)
34 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 3)
40 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), -1)
52 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 0)
58 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 1)
64 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 3)
70 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), -1)
82 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 0)
88 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 1)
[all …]
H A Dmcs221_period_diff_function.result21 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 202011) F…
22 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 202011)
27 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 222212) F…
28 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 222212)
34 t1_dt EXTRACT(YEAR_MONTH FROM t1_dt) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_dt), 201001)
39 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_d), 202011) FROM…
40 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_d), 202011)
46 t1_d EXTRACT(YEAR_MONTH FROM t1_d) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_d), 222212)
52 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_t), 202211)
58 t1_t EXTRACT(YEAR_MONTH FROM t1_t) PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM t1_t), 201001)
[all …]
/dports/emulators/mess/mame-mame0226/src/devices/cpu/se3208/
H A Dse3208dis.cpp31 uint32_t Offset=EXTRACT(Opcode,0,4); in INST()
32 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
33 uint32_t SrcDst=EXTRACT(Opcode,8,10); in INST()
49 uint32_t Offset=EXTRACT(Opcode,0,4); in INST()
50 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
67 uint32_t Offset=EXTRACT(Opcode,0,4); in INST()
68 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
88 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
108 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
189 ER=(EXTRACT(ER,0,17)<<14)|Imm; in INST()
[all …]
H A Dse3208.cpp601 uint32_t Src=EXTRACT(Opcode,3,5); in INST()
610 uint32_t Imm=EXTRACT(Opcode,0,7); in INST()
723 uint32_t Src=EXTRACT(Opcode,3,5); in INST()
724 uint32_t Dst=EXTRACT(Opcode,0,2); in INST()
739 uint32_t Src=EXTRACT(Opcode,3,5); in INST()
740 uint32_t Dst=EXTRACT(Opcode,0,2); in INST()
1443 switch(EXTRACT(Opcode,14,15)) in DecodeOp()
1473 switch(EXTRACT(Opcode,11,13)) in DecodeOp()
1495 switch(EXTRACT(Opcode,6,8)) in DecodeOp()
1530 switch(EXTRACT(Opcode,12,13)) in DecodeOp()
[all …]
/dports/emulators/mame/mame-mame0226/src/devices/cpu/se3208/
H A Dse3208dis.cpp31 uint32_t Offset=EXTRACT(Opcode,0,4); in INST()
32 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
33 uint32_t SrcDst=EXTRACT(Opcode,8,10); in INST()
49 uint32_t Offset=EXTRACT(Opcode,0,4); in INST()
50 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
67 uint32_t Offset=EXTRACT(Opcode,0,4); in INST()
68 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
88 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
108 uint32_t Index=EXTRACT(Opcode,5,7); in INST()
189 ER=(EXTRACT(ER,0,17)<<14)|Imm; in INST()
[all …]
H A Dse3208.cpp601 uint32_t Src=EXTRACT(Opcode,3,5); in INST()
610 uint32_t Imm=EXTRACT(Opcode,0,7); in INST()
723 uint32_t Src=EXTRACT(Opcode,3,5); in INST()
724 uint32_t Dst=EXTRACT(Opcode,0,2); in INST()
739 uint32_t Src=EXTRACT(Opcode,3,5); in INST()
740 uint32_t Dst=EXTRACT(Opcode,0,2); in INST()
1443 switch(EXTRACT(Opcode,14,15)) in DecodeOp()
1473 switch(EXTRACT(Opcode,11,13)) in DecodeOp()
1495 switch(EXTRACT(Opcode,6,8)) in DecodeOp()
1530 switch(EXTRACT(Opcode,12,13)) in DecodeOp()
[all …]
/dports/devel/gdb761/gdb-7.6.1/sim/testsuite/sim/bfin/
H A Dc_dsp32shift_fextx.s16 R1 = EXTRACT( R1, R0.L ) (Z);
17 R2 = EXTRACT( R2, R0.L ) (Z);
18 R3 = EXTRACT( R3, R0.L ) (Z);
19 R4 = EXTRACT( R4, R0.L ) (X);
20 R5 = EXTRACT( R5, R0.L ) (Z);
21 R6 = EXTRACT( R6, R0.L ) (Z);
22 R7 = EXTRACT( R7, R0.L ) (X);
23 R0 = EXTRACT( R0, R0.L ) (Z);
41 R0 = EXTRACT( R0, R1.L ) (Z);
42 R2 = EXTRACT( R2, R1.L ) (Z);
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs236_extract_function.test2 # Test EXTRACT() function
21 SELECT t1_d, EXTRACT(SECOND FROM t1_d) FROM t1 ORDER BY 1;
22 SELECT t1_d, EXTRACT(MINUTE FROM t1_d) FROM t1 ORDER BY 1;
23 SELECT t1_d, EXTRACT(HOUR FROM t1_d) FROM t1 ORDER BY 1;
24 SELECT t1_d, EXTRACT(DAY FROM t1_d) FROM t1 ORDER BY 1;
25 SELECT t1_d, EXTRACT(WEEK FROM t1_d) FROM t1 ORDER BY 1;
26 SELECT t1_d, EXTRACT(MONTH FROM t1_d) FROM t1 ORDER BY 1;
27 SELECT t1_d, EXTRACT(QUARTER FROM t1_d) FROM t1 ORDER BY 1;
28 SELECT t1_d, EXTRACT(YEAR FROM t1_d) FROM t1 ORDER BY 1;
45 SELECT t1_dt, EXTRACT(DAY FROM t1_dt) FROM t1 ORDER BY 1;
[all …]
H A Dmcs220_period_add_function.test25 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 0) FROM t1…
26 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 1) FROM t1…
27 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 3) FROM t1…
31 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 0) FROM t1 OR…
32 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 1) FROM t1 OR…
33 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 3) FROM t1 OR…
34 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), -1) FROM t1 O…
35 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), -3) FROM t1 O…
37 SELECT t1_t, EXTRACT(YEAR_MONTH FROM t1_t), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 0) FROM t1 OR…
38 SELECT t1_t, EXTRACT(YEAR_MONTH FROM t1_t), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 1) FROM t1 OR…
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs236_extract_function.test2 # Test EXTRACT() function
21 SELECT t1_d, EXTRACT(SECOND FROM t1_d) FROM t1 ORDER BY 1;
22 SELECT t1_d, EXTRACT(MINUTE FROM t1_d) FROM t1 ORDER BY 1;
23 SELECT t1_d, EXTRACT(HOUR FROM t1_d) FROM t1 ORDER BY 1;
24 SELECT t1_d, EXTRACT(DAY FROM t1_d) FROM t1 ORDER BY 1;
25 SELECT t1_d, EXTRACT(WEEK FROM t1_d) FROM t1 ORDER BY 1;
26 SELECT t1_d, EXTRACT(MONTH FROM t1_d) FROM t1 ORDER BY 1;
27 SELECT t1_d, EXTRACT(QUARTER FROM t1_d) FROM t1 ORDER BY 1;
28 SELECT t1_d, EXTRACT(YEAR FROM t1_d) FROM t1 ORDER BY 1;
45 SELECT t1_dt, EXTRACT(DAY FROM t1_dt) FROM t1 ORDER BY 1;
[all …]
H A Dmcs220_period_add_function.test25 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 0) FROM t1…
26 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 1) FROM t1…
27 SELECT t1_dt, EXTRACT(YEAR_MONTH FROM t1_dt), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_dt), 3) FROM t1…
31 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 0) FROM t1 OR…
32 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 1) FROM t1 OR…
33 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), 3) FROM t1 OR…
34 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), -1) FROM t1 O…
35 SELECT t1_d, EXTRACT(YEAR_MONTH FROM t1_d), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_d), -3) FROM t1 O…
37 SELECT t1_t, EXTRACT(YEAR_MONTH FROM t1_t), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 0) FROM t1 OR…
38 SELECT t1_t, EXTRACT(YEAR_MONTH FROM t1_t), PERIOD_ADD(EXTRACT(YEAR_MONTH FROM t1_t), 1) FROM t1 OR…
[all …]
/dports/lang/gcc12-devel/gcc-12-20211205/gcc/testsuite/gcc.target/i386/
H A Dpr91103-1.c23 EXTRACT (v8sf, float, 4);
24 EXTRACT (v8sf, float, 7);
25 EXTRACT (v8si, int, 4);
26 EXTRACT (v8si, int, 7);
27 EXTRACT (v16sf, float, 4);
28 EXTRACT (v16sf, float, 8);
31 EXTRACT (v16si, int, 4);
32 EXTRACT (v16si, int, 8);
33 EXTRACT (v16si, int, 12);
34 EXTRACT (v16si, int, 15);
[all …]
/dports/lang/v8/v8-9.6.180.12/test/unittests/interpreter/
H A Dbytecode-utils.h17 #define EXTRACT(x, n) static_cast<uint8_t>((x) >> (8 * n)) macro
18 #define U16(i) EXTRACT(i, 0), EXTRACT(i, 1)
19 #define U32(i) EXTRACT(i, 0), EXTRACT(i, 1), EXTRACT(i, 2), EXTRACT(i, 3)
23 #define EXTRACT(x, n) static_cast<uint8_t>((x) >> (8 * n))
25 #define U16(i) EXTRACT(i, 1), EXTRACT(i, 0)
26 #define U32(i) EXTRACT(i, 3), EXTRACT(i, 2), EXTRACT(i, 1), EXTRACT(i, 0)

12345678910>>...130