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

Implement select_handler=AUTO

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.4.1, 5.4.1, 5.5.1
    • 6.1.1
    • None
    • None
    • 2021-2, 2021-3, 2021-4, 2021-5, 2021-6, 2021-7, 2021-8, 2021-9

    Description

      In 1.2 time Columnstore supported set infinidb_vtable_mode = 2.

      This meant "auto-switch mode": ColumnStore will attempt to process the query internally, if it cannot, it will automatically switch the query to run in row-by-row mode.

      The use case described the CS0142347 is a non-equi join.

      There are certainly other cases where this was happening in 1.2, but now fails with an error message. We should attempt to restore the behavior to be as close to what it was in 1.2 as possible.

      Best if we could also produce a standard MariaDB warning if the query ends up being done in ROW mode. If this is too hard or impossible - a message in debug log would be needed.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MCOL-4574 Move all MDB rewrites MCS needs into the plugin

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              gdorman Gregory Dorman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.