/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/ |
H A D | mcs255_least_function.result | 15 SELECT LEAST(1,-1,0) FROM t1 LIMIT 1; 16 LEAST(1,-1,0) 18 SELECT LEAST(-999,-100) FROM t1 LIMIT 1; 19 LEAST(-999,-100) 21 SELECT LEAST(0, 0.999, 'a') FROM t1 LIMIT 1; 22 LEAST(0, 0.999, 'a') 26 SELECT LEAST('a', 'oo', 'z') FROM t1 LIMIT 1; 27 LEAST('a', 'oo', 'z') 30 LEAST('a', 'oo', 'z', '!', '@') 33 t1_INT t1_DECIMAL LEAST(t1_INT, t1_DECIMAL) [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/ |
H A D | mcs255_least_function.result | 15 SELECT LEAST(1,-1,0) FROM t1 LIMIT 1; 16 LEAST(1,-1,0) 18 SELECT LEAST(-999,-100) FROM t1 LIMIT 1; 19 LEAST(-999,-100) 21 SELECT LEAST(0, 0.999, 'a') FROM t1 LIMIT 1; 22 LEAST(0, 0.999, 'a') 26 SELECT LEAST('a', 'oo', 'z') FROM t1 LIMIT 1; 27 LEAST('a', 'oo', 'z') 30 LEAST('a', 'oo', 'z', '!', '@') 33 t1_INT t1_DECIMAL LEAST(t1_INT, t1_DECIMAL) [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/json/r/ |
H A D | type_json.result | 346 LEAST(c0, c0) 350 LEAST(c0, c1) 354 LEAST(c0, c2) 358 LEAST(c0, c3) 362 LEAST(c0, c4) 366 LEAST(c0, c5) 370 LEAST(c0, c6) 374 LEAST(c0, c7) 378 LEAST(c1, c0) 382 LEAST(c1, c1) [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/json/r/ |
H A D | type_json.result | 346 LEAST(c0, c0) 350 LEAST(c0, c1) 354 LEAST(c0, c2) 358 LEAST(c0, c3) 362 LEAST(c0, c4) 366 LEAST(c0, c5) 370 LEAST(c0, c6) 374 LEAST(c0, c7) 378 LEAST(c1, c0) 382 LEAST(c1, c1) [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
H A D | func_hybrid_type.test | 130 SELECT LEAST(1.0,'10'); 133 CREATE TABLE t1 AS SELECT LEAST(1.0,'10'); 164 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 494 LEAST(_latin1'aaa',_utf8 0xC39F) AS c1, 663 LEAST(0,DATE'2001-01-01') AS i1, 664 LEAST(20010001,DATE'2001-01-01') AS i2, 676 LEAST(0,DATE'2001-01-01') AS i1, 706 SELECT LEAST(999,TIME'10:20:30') AS c1; 740 LEAST(0,DATE'2001-01-01') AS i1, 753 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
H A D | func_hybrid_type.result | 3025 SELECT LEAST(1.0,'10'); 3028 LEAST(1.0,'10') 3034 `LEAST(1.0,'10')` double NOT NULL 3071 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 3076 `LEAST(b,b)` datetime DEFAULT NULL, 3077 `LEAST(a,b)` datetime DEFAULT NULL 3576 `LEAST(a,a)` tinyint(4) DEFAULT NULL 3812 LEAST(0,DATE'2001-01-01') AS i1, 3842 LEAST(0,DATE'2001-01-01') AS i1, 3944 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/ |
H A D | func_hybrid_type.test | 130 SELECT LEAST(1.0,'10'); 133 CREATE TABLE t1 AS SELECT LEAST(1.0,'10'); 164 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 494 LEAST(_latin1'aaa',_utf8 0xC39F) AS c1, 663 LEAST(0,DATE'2001-01-01') AS i1, 664 LEAST(20010001,DATE'2001-01-01') AS i2, 676 LEAST(0,DATE'2001-01-01') AS i1, 706 SELECT LEAST(999,TIME'10:20:30') AS c1; 740 LEAST(0,DATE'2001-01-01') AS i1, 753 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
H A D | func_hybrid_type.result | 3025 SELECT LEAST(1.0,'10'); 3028 LEAST(1.0,'10') 3034 `LEAST(1.0,'10')` double NOT NULL 3071 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 3076 `LEAST(b,b)` datetime DEFAULT NULL, 3077 `LEAST(a,b)` datetime DEFAULT NULL 3576 `LEAST(a,a)` tinyint(4) DEFAULT NULL 3812 LEAST(0,DATE'2001-01-01') AS i1, 3842 LEAST(0,DATE'2001-01-01') AS i1, 3944 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/ |
H A D | mcs255_least_function.test | 2 # LEAST() function 26 SELECT LEAST(1,-1,0) FROM t1 LIMIT 1; 27 SELECT LEAST(-999,-100) FROM t1 LIMIT 1; 28 SELECT LEAST(0, 0.999, 'a') FROM t1 LIMIT 1; 29 SELECT LEAST('a', 'oo', 'z') FROM t1 LIMIT 1; 30 SELECT LEAST('a', 'oo', 'z', '!', '@') FROM t1 LIMIT 1; 32 SELECT t1_INT, t1_DECIMAL, LEAST(t1_INT, t1_DECIMAL) FROM t1 ORDER BY 1; 33 SELECT t1_INT*0, t1_INT*10, t1_INT*-10, LEAST(t1_INT*0, t1_INT*10, t1_INT*-10) FROM t1 ORDER BY 1; 36 SELECT LEAST('a') FROM t1 LIMIT 1;
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/ |
H A D | mcs255_least_function.test | 2 # LEAST() function 26 SELECT LEAST(1,-1,0) FROM t1 LIMIT 1; 27 SELECT LEAST(-999,-100) FROM t1 LIMIT 1; 28 SELECT LEAST(0, 0.999, 'a') FROM t1 LIMIT 1; 29 SELECT LEAST('a', 'oo', 'z') FROM t1 LIMIT 1; 30 SELECT LEAST('a', 'oo', 'z', '!', '@') FROM t1 LIMIT 1; 32 SELECT t1_INT, t1_DECIMAL, LEAST(t1_INT, t1_DECIMAL) FROM t1 ORDER BY 1; 33 SELECT t1_INT*0, t1_INT*10, t1_INT*-10, LEAST(t1_INT*0, t1_INT*10, t1_INT*-10) FROM t1 ORDER BY 1; 36 SELECT LEAST('a') FROM t1 LIMIT 1;
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
H A D | func_hybrid_type.test | 130 SELECT LEAST(1.0,'10'); 133 CREATE TABLE t1 AS SELECT LEAST(1.0,'10'); 164 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 494 LEAST(_latin1'aaa',_utf8 0xC39F) AS c1, 663 LEAST(0,DATE'2001-01-01') AS i1, 664 LEAST(20010001,DATE'2001-01-01') AS i2, 676 LEAST(0,DATE'2001-01-01') AS i1, 706 SELECT LEAST(999,TIME'10:20:30') AS c1; 740 LEAST(0,DATE'2001-01-01') AS i1, 753 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
H A D | func_hybrid_type.result | 3025 SELECT LEAST(1.0,'10'); 3028 LEAST(1.0,'10') 3034 `LEAST(1.0,'10')` double NOT NULL 3071 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 3076 `LEAST(b,b)` datetime DEFAULT NULL, 3077 `LEAST(a,b)` datetime DEFAULT NULL 3576 `LEAST(a,a)` tinyint(4) DEFAULT NULL 3812 LEAST(0,DATE'2001-01-01') AS i1, 3842 LEAST(0,DATE'2001-01-01') AS i1, 3944 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
H A D | func_hybrid_type.test | 130 SELECT LEAST(1.0,'10'); 133 CREATE TABLE t1 AS SELECT LEAST(1.0,'10'); 164 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 494 LEAST(_latin1'aaa',_utf8 0xC39F) AS c1, 663 LEAST(0,DATE'2001-01-01') AS i1, 664 LEAST(20010001,DATE'2001-01-01') AS i2, 676 LEAST(0,DATE'2001-01-01') AS i1, 706 SELECT LEAST(999,TIME'10:20:30') AS c1; 740 LEAST(0,DATE'2001-01-01') AS i1, 753 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
H A D | func_hybrid_type.result | 3025 SELECT LEAST(1.0,'10'); 3028 LEAST(1.0,'10') 3034 `LEAST(1.0,'10')` double NOT NULL 3071 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 3076 `LEAST(b,b)` datetime DEFAULT NULL, 3077 `LEAST(a,b)` datetime DEFAULT NULL 3576 `LEAST(a,a)` tinyint(4) DEFAULT NULL 3812 LEAST(0,DATE'2001-01-01') AS i1, 3842 LEAST(0,DATE'2001-01-01') AS i1, 3944 LEAST(0,DATE'2001-01-01') AS i1, [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/plugin/type_inet/mysql-test/type_inet/ |
H A D | type_inet6_mix_json.result | 8 LEAST(a,b), LEAST(a,c) 13 def LEAST(a,b) 254 (type=inet6) 39 0 Y 32 0 8 14 def LEAST(a,c) 254 (type=inet6) 39 0 Y 32 0 8 15 COALESCE(a,b) COALESCE(a,c) LEAST(a,b) LEAST(a,c) 19 LEAST(a,b), LEAST(a,c) 26 `LEAST(a,b)` inet6 DEFAULT NULL, 27 `LEAST(a,c)` inet6 DEFAULT NULL
|
/dports/databases/mariadb105-server/mariadb-10.5.15/plugin/type_inet/mysql-test/type_inet/ |
H A D | type_inet6_mix_json.result | 8 LEAST(a,b), LEAST(a,c) 13 def LEAST(a,b) 254 (type=inet6) 39 0 Y 32 0 8 14 def LEAST(a,c) 254 (type=inet6) 39 0 Y 32 0 8 15 COALESCE(a,b) COALESCE(a,c) LEAST(a,b) LEAST(a,c) 19 LEAST(a,b), LEAST(a,c) 26 `LEAST(a,b)` inet6 DEFAULT NULL, 27 `LEAST(a,c)` inet6 DEFAULT NULL
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/ |
H A D | func_hybrid_type.test | 130 SELECT LEAST(1.0,'10'); 133 CREATE TABLE t1 AS SELECT LEAST(1.0,'10'); 164 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 494 LEAST(_latin1'aaa',_utf8 0xC39F) AS c1, 543 CREATE TABLE t2 AS SELECT LEAST(a,a) FROM t1; 553 CREATE TABLE t2 AS SELECT LEAST(a,a) FROM t1; 663 LEAST(0,DATE'2001-01-01') AS i1, 664 LEAST(20010001,DATE'2001-01-01') AS i2, 676 LEAST(0,DATE'2001-01-01') AS i1, 677 LEAST(20010001,DATE'2001-01-01') AS i2, [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/main/ |
H A D | func_hybrid_type.test | 130 SELECT LEAST(1.0,'10'); 133 CREATE TABLE t1 AS SELECT LEAST(1.0,'10'); 164 CREATE TABLE t2 AS SELECT LEAST(a,a),LEAST(b,b),LEAST(a,b) FROM t1; 494 LEAST(_latin1'aaa',_utf8 0xC39F) AS c1, 543 CREATE TABLE t2 AS SELECT LEAST(a,a) FROM t1; 553 CREATE TABLE t2 AS SELECT LEAST(a,a) FROM t1; 663 LEAST(0,DATE'2001-01-01') AS i1, 664 LEAST(20010001,DATE'2001-01-01') AS i2, 676 LEAST(0,DATE'2001-01-01') AS i1, 677 LEAST(20010001,DATE'2001-01-01') AS i2, [all …]
|
/dports/databases/postgis32/postgis-3.2.0/raster/scripts/plpgsql/ |
H A D | st_setvalues.sql | 73 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast)); 74 newwidth := GREATEST(LEAST(1 + ST_Width(rast), oldx + newwidth), 1) - newx; 80 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast)); 81 newheight := GREATEST(LEAST(1 + ST_Height(rast), oldy + newheight), 1) - newy; 267 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast1)); 268 newwidth := GREATEST(LEAST(1 + ST_Width(rast1), oldx + newwidth), 1) - newx; 277 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast1)); 278 newheight := GREATEST(LEAST(1 + ST_Height(rast1), oldy + newheight), 1) - newy; 292 newx := x2 + LEAST(GREATEST(0, oldx - x2), ST_Width(rast2)); 293 newwidth := GREATEST(LEAST(x2 + ST_Width(rast2), oldx + newwidth), x2) - newx; [all …]
|
/dports/databases/postgis31/postgis-3.1.4/raster/scripts/plpgsql/ |
H A D | st_setvalues.sql | 73 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast)); 74 newwidth := GREATEST(LEAST(1 + ST_Width(rast), oldx + newwidth), 1) - newx; 80 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast)); 81 newheight := GREATEST(LEAST(1 + ST_Height(rast), oldy + newheight), 1) - newy; 267 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast1)); 268 newwidth := GREATEST(LEAST(1 + ST_Width(rast1), oldx + newwidth), 1) - newx; 277 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast1)); 278 newheight := GREATEST(LEAST(1 + ST_Height(rast1), oldy + newheight), 1) - newy; 292 newx := x2 + LEAST(GREATEST(0, oldx - x2), ST_Width(rast2)); 293 newwidth := GREATEST(LEAST(x2 + ST_Width(rast2), oldx + newwidth), x2) - newx; [all …]
|
/dports/databases/postgis30/postgis-3.0.4/raster/scripts/plpgsql/ |
H A D | st_setvalues.sql | 73 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast)); 74 newwidth := GREATEST(LEAST(1 + ST_Width(rast), oldx + newwidth), 1) - newx; 80 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast)); 81 newheight := GREATEST(LEAST(1 + ST_Height(rast), oldy + newheight), 1) - newy; 267 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast1)); 268 newwidth := GREATEST(LEAST(1 + ST_Width(rast1), oldx + newwidth), 1) - newx; 277 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast1)); 278 newheight := GREATEST(LEAST(1 + ST_Height(rast1), oldy + newheight), 1) - newy; 292 newx := x2 + LEAST(GREATEST(0, oldx - x2), ST_Width(rast2)); 293 newwidth := GREATEST(LEAST(x2 + ST_Width(rast2), oldx + newwidth), x2) - newx; [all …]
|
/dports/databases/postgis25/postgis-2.5.5/raster/scripts/plpgsql/ |
H A D | st_setvalues.sql | 73 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast)); 74 newwidth := GREATEST(LEAST(1 + ST_Width(rast), oldx + newwidth), 1) - newx; 80 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast)); 81 newheight := GREATEST(LEAST(1 + ST_Height(rast), oldy + newheight), 1) - newy; 267 newx := 1 + LEAST(GREATEST(0, oldx - 1), ST_Width(rast1)); 268 newwidth := GREATEST(LEAST(1 + ST_Width(rast1), oldx + newwidth), 1) - newx; 277 newy := 1 + LEAST(GREATEST(0, oldy - 1), ST_Height(rast1)); 278 newheight := GREATEST(LEAST(1 + ST_Height(rast1), oldy + newheight), 1) - newy; 292 newx := x2 + LEAST(GREATEST(0, oldx - x2), ST_Width(rast2)); 293 newwidth := GREATEST(LEAST(x2 + ST_Width(rast2), oldx + newwidth), x2) - newx; [all …]
|
/dports/math/cmlib/cmlib-3.0_8/doc/cluster/ |
H A D | mhist | 42 C THE FIRST DIMENSION OF THE MATRIX A. MUST BE AT LEAST M. 51 C DIMENSION MUST BE AT LEAST N (UNCHANGED ON OUTPUT). 56 C CLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST N. 60 C RLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST M. 67 C XMIN INTEGER VECTOR DIMENSIONED AT LEAST N (UNCHANGED ON OUTPUT). 70 C XMAX INTEGER VECTOR DIMENSIONED AT LEAST N (UNCHANGED ON OUTPUT). 83 C THE FIRST DIMENSION OF THE MATRIX WORK. MUST BE AT LEAST 87 C SECOND DIMENSION MUST BE AT LEAST N+1. 91 C THE FIRST DIMENSION OF THE MATRIX IWORK. MUST BE AT LEAST 95 C SECOND DIMENSION MUST BE AT LEAST N. [all …]
|
H A D | sparse | 41 C THE FIRST DIMENSION OF THE MATRIX A. MUST BE AT LEAST M. 50 C DIMENSION MUST BE AT LEAST N. (UNCHANGED ON OUTPUT). 55 C CLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST N. 59 C RLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST M. 70 C THE LEADING DIMENSION OF THE MATRIX COV. MUST BE AT LEAST N. 73 C SECOND DIMENSION MUST BE AT LEAST N. 78 C THE LEADING DIMENSION OF THE MATRIX WORK1. MUST BE AT LEAST 82 C SECOND DIMENSION MUST BE AT LEAST N+1. 86 C THE LEADING DIMENSION OF THE MATRIX WORK2. MUST BE AT LEAST 90 C SECOND DIMENSION MUST BE AT LEAST N+2. [all …]
|
H A D | wcov | 36 C THE FIRST DIMENSION OF THE MATRIX A. MUST BE AT LEAST M. 45 C DIMENSION MUST BE AT LEAST N. (UNCHANGED ON OUTPUT). 49 C CLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST N. 53 C RLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST M. 60 C NC INTEGER VECTOR DIMENSIONED AT LEAST M (UNCHANGED ON OUTPUT). 65 C LEAST N. 67 C WORK REAL VECTOR DIMENSIONED AT LEAST N. 74 C SECOND DIMENSION MUST BE AT LEAST N. 77 C COVLAB VECTOR OF 4-CHARACTER VARIABLES DIMENSIONED AT LEAST N.
|