andy w Wrote:
> That is, when using InnoDB tables, MySQL cannot
> find a point if an index is defined in that column
> (table t2). However, if an index is not defined
> (table t1) or the engine is MyISAM (table t3) then
> the point is found.
> Is this a bug or is it documented somewhere?
Looks like a bug, i filed a bug report for it:
http://bugs.mysql.com/bug.php?id=30825
it is not InnoDB specific by the way, add another
POINT to the MyISAM table with index and the
query will fail, too. It just succeeded by accident
on the one row table as the optimizer chose to
ignore the index and do a full scann instead on that one.
--
hartmut
--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering