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

Implement select_handler=AUTO

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.4.1, 5.4.1, 5.5.1
    • Fix Version/s: 6.1.1
    • Component/s: None
    • Labels:
      None
    • Sprint:
      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

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              gdorman Gregory Dorman
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration