/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/t/ |
H A D | type_varchar.test | 57 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 D | type_char_indexes_collation.test | 116 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 D | type_varchar.test | 57 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 D | type_varchar.test | 57 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 D | type_varchar.test | 53 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 D | type_varchar.test | 53 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 D | type_varchar.test | 53 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 D | type_varchar.test | 53 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 D | type_varchar.test | 53 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 D | type_varchar.test | 53 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 D | type_varchar.test | 55 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 D | type_varchar.test | 55 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 D | type_varchar.test | 55 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 100 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 D | type_char_indexes_collation.result | 100 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 D | type_char_indexes_collation.result | 100 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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 D | type_char_indexes_collation.result | 77 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
|