| /dports/databases/mariadb105-client/mariadb-10.5.15/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_select_max.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MAX(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_select_min.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MIN(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 ASC, score3 ASC;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 DESC, score3 DESC;
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than.result | 5 score2 INT,
7 INDEX (score1, created_at, score2)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`created_at`,`score2`)
19 INSERT INTO items (score1, score2, created_at) VALUES(1, 0, "2015-07-01 00:00:00");
20 INSERT INTO items (score1, score2, created_at) VALUES(2, 0, "2015-07-01 00:00:00");
21 INSERT INTO items (score1, score2, created_at) VALUES(3, 0, "2015-07-01 00:00:00");
22 INSERT INTO items (score1, score2, created_at) VALUES(1, 0, "2015-07-01 12:00:00");
23 INSERT INTO items (score1, score2, created_at) VALUES(2, 0, "2015-07-01 12:00:00");
24 INSERT INTO items (score1, score2, created_at) VALUES(3, 0, "2015-07-01 12:00:00");
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_select_min.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MIN(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_select_max.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MAX(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 ASC, score3 ASC;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 DESC, score3 DESC;
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_select_min.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MIN(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_select_max.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MAX(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 DESC, score3 DESC;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 ASC, score3 ASC;
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_select_max.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MAX(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_select_min.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MIN(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 ASC, score3 ASC;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 DESC, score3 DESC;
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_select_max.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MAX(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_select_min.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MIN(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 DESC, score3 DESC;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 ASC, score3 ASC;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_select_max.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MAX(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_select_min.result | 5 score2 INT NOT NULL,
6 INDEX (score1, score2)
8 INSERT INTO scores (score1, score2) VALUES(1, 1);
9 INSERT INTO scores (score1, score2) VALUES(1, 2);
10 INSERT INTO scores (score1, score2) VALUES(2, 3);
11 INSERT INTO scores (score1, score2) VALUES(2, 2);
12 INSERT INTO scores (score1, score2) VALUES(2, 1);
13 INSERT INTO scores (score1, score2) VALUES(2, 0);
14 INSERT INTO scores (score1, score2) VALUES(2, -1);
17 SELECT MIN(score2) FROM scores WHERE score1 = 2;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 ASC, score3 ASC;
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 5 score2 INT,
7 INDEX (score1, score2, score3)
14 `score2` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`score2`,`score3`)
19 INSERT INTO items (score1, score2, score3) VALUES(1, 10, -100);
20 INSERT INTO items (score1, score2, score3) VALUES(1, 10, 0);
21 INSERT INTO items (score1, score2, score3) VALUES(2, 10, 100);
22 INSERT INTO items (score1, score2, score3) VALUES(2, 30, -100);
23 INSERT INTO items (score1, score2, score3) VALUES(2, 30, 0);
31 ORDER BY score2 DESC, score3 DESC;
[all …]
|