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

Derived tables in a join subquery cause error

    Details

    • Sprint:
      2017-6, 2017-7

      Description

      When using a join with a derived table you get the error:

      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USE INDEX () join (select 1 AS `dummy`,count(test.vehicle.id) AS `total_vehicles' at line 1

      We add USE INDEX() as part of MCOL-424 but we only need to do this for real tables, not derived.

        Attachments

          Activity

            People

            • Assignee:
              dleeyh Daniel Lee
              Reporter:
              LinuxJedi Andrew Hutchings
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: