/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/ |
H A D | mcs171_null_functions.result | 24 SELECT ISNULL(NULL); 25 ISNULL(NULL) 27 SELECT ISNULL(1); 28 ISNULL(1) 30 SELECT ISNULL('a'); 31 ISNULL('a') 44 SELECT a, ISNULL(a) FROM t1; 45 a ISNULL(a) 52 b ISNULL(b) 59 c ISNULL(c) [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/ |
H A D | mcs171_null_functions.result | 24 SELECT ISNULL(NULL); 25 ISNULL(NULL) 27 SELECT ISNULL(1); 28 ISNULL(1) 30 SELECT ISNULL('a'); 31 ISNULL('a') 44 SELECT a, ISNULL(a) FROM t1; 45 a ISNULL(a) 52 b ISNULL(b) 59 c ISNULL(c) [all …]
|
/dports/misc/lifelines/lifelines-3.1.1/src/stdlib/ |
H A D | environ.c | 51 if (ISNULL(e)) e = (STRING)getenv("TMP"); in environ_determine_tempfile() 52 if (ISNULL(e)) e = "\\temp"; /* fallback is \temp */ in environ_determine_tempfile() 82 if (ISNULL(e)) e = (STRING) getenv("ED"); in environ_determine_editor() 83 if (ISNULL(e)) e = (STRING) getenv("EDITOR"); in environ_determine_editor() 87 if (ISNULL(e)) e = (STRING) "notepad.exe"; in environ_determine_editor() 90 if (ISNULL(e)) e = (STRING) "vi"; in environ_determine_editor() 95 if (ISNULL(e)) e = (STRING) "vi"; in environ_determine_editor()
|
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/ |
H A D | mcs171_null_functions.test | 2 # Test NULLIF, IFNULL, ISNULL functions 23 SELECT ISNULL(NULL); 24 SELECT ISNULL(1); 25 SELECT ISNULL('a'); 30 SELECT a, ISNULL(a) FROM t1; 31 SELECT b, ISNULL(b) FROM t1; 32 SELECT c, ISNULL(c) FROM t1; 33 SELECT d, ISNULL(d) FROM t1;
|
H A D | mcs91_comparison_functions.test | 2 # Test Comparison Functions like COALESCE, LEAST, GREATEST, ISNULL 44 SELECT * FROM t1 WHERE ISNULL(t1_int) ORDER BY t1_decimal; 45 SELECT * FROM t1 WHERE ISNULL(t1_decimal) ORDER BY t1_decimal; 46 SELECT * FROM t1 WHERE ISNULL(t1_text) ORDER BY t1_decimal; 47 SELECT * FROM t1 WHERE ISNULL(t1_datetime) ORDER BY t1_decimal;
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/ |
H A D | mcs171_null_functions.test | 2 # Test NULLIF, IFNULL, ISNULL functions 23 SELECT ISNULL(NULL); 24 SELECT ISNULL(1); 25 SELECT ISNULL('a'); 30 SELECT a, ISNULL(a) FROM t1; 31 SELECT b, ISNULL(b) FROM t1; 32 SELECT c, ISNULL(c) FROM t1; 33 SELECT d, ISNULL(d) FROM t1;
|
H A D | mcs91_comparison_functions.test | 2 # Test Comparison Functions like COALESCE, LEAST, GREATEST, ISNULL 44 SELECT * FROM t1 WHERE ISNULL(t1_int) ORDER BY t1_decimal; 45 SELECT * FROM t1 WHERE ISNULL(t1_decimal) ORDER BY t1_decimal; 46 SELECT * FROM t1 WHERE ISNULL(t1_text) ORDER BY t1_decimal; 47 SELECT * FROM t1 WHERE ISNULL(t1_datetime) ORDER BY t1_decimal;
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 52 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 57 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 52 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 57 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 50 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 55 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 50 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 55 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 50 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 55 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 50 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 55 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/csinternal/devregression/t/ |
H A D | mcs7113_regression_bug3719.test | 193 `tag_values_geo_country`.`value`, `dim_date`.`cdate` order by ISNULL(`areas`.`id`), `areas`.`id` AS… 194 ISNULL(`tag_values_ptype`.`id`), `tag_values_ptype`.`id` ASC, ISNULL(`sizes`.`id`), `sizes`.`id` AS… 195 ISNULL(`tag_values_geo_region`.`id`), `tag_values_geo_region`.`id` ASC, ISNULL(`tag_values_geo_coun… 196 `tag_values_geo_country`.`id` ASC, ISNULL(`dim_date`.`cdate`), `dim_date`.`cdate` ASC; 250 ISNULL(`areas`.`id`) 254 ISNULL(`tag_values_ptype`.`id`), 256 ISNULL(`sizes`.`id`), `sizes`.`id` ASC, 257 ISNULL(`tag_values_geo_region`.`id`), 259 ISNULL(`tag_values_geo_country`.`id`), 261 ISNULL(`dim_date`.`cdate`), [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/csinternal/devregression/t/ |
H A D | mcs7113_regression_bug3719.test | 193 `tag_values_geo_country`.`value`, `dim_date`.`cdate` order by ISNULL(`areas`.`id`), `areas`.`id` AS… 194 ISNULL(`tag_values_ptype`.`id`), `tag_values_ptype`.`id` ASC, ISNULL(`sizes`.`id`), `sizes`.`id` AS… 195 ISNULL(`tag_values_geo_region`.`id`), `tag_values_geo_region`.`id` ASC, ISNULL(`tag_values_geo_coun… 196 `tag_values_geo_country`.`id` ASC, ISNULL(`dim_date`.`cdate`), `dim_date`.`cdate` ASC; 250 ISNULL(`areas`.`id`) 254 ISNULL(`tag_values_ptype`.`id`), 256 ISNULL(`sizes`.`id`), `sizes`.`id` ASC, 257 ISNULL(`tag_values_geo_region`.`id`), 259 ISNULL(`tag_values_geo_country`.`id`), 261 ISNULL(`dim_date`.`cdate`), [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/perfschema/r/ |
H A D | connect_attrs.result | 2 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 7 SUM(ISNULL(ATTR_VALUE)) COUNT(*) 15 SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*) 20 SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|