Skip to content

Can't parse START TRANSACTION #1510

Description

@vkostyukov

Here is a quick repl experiment (from version 4.2):

scala> import net.sf.jsqlparser.parser.CCJSqlParserUtil
import net.sf.jsqlparser.parser.CCJSqlParserUtil

scala> CCJSqlParserUtil.parse("start transaction")
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "start" "START"
    at line 1, column 1.

Was expecting one of:

    "("
    "ALTER"
    "CALL"
    "COMMENT"
    "COMMIT"
    "CREATE"
    "DECLARE"
    "DELETE"
    "DESCRIBE"
    "DROP"
    "EXEC"
    "EXECUTE"
    "EXPLAIN"
    "GRANT"
    "IF"
    "INSERT"
    "MERGE"
    "PURGE"
    "RENAME"
    "REPLACE"
    "RESET"
    "ROLLBACK"
    "SAVEPOINT"
    "SET"
    "SHOW"
    "TRUNCATE"
    "UPDATE"
    "UPSERT"
    "USE"
    "VALUES"
    "WITH"
    <K_SELECT>

  at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:190)
  at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
  at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
  ... 34 elided

Activity

  1. manticore-projects commented on Apr 14, 2022

    @manticore-projects
    Contributor

    Greetings.

    START TRANSACTION is not a standard compliant SQL command and has not been implemented (yet) in JSQLParser.
    What RDBMS is supporting it please? Can you point me on the syntax documentation please?

  2. vkostyukov commented on Apr 18, 2022

    @vkostyukov
    Author

    It's available in MySQL, starting from 5.7, at least: https://dev.mysql.com/doc/refman/5.7/en/commit.html

  3. wumpz commented on Apr 22, 2022

    @wumpz
    Member

    You are right. But JSqlParser does not pretend to be a complete parser for all the database dialects. It is feature request-driven.

    So PRs are welcome or do you want to fund this new feature. I expect there is more to this, not only this start transaction statement.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions