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

Cannot use DEFAULT function in a view

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.0.29
    • Views
    • Can result in unexpected behaviour

    Description

      create table t1 (i int default 0);
      		 
      insert into t1 values (1);
      		 
      select default(i) from t1;
      		 
      create view v1 as select default(i) from t1;


      MariaDB [test]> create view v1 as select default(i) from t1;
      		 
      ERROR 1143 (42000): create view command denied to user 'root'@'localhost' for column 'default(i)' in table 'v1'

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11265 Access defied when CREATE VIIEW v1 AS SELECT DEFAULT(column) FROM t1

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Bug #80543 Cannot use DEFAULT function in a view

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.