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

SqlSnapshot unparse lost the AS keyword when the table has alias

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            yr jibiyr
            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

                Slack

                  Issue deployment