/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | partition_join.sql | 34 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 35 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 54 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 55 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 141 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 142 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 145 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 146 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 153 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 154 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | partition_join.sql | 34 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 35 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 54 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 55 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 141 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 142 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 145 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 146 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 153 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 154 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | partition_join.sql | 34 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 35 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 54 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 55 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 141 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 142 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 145 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 146 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 153 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 154 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | partition_join.sql | 34 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 35 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 54 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 55 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 141 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 142 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 145 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 146 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 153 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 154 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
H A D | partition_join.sql | 34 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 35 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t… 54 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 55 SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.a < 450 AND t2.b > 250… 141 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 142 SELECT t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1, prt1_e t2 WHERE t1.a = 0 AND t1.b… 145 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 146 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 153 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… 154 …t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR… [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 16 SELECT * FROM t1; 17 TRUNCATE TABLE t1; 20 SELECT * FROM t1; 29 SELECT * FROM t1; 33 SELECT * FROM t1; 34 DROP TABLE t1; 61 DROP TABLE t1; 88 DROP TABLE t1; 115 DROP TABLE t1; 142 DROP TABLE t1; [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 16 SELECT * FROM t1; 17 TRUNCATE TABLE t1; 20 SELECT * FROM t1; 29 SELECT * FROM t1; 33 SELECT * FROM t1; 34 DROP TABLE t1; 61 DROP TABLE t1; 88 DROP TABLE t1; 115 DROP TABLE t1; 142 DROP TABLE t1; [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 16 SELECT * FROM t1; 17 TRUNCATE TABLE t1; 20 SELECT * FROM t1; 29 SELECT * FROM t1; 33 SELECT * FROM t1; 34 DROP TABLE t1; 61 DROP TABLE t1; 88 DROP TABLE t1; 115 DROP TABLE t1; 142 DROP TABLE t1; [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/engines/funcs/t/ |
H A D | ai_reset_by_truncate.test | 2 DROP TABLE IF EXISTS t1; 12 SELECT * FROM t1; 13 TRUNCATE TABLE t1; 16 SELECT * FROM t1; 25 SELECT * FROM t1; 29 SELECT * FROM t1; 30 DROP TABLE t1; 57 DROP TABLE t1; 84 DROP TABLE t1; 111 DROP TABLE t1; [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/r/ |
H A D | ta_add_column_first.result | 5 t1 8 t1 CREATE TABLE `t1` ( 17 t1 CREATE TABLE `t1` ( 30 t1 CREATE TABLE `t1` ( 39 t1 CREATE TABLE `t1` ( 52 t1 CREATE TABLE `t1` ( 61 t1 CREATE TABLE `t1` ( 74 t1 CREATE TABLE `t1` ( 83 t1 CREATE TABLE `t1` ( 96 t1 CREATE TABLE `t1` ( [all …]
|