cube
cube copied to clipboard
SQL API: Error with subquery, but only when there is no SQL LIMIT
Failed SQL
Found an odd discrepancy when testing generated queries against our test Cube instance. This one was interesting because it only failed when there was no SQL LIMIT
in the query, but simply adding a SQL LIMIT
produced the expected result.
Queries
=> SELECT
DISTINCT status
FROM
(
SELECT
id,
status,
created_at,
line_items_id,
line_items_product_id,
name,
product_category,
completed_count
FROM
orders_cube
) AS anon_1
ORDER BY
1;
ERROR: Error during planning: No field named 'anon_1.status'. Valid fields are 'orders_cube.status'.
=> SELECT
DISTINCT status
FROM
(
SELECT
id,
status,
created_at,
line_items_id,
line_items_product_id,
name,
product_category,
completed_count
FROM
orders_cube
) AS anon_1
ORDER BY
1
LIMIT
50;
status
------------
completed
processing
shipped
(3 rows)
Version: 0.35.47
Additional context
CUBESQL_SQL_PUSH_DOWN = true
here