Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4526

SqlSnapshot unparse lost the AS keyword when the table has alias

    XMLWordPrintableJSON

    Details

      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-19670.
       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                yr jibiyr
                Reporter:
                yr jibiyr
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 10m
                  2h 10m