| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/storage_engine/ |
| H A D | type_binary_indexes.result | 3 b20 BINARY(20) <CUSTOM_COL_OPTIONS>,
6 <CUSTOM_INDEX> b20 (b20)
12 SELECT HEX(b20) FROM t1 ORDER BY b20;
13 HEX(b20)
28 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
31 SELECT HEX(b20) FROM t1 ORDER BY b20;
32 HEX(b20)
37 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
40 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
41 HEX(b20)
[all …]
|
| H A D | type_binary_indexes.test | 16 b20 BINARY(20) $col_indexed_opts,
19 $default_index b20 (b20)
35 SELECT HEX(b20) FROM t1 ORDER BY b20;
44 b20 BINARY(20) $col_indexed_opts PRIMARY KEY,
64 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
65 SELECT HEX(b20) FROM t1 ORDER BY b20;
68 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
69 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
76 b20 BINARY(20) $col_opts,
115 b20 BINARY(20) $col_opts,
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/storage_engine/ |
| H A D | type_binary_indexes.result | 3 b20 BINARY(20) <CUSTOM_COL_OPTIONS>,
6 <CUSTOM_INDEX> b20 (b20)
12 SELECT HEX(b20) FROM t1 ORDER BY b20;
13 HEX(b20)
28 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
31 SELECT HEX(b20) FROM t1 ORDER BY b20;
32 HEX(b20)
37 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
40 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
41 HEX(b20)
[all …]
|
| H A D | type_binary_indexes.test | 16 b20 BINARY(20) $col_indexed_opts,
19 $default_index b20 (b20)
35 SELECT HEX(b20) FROM t1 ORDER BY b20;
44 b20 BINARY(20) $col_indexed_opts PRIMARY KEY,
64 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
65 SELECT HEX(b20) FROM t1 ORDER BY b20;
68 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
69 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
76 b20 BINARY(20) $col_opts,
115 b20 BINARY(20) $col_opts,
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/storage_engine/ |
| H A D | type_binary_indexes.result | 3 b20 BINARY(20) <CUSTOM_COL_OPTIONS>,
6 <CUSTOM_INDEX> b20 (b20)
12 SELECT HEX(b20) FROM t1 ORDER BY b20;
13 HEX(b20)
28 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
31 SELECT HEX(b20) FROM t1 ORDER BY b20;
32 HEX(b20)
37 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
40 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
41 HEX(b20)
[all …]
|
| H A D | type_binary_indexes.test | 16 b20 BINARY(20) $col_indexed_opts,
19 $default_index b20 (b20)
35 SELECT HEX(b20) FROM t1 ORDER BY b20;
44 b20 BINARY(20) $col_indexed_opts PRIMARY KEY,
64 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
65 SELECT HEX(b20) FROM t1 ORDER BY b20;
68 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
69 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
76 b20 BINARY(20) $col_opts,
115 b20 BINARY(20) $col_opts,
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/storage_engine/ |
| H A D | type_binary_indexes.result | 3 b20 BINARY(20) <CUSTOM_COL_OPTIONS>,
6 <CUSTOM_INDEX> b20 (b20)
12 SELECT HEX(b20) FROM t1 ORDER BY b20;
13 HEX(b20)
28 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
31 SELECT HEX(b20) FROM t1 ORDER BY b20;
32 HEX(b20)
37 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
40 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
41 HEX(b20)
[all …]
|
| H A D | type_binary_indexes.test | 16 b20 BINARY(20) $col_indexed_opts,
19 $default_index b20 (b20)
35 SELECT HEX(b20) FROM t1 ORDER BY b20;
44 b20 BINARY(20) $col_indexed_opts PRIMARY KEY,
64 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
65 SELECT HEX(b20) FROM t1 ORDER BY b20;
68 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
69 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
76 b20 BINARY(20) $col_opts,
115 b20 BINARY(20) $col_opts,
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/storage_engine/ |
| H A D | type_binary_indexes.result | 3 b20 BINARY(20) <CUSTOM_COL_OPTIONS>,
6 <CUSTOM_INDEX> b20 (b20)
12 SELECT HEX(b20) FROM t1 ORDER BY b20;
13 HEX(b20)
28 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
31 SELECT HEX(b20) FROM t1 ORDER BY b20;
32 HEX(b20)
37 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
40 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
41 HEX(b20)
[all …]
|
| H A D | type_binary_indexes.test | 16 b20 BINARY(20) $col_indexed_opts,
19 $default_index b20 (b20)
35 SELECT HEX(b20) FROM t1 ORDER BY b20;
44 b20 BINARY(20) $col_indexed_opts PRIMARY KEY,
64 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
65 SELECT HEX(b20) FROM t1 ORDER BY b20;
68 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
69 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
76 b20 BINARY(20) $col_opts,
115 b20 BINARY(20) $col_opts,
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/storage_engine/ |
| H A D | type_binary_indexes.result | 3 b20 BINARY(20) <CUSTOM_COL_OPTIONS>,
6 <CUSTOM_INDEX> b20 (b20)
12 SELECT HEX(b20) FROM t1 ORDER BY b20;
13 HEX(b20)
28 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
31 SELECT HEX(b20) FROM t1 ORDER BY b20;
32 HEX(b20)
37 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
40 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
41 HEX(b20)
[all …]
|
| H A D | type_binary_indexes.test | 16 b20 BINARY(20) $col_indexed_opts,
19 $default_index b20 (b20)
35 SELECT HEX(b20) FROM t1 ORDER BY b20;
44 b20 BINARY(20) $col_indexed_opts PRIMARY KEY,
64 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
65 SELECT HEX(b20) FROM t1 ORDER BY b20;
68 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
69 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
76 b20 BINARY(20) $col_opts,
115 b20 BINARY(20) $col_opts,
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/rocksdb/r/ |
| H A D | type_binary_indexes.result | 4 b20 BINARY(20) PRIMARY KEY,
12 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 … 1003 /* select#1 */ select hex(`test`.`t1`.`b20`) AS `HEX(b20)` from `test`.`t1` order by `test`.…
17 SELECT HEX(b20) FROM t1 ORDER BY b20;
18 HEX(b20)
23 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
27 …lect#1 */ select hex(`test`.`t1`.`b20`) AS `HEX(b20)` from `test`.`t1` IGNORE INDEX (PRIMARY) orde…
28 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
29 HEX(b20)
36 b20 BINARY(20),
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/rocksdb/r/ |
| H A D | type_binary_indexes.result | 4 b20 BINARY(20) PRIMARY KEY,
12 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 … 1003 /* select#1 */ select hex(`test`.`t1`.`b20`) AS `HEX(b20)` from `test`.`t1` order by `test`.…
17 SELECT HEX(b20) FROM t1 ORDER BY b20;
18 HEX(b20)
23 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
27 …lect#1 */ select hex(`test`.`t1`.`b20`) AS `HEX(b20)` from `test`.`t1` IGNORE INDEX (PRIMARY) orde…
28 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
29 HEX(b20)
36 b20 BINARY(20),
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/rocksdb/r/ |
| H A D | type_binary_indexes.result | 4 b20 BINARY(20) PRIMARY KEY,
12 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 … 1003 /* select#1 */ select hex(`test`.`t1`.`b20`) AS `HEX(b20)` from `test`.`t1` order by `test`.…
17 SELECT HEX(b20) FROM t1 ORDER BY b20;
18 HEX(b20)
23 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
27 …lect#1 */ select hex(`test`.`t1`.`b20`) AS `HEX(b20)` from `test`.`t1` IGNORE INDEX (PRIMARY) orde…
28 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
29 HEX(b20)
36 b20 BINARY(20),
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/storage/rocksdb/mysql-test/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/storage/rocksdb/mysql-test/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/storage/rocksdb/mysql-test/rocksdb/r/ |
| H A D | type_binary_indexes.result | 5 b20 BINARY(20) PRIMARY KEY,
11 t1 0 PRIMARY 1 b20 A 1000 NULL NULL LSMTREE
12 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
13 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
16 SELECT HEX(b20) FROM t1 ORDER BY b20;
17 HEX(b20)
22 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
25 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
26 HEX(b20)
33 b20 BINARY(20),
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/rocksdb/t/ |
| H A D | type_binary_indexes.test | 21 b20 BINARY(20) PRIMARY KEY,
28 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
31 EXPLAIN SELECT HEX(b20) FROM t1 ORDER BY b20;
32 SELECT HEX(b20) FROM t1 ORDER BY b20;
35 EXPLAIN SELECT HEX(b20) FROM t1 IGNORE INDEX (PRIMARY) ORDER BY b20 DESC;
36 SELECT HEX(b20) FROM t1 ORDER BY b20 DESC;
43 b20 BINARY(20),
53 INSERT INTO t1 (b,b20,v16,v128) VALUES ('a','char1','varchar1a','varchar1b'),('a','char2','varchar2…
75 b20 BINARY(20),
84 INSERT INTO t1 (b,b20,v16,v128,pk) VALUES ('a','char1','varchar1a','varchar1b',1),('a','char2','var…
[all …]
|