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

Export csv get error when there is a plus sign in the sql

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.2, v1.4.0
    • Fix Version/s: v1.3.1, v1.5.1
    • Component/s: Web
    • Labels:
      None
    • Flags:
      Patch

      Description

      For example, query the sample cube with "select max(price)+min(price) from KYLIN_SALES", get the result on the web window. But click the "export" button get an error message "Encountered \"min\" at line 1, column 19. Was expecting one of...".

      This is because the export button visit the api url directly, in the url, the plus sign is treated as blank, so kylin server get sql "select max(price) min(price) from KYLIN_SALES" which is an invalid sql.

      I will submit two patches for 1.x and 2.x.

        Attachments

        1. KYLIN-1472-FOR1X.patch
          2 kB
          nichunen
        2. KYLIN-1472-FOR2X.patch
          2 kB
          nichunen

          Issue Links

            Activity

              People

              • Assignee:
                nichunen nichunen
                Reporter:
                nichunen nichunen
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: