Calculated field
ISMEMBEROF('Operations')
Sample data
| label | quantity | amount | flag |
|---|---|---|---|
| cedar cedar | 65 | 12.8 | True |
| ORCHID-west | 66 | -7.6 | False |
| maple-east | 67 | 0 | null |
| willow north | 68 | 25.3 | True |
| birch-birch | 69 | 4.9 | False |
| pine/south | 70 | -1.2 | null |
| ash | 71 | 9 | True |
| null | null | null | null |
The same calculation as SQL
SELECT true AS result FROM input
Runs the example above.
SELECT true AS result FROM input
Written for this dialect; not run here.
SELECT true AS result FROM input
Written for this dialect; not run here.
Result
| result |
|---|
| True |
| True |
| True |
| True |
| True |
| True |
| True |
| True |
Same rows from the calculation and from the SQL in DuckDB.
Where a naive translation goes wrong
- SQL must receive the application user context; database session identity is a different principal.
Naive SQL
SELECT false AS result FROM input
result False False False False False False False False Matches the calculation
SELECT true AS result FROM input
result True True True True True True True True
Signature
ISMEMBEROF(literal)