Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3506

SELECT on temporary table fails with "Table doesn't exist" error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
    • Environment:
      OS Xubuntu 16.04

      Description

      The problem is specific for MariaDB Galera Cluster, and cannot be reproduced on standalone MariaDB.

      Steps to reproduce:
      1. Execute the following two statements within one query, using mysql_real_query( ) function:
      (CLIENT_MULTI_STATEMENTS flag is passed to mysql_real_connect() )

      DROP TEMPORARY TABLE IF EXISTS __ttmp_test_host_product_table;
      CREATE TEMPORARY TABLE IF NOT EXISTS `__ttmp_test_host_product_table` (   `hostid` INT,   `productname` VARCHAR(32) UNICODE,   `bitmask` INT )ENGINE=InnoDB DEFAULT CHARACTER SET `ascii` COLLATE `ascii_general_ci`;
      

      2. Execute the statement below in a separate query, but on the same connection:

      SELECT * FROM `__ttmp_test_host_product_table`
      

      Result is:

      mysql_errno:1146, mysql_warning_count:0, mysql_sqlstate:'42S02', mysql_error:'Table 'ILIN.__ttmp_test_host_product_table' doesn't exist'
      

      Still it's possible to execute DELETE or INSERT on the temporary table 'ILIN.__ttmp_test_host_product_table'

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            Mike Ilin Mike Ilin
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration