Skip to:

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

LP #1083073: enforce-storage-engine should ignore explicit temporary tables

Description

**Reported in Launchpad by Alexey Kopytov last update 02-02-2016 09:02:40

Currently enforce-storage-engine affects all explicitly created tables, even temporary ones:

mysql> select @@enforce_storage_engine;
--------------------------

@@enforce_storage_engine

--------------------------

innodb

--------------------------
1 row in set (0.00 sec)

mysql> create temporary table t3(a int) engine=memory;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> show warnings;
---------------------------------------------------------

Level

Code

Message

---------------------------------------------------------

Note

1266

Using storage engine InnoDB for table 't3'

---------------------------------------------------------
1 row in set (0.00 sec)

In most cases creating explicit temporary tables with other storage engines should be allowed. We can make this behavior optional for cases where enforcing temporary tables engine is required.

Environment

None

Smart Checklist

Activity

Julia Vural March 4, 2025 at 9:05 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.

Won't Do

Details

Assignee

Reporter

Labels

Priority

Smart Checklist

Created January 22, 2018 at 10:36 PM
Updated March 4, 2025 at 9:05 PM
Resolved March 4, 2025 at 9:05 PM

Flag notifications