Home
last modified time | relevance | path

Searched refs:AS (Results 201 – 225 of 52529) sorted by relevance

12345678910>>...2102

/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/
H A Dfunc_time.test1318 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dgeneral_no_data.result3 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 Dissue_5248.out93 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 Dsnort_view4 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 Dreads.sam3 …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 Dudf_if.q7 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 Dweight_string_81309D30.inc2 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 …]

12345678910>>...2102