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

"--" should not be a comment marker use between single quotes in SQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v2.4.1
    • Fix Version/s: v2.6.0
    • Component/s: Query Engine
    • Labels:
      None

      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
       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                caolijun1166 Lijun Cao
                Reporter:
                fandayrockworld Scott Fan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: