From: René Fournier
Date: December 21 2009 6:05am
Subject: Why does this query return no rows?
List-Archive: http://lists.mysql.com/mysql/219861
Message-Id: <AA996679-8D4C-49B5-AD88-CEB0BC2C0C35@renefournier.com>
MIME-Version: 1.0 (Apple Message framework v1077)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

This query works as expected:

mysql> SELECT id, AsText(coordinates) FROM qs WHERE latitude > 48.6 AND =
latitude < 53.4 AND longitude > -116.4 AND longitude < -111.6 LIMIT 3;
+--------+----------------------------------+
| id     | AsText(coordinates)              |
+--------+----------------------------------+
| 168155 | POINT(48.99702035 -111.60886893) |=20
| 168154 | POINT(48.99707385 -111.61983703) |=20
| 168160 | POINT(48.99712759 -111.63108001) |=20
+--------+----------------------------------+
3 rows in set (0.00 sec)

But this one doesn't:

mysql> SELECT id, AsText(coordinates) FROM qs WHERE =
MBRContains(GeomFromText('POLYGON((48.6 -116.4,53.4 -116.4,53.4 =
-111.6,48.6 -111.6,48.6 -116.4))'), coordinates) LIMIT 3;
Empty set (0.00 sec)

What am I doing wrong?

...Rene