spaccabit / spatialite-android

Automatically exported from code.google.com/p/spatialite-android
0 stars 0 forks source link

Android app crash when perform a query on spatialite db #35

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?

1. Capture a series on point with tap event on map
2. Perform following query on spatialite db:

SELECT *,ST_AsBinary(CastToXY(geometry))AS MAPSTORE_9384_GEOMETRY 
FROM "railways_tuscany" 
WHERE ST_Intersects(geometry , PolygonFromText('POLYGON((11.067081970744752 
43.778865869630046 , 11.037556213908815 43.787417267897354 , 11.118408722453736 
43.79423272374205 , 11.043564362102174 43.735594405385626 , 11.123901886516236 
43.75407229689403))')) = 1  
AND ROWID IN (     
SELECT ROWID 
FROM Spatialindex WHERE f_table_name ='railways_tuscany'    
AND search_frame = PolygonFromText('POLYGON((11.067081970744752 
43.778865869630046 , 11.037556213908815 43.787417267897354 , 11.118408722453736 
43.79423272374205 , 11.043564362102174 43.735594405385626 , 11.123901886516236 
43.75407229689403))') ) LIMIT 1;

3.When results is different from one app crash.

What is the expected output? What do you see instead?
Expected output is a list of results, but app crash and report following error 
code:

Fatal signal 11 (SIGSEGV) at 0x00000000 (code=1), thread 15868 (ModernAsyncTask)

What version of the product are you using? On what operating system?
spatialite 3.0.1
android API 4.3
android OS on cellular 4.1.2

Please provide any additional information below.

Thanks to all.

Original issue reported on code.google.com by Jacopo.p...@gmail.com on 16 Jan 2014 at 1:06

GoogleCodeExporter commented 8 years ago
Have you tried closing your polygon?  i.e. repeat the first coordinates as the 
last.

Original comment by sconrad9...@gmail.com on 16 Apr 2015 at 8:16