Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Not a Bug
-
Affects Version/s: 10.2.3
-
Fix Version/s: 10.2.4
-
Component/s: Optimizer - CTE
-
Labels:None
Description
CREATE TABLE transactions (timestamp int, customer_id int, amount int); |
|
|
SELECT timestamp, customer_id, amount, ( |
SELECT sum(amount) from transactions as t2 where t2.customer_id = t1.customer_id and t2.timestamp <= t1.timestamp) |
FROM transactions AS t1 |
ORDER BY customer_id, timestamp; |
Header results looks like this:
+-----------+-------------+--------+------------+
|
| timestamp | customer_id | amount | SELECT sum(amount) from transactions as t2 where t2.customer_id = t1.customer_id and t2.timestamp <= t1.timestamp |
|
+-----------+-------------+--------+------------+
|
WITH result as ( |
SELECT timestamp, customer_id, amount, ( |
SELECT sum(amount) from transactions as t2 where t2.customer_id = t1.customer_id and t2.timestamp <= t1.timestamp) |
FROM transactions AS t1 |
ORDER BY customer_id, timestamp) |
SELECT * from result; |
Header result looks different for the same definition.
+-----------+-------------+--------+------------+
|
| timestamp | customer_id | amount | Name_exp_4 |
|
+-----------+-------------+--------+------------+
|