Menu ▾ ▴

UPDATE with ALIAS

Open Discussion
Alain Gutierrez
2010-06-25
2012-12-07

  • Alain Gutierrez

    Alain Gutierrez - 2010-06-25

    Parsing the statement:

    UPDATE tabla A SET A.campo = 'XXX' WHERE A.cod_tabla = 'YYY'

    throws:

    net.sf.jsqlparser.JSQLParserException
    at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:40)
    at com.example.Test1.main(Test1.java:64)
    Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "A "" at line 1, column 17.
    Was expecting:
        "SET" …
       
    at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:5359)
    at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:5235)
    at net.sf.jsqlparser.parser.CCJSqlParser.Update(CCJSqlParser.java:161)
    at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:113)
    at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:38)
    … 1 more

    The Alias in UPDATEs are not supported????

     

  • Leonardo Francalanci

    Leonardo Francalanci - 2010-11-18

    fixed in 0.6.4

     

Log in to post a comment.