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

SHOW OPEN TABLES IN DB1 -- is case insensitive with lower-case-table-names=0

Details

    Description

      I run the following SQL script with a Linux server with --lower-case-table-names=0:

      CREATE DATABASE db1;
      CREATE TABLE db1.t1 (a INT);
      SELECT * FROM db1.t1;
      SHOW OPEN TABLES IN DB1;
      

      +----------+-------+--------+-------------+
      | Database | Table | In_use | Name_locked |
      +----------+-------+--------+-------------+
      | db1      | t1    |      0 |           0 |
      +----------+-------+--------+-------------+
      

      Looks wrong. The expected result is empty set, as the database does not match.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.