/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
H A D | func_time.test | 1318 SELECT CAST(COALESCE(a,a) AS SIGNED) AS c1, CAST(COALESCE(a,a) AS DECIMAL(25,3)) AS c2, ROUND(COALE… 1322 SELECT CAST(COALESCE(a,a) AS SIGNED) AS c1, CAST(COALESCE(a,a) AS DECIMAL(25,3)) AS c2, ROUND(COALE… 1956 SELECT t1.pk AS pk, t1.a1 AS a1 FROM t1; 2123 CAST(TIMESTAMP'0000-00-01 10:00:00' AS TIME) AS c0, 2135 CAST(CAST(LAST_DAY(TIME'00:00:00') AS DATE) AS TIME) AS c2, 2136 CAST(LAST_DAY(TIME'00:00:00') AS TIME) AS c3; 2282 CAST(CAST(LAST_DAY(TIME'00:00:00') AS DATE) AS TIME) AS c2, 2283 CAST(LAST_DAY(TIME'00:00:00') AS TIME) AS c3; 2649 CAST(ADDTIME(0.0, 8395959) AS DECIMAL(30,0)) AS c0, 2650 CAST(ADDTIME(0.0, 8395959) AS DECIMAL(30,1)) AS c1, [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/engines/funcs/r/ |
H A D | general_no_data.result | 3 SELECT MAX(c1) AS value FROM t1; 20 SELECT MAX(c1) AS value FROM t1; 37 SELECT MAX(c1) AS value FROM t1; 54 SELECT MAX(c1) AS value FROM t1; 71 SELECT MAX(c1) AS value FROM t1; 88 SELECT MAX(c1) AS value FROM t1; 105 SELECT MIN(c1) AS value FROM t1; 122 SELECT MIN(c1) AS value FROM t1; 139 SELECT MIN(c1) AS value FROM t1; 156 SELECT MIN(c1) AS value FROM t1; [all …]
|
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
H A D | issue_5248.out | 93 SELECT subq_3.c15 AS c0, 94 subq_3.c0 AS c1, 95 subq_3.c15 AS c2, 96 subq_0.c1 AS c3, 122 INNER JOIN pg_catalog.pg_language AS ref_2 128 cast(NULL AS bpchar) ~<=~ cast(NULL AS bpchar)) 147 cast(NULL AS float8) > 155 END , cast(NULL AS path)) AS path) = cast(NULL AS path)) AS subq_0, 166 cast(COALESCE(subq_2.c0, subq_2.c0) AS text) AS c5, 175 … FROM pg_catalog.pg_description limit 1 offset 1) AS oid)) AS c11, [all …]
|
/dports/security/webfwlog/webfwlog-1.1.1/mysql/scripts/ |
H A D | snort_view | 4 VIEW $SNORT_VIEW AS 11 AS "oob_prefix", 12 interface AS "oob_in", 13 ip_ver AS "ip_ver", 14 ip_hlen AS "ip_ihl", 15 ip_tos AS "ip_tos", 17 ip_id AS "ip_id", 19 ip_ttl AS "ip_ttl", 21 ip_csum AS "ip_csum", 22 ip_src AS "ip_saddr", [all …]
|
/dports/biology/seqan-apps/seqan-seqan-v2.4.0/demos/tutorial/realignment/ |
H A D | reads.sam | 3 …HGIGHIIHHGIHGIEGIGIIBHAIIIDIIAFIEEIICIGHCIIGFCEHIFAGBIIIA@IBI@IIB@CGDIFIC=IC NM:i:0 AS:i:100 XS:i:0 4 …GIIFIGGIFIHHIIIIEIHIIGGCFEHIHIHIIIEGEIIFIIIEIGHH??IIDGIIII?GIH@IBGFIIIBBDII2I NM:i:0 AS:i:98 XS:i:0 5 …IHIIIIGFGFEFEIDHEGIIHIIHGEIHI?FIIDHIDAEDICIIFDFEI>FIIIIHDAIIGHAIIICFEFGIIEGII NM:i:1 AS:i:95 XS:i:0 6 …IEFIIBIIIEHIIFIC@HHCIEIIIGIGICIIHCHEHIFFIHIIIIEIGIGHIGIIHHIIIHIIGHIIIHIHHIIIH NM:i:2 AS:i:87 XS:i:0 7 …FIHFGEIIFHHIIIDIIIHIEIGFIDIFGIIIACHDIFHIDIIIIIIHIBI@EIBDIIEIHIIIBIHBI0>>G;HH NM:i:0 AS:i:100 XS:i:0 8 …IIGFHIIIDIIIIGGFIBIIIHIGIDEFHFIFIIDIFGDGGIIGIIA=IIHFHIAFIDEIIC;HADIIIIGIICIII NM:i:3 AS:i:87 XS:i:0 9 …HGIGIIGHFHHIHIIFHIAIIEGIBEGHHIFIE?IFFIIIIIDHIIBICIIBIHEH=IFHIEF@IFFI6GIGIIEHA NM:i:8 AS:i:81 XS:i:0 10 …IEIEFIGHIIEGGIGFIIIGBIIEIIFIIFIIIIIICFIGCGIHIIICIH7ICHI@IIIIFGDCG9>IIIHIIIIDI NM:i:7 AS:i:84 XS:i:0 12 …GFGIHIIIIIIHIHEIIIIFHIBDEGCIIEIIFDEFGGIFIFGEGIHHIFFIDIGICIII<HIGGAACCIII>FAI< NM:i:6 AS:i:88 XS:i:0 13 …I=IIHICCGIGGGIIIIECFIG=FIGDGEGIIDIEGHHEIIGIIHFCGCFIIIHHIHIEHHHIIIIIGHIHIIIIHI NM:i:8 AS:i:86 XS:i:0 [all …]
|
/dports/devel/spark/spark-2.1.1/sql/hive/src/test/resources/ql/src/test/queries/clientpositive/ |
H A D | udf_if.q | 7 SELECT IF(TRUE, 1, 2) AS COL1, 8 IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2, 10 IF(2=2, 1, NULL) AS COL4, 11 IF(2=2, NULL, 1) AS COL5, 16 SELECT IF(TRUE, 1, 2) AS COL1, 17 IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2, 19 IF(2=2, 1, NULL) AS COL4, 20 IF(2=2, NULL, 1) AS COL5, 26 SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1, 27 IF(FALSE, 1, 1.1) AS COL2, [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/include/ |
H A D | weight_string_81309D30.inc | 2 SELECT collation(CAST(0x81309D30 AS CHAR)); 3 SELECT HEX(WEIGHT_STRING(CAST(0x6141 AS CHAR))); 4 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR))); 5 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(1))); 6 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(1))); 7 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(3))); 8 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(3))); 9 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D30 AS CHAR) AS CHAR(3))); 10 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D3081309D30 AS CHAR) AS CHAR(3))); 11 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D3081309D3081309D30 AS CHAR) AS CHAR(3))); [all …]
|