Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4290

Join query errors when using upper case table names

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 1.5.3
    • 5.4.1
    • MDB Plugin
    • None

    Description

      It is reported by a customer, that cross engine join query having an upper cased INNODB table, throwing ERROR.

      Here are the repro steps:

      MariaDB [inno]> CREATE TABLE INNO (a int, b varchar(10));
      Query OK, 0 rows affected (0.004 sec)

      MariaDB [inno]> create table cs (a int, b varchar(10)) engine=columnstore;
      Query OK, 0 rows affected (1.120 sec)

      MariaDB [inno]> select * from cs a, INNO b where a.a=b.a;
      ERROR 1815 (HY000): Internal error: fatal error runing mysql_real_query() in libmysql_client lib (1146) (Table 'inno.inno' doesn't exist)

      MariaDB [inno]> select @@lower_case_table_names;
      --------------------------

      @@lower_case_table_names

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

      0

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

      MariaDB [inno]> select @@version;
      ----------------

      @@version

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

      10.5.5-MariaDB

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

      Attachments

        Issue Links

          Activity

            People

              David.Hall David Hall (Inactive)
              suresh.ramagiri@mariadb.com suresh ramagiri
              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.