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

Support JOINs wide-DECIMAL keys.

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.2.1, 6.2.2
    • Component/s: None
    • Labels:
      None

      Description

      There are number of JOIN types and JOIN-based operations in MCS that doesn't support 16 byte wide-decimal columns as JOIN key parts.
      Here is the list of JOIN and JOIN-based operations that must support wide-decimal:

      • INNER JOIN
      • LEFT|RIGHT JOIN
      • [NOT]IN+correlated subquery
      • [NOT] EXISTS
        The JOIN operation must support equi predicates with different width columns ,e.g. DECIMAL(38) = INT. The prerequisite for cross-type join is that both sides must be integers, e.g. DECIMAL(20) and BIGINT. It is impossible to join DECIMAL(20,1) and BIGINT.
        The JOIN operation must also support equi predicates functions with a wide-decimal argument.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              drrtuy Roman
              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.