[KYLIN-1472] Export csv get error when there is a plus sign in the sql

• 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
• Flags: Patch
• Assignee: nichunen
• Reporter: nichunen
• Created: 07/Mar/16 02:36
• Updated: 17/Oct/18 01:19
• Resolved: 17/Oct/18 01:19

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.

Issue Links

• relates to: KYLIN-1373 need to encode export query url to get right result in query page