[MDEV-16189] misleading error when partitioning a table with an utf8 space after backticks on partition names Created: 2018-05-16 Updated: 2023-04-27 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Parser, Server |
| Affects Version/s: | 5.5, 10.0, 10.1, 10.1.33, 10.2.14, 10.2, 10.3 |
| Fix Version/s: | 10.4 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Rick Pizzi | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | upstream | ||
| Description |
|
Can be reproduced on 10.1 and 10.2 |
| Comments |
| Comment by Elena Stepanova [ 2018-05-16 ] |
|
As per serg's finding, the query has `0xC2 0xA0` after the second backtick. If the space is removed, backticks work all right. So all in all, there is a bug in there, as the space shouldn't cause the trouble – it's an old upstream issue, reproducible on all of MariaDB 5.5-10.3 and MySQL 5.5-5.7, but it's not about backticks as such. |
| Comment by Rick Pizzi [ 2018-05-16 ] |
|
As @marko pointed out this is a non breaking space that can be entered on Mac with Alt + SPACE Thanks again for your time guys |