/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
H A D | func_extract.test | 7 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 D | func_extract.result | 77 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) … 233 …EXTRACT(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 D | func_extract.test | 7 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 D | func_extract.result | 77 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) … 233 …EXTRACT(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 D | func_extract.test | 7 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 D | func_extract.result | 77 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) … 233 …EXTRACT(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 D | func_extract.test | 7 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 D | func_extract.result | 77 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) … 233 …EXTRACT(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 D | mcs236_extract_function.result | 16 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 D | mcs220_period_add_function.result | 22 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 D | mcs221_period_diff_function.result | 21 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 D | mcs236_extract_function.result | 16 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 D | mcs220_period_add_function.result | 22 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 D | mcs221_period_diff_function.result | 21 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 D | se3208dis.cpp | 31 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 D | se3208.cpp | 601 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 D | se3208dis.cpp | 31 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 D | se3208.cpp | 601 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 D | c_dsp32shift_fextx.s | 16 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 D | mcs236_extract_function.test | 2 # 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 D | mcs220_period_add_function.test | 25 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 D | mcs236_extract_function.test | 2 # 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 D | mcs220_period_add_function.test | 25 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 D | pr91103-1.c | 23 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 D | bytecode-utils.h | 17 #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)
|