Bug #98135 | JSON to string includes extraneous spaces... | ||
---|---|---|---|
Submitted: | 6 Jan 2020 14:32 | Modified: | 10 May 2020 8:00 |
Reporter: | Joey PRIVATE | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: JSON | Severity: | S4 (Feature request) |
Version: | 8 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[6 Jan 2020 14:32]
Joey PRIVATE
[9 Apr 2020 13:32]
MySQL Verification Team
Hi Mr. PRIVATE, Thank you for your feature request. Can you just give us a small test case that will display this behaviour. If we can reproduce it, then we will verify this feature request. Thanks in advance.
[10 May 2020 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[10 May 2020 8:00]
MySQL Verification Team
No need for a specific testcase. Anything will do: -- ----- create table t(a json); set @a:=concat('[',repeat('1,',100),'1]'); insert into t values(@a); select a from t; -- ----- Output is: [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1] A third of the output is wasted on whitespaces. This would be more compact: [1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1] Seems like reporter wants a function, opposite of JSON_PRETTY that outputs the latter compact format.
[11 May 2020 12:11]
MySQL Verification Team
I agree, but due to the existence of the good workaround, it is not a high priority request.