[MDEV-8122] REPAIR VIEW: FROM MYSQL should probably take precedence over mariadb-version Created: 2015-05-08 Updated: 2015-08-03 Resolved: 2015-08-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Admin statements |
| Affects Version/s: | 5.5, 10.0 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Elena Stepanova | Assignee: | Sergei Golubchik |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 5.5.45 |
| Description |
|
Currently REPAIR VIEW .. FROM MYSQL doesn't do anything of mariadb-version in the FRM file is already updated. It makes the extension fairly useless, because it means that to make it work, the user needs to prevent mysql_upgrade (including the automatic one), and also resist from running REPAIR VIEW... (without FROM MYSQL), which in real life will hardly even happen. But please only consider it if there is no risk breaking mysql_upgrade/mysqlcheck logic. |
| Comments |
| Comment by Sergei Golubchik [ 2015-06-06 ] |
|
I kind of agree with what you're saying. But on the other hand, I wouldn't want to turn REPAIR VIEW into a universal "alter view toggle algorithm" command. |
| Comment by Sergei Golubchik [ 2015-07-31 ] |
this is not quite true. mysql_upgrade will use REPAIR VIEW .. FROM MYSQL automatically, as needed. So normally the user does not need to do anything, only run mysql_upgrade (manually or automatically) after an upgrade. |
| Comment by Sergei Golubchik [ 2015-08-03 ] |
|
Let's keep the current behavior. And later, if needed, we could either add FORCE variant or fix ALTER statement to be able to change view algorithm. |