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

UPDATE_TIME field for XtraDB / InnoDB

Details

    Description

      This is a port of MySQL bug # 2681 [1] to MariaDB.

      Currently XtraDB / InnoDB does not support the UPDATE_TIME for tables in the INFORMATION_SCHEMA. Please add this support, as is the case for other popular table types such as MyISAM. Thank you.

      [1] http://bugs.mysql.com/bug.php?id=2681

      Attachments

        Issue Links

          Activity

            This has been fixed in MySQL 5.7.2 already (and 5.7.8 for partitioned tables). Please implement a fix in MariaDB!

            mh Maciej Holyszko added a comment - This has been fixed in MySQL 5.7.2 already (and 5.7.8 for partitioned tables). Please implement a fix in MariaDB!
            milan Milan Orszagh added a comment -

            Would be nice to have

            milan Milan Orszagh added a comment - Would be nice to have
            sfatula Steve Fatula added a comment -

            Well, you are referring likely to bug 14374 in mysql also. True, it is in 5.7.2, but, not persistent across server restarts. That would be WL6917 in MySQL, which is not done yet. Would like for this to be implemented in Mariadb for innodb for sure! Very very useful, for example, to find tables that were created say to solve some issue or look for something, test, whatever, but never dropped. If the last access date is years old, that's a hint!

            sfatula Steve Fatula added a comment - Well, you are referring likely to bug 14374 in mysql also. True, it is in 5.7.2, but, not persistent across server restarts. That would be WL6917 in MySQL, which is not done yet. Would like for this to be implemented in Mariadb for innodb for sure! Very very useful, for example, to find tables that were created say to solve some issue or look for something, test, whatever, but never dropped. If the last access date is years old, that's a hint!

            MariaDB 10.2.2 imported the InnoDB of MySQL 5.7.9. WL#6658 introduced a non-persistent update_time in MySQL 5.7.2.

            The tests innodb.update_time and innodb.update_time_wl6658 were missing. I imported and adjusted them for MariaDB 10.2.

            marko Marko Mäkelä added a comment - MariaDB 10.2.2 imported the InnoDB of MySQL 5.7.9. WL#6658 introduced a non-persistent update_time in MySQL 5.7.2. The tests innodb.update_time and innodb.update_time_wl6658 were missing. I imported and adjusted them for MariaDB 10.2.

            People

              marko Marko Mäkelä
              dotancohen Dotan Cohen
              Votes:
              3 Vote for this issue
              Watchers:
              9 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.