Kouhei Sutou
null+****@clear*****
Thu Nov 26 12:23:27 JST 2015
Kouhei Sutou 2015-11-26 12:23:27 +0900 (Thu, 26 Nov 2015) New Revision: 1256dddfea104608fb58239bf750b470a090bbbf https://github.com/mroonga/mroonga/commit/1256dddfea104608fb58239bf750b470a090bbbf Message: test: add a test for index is used for MRBContains Modified files: mysql-test/mroonga/storage/geometry/r/contains.result mysql-test/mroonga/storage/geometry/t/contains.test Modified: mysql-test/mroonga/storage/geometry/r/contains.result (+6 -0) =================================================================== --- mysql-test/mroonga/storage/geometry/r/contains.result 2015-11-24 00:00:18 +0900 (29fd989) +++ mysql-test/mroonga/storage/geometry/r/contains.result 2015-11-26 12:23:27 +0900 (95959f6) @@ -167,4 +167,10 @@ id name location_text 14 tetsuji POINT(139.76857 35.680911944444446) 19 daruma POINT(139.7705988888889 35.68146111111111) 26 kazuya POINT(139.760895 35.67350805555556) +EXPLAIN +SELECT id, name, ST_AsText(location) AS location_text FROM shops +WHERE MBRContains(ST_GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) +ORDER BY id; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE shops range location_index location_index 34 NULL 36 Using where; Using filesort DROP TABLE shops; Modified: mysql-test/mroonga/storage/geometry/t/contains.test (+5 -0) =================================================================== --- mysql-test/mroonga/storage/geometry/t/contains.test 2015-11-24 00:00:18 +0900 (bdbf8d3) +++ mysql-test/mroonga/storage/geometry/t/contains.test 2015-11-26 12:23:27 +0900 (4ca07cf) @@ -144,6 +144,11 @@ SELECT id, name, ST_AsText(location) AS location_text FROM shops WHERE MBRContains(ST_GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) ORDER BY id; +EXPLAIN +SELECT id, name, ST_AsText(location) AS location_text FROM shops + WHERE MBRContains(ST_GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) + ORDER BY id; + DROP TABLE shops; --source ../../../include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Download