| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
| H A D | func_bit.test | 51 SELECT CAST(CAST(18446744073709551615 AS UNSIGNED) AS DECIMAL(32))<<0 AS c1;
52 SELECT CAST(CAST(18446744073709551615 AS UNSIGNED) AS DOUBLE)<<0 AS c1;
54 SELECT COALESCE(CAST(CAST(0xFFFFFFFFFFFFFFFF AS UNSIGNED) AS DECIMAL(32))) << 0 AS c1;
55 SELECT COALESCE(CAST(CAST(0xFFFFFFFFFFFFFFFF AS UNSIGNED) AS DOUBLE)) << 0 AS c1;
57 SELECT 18446744073709551615 ^ 1 AS c1;
58 SELECT 18446744073709551615.0 ^ 1 AS c1;
76 SELECT 0 | 18446744073709551615 AS c1;
79 SELECT 18446744073709551615 | 0 AS c1;
83 SELECT ~18446744073709551615 AS c1;
84 SELECT ~18446744073709551615.0 AS c1;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
| H A D | func_bit.test | 51 SELECT CAST(CAST(18446744073709551615 AS UNSIGNED) AS DECIMAL(32))<<0 AS c1;
52 SELECT CAST(CAST(18446744073709551615 AS UNSIGNED) AS DOUBLE)<<0 AS c1;
54 SELECT COALESCE(CAST(CAST(0xFFFFFFFFFFFFFFFF AS UNSIGNED) AS DECIMAL(32))) << 0 AS c1;
55 SELECT COALESCE(CAST(CAST(0xFFFFFFFFFFFFFFFF AS UNSIGNED) AS DOUBLE)) << 0 AS c1;
57 SELECT 18446744073709551615 ^ 1 AS c1;
58 SELECT 18446744073709551615.0 ^ 1 AS c1;
76 SELECT 0 | 18446744073709551615 AS c1;
79 SELECT 18446744073709551615 | 0 AS c1;
83 SELECT ~18446744073709551615 AS c1;
84 SELECT ~18446744073709551615.0 AS c1;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/gcol/inc/ |
| H A D | gcol_rejected.inc | 51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
[all …]
|
| /dports/devel/spark/spark-2.1.1/sql/hive/src/test/resources/ql/src/test/queries/clientpositive/ |
| H A D | udf_pmod.q | 15 …T pmod(CAST(-100 AS TINYINT),CAST(9 AS TINYINT)), pmod(CAST(-50 AS TINYINT),CAST(101 AS TINYINT)),…
16 …mod(CAST(-100 AS SMALLINT),CAST(9 AS SMALLINT)), pmod(CAST(-50 AS SMALLINT),CAST(101 AS SMALLINT))…
17 …ECT pmod(CAST(-100 AS BIGINT),CAST(9 AS BIGINT)), pmod(CAST(-50 AS BIGINT),CAST(101 AS BIGINT)), p…
19 …od(CAST(-100.91 AS FLOAT),CAST(9.8 AS FLOAT)), pmod(CAST(-50.1 AS FLOAT),CAST(101.8 AS FLOAT)), pm…
20 …CAST(-100.91 AS DOUBLE),CAST(9.8 AS DOUBLE)), pmod(CAST(-50.1 AS DOUBLE),CAST(101.8 AS DOUBLE)), p…
21 …AS DECIMAL(5,2)),CAST(9.8 AS DECIMAL(2,1))), pmod(CAST(-50.1 AS DECIMAL(3,1)),CAST(101.8 AS DECIMA…
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 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/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 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/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 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/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 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/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/engines/funcs/t/ |
| H A D | general_no_data.test | 5 SELECT MAX(c1) AS value FROM t1;
12 SELECT MAX(c1) AS value FROM t1;
19 SELECT MAX(c1) AS value FROM t1;
26 SELECT MAX(c1) AS value FROM t1;
33 SELECT MAX(c1) AS value FROM t1;
40 SELECT MAX(c1) AS value FROM t1;
47 SELECT MIN(c1) AS value FROM t1;
54 SELECT MIN(c1) AS value FROM t1;
61 SELECT MIN(c1) AS value FROM t1;
68 SELECT MIN(c1) AS value FROM t1;
[all …]
|