[MDEV-24591] Server cannot bootstrap with swe7 as default server character set anymore Created: 2021-01-14 Updated: 2021-01-15 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Character Sets |
| Affects Version/s: | 10.4, 10.5 |
| Fix Version/s: | 10.4, 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Elena Stepanova | Assignee: | Alexey Botchkov |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Starting from 10.4, if swe7 is set as the server character set, bootstrap fails with
The reason for it is CHECK(JSON_VALID(Priv)) on mysql.global_priv. With swe7, JSON_VALID fails for any JSON text, apparently because it doesn't have curly brackets and square brackets. |
| Comments |
| Comment by Elena Stepanova [ 2021-01-14 ] |
|
Assigning to serg because I have no idea what can/needs to be done with it, maybe just document as a limitation? |
| Comment by Sergei Golubchik [ 2021-01-15 ] |
|
I would expect mysql.global_priv.priv column to be in utf8mb4. And I would expect JSON_VALID() to use whatever charset the argument uses. Why would globally defined server charset matter? |