Home
last modified time | relevance | path

Searched refs:email_i (Results 1 – 25 of 54) sorted by relevance

123

/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/t/
H A Dtype_varchar.test57 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
60 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
61 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
71 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
72 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
H A Dtype_char_indexes_collation.test116 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
119 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
120 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
124 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
126 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/t/
H A Dtype_varchar.test57 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
60 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
61 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
71 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
72 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/t/
H A Dtype_varchar.test57 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
60 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
61 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
71 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
72 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/mariadb104-server/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/t/
H A Dtype_varchar.test53 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
56 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
57 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
64 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
67 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/mariadb104-client/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/t/
H A Dtype_varchar.test53 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
56 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
57 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
64 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
67 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/mariadb103-client/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/t/
H A Dtype_varchar.test53 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
56 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
57 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
64 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
67 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/t/
H A Dtype_varchar.test53 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
56 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
57 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
64 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
67 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/mariadb103-server/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/t/
H A Dtype_varchar.test53 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
56 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
57 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
64 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
67 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/t/
H A Dtype_varchar.test53 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
56 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
57 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
64 create table t (id int primary key, email varchar(100), KEY email_i (email(30)));
67 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
68 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/rocksdb/t/
H A Dtype_varchar.test55 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb;
58 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
59 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
66 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb;
69 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
70 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/rocksdb/t/
H A Dtype_varchar.test55 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb;
58 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
59 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
66 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb;
69 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
70 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/rocksdb/t/
H A Dtype_varchar.test55 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb;
58 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
59 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
66 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb;
69 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
70 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
81 1 SIMPLE t index NULL email_i 33 NULL # Using index
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
81 1 SIMPLE t index NULL email_i 33 NULL # Using index
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
81 1 SIMPLE t index NULL email_i 33 NULL # Using index
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/rocksdb/r/
H A Dtype_char_indexes_collation.result100 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
102 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
104 1 SIMPLE t NULL index NULL email_i 33 NULL # # Using index
106 Note 1003 /* select#1 */ select 'email_i' AS `index_name`,count(0) AS `count` from `test`.`t` FORCE…
107 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
109 email_i 1
111 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
113 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
115 email_i 1
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/rocksdb/r/
H A Dtype_char_indexes_collation.result100 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
102 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
104 1 SIMPLE t NULL index NULL email_i 33 NULL # # Using index
106 Note 1003 /* select#1 */ select 'email_i' AS `index_name`,count(0) AS `count` from `test`.`t` FORCE…
107 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
109 email_i 1
111 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
113 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
115 email_i 1
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/rocksdb/r/
H A Dtype_char_indexes_collation.result100 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
102 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
104 1 SIMPLE t NULL index NULL email_i 33 NULL # # Using index
106 Note 1003 /* select#1 */ select 'email_i' AS `index_name`,count(0) AS `count` from `test`.`t` FORCE…
107 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
109 email_i 1
111 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
113 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
115 email_i 1
/dports/databases/mariadb104-server/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/mariadb104-client/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/mariadb103-client/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/mariadb103-server/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/r/
H A Dtype_char_indexes_collation.result77 create table t (id int primary key, email varchar(100), KEY email_i (email(30))) engine=rocksdb def…
79 explain select 'email_i' as index_name, count(*) AS count from t force index(email_i);
82 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
84 email_i 1
86 create table t (id int primary key, email varchar(767), KEY email_i (email)) engine=rocksdb default…
88 select 'email_i' as index_name, count(*) AS count from t force index(email_i);
90 email_i 1

123