Home
last modified time | relevance | path

Searched refs:t2i (Results 1 – 25 of 553) sorted by relevance

12345678910>>...23

/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
85 explain select min(7) from t2i join t1i;
87 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
91 select min(7) from t2i join t1i;
103 explain select max(7) from t2i join t1i;
105 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
109 select max(7) from t2i join t1i;
145 explain select count(*), min(7), max(7) from t1m, t2i;
151 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/tokudb.bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/tokudb.bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/mariadb104-server/mariadb-10.4.24/storage/tokudb/mysql-test/tokudb_bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/mariadb104-client/mariadb-10.4.24/storage/tokudb/mysql-test/tokudb_bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/tokudb/mysql-test/tokudb_bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/mariadb103-client/mariadb-10.3.34/storage/tokudb/mysql-test/tokudb_bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/mariadb103-server/mariadb-10.3.34/storage/tokudb/mysql-test/tokudb_bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/tokudb/mysql-test/tokudb_bugs/r/
H A Dmdev5932.result2 drop table if exists t1i,t2i;
22 CREATE TABLE t2i AS
24 SELECT * FROM t2i;
26 include/diff_tables.inc [t2,t2i]
27 drop table t1,t2,t1i,t2i;
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
83 explain select min(7) from t2i join t1i;
85 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
89 select min(7) from t2i join t1i;
101 explain select max(7) from t2i join t1i;
103 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
107 select max(7) from t2i join t1i;
142 explain select count(*), min(7), max(7) from t1m, t2i;
147 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
83 explain select min(7) from t2i join t1i;
85 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
89 select min(7) from t2i join t1i;
101 explain select max(7) from t2i join t1i;
103 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
107 select max(7) from t2i join t1i;
142 explain select count(*), min(7), max(7) from t1m, t2i;
147 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
83 explain select min(7) from t2i join t1i;
85 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
89 select min(7) from t2i join t1i;
101 explain select max(7) from t2i join t1i;
103 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
107 select max(7) from t2i join t1i;
142 explain select count(*), min(7), max(7) from t1m, t2i;
147 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
83 explain select min(7) from t2i join t1i;
85 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
89 select min(7) from t2i join t1i;
101 explain select max(7) from t2i join t1i;
103 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
107 select max(7) from t2i join t1i;
142 explain select count(*), min(7), max(7) from t1m, t2i;
147 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
83 explain select min(7) from t2i join t1i;
85 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
89 select min(7) from t2i join t1i;
101 explain select max(7) from t2i join t1i;
103 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
107 select max(7) from t2i join t1i;
142 explain select count(*), min(7), max(7) from t1m, t2i;
147 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/r/
H A Dfunc_group_innodb.result13 create table t2i (a int) engine=innodb;
15 insert into t2i values (5);
83 explain select min(7) from t2i join t1i;
85 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
89 select min(7) from t2i join t1i;
101 explain select max(7) from t2i join t1i;
103 1 SIMPLE t2i NULL ALL NULL NULL NULL NULL 1 100.00 NULL
107 select max(7) from t2i join t1i;
142 explain select count(*), min(7), max(7) from t1m, t2i;
147 select count(*), min(7), max(7) from t1m, t2i;
[all …]
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/r/
H A Dsubquery_mat_all.result22 create table t2i (b1 char(8), b2 char(8));
27 create index it2i1 on t2i (b1);
28 create index it2i2 on t2i (b2);
29 create index it2i3 on t2i (b1, b2);
34 insert into t2i select * from t2;
271 1 SIMPLE t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatc…
273 …t2i` join `test`.`t3i`) semi join (`test`.`t2i`) where ((`test`.`t1i`.`a2` = `test`.`t2i`.`b2`) an…
357 7 UNION t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatch…
804 CREATE TABLE t2 (t2i int);
816 SELECT t2i
[all …]
H A Dsubquery_mat_none.result3 drop table if exists t1, t2, t3, t1i, t2i, t3i;
21 create table t2i (b1 char(8), b2 char(8));
26 create index it2i1 on t2i (b1);
27 create index it2i2 on t2i (b2);
28 create index it2i3 on t2i (b1, b2);
33 insert into t2i select * from t2;
133 …t2i` where (`test`.`t2i`.`b1` > '0') group by `test`.`t2i`.`b1` having (((<cache>(`test`.`t1i`.`a1…
173 …t2i` where (`test`.`t2i`.`b1` > '0') group by `test`.`t2i`.`b1` having (((<cache>(`test`.`t1`.`a1`…
794 CREATE TABLE t2 (t2i int);
806 SELECT t2i
[all …]
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/r/
H A Dsubquery_mat_all.result22 create table t2i (b1 char(8), b2 char(8));
27 create index it2i1 on t2i (b1);
28 create index it2i2 on t2i (b2);
29 create index it2i3 on t2i (b1, b2);
34 insert into t2i select * from t2;
271 1 SIMPLE t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatc…
273 …t2i` join `test`.`t3i`) semi join (`test`.`t2i`) where ((`test`.`t1i`.`a2` = `test`.`t2i`.`b2`) an…
357 7 UNION t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatch…
804 CREATE TABLE t2 (t2i int);
816 SELECT t2i
[all …]
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/r/
H A Dsubquery_mat_all.result22 create table t2i (b1 char(8), b2 char(8));
27 create index it2i1 on t2i (b1);
28 create index it2i2 on t2i (b2);
29 create index it2i3 on t2i (b1, b2);
34 insert into t2i select * from t2;
271 1 SIMPLE t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatc…
273 …t2i` join `test`.`t3i`) semi join (`test`.`t2i`) where ((`test`.`t1i`.`a2` = `test`.`t2i`.`b2`) an…
357 7 UNION t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatch…
804 CREATE TABLE t2 (t2i int);
816 SELECT t2i
[all …]
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/r/
H A Dsubquery_mat_all.result22 create table t2i (b1 char(8), b2 char(8));
27 create index it2i1 on t2i (b1);
28 create index it2i2 on t2i (b2);
29 create index it2i3 on t2i (b1, b2);
34 insert into t2i select * from t2;
271 1 SIMPLE t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatc…
273 …t2i` join `test`.`t3i`) semi join (`test`.`t2i`) where ((`test`.`t1i`.`a2` = `test`.`t2i`.`b2`) an…
357 7 UNION t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatch…
804 CREATE TABLE t2 (t2i int);
816 SELECT t2i
[all …]
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/r/
H A Dsubquery_mat_all.result22 create table t2i (b1 char(8), b2 char(8));
27 create index it2i1 on t2i (b1);
28 create index it2i2 on t2i (b2);
29 create index it2i3 on t2i (b1, b2);
34 insert into t2i select * from t2;
271 1 SIMPLE t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatc…
273 …t2i` join `test`.`t3i`) semi join (`test`.`t2i`) where ((`test`.`t1i`.`a2` = `test`.`t2i`.`b2`) an…
357 7 UNION t2i ref it2i1,it2i2,it2i3 it2i3 18 test.t2i.b1,test.t2i.b2 2 100.00 Using index; FirstMatch…
804 CREATE TABLE t2 (t2i int);
816 SELECT t2i
[all …]

12345678910>>...23