[CALCITE-4527] SqlSnapshot unparse problem when tablRef is As-SqlBasicCall

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Duplicate
• Affects Version/s: 1.26.0
• Component/s: core
• Assignee: Unassigned
• Reporter: jibiyr
• Created: 09/Mar/21 07:27
• Updated: 09/Mar/21 19:05
• Resolved: 09/Mar/21 07:28

Description

hi,community. now calcite support SqlSnapshot. 

when a sql like SELECT orders.order_id, products.pro_id, products.product_name
FROM default_catalog.default_database.orders AS orders
LEFT JOIN default_catalog.default_database.products FOR SYSTEM_TIME AS OF orders.proctime AS products ON orders.product_id = products.pro_id .

 

default_catalog.default_database.products FOR SYSTEM_TIME AS OF orders.proctime AS products  parse to SqlSnapshot .however, when unparse. it is default_catalog.default_database.products AS products FOR SYSTEM_TIME AS OF orders.proctime. which can not be parsed again.

 

if we should consider this condition.

the same problem when I found in flink link title
 

Issue Links

• duplicates: CALCITE-4526 SqlSnapshot unparse lost the AS keyword when the table has alias