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

          relates to

          Task - A task that needs to be done. MDEV-4697 UPDATE_TIME field for XtraDB / InnoDB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10139 Support for SEQUENCE objects

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-12930 Testing SEQUENCE object

          • Major - Major loss of function.
          • Closed

          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.