MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/76384 #76384: Spatial index not used when checking return values explicitly http://bugs.mysql.com/bug.php?id=76384 Submitted by: Johannes Staffans
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 5.6.19, 5.6.25, 5.7.8
]]> Thu, 19 Mar 2015 08:41:01 +0000 Server: GIS http://bugs.mysql.com/77712 #77712: mysql_real_query does not report an error for some queries! http://bugs.mysql.com/bug.php?id=77712 Submitted by: Shane Bester
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.0
]]> Tue, 14 Jul 2015 07:16:46 +0000 Server: GIS http://bugs.mysql.com/92159 #92159: st_intersects with srid 4326 unexpected values as a result http://bugs.mysql.com/bug.php?id=92159 Submitted by: w vd vorm
Category: Server: GIS
Status: Verified
Severity: 1
OS: Windows
Version: 5.7/8.0
]]> Thu, 23 Aug 2018 13:37:36 +0000 Server: GIS http://bugs.mysql.com/92349 #92349: Storage Format is wrong regarding POINT data with SRID=2443-2461,6669-6687,30161 http://bugs.mysql.com/bug.php?id=92349 Submitted by: Yoshiaki Yamasaki
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.0.12
]]> Mon, 10 Sep 2018 09:22:21 +0000 Server: GIS http://bugs.mysql.com/92937 #92937: st_isvalid returns invalid for a valid geometry. http://bugs.mysql.com/bug.php?id=92937 Submitted by: Nicolas Troncoso
Category: Server: GIS
Status: Verified
Severity: 2
OS: Linux
Version: 5.7
]]> Wed, 24 Oct 2018 21:08:53 +0000 Server: GIS http://bugs.mysql.com/94560 #94560: record comparison in spatial index non-leaf rtree node seems incorrect http://bugs.mysql.com/bug.php?id=94560 Submitted by: Jie Zhou
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 5.7, 8.0
]]> Tue, 05 Mar 2019 11:43:38 +0000 Server: GIS http://bugs.mysql.com/96963 #96963: gis function incompatible between 5.6 vs 8.0 http://bugs.mysql.com/bug.php?id=96963 Submitted by: andy zhang
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 5.7.27, 8.0.17
]]> Sun, 22 Sep 2019 14:51:49 +0000 Server: GIS http://bugs.mysql.com/102599 #102599: Slow performance of MySQL 8 compared with 5.7 on geographical SELECT http://bugs.mysql.com/bug.php?id=102599 Submitted by: Martin Baxter
Category: Server: GIS
Status: Verified
Severity: 5
OS: Windows (Win 10)
Version: 8.0.22
]]> Mon, 15 Feb 2021 12:11:56 +0000 Server: GIS http://bugs.mysql.com/103678 #103678: ST_Contains function returns incorrect result. http://bugs.mysql.com/bug.php?id=103678 Submitted by: Eunbin Baek
Category: Server: GIS
Status: Verified
Severity: 2
OS: Linux
Version: MySQL 8.0.20, MySQL 8.0.25
]]> Thu, 13 May 2021 08:45:09 +0000 Server: GIS http://bugs.mysql.com/104823 #104823: ST_Overlaps, ST_Touches returning different values in between SRID 0 and 4326 http://bugs.mysql.com/bug.php?id=104823 Submitted by: Matt Miller
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.13, 8.0.23, 8.0.26
]]> Fri, 03 Sep 2021 17:49:49 +0000 Server: GIS http://bugs.mysql.com/107402 #107402: value has changed when 1e-16 is input of GIS expr http://bugs.mysql.com/bug.php?id=107402 Submitted by: Wenbo Li
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Thu, 26 May 2022 08:53:18 +0000 Server: GIS http://bugs.mysql.com/107424 #107424: st_intersects() returns different results with or without spatial index http://bugs.mysql.com/bug.php?id=107424 Submitted by: Jeremy Wang
Category: Server: GIS
Status: Verified
Severity: 2
OS: Linux
Version: 8.0.26, 8.0.29, 8.0.32
]]> Mon, 30 May 2022 05:45:59 +0000 Server: GIS http://bugs.mysql.com/107435 #107435: It will return success from expr ST_GeomFromWKB with invalid wkb http://bugs.mysql.com/bug.php?id=107435 Submitted by: T H
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
]]> Tue, 31 May 2022 13:06:28 +0000 Server: GIS http://bugs.mysql.com/107896 #107896: if exchange the order of input geo, st_intersects will get opposite result http://bugs.mysql.com/bug.php?id=107896 Submitted by: T H
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.0
]]> Fri, 15 Jul 2022 13:50:51 +0000 Server: GIS http://bugs.mysql.com/111851 #111851: Spatial index not used for join when field is used in MBRIntersects call http://bugs.mysql.com/bug.php?id=111851 Submitted by: Liam Meck
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any (Linux & Mac)
Version: 8.0.32, 8.0.34, 5.7.43
]]> Sat, 22 Jul 2023 22:59:04 +0000 Server: GIS http://bugs.mysql.com/113167 #113167: After creating the spatial index, ST_Disjoint gives the incorrect answer http://bugs.mysql.com/bug.php?id=113167 Submitted by: Wendy Deng
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.2.0, 8.0.35
]]> Tue, 21 Nov 2023 14:17:31 +0000 Server: GIS http://bugs.mysql.com/113205 #113205: After swapping the X and Y coordinates, ST_Crosses gives the incorrect answer. http://bugs.mysql.com/bug.php?id=113205 Submitted by: Wendy Deng
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.2.0, 8.0.35
]]> Fri, 24 Nov 2023 03:06:22 +0000 Server: GIS http://bugs.mysql.com/113888 #113888: st_contains function result is obviously wrong http://bugs.mysql.com/bug.php?id=113888 Submitted by: T H
Category: Server: GIS
Status: Verified
Severity: 2
OS: Linux
Version: 8.0
]]> Sun, 04 Feb 2024 03:38:22 +0000 Server: GIS http://bugs.mysql.com/114291 #114291: ST_Overlap gives an incorrect answer. http://bugs.mysql.com/bug.php?id=114291 Submitted by: Wendy Deng
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.2.0, 8.0.36
]]> Sun, 10 Mar 2024 07:20:16 +0000 Server: GIS http://bugs.mysql.com/116352 #116352: spatial index cause check table wrong http://bugs.mysql.com/bug.php?id=116352 Submitted by: seaver wu
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.31, 8.0.39, 8.4.2
]]> Mon, 14 Oct 2024 02:57:11 +0000 Server: GIS http://bugs.mysql.com/117036 #117036: Spatial Index causes CHECK TABLE to fail http://bugs.mysql.com/bug.php?id=117036 Submitted by: Xizhe Zhang
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.0, 8.0.40
]]> Mon, 23 Dec 2024 07:28:20 +0000 Server: GIS http://bugs.mysql.com/117042 #117042: ST_Within gives unexpected result with Linestring and Polygon in WGS84. http://bugs.mysql.com/bug.php?id=117042 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 2
OS: Windows
Version: 8.0.40
]]> Wed, 25 Dec 2024 06:56:38 +0000 Server: GIS http://bugs.mysql.com/117046 #117046: Negative buffer of a polygon gives an result that not small enough. http://bugs.mysql.com/bug.php?id=117046 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.0.40
]]> Wed, 25 Dec 2024 12:44:13 +0000 Server: GIS http://bugs.mysql.com/117047 #117047: ST_Touches always return null with Point and GeometryCollection with Points http://bugs.mysql.com/bug.php?id=117047 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 1
OS: Any
Version: 8.0.40
]]> Thu, 26 Dec 2024 08:27:08 +0000 Server: GIS http://bugs.mysql.com/117048 #117048: ST_Buffer gives unexpected reuslt using end_flat strategy with closed Linestring http://bugs.mysql.com/bug.php?id=117048 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.0.40
]]> Thu, 26 Dec 2024 09:06:40 +0000 Server: GIS http://bugs.mysql.com/117063 #117063: Spatial index causes the disjoint predicate gives wrong result with WHERE,INNER JOIN and CROSS JOIN, http://bugs.mysql.com/bug.php?id=117063 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 1
OS: Any
Version: 8.0.40
]]> Sat, 28 Dec 2024 13:40:53 +0000 Server: GIS http://bugs.mysql.com/117076 #117076: ST_Intersection returns a non-empty result for two geometries that are disjoint. http://bugs.mysql.com/bug.php?id=117076 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 2
OS: Any
Version: 8.0.40
]]> Mon, 30 Dec 2024 13:38:38 +0000 Server: GIS http://bugs.mysql.com/117120 #117120: Inconsistent Results with ST_Collect in WHERE Clause http://bugs.mysql.com/bug.php?id=117120 Submitted by: Wenqian Deng
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 9.0, 8.0.40
]]> Tue, 07 Jan 2025 12:40:27 +0000 Server: GIS http://bugs.mysql.com/117129 #117129: Potential bug in ST_Crosses http://bugs.mysql.com/bug.php?id=117129 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 3
OS: Any
Version: 8.0.40
]]> Wed, 08 Jan 2025 06:33:56 +0000 Server: GIS http://bugs.mysql.com/117134 #117134: ST_Buffer gives unexpected result with LinearRing http://bugs.mysql.com/bug.php?id=117134 Submitted by: shijie li
Category: Server: GIS
Status: Verified
Severity: 1
OS: Any
Version: 8.0.40
]]> Wed, 08 Jan 2025 10:25:56 +0000 Server: GIS