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/76834 #76834: Different result when using index for jsn_extract http://bugs.mysql.com/bug.php?id=76834 Submitted by: Daniël van Eeden
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 5.7.7-labs-json, 5.7.9
]]> Sat, 25 Apr 2015 11:07:47 +0000 Server: JSON http://bugs.mysql.com/79316 #79316: json_search fail with integers http://bugs.mysql.com/bug.php?id=79316 Submitted by: Stefano Giacone
Category: Server: JSON
Status: Duplicate
Severity: 2
OS: Windows (win7)
Version: 5.7.9
]]> Tue, 17 Nov 2015 16:30:25 +0000 Server: JSON http://bugs.mysql.com/80093 #80093: JSON_EXTRACT returns quoted string http://bugs.mysql.com/bug.php?id=80093 Submitted by: Alexey Nick
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 5.7.10, 5.7.11
]]> Thu, 21 Jan 2016 09:10:44 +0000 Server: JSON http://bugs.mysql.com/83702 #83702: Math operations with JSON extracted values http://bugs.mysql.com/bug.php?id=83702 Submitted by: gz —
Category: Server: JSON
Status: Duplicate
Severity: 2
OS: Any (Win, Ubuntu)
Version: 5.7.15, 5.7.16
]]> Sat, 05 Nov 2016 01:58:14 +0000 Server: JSON http://bugs.mysql.com/83968 #83968: Server crashes when a value from a stored funtion is inserted into a JSON field http://bugs.mysql.com/bug.php?id=83968 Submitted by: Yura Sorokin
Category: Server: JSON
Status: Duplicate
Severity: 2
OS: Any
Version: 5.7.16
]]> Fri, 25 Nov 2016 13:26:24 +0000 Server: JSON http://bugs.mysql.com/87440 #87440: use union index,the value of key_len different with used_key_parts’ value. http://bugs.mysql.com/bug.php?id=87440 Submitted by: kid zhang
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Ubuntu
Version: 5.7.18
]]> Wed, 16 Aug 2017 14:26:05 +0000 Server: JSON http://bugs.mysql.com/88812 #88812: JSON does not preserve zero fraction floats when manipulated http://bugs.mysql.com/bug.php?id=88812 Submitted by: Martin Skovvang Petersen
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.3
]]> Thu, 07 Dec 2017 12:16:25 +0000 Server: JSON http://bugs.mysql.com/91621 #91621: Unit separator character (#1f) is not escaped in JSON returned by MySQL server http://bugs.mysql.com/bug.php?id=91621 Submitted by: Kristopher Windsor
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 5.7.18-15
]]> Thu, 12 Jul 2018 19:33:51 +0000 Server: JSON http://bugs.mysql.com/93167 #93167: Improper JSON NULL handling http://bugs.mysql.com/bug.php?id=93167 Submitted by: Philippe Riand
Category: Server: JSON
Status: Duplicate
Severity: 2
OS: Any
Version: 8.0.13
]]> Tue, 13 Nov 2018 01:55:36 +0000 Server: JSON http://bugs.mysql.com/93568 #93568: Cannot create a JSON value from a string with CHARACTER SET 'binary'. http://bugs.mysql.com/bug.php?id=93568 Submitted by: AMU lin
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Windows
Version: 5.7.2
]]> Wed, 12 Dec 2018 07:54:28 +0000 Server: JSON http://bugs.mysql.com/98496 #98496: JSON columns allow empty string, allowing invalid JSON in binlog row images http://bugs.mysql.com/bug.php?id=98496 Submitted by: Jeremy Cole
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 5.7, 8.0
]]> Wed, 05 Feb 2020 20:21:20 +0000 Server: JSON http://bugs.mysql.com/100587 #100587: Unexpected cast to FLOAT from INT attribute from a JSON data http://bugs.mysql.com/bug.php?id=100587 Submitted by: Sveta Smirnova
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.21
]]> Thu, 20 Aug 2020 13:32:07 +0000 Server: JSON http://bugs.mysql.com/102067 #102067: Selecting JSON with binary data produces broken JSON string http://bugs.mysql.com/bug.php?id=102067 Submitted by: John WhyIsThisSoComplicated
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 5.7+, 5.7.32, 8
]]> Thu, 24 Dec 2020 11:49:18 +0000 Server: JSON http://bugs.mysql.com/104935 #104935: JSON_TABLE function report duplicate column name http://bugs.mysql.com/bug.php?id=104935 Submitted by: Yin Peng
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.25, 8.0.26
]]> Tue, 14 Sep 2021 08:12:42 +0000 Server: JSON http://bugs.mysql.com/106180 #106180: case expression not equivalent to if expression for a json http://bugs.mysql.com/bug.php?id=106180 Submitted by: Dave Pullin
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: CentOS
Version: 5.7.31, 8.0.27, 5.7.36
]]> Sun, 16 Jan 2022 20:50:19 +0000 Server: JSON http://bugs.mysql.com/111992 #111992: cannot update null value into nullable field when using UPDATE JOIN JSON_TABLE http://bugs.mysql.com/bug.php?id=111992 Submitted by: Nam Dang
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any (azure mysql single server)
Version: 8.0
]]> Tue, 08 Aug 2023 03:30:19 +0000 Server: JSON http://bugs.mysql.com/113514 #113514: JSON_OBJECT changes order of keys in output http://bugs.mysql.com/bug.php?id=113514 Submitted by: Yoni Sade
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Linux
Version: 8.0.35
]]> Tue, 26 Dec 2023 16:07:56 +0000 Server: JSON http://bugs.mysql.com/115429 #115429: JSON_SCHEMA_VALID doesn't validate exclusiveMinimum http://bugs.mysql.com/bug.php?id=115429 Submitted by: Daniël van Eeden
Category: Server: JSON
Status: Duplicate
Severity: 2
OS: Any
Version: 8.4.0
]]> Tue, 25 Jun 2024 12:54:41 +0000 Server: JSON http://bugs.mysql.com/118496 #118496: Inserting data in JSON type, precision error http://bugs.mysql.com/bug.php?id=118496 Submitted by: Alice Alice
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.41
]]> Fri, 20 Jun 2025 08:54:39 +0000 Server: JSON http://bugs.mysql.com/120147 #120147: DISTINCTROW may drop rows when a constant replaces an aggregate expression, affecting JSON_OBJECTAGG results. http://bugs.mysql.com/bug.php?id=120147 Submitted by: yinling li
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 9.6.0
]]> Wed, 25 Mar 2026 06:26:43 +0000 Server: JSON http://bugs.mysql.com/120148 #120148: Wrong result with DISTINCTROW due to constant projection interacting with JSON_ARRAYAGG http://bugs.mysql.com/bug.php?id=120148 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 9.6.0
]]> Wed, 25 Mar 2026 07:41:12 +0000 Server: JSON http://bugs.mysql.com/120149 #120149: Unexpected row loss with JSON_ARRAY when replacing aggregation with constant in DISTINCTROW query http://bugs.mysql.com/bug.php?id=120149 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 9.6.0
]]> Wed, 25 Mar 2026 07:49:16 +0000 Server: JSON http://bugs.mysql.com/120150 #120150: DISTINCTROW query loses rows when constant projection is used with JSON_OBJECT http://bugs.mysql.com/bug.php?id=120150 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 9.6.0
]]> Wed, 25 Mar 2026 07:52:31 +0000 Server: JSON http://bugs.mysql.com/120151 #120151: DISTINCTROW query drops rows when constant COUNT projection is used with JSON_SET http://bugs.mysql.com/bug.php?id=120151 Submitted by: Wang Ojiken
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 9.6.0
]]> Wed, 25 Mar 2026 07:55:42 +0000 Server: JSON http://bugs.mysql.com/121143 #121143: Correlated usage of json_table function does not seem to produce values http://bugs.mysql.com/bug.php?id=121143 Submitted by: Christian Beikov
Category: Server: JSON
Status: Duplicate
Severity: 3
OS: Any
Version: 8.0.46
]]> Thu, 20 Aug 2026 09:40:09 +0000 Server: JSON