Why does this query return no rows?

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg