How to perform MySQL spatial buffer function successfully? -


Does anyone use MySQL spatial buffer functions successfully? I have read the document here:

As mentioned in the document, there are 2 parameters in the buffer function, one geometry has been typed first, the second is the distance.

I have tried to create a geometry variable 

  mysql> Set @ G1 = GeFromText ('POINT (1)'); The query is ok, affected 0 rows (0.00 seconds)   
 Again, to ensure that my variable is set correctly, I execute a query. If the variable is not set correctly, such a query will return the call. In this situation, it is confirmed that my variable is set correctly  
  mysql> Choose Astext (@ G1); + ------------- + | Astext (@ G1) | + ------------- + | Number (1 1) | + ------------- + 1 line set (0.00 seconds)   
 I run a query to select buffer as described in the document.  > 
  mysql> Choose Astext (buffer (@ g1, 5)); Error 1305 (42000): Function module_devell.buffer does not exist   
 Do I miss something here?  
  Edit  Sorry, I think I miss it:  
 
 12.17.5.3.2. Local operator  
 OpenGIS offers many other functions that can produce physics. They are designed to implement local operators.  These functions are not implemented in MySQL.     
 
 
 This may be related to the bug report which MySQL server Are you using? You may need to upgrade.

Comments

Post a Comment