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

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

                Dates

                Created:
                Updated: