Using columns in a virtual query fails


#1

When I run this query it works fine:

SELECT * FROM dev.frontend.entity.Team.v1.Team WHERE customer_id = ‘5500a5ba8135f296’

When I run this query it fails:

SELECT id, name FROM dev.frontend.entity.Team.v1.Team WHERE customer_id = ‘5500a5ba8135f296’

Here’s the profile:

f4c36916-4756-4f18-acb9-0e512b957ebc.zip (381.7 KB)


#2

as a horrible workaround, if i wrap the query underneath in another subselect it works