Re: Unable to get spatial examples working

[Michael Gray]

Okay - Have figured out a little more -- apparently it is a problem with my use of the MySQL Query Browser -- it is treating each line independently of each other instead of as a single active session. Thus, the NULLs are caused by the 3rd line NOT knowing what the variables are! Argh.

I tested it by opening a direct cmd interface into MySQL -->

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -ppassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 5.0.19-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET @g1 := GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
Query OK, 0 rows affected (0.00 sec)

mysql> SET @g2 := GeomFromText('Polygon((0 0,0 5,5 5,5 0,0 0))');
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT MBRWithin(@g1,@g2), MBRWithin(@g2,@g1);
+--------------------+--------------------+
| MBRWithin(@g1,@g2) | MBRWithin(@g2,@g1) |
+--------------------+--------------------+
| 1 | 0 |
+--------------------+--------------------+
1 row in set (0.00 sec)



Soo.... the question now remaining, is what query environment (preferably freeware) are you using to develop with variables and spatial gis in? I don't need much of a gui (number of years in SQLServer/SQL Query Analyzer/and distant past a bit of Oracle).