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

Autopilot's datatypecasting no long works after join requirement was made more restrictive

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.1.1
    • Icebox
    • ExeMgr
    • None

    Description

      Build tested: 1.1.1-1

      Autopilot's datatypecasting test was designed to join columns of different datatypes. It compares query requires between columnstore and innodb to ensure columnstore is working correctly, or at least the same as innodb. Few examples of such joins are:

      date=vchar()
      tinyint=smallint
      tinyint=decimal
      integer=varchar()

      The test suite use to work, and now return over 800 error because of incompatible data types in join clause.

      The concern is that, good practice or not, people do use string columns to store numeric strings, dates, etc. These join requirement could be too restrictive for some existing data bases to be converted to ColumnStore. Such simple joins should be supported, especially they are supported in InnoDB.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.