Custom columns don't work after aggregation unless the user has native query permissions #42765
Labels
Priority:P1
Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness
Querying/Processor
.Regression
Bugs that were previously fixed and/or bugs unintentionally shipped with new features.
.Team/QueryProcessor
:hammer_and_wrench:
Type:Bug
Product defects
Describe the bug
In questions based on native models, post aggregation custom columns no longer work, unless the user is given native query permissions.
To Reproduce
select * from products
), save itLog in with a user that does not have native query permissions:
2. Create a GUI question, based on the model created in step 1
3. Add an aggregation(summarize: Count of Rows, by Category)
4. Add a custom column (
[Count] + 1
)5.(!) Visualize, and see the error
Assigning native query permissions to the user makes the question runnabl.
Expected behavior
The question should work without native query permissions.
Logs
n/a
Information about your Metabase installation
Severity
P1 - affects a common function
Additional context
Reproduced it in
49.10
but I suspect the issue might have existed in earlier versions (49.8
).The text was updated successfully, but these errors were encountered: