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

Database name is upper cased, SIMPLE select for that DB tables ERRORs.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.5.3
    • N/A
    • MDB Plugin
    • None

    Description

      One of the customers reported that, on the MariaDB columnstore 10.5.5. The simple SELECT query error as "ERROR 1815 (HY000): Internal error: IDB-1000: '<tablename>' and '<tablename>' are not joined."

      It is observed that if a database name is upper cased, and a table created in that database simple SELECT throws above noted error.

      Repro step:

      MariaDB [(none)]> create database SURESH;
      Query OK, 1 row affected (0.002 sec)

      MariaDB [(none)]> use SURESH
      Database changed

      MariaDB [SURESH]> create table foo (a int) engine=columnstore;
      Query OK, 0 rows affected (0.325 sec)

      MariaDB [SURESH]> select * from foo;
      ERROR 1815 (HY000): Internal error: IDB-1000: 'foo' and 'foo' are not joined.
      MariaDB [SURESH]> select @@version;
      ----------------

      @@version

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

      10.5.5-MariaDB

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

      Thank You.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              suresh.ramagiri@mariadb.com suresh ramagiri
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.