Hi,

i try to execute the following partition function on the adventureworks salestaxrate table

SELECT 
        "StateProvinceID"
        , COUNT(*) OVER (PARTITION BY a."CountryRegionCode") AS num
    FROM salestaxrate a
    WHERE "TaxType" = 3

it returns me the correct result

But if I wrap it into a following select

SELECT *
FROM
(
    SELECT 
        "StateProvinceID"
        , COUNT(*) OVER (PARTITION BY a."CountryRegionCode") AS num
    FROM salestaxrate a
    WHERE "TaxType" = 3
) x
WHERE "StateProvinceID" = 45

it returns me

I'm running TEIID 8.1. Is it a known bug?