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/79053 #79053: Second argument "one" to JSON_CONTAINS_PATH is a misnomer http://bugs.mysql.com/bug.php?id=79053 Submitted by: Roland Bouman
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.9
]]> Sun, 01 Nov 2015 03:18:20 +0000 Server: JSON http://bugs.mysql.com/79813 #79813: Boolean values are returned inconsistently with JSON_OBJECT http://bugs.mysql.com/bug.php?id=79813 Submitted by: Bear Limvere
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.10, 8.0.0, 5.7.43, 8.0.34, 8.1.0
]]> Wed, 30 Dec 2015 18:33:49 +0000 Server: JSON http://bugs.mysql.com/83954 #83954: JSON handeling of DECIMAL values, JSON from JSON string http://bugs.mysql.com/bug.php?id=83954 Submitted by: sinai yoktan
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7, 8.0
]]> Thu, 24 Nov 2016 12:42:23 +0000 Server: JSON http://bugs.mysql.com/84082 #84082: JSON_OBJECT("k", dateTime) adds milliseconds to time http://bugs.mysql.com/bug.php?id=84082 Submitted by: enzo mdd
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.14-google-log
]]> Tue, 06 Dec 2016 19:01:28 +0000 Server: JSON http://bugs.mysql.com/85755 #85755: JSON containing null value is extracted as a string "null" http://bugs.mysql.com/bug.php?id=85755 Submitted by: Dave Pullin
Category: Server: JSON
Status: Verified
Severity: 2
OS: CentOS (centos 7)
Version: 5.7.17
]]> Sat, 01 Apr 2017 00:53:27 +0000 Server: JSON http://bugs.mysql.com/88033 #88033: Generated INT column with value from JSON document http://bugs.mysql.com/bug.php?id=88033 Submitted by: Geert Vanderkelen
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.24, 5.7.19
]]> Mon, 09 Oct 2017 18:38:37 +0000 Server: JSON http://bugs.mysql.com/88689 #88689: LOAD DATA is failed if JSON file include blank line at end of file http://bugs.mysql.com/bug.php?id=88689 Submitted by: Yoshimi Takahashi
Category: Server: JSON
Status: Verified
Severity: 3
OS: Linux
Version: 5.7, 5.7.36
]]> Wed, 29 Nov 2017 06:57:14 +0000 Server: JSON http://bugs.mysql.com/90835 #90835: NULL treatment of JSON_ARRAYAGG http://bugs.mysql.com/bug.php?id=90835 Submitted by: Markus Winand
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7/8.0
]]> Fri, 11 May 2018 12:01:12 +0000 Server: JSON http://bugs.mysql.com/91245 #91245: json column wtih integer value got incorrect result http://bugs.mysql.com/bug.php?id=91245 Submitted by: chen kris
Category: Server: JSON
Status: Verified
Severity: 2
OS: MacOS
Version: 5.7.19, 5.7.22, 8.0.11
]]> Thu, 14 Jun 2018 02:08:06 +0000 Server: JSON http://bugs.mysql.com/92749 #92749: JSON arrow operator not wotking with variables and functions http://bugs.mysql.com/bug.php?id=92749 Submitted by: Andrej Thomsen
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8, 8.0.12
]]> Thu, 11 Oct 2018 11:28:55 +0000 Server: JSON http://bugs.mysql.com/93010 #93010: JSON_SET() does not create intermediate objects http://bugs.mysql.com/bug.php?id=93010 Submitted by: Alfredo Kojima
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.13
]]> Tue, 30 Oct 2018 14:40:14 +0000 Server: JSON http://bugs.mysql.com/93881 #93881: where clause with JSON column path broken when using LIKE http://bugs.mysql.com/bug.php?id=93881 Submitted by: A P
Category: Server: JSON
Status: Verified
Severity: 3
OS: MacOS
Version: 8.0.13
]]> Thu, 10 Jan 2019 20:23:43 +0000 Server: JSON http://bugs.mysql.com/95698 #95698: JSON columns are returned with binary charset http://bugs.mysql.com/bug.php?id=95698 Submitted by: Daniel Book
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.16, 5.7.26
]]> Fri, 07 Jun 2019 22:40:21 +0000 Server: JSON http://bugs.mysql.com/98214 #98214: json function may make indexs Invalid http://bugs.mysql.com/bug.php?id=98214 Submitted by: Danie Dong
Category: Server: JSON
Status: Verified
Severity: 2
OS: CentOS
Version: 8.0.18
]]> Tue, 14 Jan 2020 07:34:39 +0000 Server: JSON http://bugs.mysql.com/100567 #100567: Unexpected cast to float from attribute of a JSON datum http://bugs.mysql.com/bug.php?id=100567 Submitted by: Marcos Albe
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.21, 8.0.11
]]> Wed, 19 Aug 2020 03:37:42 +0000 Server: JSON http://bugs.mysql.com/100885 #100885: generated column index against json column is not used with different encoding http://bugs.mysql.com/bug.php?id=100885 Submitted by: Nikolai Ikhalainen
Category: Server: JSON
Status: Verified
Severity: 5
OS: Any
Version: 5.7.31
]]> Fri, 18 Sep 2020 03:43:07 +0000 Server: JSON http://bugs.mysql.com/101945 #101945: JSON Unsigned Integer out of range for Unsigned Bigint column http://bugs.mysql.com/bug.php?id=101945 Submitted by: Morgan Tocker
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.31, 8.0.22
]]> Wed, 09 Dec 2020 22:03:42 +0000 Server: JSON http://bugs.mysql.com/102233 #102233: JSON Path evaluation is not standard-compliant http://bugs.mysql.com/bug.php?id=102233 Submitted by: Sergei Petrunia
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0, 8.0.22
]]> Tue, 12 Jan 2021 11:34:37 +0000 Server: JSON http://bugs.mysql.com/102594 #102594: json variable set to null is not <=> null http://bugs.mysql.com/bug.php?id=102594 Submitted by: Dave Pullin
Category: Server: JSON
Status: Verified
Severity: 3
OS: CentOS (CentOS Linux release 7.6.1810 (Core))
Version: 5.7.31, 5.7.33
]]> Sun, 14 Feb 2021 22:31:50 +0000 Server: JSON http://bugs.mysql.com/102595 #102595: Internal error: JSON wrapper: unexpected type from json_unquote json_extract http://bugs.mysql.com/bug.php?id=102595 Submitted by: Dave Pullin
Category: Server: JSON
Status: Verified
Severity: 3
OS: CentOS (CentOS Linux release 7.6.1810 (Core))
Version: 5.7.31, 5.7.33
]]> Sun, 14 Feb 2021 23:00:21 +0000 Server: JSON http://bugs.mysql.com/102601 #102601: nested nullif of json values fails http://bugs.mysql.com/bug.php?id=102601 Submitted by: Dave Pullin
Category: Server: JSON
Status: Verified
Severity: 3
OS: CentOS (CentOS Linux release 7.6.1810 (Core))
Version: 5.7.31, 5.7.33
]]> Mon, 15 Feb 2021 13:42:21 +0000 Server: JSON http://bugs.mysql.com/103361 #103361: JSON_VALUE() does not accept an expression in path parameter http://bugs.mysql.com/bug.php?id=103361 Submitted by: Владислав Сокол
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.23
]]> Mon, 19 Apr 2021 06:00:05 +0000 Server: JSON http://bugs.mysql.com/103522 #103522: JSON_TABLE: Warning is not produced on truncation http://bugs.mysql.com/bug.php?id=103522 Submitted by: Sergei Petrunia
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.24
]]> Wed, 28 Apr 2021 18:02:16 +0000 Server: JSON http://bugs.mysql.com/106189 #106189: json_object(x,F()) returns NULL if F returns JSON and returns null http://bugs.mysql.com/bug.php?id=106189 Submitted by: Dave Pullin
Category: Server: JSON
Status: Verified
Severity: 3
OS: CentOS
Version: 5.7.31
]]> Mon, 17 Jan 2022 22:50:55 +0000 Server: JSON http://bugs.mysql.com/106841 #106841: Error comparing Json objects and text utf32 http://bugs.mysql.com/bug.php?id=106841 Submitted by: Luis Donoso
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.28, 5.7.37
]]> Fri, 25 Mar 2022 16:55:07 +0000 Server: JSON http://bugs.mysql.com/106928 #106928: Can not restore mysqldump that was taken using charset binary http://bugs.mysql.com/bug.php?id=106928 Submitted by: lalit Choudhary
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7
]]> Wed, 06 Apr 2022 11:39:45 +0000 Server: JSON http://bugs.mysql.com/107199 #107199: Inconsistent JSON path ** behaviour between versions http://bugs.mysql.com/bug.php?id=107199 Submitted by: chen chen
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.27
]]> Tue, 03 May 2022 15:33:31 +0000 Server: JSON http://bugs.mysql.com/107225 #107225: IFNULL Stringifies JSON Object http://bugs.mysql.com/bug.php?id=107225 Submitted by: David Allen
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0
]]> Thu, 05 May 2022 17:13:21 +0000 Server: JSON http://bugs.mysql.com/108231 #108231: JSON_ARRAY_APPEND adds backslashes when a JSON_OBJECT passed as variable http://bugs.mysql.com/bug.php?id=108231 Submitted by: Derek McKinnon
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.37, 5.7.39, 8.0.30
]]> Tue, 23 Aug 2022 05:15:16 +0000 Server: JSON http://bugs.mysql.com/108365 #108365: JSON_TABLE fails to parse when used in LATERAL join http://bugs.mysql.com/bug.php?id=108365 Submitted by: Justin Naifeh
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 8.0.30
]]> Thu, 01 Sep 2022 19:15:07 +0000 Server: JSON