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

Drop temporary table generating warning message

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.3
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:
      None
    • Environment:
      Linux pa1-lda-001.dev.tradingscreen.com 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux

      Description

      After a temp table is created

      mysql 23:45:02 [PA DEV 001] [tempdb] [3108]> create temporary table x ( a int);
      Query OK, 0 rows affected (0.04 sec)

      Dropping it like this

      mysql 23:45:14 [PA DEV 001] [tempdb] [3108]> drop table x;
      Query OK, 0 rows affected (0.00 sec)

      seems to generate a warning message in the log

      InnoDB: We removed now the InnoDB internal data dictionary entry
      InnoDB: of table 130814 23:44:43 [Warning] Invalid (old?) table or database name '#sql577f_15c2_0'
      `mysql_tmp`.<result 2 when explaining filename '#sql577f_15c2_0'>.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dyan Daisy Yan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: