Uploaded image for project: 'SlamData'
  1. SD-1869

JOINs do not produce results in Show Table card

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ASAP
    • Component/s: Quasar
    • Labels:
      None
    • Environment:

      3.0.0 Community, 3.0.0 Advanced, 3.0.1 Community

      Description

      It appears that any query with a join produces no results in a Show Table card, but also produces no errors, just empty results table. Example:

      SELECT
        cust.name AS customer,
        cars.name AS car
      FROM `/devguide/devdb/customers` AS cust
      JOIN `/devguide/devdb/cars` AS cars
      ON cust.customer_id = cars.customer_id
      

      Verified that normal queries to those same tables produce results in Show Table card.

      No errors appear in the JavaScript console either.

      Quasar REPL does return results with the same query.

        Attachments

          Activity

            People

            • Assignee:
              moss Moss Prescott
              Reporter:
              damon Damon LaCaille
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: