| /dports/databases/mariadb105-client/mariadb-10.5.15/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at < "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at > "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at >= "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at <= "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_order_by_where_equal_asc_asc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at >= "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at <= "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at > "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at < "2015-07-01 12:00:00"
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at >= "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at > "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at < "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at <= "2015-07-01 12:00:00"
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_order_by_where_equal_asc_asc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_order_by_where_equal_desc_desc.result | 4 score1 INT,
7 INDEX (score1, score2, score3)
13 `score1` 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);
30 WHERE score1 = 2
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at < "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at <= "2015-07-01 12:00:00"
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/storage/mroonga/mysql-test/mroonga/storage/r/ |
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at > "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_greater_than_or_equal.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at >= "2015-07-01 12:00:00"
[all …]
|
| H A D | index_multiple_column_range_partially_used_have_prefix_less_than.result | 4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` 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");
30 WHERE score1 = 2 AND created_at < "2015-07-01 12:00:00"
[all …]
|