Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Normal

      Description

      Bryan Pendleton reports:

      When I mistype 'join' as 'joing', the error message that I
      get actually complains about the word 'left'. It ought to,
      in my opinion, complain about the word 'joing', since that
      is truly the word with the syntax error in it.

      ij> select * from t1 left outer joing t2 on t1.c2=t2.c1;
      ERROR 42X01: Syntax error: Encountered "left" at line 1, column 18.

      I don't know if this is a PITA to fix or not, but I thought
      I'd send it along anyway since it was so easy to reproduce.

      -------------------------------------------------------

      This appears to be a problem with hand-coded lookahead logic. Although fixing this particular lookahead issue might be trivial, this is part of a larger problem since the parser is liberally peppered with similar hand-coded lookahead logic. Coming up with a general solution might involve some creativity.

        Activity

        Hide
        Mike Matrigali added a comment -

        Triaged July 10, 2009: assigned normal urgency.

        Show
        Mike Matrigali added a comment - Triaged July 10, 2009: assigned normal urgency.
        Hide
        Rick Hillegas added a comment -

        Update "affects version" field.

        Show
        Rick Hillegas added a comment - Update "affects version" field.

          People

          • Assignee:
            Unassigned
            Reporter:
            Rick Hillegas
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development