Skip to content

function "get_attributes" does not work properly if the query contains alias

The query parser no longer recognises the attributes after the WHERE condition if they occur with an alias, schema prefix or view

Example without alias after WHERE clause --> works fine
SELECT *
FROM product as p
JOIN order as o ON o.prodid = p.id
WHERE price > 100

Example with alias after WHERE clause --> does not work properly
SELECT *
FROM product as p
JOIN order as o ON o.prodid = p.id
WHERE p.price > 100

Edited by kevin ammann