Closed
Description
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()
})
})