Skip to content

WITH doesn't seem supported as a keyword #20

@pgalbavy

Description

@pgalbavy

For this:

    gateway-grouped-maturity: >
      WITH v AS (
        SELECT ${label} label,
               count(distinct a.gateway) total,
               count(distinct m.gateway) mature,
               count(distinct e.gateway) empty,
               count(distinct l1.gateway) l1mature,
               count(distinct l2.gateway) l2mature,
               count(distinct l3.gateway) l3mature
          FROM      ${database.gateways.view} a
          LEFT JOIN ${database.mature-gateways.view} m USING (licenseGroup, gateway)
          LEFT JOIN ${database.empty-gateways.view} e USING (licenseGroup, gateway)
          LEFT JOIN ${database.l1mature-gateways.view} l1 USING (licenseGroup, gateway)
          LEFT JOIN ${database.l2mature-gateways.view} l2 USING (licenseGroup, gateway)
          LEFT JOIN ${database.l3mature-gateways.view} l3 USING (licenseGroup, gateway)
        GROUP BY ${groups}
      )
      SELECT label,
             total,
             mature,

I see (note red closing parenthesis):

image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions