Skip to content

Redshift - Cannot parse a query with POSITION #2113

Closed
@LaizaAngrest

Description

@LaizaAngrest

Describe the bug
Cannot parse a query with POSITION

Database Engine
Redshift

To Reproduce

  it('Should parse query with over partition after function - snowflake', function () {
    const parser = new SqlParser(WarehouseType.Redshift)
    const query = `

    SELECT pv.email,
            pv.action_date_id,
            SUM(CASE
                    WHEN event_category_name = 'Download'
                      AND POSITION('PNG' IN event_full_name) > 0
                    THEN 1
                    ELSE 0
                END) AS download_png
    FROM dwh.dwh_fact_pageviews pv
    WHERE action_date_id >= '2022-01-01'
    GROUP BY 1, 2
  `
    const parsedSql = parser.parse(query)
    expect(parsedSql).toBeDefined()
  })
})

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions