[MDEV-18473] DB restore fails when CHECK and COMMENT are used Created: 2019-02-04 Updated: 2019-04-03 Resolved: 2019-02-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Parser |
| Affects Version/s: | 10.3.9, 10.2.21 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | HGL IT | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | check | ||
| Environment: |
CentOS 7 |
||
| Issue Links: |
|
||||||||||||
| Description |
|
We have found that MariaDB back-ups fail to restore if they include CHECKs on a column with COMMENTS. If we edit the SQL dump file, locate the lines with CHECK and COMMENT, and manually delete the COMMENT, then the restore will work. Alternatively, if we edit the DB prior to back-up, deleting comments against columns with CHECKs, and then perform the back-up - the restore completes. |
| Comments |
| Comment by Elena Stepanova [ 2019-02-04 ] |
|
I think you have encountered |
| Comment by HGL IT [ 2019-02-04 ] |
|
Ah, yes, Elena. I do believe this to be the same issue. |
| Comment by Elena Stepanova [ 2019-02-04 ] |
|
Let's track it there, then. I'll raise the priority. |