Home
last modified time | relevance | path

Searched refs:t1 (Results 226 – 250 of 51760) sorted by relevance

12345678910>>...2071

/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Dpartition_join.sql34 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…
145t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
146t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
153t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
154t1.* 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 Dpartition_join.sql34 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…
145t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
146t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
153t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
154t1.* 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 Dpartition_join.sql34 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…
145t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
146t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
153t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
154t1.* 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 Dpartition_join.sql34 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…
145t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
146t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
153t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
154t1.* 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 Dpartition_join.sql34 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…
145t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
146t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
153t1.* FROM prt1 t1 WHERE t1.a IN (SELECT t1.b FROM prt2 t1 WHERE t1.b IN (SELECT (t1.a + t1.b)/2 FR…
154t1.* 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 Dai_reset_by_truncate.test16 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 Dai_reset_by_truncate.test16 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 Dai_reset_by_truncate.test16 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dai_reset_by_truncate.test2 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 Dta_add_column_first.result5 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 …]

12345678910>>...2071