[dtp-sqldevtools-dev] MySQL select ... for update

["Neil Aggarwal" <neil@xxxxxxxxxxxxxxxxxx>]

Hello:

I am trying to use the SQL devtools parser on queries
for a MySQL database.

One of the queries MySQL supports is select ... for update.
Here is a page describing it:
http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html

When I tried used the parser to parse a sample query,
I get this exception:

Exception in thread "main"
org.eclipse.datatools.sqltools.parsers.sql.SQLParserException: Unable to
parse the input: "SELECT col1 FROM table1 FOR UPDATE;".
	at
org.eclipse.datatools.sqltools.parsers.sql.AbstractSQLParser.parser(Abstract
SQLParser.java:409)
	at
org.eclipse.datatools.sqltools.parsers.sql.SQLParserManager.makeAST(SQLParse
rManager.java:436)
	at
org.eclipse.datatools.sqltools.parsers.sql.SQLParserManager.parse(SQLParserM
anager.java:791)
	at
org.eclipse.datatools.sqltools.parsers.sql.query.SQLQueryParserManager.parse
Query(SQLQueryParserManager.java:326)
	at test.SQLParserTest.main(SQLParserTest.java:28)
Caused by: lpg.lpgjavaruntime.BadParseException
	at
lpg.lpgjavaruntime.BacktrackingParser.parse(BacktrackingParser.java:142)
	at
lpg.lpgjavaruntime.BacktrackingParser.parse(BacktrackingParser.java:100)
	at
org.eclipse.datatools.sqltools.parsers.sql.AbstractSQLParser.parser(Abstract
SQLParser.java:379)
	... 4 more

Does the SQL Parser support MySQL's select ... for update query?

Thanks,
	Neil

--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.