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

Support JOINs wide-DECIMAL keys.

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 6.2.1, 6.2.2
    • None
    • 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

              dleeyh Daniel Lee (Inactive)
              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.