Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

create_time and update_time always null in information_schema.temporary_tables

Description

This is related to this functionality: https://www.percona.com/doc/percona-server/8.0/diagnostics/misc_info_schema_tables.html

It seems that in both information_schema.temporary_tables and information_schema.global_temporary_tables create_time and update_time columns are always null.

Here's how it looks:
8.0

5.7

5.6

Environment

None

Smart Checklist

Activity

Julia Vural March 4, 2025 at 9:02 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

Peter Schwaller November 27, 2018 at 1:19 PM

Not to be addressed in 8.0 GA (8.0 bug triage meeting)

Laurynas Biveinis November 20, 2018 at 10:44 AM

Let's keep columns then, and this task open to restore meaningful information for them

Przemyslaw Skibinski November 20, 2018 at 9:35 AM

1. CREATE_TIME and UPDATE_TIME work for ENGINE=MyISAM

2. UPDATE_TIME doesn't work for InnoDB because trx_undo_report_row_operation() contains:

3. CREATE_TIME in 5.7 depends on creation time of a table file (checked with stat()) but in my experiments temp tables didn't create files.
Moreover code related to CREATE_TIME was removed from InnoDB in 8.0:

Laurynas Biveinis November 12, 2018 at 8:32 AM

OK, then let's investigate before the GA, maybe these columns can be removed

Won't Do

Details

Assignee

Reporter

Labels

Time tracking

30m logged

Affects versions

Priority

Smart Checklist

Created November 9, 2018 at 2:59 PM
Updated March 4, 2025 at 9:02 PM
Resolved March 4, 2025 at 9:02 PM