ypankovych opened a new issue #14043:
URL: https://github.com/apache/superset/issues/14043
I have a virtual dataset:
```SQL
(select *
from public.invoice_invoice i
left join public.attrs ia on ia.id = i.id) AS virtual_table
```
Then I try to filter/select based on column from virtual dataset, here's the
query generated by superset:
```SQL
SELECT "virtual_table"."internal_0" AS """virtual_table"".""internal_0"""
FROM
(select *
from public.invoice_invoice i
left join public.attrs ia on ia.id = i.id) AS virtual_table
WHERE invoice_date >= TO_DATE('2020-04-08', 'YYYY-MM-DD')
AND invoice_date < TO_DATE('2021-04-08', 'YYYY-MM-DD')
LIMIT 10000;
```
### Expected results
Value from internal_0 column
### Actual results
`Error: Columns missing in datasource: ['"virtual_table"."internal_0"']`
### Environment
(please complete the following information):
- superset version: `0.999.0dev` (FROM apache/superset:latest)
- python version: `3.8`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
