LIMIT SYNTAX error when using SELECT FOR UPDATE

[williamdes]

Execute

START TRANSACTION;
SELECT * FROM mytable WHERE id = 88777 FOR UPDATE;

# 1064 - Erreur de syntaxe près de 'LIMIT 0, 25' à la ligne 1

# 1064 - Syntax error near 'LIMIT 0, 25' at line 1

[williamdes]

        return Query::replaceClause(
            $analyzed_sql_results['statement'],
            $analyzed_sql_results['parser']->list,
            'LIMIT ' . $_SESSION['tmpval']['pos'] . ', '
            . $_SESSION['tmpval']['max_rows']
        );

[williamdes]

LIMIT clause must go before FOR UPDATE

[williamdes]

or should we add a limit to a FOR UPDATE clause ?

[williamdes]

Also using

UNION
SELECT ... FROm xxx WHERE YEAR(birthdate) < 1900 AND birthdate IS NOT NULL AND YEAR(birthdate) !=0;
SELECT ... FROm yyy WHERE YEAR(birthdate) < 1900 AND birthdate IS NOT NULL AND YEAR(birthdate) !=0;