All Tickets
Not logged in
Key: Active Review Fixed Tested Deferred Closed
# mtime type status subsystem title
000b0fb3fd 2016-12-10 13:36:08 Incident Fixed   Discrepancy in KNN function
01cc9e33cf 2020-08-26 07:16:49 Build_Problem Closed   Try to build the dll libspatialite-4.3.0a
043231bf1a 2020-08-26 07:10:58 Build_Problem Closed   Autoconf build for Android
0471a3a1a3 2016-04-24 10:18:03 Code_Defect Fixed    
050cb1d796 2016-04-06 11:37:07 Code_Defect Closed   UTF-8 encoding fail in dbf while using ImportSHP() SQL function
09771b704f 2016-12-29 04:30:22 Documentation Closed   Compilated version of libspatialite
0b20318c07 2019-07-30 06:00:27 Build_Problem Closed   libspatialite won't compile in void linux
0f72cca3a2 2018-07-12 17:50:59 Code_Defect Fixed   ATan2(y, x) is actually returning the result of ATan2(x, y) depending on type.
105da85e11 2018-06-19 13:39:07 Code_Defect Closed   Touches() fails to detect overlapping linestrings when one of them is a circular one
1512de6d8a 2018-07-14 16:54:36 Feature_Request Closed   Function utility to check if a (possibly text) column is numeric
17a510e68c 2017-11-19 15:06:18 Documentation Closed   return type of SQL functions for Spatial-MetaData and Spatial-Index handling is misleading
198c7314db 2020-08-02 11:26:58 Code_Defect Closed   GeomFromGeoJSON() fails with scientific notation numbers
1b33d171d1 2020-08-02 11:24:00 Code_Defect Closed   AddGeometryColumn missing SRID trigger
1bb24fe236 2020-08-26 07:21:22 Code_Defect Closed   AddFDOGeometryColumn does not support dimension=5 [XYZ]
1c3f376d50 2013-01-23 13:53:39 Code_Defect Fixed   CheckSpatialIndex() is FALSE on valid data with sqlite >= 3.7.13
1e70a58b76 2015-12-21 07:41:16 Code_Defect Closed   Precision for EXTENT function
28f6a8edf5 2020-08-26 07:14:56 Code_Defect Closed   Direct access to Spatial Index from view not working
29a40a5523 2020-09-25 08:08:08 Code_Defect Closed    
2a578d383e 2019-01-06 16:00:28 Feature_Request Closed   VirtualGeoJSON to assist import of text files fully in geojson format
2cad2f4b9d 2019-02-10 19:09:23 Code_Defect Closed   virtualknn test hangs
30b9b03338 2020-09-25 13:36:51 Feature_Request Closed   pgr_routing like dynamic costing in VirtualRouting
31db3c7543 2020-08-26 07:19:54 Code_Defect Closed   Stored Procedures metatables are not created automatically as documented
321a68420d 2015-10-30 19:21:41 Code_Defect Closed   segfault reading malformed CSV file
32906d4cc1 2016-11-29 12:35:04 Feature_Request Fixed   spatialite_gui: 'Edit Table row' with a sub-query not possible
3886d972c7 2017-04-27 11:31:33 Code_Defect Closed   CountUnsafeTriggers finds eval in fields like 'ByteValue' and 'DoubleValue'
38f5163a2d 2018-09-06 08:26:48 Code_Defect Closed   INSERT with ORDER BY from a VirtualText table, ORDER BY not correct
3a83871261 2018-08-18 15:36:46 Incident Closed   Shapefile with unusual header doesn't open
3ab67230de 2018-02-05 14:53:35 Build_Problem Closed    
3b05c89077 2015-09-08 10:19:33 Code_Defect Fixed   Use proj.4 geodesic distance routine if it's available
3e46349bf2 2020-12-01 07:45:07 Code_Defect Closed   Tests failing with PROJ 7.2
3e80a69485 2016-12-24 14:41:54 Documentation Closed   Shapefile question
42c515ec88 2018-08-11 17:34:58 Feature_Request Closed   Create Documentation for a Dummie
474a0ace03 2020-08-26 07:12:40 Code_Defect Closed   DXF import fails with a bloc's attribute named SECTION
47ee66e53c 2018-09-03 03:13:00 Feature_Request Closed   Move to GitHub
4a05517b43 2017-11-19 14:14:59 Code_Defect Closed   DisableSpatialIndex() doesn't drop idx_<table>_<col> table
4a1b0746fb 2017-11-19 12:32:14 Build_Problem Closed   Spatialite Cocoa Pod v4.1.1 on CocoaPods.org not compiling
4b5ea16108 2018-08-11 15:04:52 Code_Defect Closed   Patch to fix spelling errors
4f6395547e 2020-08-02 11:07:28 Documentation Closed   Performance
53e451acc7 2018-03-28 15:23:47 Code_Defect Fixed   Consistent use of sqlite3_int64 for SQLITE_INTEGER
564704aa69 2020-08-26 07:20:18 Documentation Closed   Stored Procedures: sample Database contains an invalid "stored_variables" TABLE
56510318e2 2017-04-27 11:24:30 Code_Defect Closed   Discrepancy with max_items in KNN function
597fce55f2 2017-05-30 09:59:19 Feature_Request Closed   Adapting addVectorLayerAuth to look for triggers for SpatialViews
5a23e67d33 2019-01-11 03:57:14 Documentation Closed   Release notes showing what's new in 5.0
5e5904b9e0 2020-08-26 07:18:54 Code_Defect Closed   DiscardGeometryColumn() leaves orphan rows in Spatial MetaData tables
604fae8d28 2020-08-26 07:18:17 Feature_Request Closed   Add logic to add missing new spatialite internal TABLES to older Databases
6139d9e734 2016-11-29 12:29:11 Feature_Request Fixed   Extending ElementaryGeometries functionality to return only unique Elements
6299732ae0 2018-07-12 17:49:43 Documentation Fixed   MBR predicates return NULL, but not -1 on NULL arguments
64565c9c1c 2020-08-26 07:16:25 Code_Defect Closed   mod_spatialite.dll for windows 64bit is not loading
6546d74141 2016-11-26 08:57:59 Incident Closed   Spatialite program crash when show OpenFileDialog
6763032337 2019-01-06 16:12:01 Code_Defect Closed   ST_InterpolatePoint returns incorrect answer
69f6377900 2018-12-13 14:59:20 Feature_Request Closed   Is there any ORM for SpatiaLite android?
6abf4e3b7a 2020-08-26 07:24:47 Code_Defect Closed    
6af9a4f1ff 2020-08-02 14:58:24 Build_Problem Closed   config.sub/config.guess are very old
6d2e188aba 2013-06-28 11:20:51 Code_Defect Closed   Tag <gml:pos> not implemented correctly in GeomFromGml method
6e00b793ec 2018-06-20 11:00:38 Documentation Fixed   documentation for AsGeoJSON precision
6eabdf0e6d 2019-05-15 08:59:05 Feature_Request Closed   Support for PROJ 6.0.0
70264084d8 2016-11-26 08:52:13 Code_Defect Fixed   Problems understanding the use of parameter out_multi_id of ElementaryGeometries
72b73df2a3 2016-11-26 10:32:06 Feature_Request Closed   spatialite produces NULL instead of empty geometries
74ba14876c 2019-07-25 18:52:30 Code_Defect Fixed   GeomFromGeoJSON requires properties in a specific order
75f611d860 2020-09-25 08:09:30 Code_Defect Closed   ImportSHP() fails if special characters in path (Windows)
760ef1affb 2020-12-01 07:37:04 Code_Defect Closed   CLI -silent does not suppress VirtualXPath, etc.
78f6da7811 2020-08-02 14:56:21 Build_Problem Closed   Some functions fail to compile if ICONV not available
7a2e998b64 2020-10-26 11:20:00 Code_Defect Closed   ImportZipSHP fails when the enclosed DBF file is larger than 2GB
84c2973733 2016-11-26 10:27:40 Code_Defect Fixed   An 'init_splite_internal_cache' function needed
89346e3b69 2015-12-22 11:11:42 Code_Defect Closed   Segfault in ST_Length()
89e186efa2 2016-04-06 09:36:03 Code_Defect Fixed   CSV import/export fails on fields >= 65536 in spatialite_gui
8c09a2fd87 2017-09-25 13:32:58 Code_Defect Tested   ST_Transform should ignore Z value as default, adding bAttempt3D Parameter
8c0df18c7a 2020-12-01 10:17:25 Documentation Closed   Spatialite with newer version of sqlite
8e6ab730f2 2019-07-30 05:45:35 Code_Defect Closed   compile fails in android for virtualgeojson.c though misuse of spatialite_e
8f59ddebf0 2018-03-28 15:39:54 Code_Defect Fixed   Log(b, x) is actually returning the result of Log(x, b).
9183e58794 2020-08-26 07:15:24 Documentation Closed   resolving GEOS memory leaks
94eb59015a 2018-01-10 10:50:33 Code_Defect Fixed   fnct_sp_stored_execute: Invalid free() / delete / delete[] / realloc() for 'blob'
96216ad92d 2020-08-26 07:29:49 Code_Defect Closed   axis order is not respected when using transform
970ab8322e 2020-08-02 16:10:31 Code_Defect Closed   spatial_ref_sys definitions shouldn't contain TOWGS84[] in WKT definition
99db4140e9 2020-08-27 08:53:57 Code_Defect Closed   mising blade identifier in LineString originating from a MultiLineString
9a3cb09825 2020-08-02 11:31:50 Documentation Closed   Recommended DQS setting
9aebc73687 2017-11-19 12:28:25 Documentation Fixed   spatialite-sql-latest.html has markup errors
9c9378264c 2018-03-28 15:53:46 Feature_Request Closed   add support for importing/exporting encoded polyline strings
a318e225b3 2019-02-28 13:33:13 Incident Closed   Problem on fonction ST_Intersection, ST_Intersects with COMPOUNDCURVE, CIRCULARSTRING
a36653eb0d 2017-11-20 15:22:50 Documentation Fixed   incorrect SetSRID description
a62b57f3d9 2020-08-26 07:11:35 Incident Closed   reoganisation of Windows Binary download files is needed
a90f4e1508 2016-11-26 08:31:33 Code_Defect Fixed   Documentation ST_ClosestPoint and ST_SetEndtPoint
aab7451665 2016-05-10 04:34:42 Code_Defect Fixed   ST_Line_Substring bring unexpected results
abbf0c051b 2015-12-06 11:06:47 Documentation Fixed   GeoHash precision option is undocumented
abeeaad448 2020-08-26 07:13:36 Build_Problem Closed   Use geos-config --cflags for getting the includes
abeeb6da79 2018-08-11 16:29:29 Build_Problem Closed   check_sql_stmt fail during build
adbde604ba 2018-01-08 05:03:48 Code_Defect Closed   libspatialite does not support newer versions of liblwgeom
af36b03cfa 2016-11-26 08:29:57 Code_Defect Fixed   non-zero distance in meters is returned for polygon and point covered by that polygon
afe76b7099 2019-01-06 15:43:55 Code_Defect Closed   After ImportDXF, no results found
b087afbba5 2017-04-20 15:35:00 Code_Defect Closed   VirtualKnn wrong join result
b1fcb045a7 2015-06-05 15:18:59 Code_Defect Closed   ST_HexagonalGrid and ST_TriangularGrid do not function with negative numbers in the geometry
b266297296 2020-08-26 07:35:24 Build_Problem Closed   spatialite_alloc_connection and PROJ_NEW
b422281811 2016-05-08 20:42:29 Code_Defect Closed   unwanted console output
b4e8fbfb77 2020-08-26 07:17:30 Code_Defect Closed   GeomFromGeoJSON - Parser stack overflow
b67135df9d 2016-11-26 10:31:24 Code_Defect Closed   importSHP, exportSHP and DBF writing to stderr
b70cf07009 2017-06-02 14:49:29 Build_Problem Closed   tests are linked against system-installed library
bbab46cf4d 2020-08-02 15:17:39 Incident Closed   Strange Interaction Between Spatialite and Shapely
bfddeed209 2020-12-01 19:19:02 Code_Defect Closed   SQL Procedures fail when searching/replacing '@'
c047d0dffb 2020-08-26 07:19:19 Documentation Closed   Purpose of field 'hidden' unclear
c1ad767d95 2016-04-24 09:42:47 Code_Defect Fixed   failure to set gaia_geosaux_error_msg, possible crash
c2ab8334b1 2019-01-06 15:48:49 Feature_Request Closed   Vector tiles support
c590f8547f 2017-01-26 03:20:30 Documentation Fixed   ST_Relate Documentation very confusing, misleading
c5feeb938a 2020-08-26 07:20:51 Code_Defect Closed   error closing database after SqlProc exception
cc7895b68b 2017-08-25 08:26:39 Code_Defect Closed   MakeValid fails with Unknown Reason on one feature
cd17e2742e 2017-03-27 15:34:50 Code_Defect Closed   Failed route geometry uses incorrect SRID
d363d89194 2020-09-25 13:50:06 Code_Defect Closed   VirtualKNN doesn't work from PHP, 0 rows returned
d580e0bded 2020-09-25 08:05:01 Build_Problem Closed   Function signature of GEOS_init_r
d721933f4d 2015-12-12 10:58:11 Feature_Request Fixed   adapt spatialite to function as sqlite3 for the macro .read (without need of UTF-8)
d9249c47f9 2018-11-29 12:27:34 Documentation Closed   Can I use this spatialite database with room library for android?
d95f6beaae 2020-09-29 16:19:36 Code_Defect Closed   ST_Cutter | resulting geometry bug
d975d135eb 2019-07-30 06:16:45 Documentation Closed   64 bit version of Spatialite for Android with LWGEOM
db0c391f2a 2016-12-05 18:09:27 Code_Defect Fixed   ImportWFS - test_wfs_paging: weird checks
dbbfdf8426 2015-09-07 11:48:11 Code_Defect Closed   Distribute application without need of installing additional software
decb2848ea 2013-10-21 11:38:07 Code_Defect Closed   check_sql_stmt fails on armel, armhf, mips & mipsel architectures.
e3446fff3f 2020-08-26 07:13:56 Build_Problem Closed   Unable to build spatialite 4.2 sources
e8d83559fb 2019-01-11 06:02:07 Documentation Closed   gaiaGetVectorLayersList returns wrong field name
eba55ae574 2016-11-26 08:33:20 Code_Defect Fixed   64 bit Windows extension causes crash when closing dataset
ebb65ee7ed 2019-01-06 16:21:37 Code_Defect Closed   @GEOS_CFLAGS@ place needs to be switched in Makefile.in
ed1f490e52 2017-03-09 11:49:12 Code_Defect Closed   Encryption for Spatialite
edd609bb5e 2020-09-25 14:00:26 Code_Defect Closed   config.sub/config.guess unchanged in 5.0.0
f0ec3458e4 2020-08-26 07:22:34 Feature_Request Closed   Spatialite bridge with Room android
f2ad2efd65 2020-08-26 07:13:12 Build_Problem Closed   Fix error in configure.ac: space is missing with GEOS LIBS
f3382164af 2020-12-01 12:22:59 Code_Defect Closed   ST_AsText doesn´t work within Python (sqlite3/mod_spatialite)
f65f05b71a 2020-09-25 13:44:45 Code_Defect Closed   InitSpatialMetadata() seg faults with PHP MapScript extension
f8444f1c67 2016-11-26 08:29:33 Code_Defect Fixed   ST_Distance(geom1 Geometry, geom2 Geometry, use_ellipsoid Boolean) returns NULL instead of zero
f86593f49e 2015-11-12 21:29:00 Code_Defect Closed   GeomFromWKB will not work with a bound parameter
fa7a523d5f 2017-01-26 03:22:02 Code_Defect Fixed   fnct_has_topology faulty #ifdef RTTOPO
fb96512d3c 2018-06-19 13:32:08 Feature_Request Fixed   GetSpatialIndexExtent: missing support for GeoPackages
fde6fb2385 2020-08-26 07:12:14 Build_Problem Closed   hexgrid22.testcase fails on 32bit architectures.
0ed7f875b5 2021-01-04 10:32:43 Code_Defect Closed   Silent option in spatialite is not totally silent
3a6c4b2e19 2021-01-04 10:41:55 Code_Defect Closed   Virtual Shapefile and character case
503b25be31 2021-02-04 18:16:51 Code_Defect Closed   spatialindex this has no effect in spatialite 5
bd44c48c06 2021-03-20 10:42:22 Code_Defect Closed   Tests failing with GEOS 3.9.1
dd93f283ce 2021-08-14 10:38:29 Code_Defect Closed   Error reading float in WKT
8e66e99c12 2021-08-14 11:08:29 Code_Defect Closed   gg_sqlaux.c:1150:infinite-recursion
0713141650 2021-08-14 11:47:11 Code_Defect Closed   -version anonymous
3df8b6c54f 2021-08-14 16:10:20 Build_Problem Closed   Use WIN32 mutex locks on Windows
ba12cb832c 2021-08-14 16:16:38 Code_Defect Closed   spatialite-gui - Incorrect data type interpretation in VirtualText
0bac28051d 2022-03-07 07:46:30 Build_Problem Closed   Uppercase gg_shape.c include fails on mingw
0c640e91f0 2022-03-07 08:26:32 Feature_Request Closed   ImportGeoJSON() error "GeoJSON Object's Numeric Value: len > 1024 chars"
57aaea0030 2022-03-07 08:38:24 Documentation Closed   ImportGeoJSON() error "AddGeometryColumn() error: unexpected metadata layout"
8b6910dbbb 2022-03-07 08:46:27 Code_Defect Closed   srid 32760 (UTM zone 60 south) missing from spatial_ref_sys
08771f948e 2022-03-07 09:07:01 Code_Defect Closed   ST_Simplify doesn't remove first vertex
8dd9bfc0a3 2022-03-07 09:30:21 Code_Defect Closed   spatialite tools: calculating with FLOAT or REAL number seems to add random digits after decimal
3302f0ab82 2022-03-21 13:46:44 Feature_Request Open   Make Buffer Options as parameters
c736c646d2 2022-05-27 15:52:17 Code_Defect Closed   -version-info should be 9:0:1 or 9:0:0
109d0fea86 2023-05-17 15:00:54 Build_Problem Closed   rtt_AddLineNoFace not found in librttopo.so.1.1.0
f9058d44e2 2023-07-23 08:54:42 Code_Defect Closed   Test suite is failing
8b37bc0529 2023-07-23 09:01:09 Build_Problem Closed   libspatialite build fails with proj 8.0.0
5d7c9a738f 2023-07-23 09:03:06 Code_Defect Closed   EPSG:2169 definition not correct
f0b21760e0 2023-07-23 09:22:30 Documentation Closed   Import description may reference the wrong GeoJSON spec
8a9e2d256e 2023-07-23 09:25:41 Code_Defect Closed   Leverage PROJ_DATA (as PROJ_LIB is now deprecated)
b412878220 2023-07-23 09:29:01 Build_Problem Closed    
31a1a13a9c 2023-07-23 09:34:25 Documentation Closed   How to create a user for SpatiaLite website?
ee52f4955f 2023-07-23 09:42:42 Build_Problem Closed   unportable test(1) operators
6faa96eb5d 2023-07-23 10:32:19 Build_Problem Closed   Please update config.guess to support RISC-V
163a49b9c4 2023-07-23 12:28:00 Build_Problem Closed   The version 5.0.1 does not compile on Windows - librttopo_geom.h is missing
bf309c3301 2023-07-23 12:51:32 Incident Closed   RenameTable in DB Browser with mod_spatialite
d86ac2c812 2023-07-23 13:07:48 Code_Defect Closed   Meta command .schema gives error "Error: no such column: rowid"
3bb7dc7dd2 2023-07-23 13:09:12 Build_Problem Closed   configure script is out of date
cfa630d01b 2023-07-23 13:27:40 Feature_Request Closed   Support CIRCULARSTRING, COMPOUNDCURVE and CURVEPOLYGON
9904e5acaa 2023-07-23 14:27:37 Code_Defect Closed   Leak of pthread_keys when loading mod_spatialite extension
ace26679a1 2023-07-24 07:07:35 Code_Defect Closed    
6fa0670c7b 2023-07-24 15:10:32 Code_Defect Closed   KNN2 returns rows where the radius is greater than that specified.
ab4b754cba 2023-07-24 15:13:50 Code_Defect Closed   Inconsistent KNN results near north/south pole
721d26863b 2023-07-24 15:37:36 Code_Defect Closed   Inconsistent KNN2 results near north/south pole
69946f6877 2023-07-25 11:00:07 Code_Defect Closed   Patch to fix: undefined reference to symbol 'sqlite3_errmsg'
f318a4be48 2023-08-12 15:14:53 Documentation Closed   SQL reference "latest" lags behind
15c8ee0674 2023-09-02 17:30:18 Documentation Fixed   SQL functions reference list - typos in the syntax column
bbc3575db2 2023-09-02 18:03:56 Documentation Fixed   KNN2 results for "tied" values of distances
d8b5703db6 2023-09-04 07:47:16 Code_Defect Fixed    
a516f739e0 2023-09-21 08:00:01 Code_Defect Closed   spatialite.pc lacks -L switch for -lproj
2da2b48d71 2023-09-21 08:03:06 Code_Defect Open   check_sql_stmt.h:562:90: error: invalid suffix "dev" on integer constant
7663ebc10e 2023-09-22 00:47:24 Code_Defect Open   gpkgCreateTilesZoomLevel() rounds pixel size,
d5c8f926be 2023-12-05 10:50:24 Build_Problem Open   Build failure with stricter C compielrs (e.g. GCC 14)
9e0bede0af 2024-05-14 06:27:53 Incident Closed   error loading mod_spatialite with System.Data.SQLite connection
d1fe66d9cc 2024-05-29 15:09:37 Code_Defect Open   sqlite3_interrupt() can cause spatialite to enter infinite loop
1f7d7ef80d 2024-06-07 18:09:14 Code_Defect Open   Bug: Missing space in CREATE TRIGGER 'gpkg_metadata_reference_column_name_update' statement
c9afddb3b6 2024-06-19 07:58:12 Code_Defect Open   Is it possible migrate VCS to git?
2b1697e601 2024-07-10 11:52:33 Build_Problem Closed   libspatialite.so: undefined reference to `xmlNanoHTTPCleanup'
e21980b271 2024-07-18 13:54:32 Code_Defect Open   GeoPackage feature tables may have incorrect extent
c828bceee8 2024-07-19 13:43:37 Code_Defect Open   ST_Cutter | resulting geometry bug
a7af141937 2024-07-19 16:00:35 Code_Defect Open   Use of XB_SchemaValidate() causes crash on quit
7171cce4f0 2024-08-08 13:49:23 Code_Defect Open   VirtualGPKG never INSERTs a row in a table -- missing call to sqlite3_step()
e46ed9ff78 2024-08-09 10:52:20 Code_Defect Open   Some WebP files are not properly detected by gaiaGuessBlobType()
cd6c9d0244 2024-09-23 19:04:20 Feature_Request Open   Topology-Network allow 3D Pioints in specs for tunnels/bridges for roads
7c452740fe 2024-10-10 17:24:41 Build_Problem Open   Check whether libxml2 supports HTTP