Home
last modified time | relevance | path

Searched refs:t1 (Results 76 – 100 of 28848) sorted by relevance

12345678910>>...1154

/dports/databases/postgresql13-plperl/postgresql-13.5/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…
174 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…
175 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…
178 …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…
179 …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…
186 …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…
187 …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/postgresql13-docs/postgresql-13.5/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…
174 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…
175 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…
178 …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…
179 …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…
186 …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…
187 …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/mariadb105-client/mariadb-10.5.15/mysql-test/main/
H A Dhaving_cond_pushdown.test11 AS SELECT t1.a,MAX(t1.b),t1.c
86 SELECT t1.a,MAX(t1.b),MIN(t1.c)
95 SELECT t1.a,MAX(t1.b),t1.c
319 SELECT t1.a,MAX(t1.b),t1.c
328 SELECT t1.a,MAX(t1.b),t1.c FROM t1
335 SELECT MAX(t1.a),t1.a,t1.b,t1.c
344 SELECT MAX(t1.a),t1.a,t1.b,t1.c
387 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
397 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
432 WHERE (t1.a=t1.c) AND (t1.a>1) AND (t1.c<3)
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/
H A Dhaving_cond_pushdown.test11 AS SELECT t1.a,MAX(t1.b),t1.c
86 SELECT t1.a,MAX(t1.b),MIN(t1.c)
95 SELECT t1.a,MAX(t1.b),t1.c
319 SELECT t1.a,MAX(t1.b),t1.c
328 SELECT t1.a,MAX(t1.b),t1.c FROM t1
335 SELECT MAX(t1.a),t1.a,t1.b,t1.c
344 SELECT MAX(t1.a),t1.a,t1.b,t1.c
387 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
397 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
432 WHERE (t1.a=t1.c) AND (t1.a>1) AND (t1.c<3)
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/
H A Dhaving_cond_pushdown.test11 AS SELECT t1.a,MAX(t1.b),t1.c
86 SELECT t1.a,MAX(t1.b),MIN(t1.c)
95 SELECT t1.a,MAX(t1.b),t1.c
319 SELECT t1.a,MAX(t1.b),t1.c
328 SELECT t1.a,MAX(t1.b),t1.c FROM t1
335 SELECT MAX(t1.a),t1.a,t1.b,t1.c
344 SELECT MAX(t1.a),t1.a,t1.b,t1.c
387 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
397 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
432 WHERE (t1.a=t1.c) AND (t1.a>1) AND (t1.c<3)
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/
H A Dhaving_cond_pushdown.test11 AS SELECT t1.a,MAX(t1.b),t1.c
86 SELECT t1.a,MAX(t1.b),MIN(t1.c)
95 SELECT t1.a,MAX(t1.b),t1.c
319 SELECT t1.a,MAX(t1.b),t1.c
328 SELECT t1.a,MAX(t1.b),t1.c FROM t1
335 SELECT MAX(t1.a),t1.a,t1.b,t1.c
344 SELECT MAX(t1.a),t1.a,t1.b,t1.c
387 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
397 HAVING ((t1.a=t1.c) AND (t1.a>1)) OR ((t1.a<3) AND (t1.c>3));
432 WHERE (t1.a=t1.c) AND (t1.a>1) AND (t1.c<3)
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test15 SELECT * FROM t1;
16 TRUNCATE TABLE t1;
19 SELECT * FROM t1;
27 SELECT * FROM t1;
31 SELECT * FROM t1;
32 DROP TABLE t1;
57 DROP TABLE t1;
82 DROP TABLE t1;
107 DROP TABLE t1;
132 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test15 SELECT * FROM t1;
16 TRUNCATE TABLE t1;
19 SELECT * FROM t1;
27 SELECT * FROM t1;
31 SELECT * FROM t1;
32 DROP TABLE t1;
57 DROP TABLE t1;
82 DROP TABLE t1;
107 DROP TABLE t1;
132 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test17 SELECT * FROM t1;
18 TRUNCATE TABLE t1;
21 SELECT * FROM t1;
29 SELECT * FROM t1;
33 SELECT * FROM t1;
34 DROP TABLE t1;
59 DROP TABLE t1;
84 DROP TABLE t1;
109 DROP TABLE t1;
134 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test15 SELECT * FROM t1;
16 TRUNCATE TABLE t1;
19 SELECT * FROM t1;
27 SELECT * FROM t1;
31 SELECT * FROM t1;
32 DROP TABLE t1;
57 DROP TABLE t1;
82 DROP TABLE t1;
107 DROP TABLE t1;
132 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test17 SELECT * FROM t1;
18 TRUNCATE TABLE t1;
21 SELECT * FROM t1;
29 SELECT * FROM t1;
33 SELECT * FROM t1;
34 DROP TABLE t1;
59 DROP TABLE t1;
84 DROP TABLE t1;
109 DROP TABLE t1;
134 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test17 SELECT * FROM t1;
18 TRUNCATE TABLE t1;
21 SELECT * FROM t1;
29 SELECT * FROM t1;
33 SELECT * FROM t1;
34 DROP TABLE t1;
59 DROP TABLE t1;
84 DROP TABLE t1;
109 DROP TABLE t1;
134 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/engines/funcs/t/
H A Dai_reset_by_truncate.test15 SELECT * FROM t1;
16 TRUNCATE TABLE t1;
19 SELECT * FROM t1;
27 SELECT * FROM t1;
31 SELECT * FROM t1;
32 DROP TABLE t1;
57 DROP TABLE t1;
82 DROP TABLE t1;
107 DROP TABLE t1;
132 DROP TABLE t1;
[all …]
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/math/cloog/cloog-cloog-0.20.0/test/
H A Ddarte.good.c67 for (t1=ceild(-2*n+5,2);t1<=min(-n+6,-1);t1++) { in test()
68 for (t2=-t1+2;t2<=-t1+4;t2++) { in test()
80 for (t2=-t1+5;t2<=t1+2*n;t2++) { in test()
122 for (t1=-n+7;t1<=-1;t1++) { in test()
123 for (t2=-t1+2;t2<=-t1+4;t2++) { in test()
195 for (t1=0;t1<=min(1,-n+6);t1++) { in test()
238 for (t1=max(-n+7,0);t1<=1;t1++) { in test()
239 for (t2=t1+2;t2<=-t1+4;t2++) { in test()
314 for (t1=2;t1<=n-5;t1++) { in test()
320 S1(t1+1,1,(-t1+t3-2)/2) ; in test()
[all …]
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/funcs/t/
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/engines/funcs/t/
H A Dse_string_distinct.test20 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
21 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
22 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
23 SELECT DISTINCT c1,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
24 SELECT DISTINCT c1,c2,c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
41 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
42 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
43 SELECT DISTINCT c3 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
62 SELECT DISTINCT c1 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
63 SELECT DISTINCT c2 FROM t1 WHERE t1.c1='#C2' AND t1.c2='#C2';
[all …]

12345678910>>...1154