[KYLIN-3620] "--" should not be a comment marker use between single quotes in SQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v2.4.1
• Fix Version/s: v2.6.0
• Component/s: Query Engine
• Assignee: Lijun Cao
• Reporter: Scott Fan
• Created: 12/Oct/18 01:03
• Updated: 12/Jan/19 06:41
• Resolved: 24/Oct/18 06:48

Description

Hi,

When I exec a SQL like below, there was an error.

SELECT * FROM TABLEA WHERE NAME='Jason--Arthur'

Seems like KYLIN use  the – as a comment marker.

It should not be that between single quotes, I think.
 
Even I send a REST POST contains SQL like that, or do an ODBC query, there was an error too.

You may tell me that I can use a \ as escape, but I can't change the SQL generated by BI tools like tableau.  

Thanks
 

Issue Links

• links to: GitHub Pull Request #302