Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7207

ALTER VIEW does not change ALGORITM

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.40
        • Fix Version/s: 10.0.20, 10.1.6, 5.5.44
        • Component/s: Views
        • Labels:
          None
        • Sprint:
          5.5.44

          Description

          create table t1 (a int, b int);
create algorithm=temptable view v2 (c) as select b+1 from t1;
show create view v2;
View	Create View	character_set_client	collation_connection
v2	CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1`	latin1	latin1_swedish_ci
alter algorithm=undefined view v2 (c) as select b+1 from t1;
show create view v2;
View	Create View	character_set_client	collation_connection
v2	CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1`	latin1	latin1_swedish_ci
alter algorithm=merge view v2 (c) as select b+1 from t1;
show create view v2;
View	Create View	character_set_client	collation_connection
v2	CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1`	latin1	latin1_swedish_ci
drop view v2;
drop table t1;

          test suite:

          create table t1 (a int, b int);
create algorithm=temptable view v2 (c) as select b+1 from t1;
show create view v2;
alter algorithm=undefined view v2 (c) as select b+1 from t1;
show create view v2;
alter algorithm=merge view v2 (c) as select b+1 from t1;
show create view v2;
drop view v2;
drop table t1;

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Github revision

                  Activity

                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

                  Sergei Golubchik, please review fix for this bug.

                  Show
                  svoj Sergey Vojtovich added a comment - Sergei Golubchik , please review fix for this bug.

                    People

                    • Assignee:
                      svoj Sergey Vojtovich
                      Reporter:
                      sanja Oleksandr Byelkin
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 5 minutes
                        5m

                          Agile