Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1453

sql parse error occured with join query

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 0.10.0
    • Fix Version/s: None
    • Component/s: SQL Parser
    • Labels:
      None

      Description

      It is simple parse error.
      I am testing Tajo with BI solution, Birst.
      Birst usually generate join query like following:
      select table1.* from table1 inner join (table2) on (table1.id = table2.id);

      If "table2" has parenthesis, Tajo displays follwing error:
      ERROR: syntax error at or near 'table2'

      I didn't check ANSI SQL doesn't allow parenthesis in this case.
      But Almost databases I evaluated support this case.

        Attachments

        1. TAJO-1453.patch
          3 kB
          Yongjin Choi

          Activity

            People

            • Assignee:
              yongjin.choi Yongjin Choi
              Reporter:
              jrlee Jungryong Lee
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: