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

Columnstore does not allow duplicate column aliases (and reports it as duplicate column *name*)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • None
    • Icebox
    • ?
    • None

    Description

      Stock MySQL:

      mysql> create table t1(c1 int) engine=myisam;
      Query OK, 0 rows affected (0.00 sec)

      mysql> create table t2(c1 int) engine=myisam;
      Query OK, 0 rows affected (0.01 sec)

      mysql> select * from t1 join t2;
      Empty set (0.00 sec)

      ColumnStore

      mysql> create table t1(c1 int) engine=myisam;
      Query OK, 0 rows affected (0.00 sec)

      mysql> create table t2(c1 int) engine=myisam;
      Query OK, 0 rows affected (0.01 sec)

      mysql> select * from t1 join t2;
      ERROR 1060 (42S21): Duplicate column name 'c1'

      Attachments

        Activity

          People

            Unassigned Unassigned
            jswanhart Justin Swanhart (Inactive)
            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.