Home
last modified time | relevance | path

Searched refs:ISNULL (Results 1 – 25 of 1434) sorted by relevance

12345678910>>...58

/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs171_null_functions.result24 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 Dmcs171_null_functions.result24 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 Denviron.c51 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 Dmcs171_null_functions.test2 # 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 Dmcs91_comparison_functions.test2 # 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 Dmcs171_null_functions.test2 # 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 Dmcs91_comparison_functions.test2 # 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dmcs7113_regression_bug3719.test193 `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 Dmcs7113_regression_bug3719.test193 `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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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 Dconnect_attrs.result2 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(*)

12345678910>>...58