RE: [DISCUSS] One sql syntax mistake in flip204

2024-01-22 Thread yunfan zhang
Sorry, in the sql is not correct. So the origin SQL in flip-204 is SELECT /*+ SHUFFLE_HASH('Customers') */ o.order_id, o.total, c.country, c.zip FROM Orders AS o JOIN Customers FOR SYSTEM_TIME AS OF o.proc_time AS c ON o.customer_id = c.id; The correct syntax is: SELECT /*+ SHUF

[DISCUSS] One sql syntax mistake in flip204

2024-01-22 Thread yunfan zhang
Hi dev, I am working on advancing the flip204 project, but I have noticed an error in the SQL syntax section. The sql syntax in the documentation is: SELECT /*+ SHUFFLE_HASH('Customers') */ o.order_id, o.total, c.country, c.zip FROM Orders AS o JOIN Customers FOR SYSTEM_TIME AS OF o.proc_time