diff options
| author | istruewing@stella.local <> | 2007-11-01 17:12:13 +0100 |
|---|---|---|
| committer | istruewing@stella.local <> | 2007-11-01 17:12:13 +0100 |
| commit | 791deb8b780a1cf0806d873dbc1a92d286024999 (patch) | |
| tree | 75023762f4664bb33950ad8e7f911124cf14a287 /mysql-test | |
| parent | 3707119e2e1a9aa6f9b58aed0e9a7c57c539b11e (diff) | |
| parent | fc888bc93252dfc8b9dd655934b6dc069acce12a (diff) | |
| download | mariadb-git-791deb8b780a1cf0806d873dbc1a92d286024999.tar.gz | |
Merge stella.local:/home2/mydev/mysql-5.0-axmrg
into stella.local:/home2/mydev/mysql-5.1-axmrg
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/include/gis_keys.inc | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/include/gis_keys.inc b/mysql-test/include/gis_keys.inc index 295e0c48234..c75311f062a 100644 --- a/mysql-test/include/gis_keys.inc +++ b/mysql-test/include/gis_keys.inc @@ -13,20 +13,20 @@ CREATE TABLE t2 (p POINT, INDEX(p)); INSERT INTO t1 VALUES (POINTFROMTEXT('POINT(1 2)')); INSERT INTO t2 VALUES (POINTFROMTEXT('POINT(1 2)')); --- no index, returns 1 as expected +# no index, returns 1 as expected SELECT COUNT(*) FROM t1 WHERE p=POINTFROMTEXT('POINT(1 2)'); --- with index, returns 1 as expected --- EXPLAIN shows that the index is not used though --- due to the "most rows covered anyway, so a scan is more effective" rule +# with index, returns 1 as expected +# EXPLAIN shows that the index is not used though +# due to the "most rows covered anyway, so a scan is more effective" rule EXPLAIN SELECT COUNT(*) FROM t2 WHERE p=POINTFROMTEXT('POINT(1 2)'); SELECT COUNT(*) FROM t2 WHERE p=POINTFROMTEXT('POINT(1 2)'); --- adding another row to the table so that --- the "most rows covered" rule doesn't kick in anymore --- now EXPLAIN shows the index used on the table --- and we're getting the wrong result again +# adding another row to the table so that +# the "most rows covered" rule doesn't kick in anymore +# now EXPLAIN shows the index used on the table +# and we're getting the wrong result again INSERT INTO t1 VALUES (POINTFROMTEXT('POINT(1 2)')); INSERT INTO t2 VALUES (POINTFROMTEXT('POINT(1 2)')); EXPLAIN |