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

update_time column of on i_s.tables remains NULL for sequence objects

    XMLWordPrintable

Details

    Description

      Following code returns NULL for InnoDB

      create or replace sequence test.x engine = innodb;
      select next value for test.x;
      select update_time from information_schema.tables where (table_name, table_schema) = ('x','test');
      

      The same for aria or myisam returns correct timestamp:

      create or replace sequence test.x1 engine = myisam;
      select next value for test.x1;
      create or replace sequence test.x2 engine = aria;
      select next value for test.x2;
      select update_time from information_schema.tables where (table_name, table_schema) in ( ('x2','test'),('x1','test'));
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              anikitin Andrii Nikitin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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