villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-526344999
Looking more closely at this problem, it seems MSSQL is one of the few
engines that
villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-524405495
The query under data source is what is created when you click explore in SQL
Lab. What
villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-524085299
If you check the diff, I added a warning about using CTEs on non-ANSIs.
Btw, I'm
villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-523999886
Unfortunately I an not that familiar with how the docker setup under contrib
works (we
villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-523509535
Please take a look at my PR that fixes the immediate problem with CTEs on
MSSQL
villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-523185284
Looking into this, it turns out that the bug stems from the fact that MSSQL
uses the
villebro commented on issue #8074: Common Table Expressions (CTE's) do not work
for Microsoft SQL Server database
URL:
https://github.com/apache/incubator-superset/issues/8074#issuecomment-523141019
Reproduced on master; running the same on sqlite works just fine. Will take
a closer