William Desportes

@devenbansod could you please have a look into it ?

🏓

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

LIMIT clause must go before `FOR UPDATE`

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

Also using ```sql 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...

@Tithugues can I have some help with this one? Can I ask your help on issues?

```json { "name": { "database": null, "table": "foo", "column": null, "expr": "`foo`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "options": [] }, "fields": null, "select": null, "like": null,...

```sql CREATE DEFINER=`root`@`%` PROCEDURE `$a`(IN `$a` INT) NO SQL SELECT $a -- or CREATE DEFINER=`root`@`%` PROCEDURE `foo`( $foo int ) select $foo ``` I had no success adding a test...

Hi @svivian This is indeed the right place to report such bugs Thank you