diff options
author | unknown <istruewing@stella.local> | 2007-11-01 17:12:13 +0100 |
---|---|---|
committer | unknown <istruewing@stella.local> | 2007-11-01 17:12:13 +0100 |
commit | 27dbd3a917611ea134eaff36cc915309f626c246 (patch) | |
tree | 75023762f4664bb33950ad8e7f911124cf14a287 /mysql-test/include | |
parent | 0ac10ca0e0b5be267fdd4662ce8db2febb1ff1cf (diff) | |
parent | baa757d3e3dca4ae15adfc194e42a266882debab (diff) | |
download | mariadb-git-27dbd3a917611ea134eaff36cc915309f626c246.tar.gz |
Merge stella.local:/home2/mydev/mysql-5.0-axmrg
into stella.local:/home2/mydev/mysql-5.1-axmrg
mysql-test/t/variables.test:
Manual merge from 5.0
Diffstat (limited to 'mysql-test/include')
-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 |