search

Aircloak / aircloak

This repository contains the Aircloak Air frontend as well as the code for our Cloak query and anonymization platform
2 stars 0 forks source link

Docs say one negative condition on rare values is allowed, system permits none #4780

Closed sebastian closed 3 years ago

sebastian commented 3 years ago

The relevant section is the "number of conditions" section (https://github.com/Aircloak/aircloak/blob/master/air/priv/static/docs/sql/restrictions.md#number-of-conditions). It claims one condition is allowed. I believe our system defaults to none but can be configured to allow one?

This is an example query:

SELECT count(*) FROM CityEmployeepayroll where rowid <> 'foo'

which is rejected with:

No negative conditions matching rare values are allowed. For further information see the "Number of conditions" subsection of the "Restrictions" section in the user guides.

where the user guide reads:

By default there is a limit of one negative condition (NOT IN, NOT LIKE, NOT ILIKE, and <>) for each anonymized query.