Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-2756

Let "LIMIT" be optional in "Inspect" page

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v2.3.0
    • Web
    • None

    Description

      Kylin's "Inspect" page will append a LIMIT clause for queries if the query doesn't have "LIMIT";

      While this will make some query be invalid because "LIMIT" not always appear in the last position. For example:

      select * from KYLIN_SALES OFFSET 100 ROWS FETCH FIRST 10 ROWS ONLY

      According to Calcite's SQL reference, LIMIT should be before OFFSET clause.

      So, Kylin should give user the option of not append the "LIMIT".

      Attachments

        Activity

          People

            Zhixiong Chen Zhixiong Chen
            shaofengshi Shao Feng Shi
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: