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

ALTER VIEW does not change ALGORITM

    XMLWordPrintable

    Details

    • 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;

        Attachments

          Issue Links

            Activity

              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: