Home
last modified time | relevance | path

Searched refs:GREATEST (Results 1 – 25 of 1854) sorted by relevance

12345678910>>...75

/dports/multimedia/zoneminder/zoneminder-1.36.5/db/
H A Dtriggers.sql7 HourEvents = GREATEST(COALESCE(HourEvents,1)-1,0),
8 HourEventDiskSpace=GREATEST(COALESCE(HourEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
36 DayEvents = GREATEST(COALESCE(DayEvents,1)-1,0),
37 DayEventDiskSpace=GREATEST(COALESCE(DayEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
65 WeekEvents = GREATEST(COALESCE(WeekEvents,1)-1,0),
66 WeekEventDiskSpace=GREATEST(COALESCE(WeekEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
93 MonthEvents = GREATEST(COALESCE(MonthEvents,1)-1,0),
154 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,0)-1,0),
218 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,1) - 1,0),
220 TotalEvents = GREATEST(COALESCE(TotalEvents,1) - 1,0),
[all …]
H A Dzm_update-1.33.8.sql7 HourEvents = GREATEST(COALESCE(HourEvents,1)-1,0),
8 HourEventDiskSpace=GREATEST(COALESCE(HourEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
36 DayEvents = GREATEST(COALESCE(DayEvents,1)-1,0),
37 DayEventDiskSpace=GREATEST(COALESCE(DayEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
65 WeekEvents = GREATEST(COALESCE(WeekEvents,1)-1,0),
66 WeekEventDiskSpace=GREATEST(COALESCE(WeekEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
93 MonthEvents = GREATEST(COALESCE(MonthEvents,1)-1,0),
153 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,0)-1,0),
217 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,1) - 1,0),
219 TotalEvents = GREATEST(COALESCE(TotalEvents,1) - 1,0),
[all …]
H A Dzm_update-1.33.7.sql8 HourEventDiskSpace=GREATEST(COALESCE(HourEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
36 DayEvents = GREATEST(COALESCE(DayEvents,1)-1,0),
37 DayEventDiskSpace=GREATEST(COALESCE(DayEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
66 WeekEventDiskSpace=GREATEST(COALESCE(WeekEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
94 MonthEventDiskSpace=GREATEST(COALESCE(MonthEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
153 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,0)-1,0),
217 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,1) - 1,0),
219 TotalEvents = GREATEST(COALESCE(TotalEvents,1) - 1,0),
220 TotalEventDiskSpace = GREATEST(COALESCE(TotalEventDiskSpace,0) - COALESCE(OLD.DiskSpace,0),0)
224 TotalEvents = GREATEST(COALESCE(TotalEvents,1)-1,0),
[all …]
H A Dzm_update-1.35.14.sql314 HourEvents = GREATEST(COALESCE(HourEvents,1)-1,0),
315 HourEventDiskSpace=GREATEST(COALESCE(HourEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
343 DayEvents = GREATEST(COALESCE(DayEvents,1)-1,0),
344 DayEventDiskSpace=GREATEST(COALESCE(DayEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
372 WeekEvents = GREATEST(COALESCE(WeekEvents,1)-1,0),
373 WeekEventDiskSpace=GREATEST(COALESCE(WeekEventDiskSpace,0)-COALESCE(OLD.DiskSpace,0),0)
400 MonthEvents = GREATEST(COALESCE(MonthEvents,1)-1,0),
460 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,0)-1,0),
524 ArchivedEvents = GREATEST(COALESCE(ArchivedEvents,1) - 1,0),
526 TotalEvents = GREATEST(COALESCE(TotalEvents,1) - 1,0),
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs253_greatest_function.result15 SELECT GREATEST(1,-1,0) FROM t1 LIMIT 1;
16 GREATEST(1,-1,0)
18 SELECT GREATEST(-999, -5, -1) FROM t1 LIMIT 1;
19 GREATEST(-999, -5, -1)
21 SELECT GREATEST(0, 0.999, 'a') FROM t1 LIMIT 1;
22 GREATEST(0, 0.999, 'a')
26 SELECT GREATEST('a', 'oo', 'z') FROM t1 LIMIT 1;
27 GREATEST('a', 'oo', 'z')
29 SELECT t1_INT, t1_DECIMAL, GREATEST(t1_INT, t1_DECIMAL) FROM t1 ORDER BY 1;
30 t1_INT t1_DECIMAL GREATEST(t1_INT, t1_DECIMAL)
[all …]
H A Dmcs91_comparison_functions.result55 SELECT t1_int, GREATEST(t1_int, t1_decimal) FROM t1 ORDER BY 1;
56 t1_int GREATEST(t1_int, t1_decimal)
60 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text) FROM t1 ORDER BY 1;
61 t1_int GREATEST(t1_int, t1_decimal, t1_text)
65 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text, t1_datetime) FROM t1 ORDER BY 1;
66 t1_int GREATEST(t1_int, t1_decimal, t1_text, t1_datetime)
71 GREATEST(IFNULL(t1_int, 0), IFNULL(t1_decimal, 0), IFNULL(t1_text, 0), IFNULL(t1_datetime, 0)) high…
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs253_greatest_function.result15 SELECT GREATEST(1,-1,0) FROM t1 LIMIT 1;
16 GREATEST(1,-1,0)
18 SELECT GREATEST(-999, -5, -1) FROM t1 LIMIT 1;
19 GREATEST(-999, -5, -1)
21 SELECT GREATEST(0, 0.999, 'a') FROM t1 LIMIT 1;
22 GREATEST(0, 0.999, 'a')
26 SELECT GREATEST('a', 'oo', 'z') FROM t1 LIMIT 1;
27 GREATEST('a', 'oo', 'z')
29 SELECT t1_INT, t1_DECIMAL, GREATEST(t1_INT, t1_DECIMAL) FROM t1 ORDER BY 1;
30 t1_INT t1_DECIMAL GREATEST(t1_INT, t1_DECIMAL)
[all …]
H A Dmcs91_comparison_functions.result55 SELECT t1_int, GREATEST(t1_int, t1_decimal) FROM t1 ORDER BY 1;
56 t1_int GREATEST(t1_int, t1_decimal)
60 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text) FROM t1 ORDER BY 1;
61 t1_int GREATEST(t1_int, t1_decimal, t1_text)
65 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text, t1_datetime) FROM t1 ORDER BY 1;
66 t1_int GREATEST(t1_int, t1_decimal, t1_text, t1_datetime)
71 GREATEST(IFNULL(t1_int, 0), IFNULL(t1_decimal, 0), IFNULL(t1_text, 0), IFNULL(t1_datetime, 0)) high…
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/
H A Dfunc_test.test259 SELECT GREATEST(5, -5) AS c1,
260 GREATEST(5, 5.5) AS c2,
261 GREATEST(5, 5.5e5) AS c3,
262 GREATEST(5, '5') AS c4,
298 SELECT GREATEST('11', 5, 2);
299 SELECT GREATEST(11, 5, 2);
325 SELECT GREATEST(11, 5, 2) + 0;
344 -- echo # GREATEST, ETC
351 SELECT GREATEST(a, b), GREATEST(a, c), GREATEST(a, d), GREATEST(a, e),
352 GREATEST(a, f) FROM t1;
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dfunc_test.result206 GREATEST(d,d)
320 GREATEST(1,NULL)
433 GREATEST(5, 5.5) AS c2,
435 GREATEST(5, '5') AS c4,
565 GREATEST('11', 5, 2)
568 GREATEST(11, 5, 2)
622 GREATEST(11, 5, 2) + 0
666 # GREATEST, ETC
672 SELECT GREATEST(a, b), GREATEST(a, c), GREATEST(a, d), GREATEST(a, e),
673 GREATEST(a, f) FROM t1;
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs253_greatest_function.test2 # GREATEST() function
26 SELECT GREATEST(1,-1,0) FROM t1 LIMIT 1;
27 SELECT GREATEST(-999, -5, -1) FROM t1 LIMIT 1;
28 SELECT GREATEST(0, 0.999, 'a') FROM t1 LIMIT 1;
29 SELECT GREATEST('a', 'oo', 'z') FROM t1 LIMIT 1;
31 SELECT t1_INT, t1_DECIMAL, GREATEST(t1_INT, t1_DECIMAL) FROM t1 ORDER BY 1;
32 SELECT t1_INT*0, t1_INT*10, t1_INT*-10, GREATEST(t1_INT*0, t1_INT*10, t1_INT*-10) FROM t1 ORDER BY …
H A Dmcs91_comparison_functions.test2 # Test Comparison Functions like COALESCE, LEAST, GREATEST, ISNULL
36 SELECT t1_int, GREATEST(t1_int, t1_decimal) FROM t1 ORDER BY 1;
37 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text) FROM t1 ORDER BY 1;
38 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text, t1_datetime) FROM t1 ORDER BY 1;
41 GREATEST(IFNULL(t1_int, 0), IFNULL(t1_decimal, 0), IFNULL(t1_text, 0), IFNULL(t1_datetime, 0)) high…
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs253_greatest_function.test2 # GREATEST() function
26 SELECT GREATEST(1,-1,0) FROM t1 LIMIT 1;
27 SELECT GREATEST(-999, -5, -1) FROM t1 LIMIT 1;
28 SELECT GREATEST(0, 0.999, 'a') FROM t1 LIMIT 1;
29 SELECT GREATEST('a', 'oo', 'z') FROM t1 LIMIT 1;
31 SELECT t1_INT, t1_DECIMAL, GREATEST(t1_INT, t1_DECIMAL) FROM t1 ORDER BY 1;
32 SELECT t1_INT*0, t1_INT*10, t1_INT*-10, GREATEST(t1_INT*0, t1_INT*10, t1_INT*-10) FROM t1 ORDER BY …
H A Dmcs91_comparison_functions.test2 # Test Comparison Functions like COALESCE, LEAST, GREATEST, ISNULL
36 SELECT t1_int, GREATEST(t1_int, t1_decimal) FROM t1 ORDER BY 1;
37 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text) FROM t1 ORDER BY 1;
38 SELECT t1_int, GREATEST(t1_int, t1_decimal, t1_text, t1_datetime) FROM t1 ORDER BY 1;
41 GREATEST(IFNULL(t1_int, 0), IFNULL(t1_decimal, 0), IFNULL(t1_text, 0), IFNULL(t1_datetime, 0)) high…
/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/databases/mariadb105-client/mariadb-10.5.15/mysql-test/include/
H A Dfunc_hybrid_type.inc14 GREATEST(a, a) AS greatest_a_a,
23 GREATEST(b, b) AS greatest_b_b
36 GREATEST(a, b) AS greatest_a_b,
37 GREATEST(b, a) AS greatest_b_a
52 GREATEST(a, a) AS greatest_a_a,
61 GREATEST(b, b) AS greatest_b_b
78 GREATEST(a, b) AS greatest_a_b,
79 GREATEST(b, a) AS greatest_b_a
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/include/
H A Dfunc_hybrid_type.inc14 GREATEST(a, a) AS greatest_a_a,
23 GREATEST(b, b) AS greatest_b_b
36 GREATEST(a, b) AS greatest_a_b,
37 GREATEST(b, a) AS greatest_b_a
52 GREATEST(a, a) AS greatest_a_a,
61 GREATEST(b, b) AS greatest_b_b
78 GREATEST(a, b) AS greatest_a_b,
79 GREATEST(b, a) AS greatest_b_a
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/include/
H A Dfunc_hybrid_type.inc14 GREATEST(a, a) AS greatest_a_a,
23 GREATEST(b, b) AS greatest_b_b
36 GREATEST(a, b) AS greatest_a_b,
37 GREATEST(b, a) AS greatest_b_a
52 GREATEST(a, a) AS greatest_a_a,
61 GREATEST(b, b) AS greatest_b_b
78 GREATEST(a, b) AS greatest_a_b,
79 GREATEST(b, a) AS greatest_b_a
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/include/
H A Dfunc_hybrid_type.inc14 GREATEST(a, a) AS greatest_a_a,
23 GREATEST(b, b) AS greatest_b_b
36 GREATEST(a, b) AS greatest_a_b,
37 GREATEST(b, a) AS greatest_b_a
52 GREATEST(a, a) AS greatest_a_a,
61 GREATEST(b, b) AS greatest_b_b
78 GREATEST(a, b) AS greatest_a_b,
79 GREATEST(b, a) AS greatest_b_a
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/include/
H A Dfunc_hybrid_type.inc14 GREATEST(a, a) AS greatest_a_a,
23 GREATEST(b, b) AS greatest_b_b
36 GREATEST(a, b) AS greatest_a_b,
37 GREATEST(b, a) AS greatest_b_a
52 GREATEST(a, a) AS greatest_a_a,
61 GREATEST(b, b) AS greatest_b_b
78 GREATEST(a, b) AS greatest_a_b,
79 GREATEST(b, a) AS greatest_b_a
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/include/
H A Dfunc_hybrid_type.inc14 GREATEST(a, a) AS greatest_a_a,
23 GREATEST(b, b) AS greatest_b_b
36 GREATEST(a, b) AS greatest_a_b,
37 GREATEST(b, a) AS greatest_b_a
52 GREATEST(a, a) AS greatest_a_a,
61 GREATEST(b, b) AS greatest_b_b
78 GREATEST(a, b) AS greatest_a_b,
79 GREATEST(b, a) AS greatest_b_a
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/
H A Dfunc_hybrid_type.result21 GREATEST(a, a) AS greatest_a_a,
30 GREATEST(b, b) AS greatest_b_b
3059 SELECT GREATEST(a,a) FROM t1;
3061 def GREATEST(a,a) 7 19 19 N 129 0 63
3062 GREATEST(a,a)
3517 SELECT a>b, COALESCE(a,b), GREATEST(a,b) FROM t1;
3518 a>b COALESCE(a,b) GREATEST(a,b)
3522 COALESCE(a,b) GREATEST(a,b)
3528 `GREATEST(a,b)` decimal(64,0) DEFAULT NULL
3922 SELECT GREATEST('9999', t) FROM t1 ORDER BY 1;
[all …]

12345678910>>...75