/dports/multimedia/zoneminder/zoneminder-1.36.5/db/ |
H A D | triggers.sql | 7 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 D | zm_update-1.33.8.sql | 7 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 D | zm_update-1.33.7.sql | 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) 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 D | zm_update-1.35.14.sql | 314 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 D | mcs253_greatest_function.result | 15 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 D | mcs91_comparison_functions.result | 55 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 D | mcs253_greatest_function.result | 15 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 D | mcs91_comparison_functions.result | 55 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 D | func_test.test | 259 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 D | func_test.result | 206 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 D | mcs253_greatest_function.test | 2 # 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 D | mcs91_comparison_functions.test | 2 # 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 D | mcs253_greatest_function.test | 2 # 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 D | mcs91_comparison_functions.test | 2 # 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 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/databases/mariadb105-client/mariadb-10.5.15/mysql-test/include/ |
H A D | func_hybrid_type.inc | 14 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 D | func_hybrid_type.inc | 14 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 D | func_hybrid_type.inc | 14 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 D | func_hybrid_type.inc | 14 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 D | func_hybrid_type.inc | 14 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 D | func_hybrid_type.inc | 14 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 D | func_hybrid_type.result | 21 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 …]
|