Home
last modified time | relevance | path

Searched refs:LEAST (Results 1 – 25 of 2167) sorted by relevance

12345678910>>...87

/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs255_least_function.result15 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 Dmcs255_least_function.result15 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 Dtype_json.result346 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 Dtype_json.result346 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 Dfunc_hybrid_type.test130 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 Dfunc_hybrid_type.result3025 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 Dfunc_hybrid_type.test130 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 Dfunc_hybrid_type.result3025 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 Dmcs255_least_function.test2 # 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 Dmcs255_least_function.test2 # 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 Dfunc_hybrid_type.test130 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 Dfunc_hybrid_type.result3025 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 Dfunc_hybrid_type.test130 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 Dfunc_hybrid_type.result3025 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 Dtype_inet6_mix_json.result8 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 Dtype_inet6_mix_json.result8 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 Dfunc_hybrid_type.test130 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 Dfunc_hybrid_type.test130 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 Dst_setvalues.sql73 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 Dst_setvalues.sql73 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 Dst_setvalues.sql73 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 Dst_setvalues.sql73 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 Dmhist42 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 Dsparse41 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 Dwcov36 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.

12345678910>>...87