[MDEV-8464] ALTER VIEW not replicated in some cases Created: 2015-07-14 Updated: 2015-08-14 Resolved: 2015-07-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, Views |
| Affects Version/s: | 10.0.20-galera |
| Fix Version/s: | 10.0.21-galera, 5.5.45-galera |
| Type: | Bug | Priority: | Critical |
| Reporter: | Pascal Jufer | Assignee: | Nirbhay Choubey (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
3 MariaDB Galera nodes v10.0.20 on Gentoo Linux |
||
| Description |
|
I've tried to change the DEFINER of a VIEW and therefore executed the following statement on the first node, which has a correct syntax:
The statement has been replicated to the other nodes as follows:
Which is a incorrect syntax and therefore could not be commited on the other nodes:
A workaround is to explicitly set the algorithm like:
|
| Comments |
| Comment by Nirbhay Choubey (Inactive) [ 2015-07-20 ] |
|
https://github.com/MariaDB/server/commit/af2f7ce3f915c4686ef04294b00c6f4885503f5e |