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


      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.


        Rick Hillegas created issue -
        Mike Matrigali made changes -
        Field Original Value New Value
        Component/s SQL [ 11408 ]
        Rick Hillegas made changes -
        Affects Version/s [ 10993 ]
        Mike Matrigali made changes -
        Urgency Normal
        Kathey Marsden made changes -
        Labels derby_triage10_5_2
        Gavin made changes -
        Workflow jira [ 12325314 ] Default workflow, editable Closed status [ 12799055 ]


          • Assignee:
            Rick Hillegas
          • Votes:
            0 Vote for this issue
            1 Start watching this issue


            • Created: