Support "SELECT .. ORDER BY .. FOR UPDATE"

[wingouyang]

When I use "SELECT .. ORDER BY .. FOR UPDATE" in sql, I get some errors. From the below syntax, I would expect it is supported. SELECT [ ALL | DISTINCT ] [ TOP n ] { * | { table_name | alias} * [ , { table_name| alias} * ] ... | expr [ [ AS ] [ ’ ] column_title [ ’ ] ] [, expr [ [ AS ] [ ’ ] column_title [ ’ ] ] ] ... } FROM table_ref [, table_ref ] ... [ { NO REORDER } ] [ WITH ( NOLOCK ) ] [ WHERE search_condition ] [ GROUP BY [ table]column_name [, [ table]column_name ] ... [ HAVING search_condition ] ; ; [ORDER BY ordering_condition ] [OFFSET offset_value { ROW | ROWS } [ FETCH {FIRST | NEXT} fetch_value {ROW | ROWS} ONLY ] ] [WITH locking_hints ] [ FOR UPDATE update_condition ] ;

Continue reading...