Bug #78929 Support for FETCH FIRST (SQL:2008)

• Submitted: 22 Oct 2015 19:27
• Modified: 8 Feb 2018 14:43
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: DML
• Severity: S4 (Feature request)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any
• Tags: FETCH FIRST, sql:2008, standard

[22 Oct 2015 19:27] Daniël van Eeden

Description:
https://en.wikipedia.org/wiki/Select_%28SQL%29#FETCH_FIRST_clause

Please support the FETCH FIRST x ROWS ONLY syntax.

Don't remove the LIMIT syntax, as many prefer it.

The aim is to be more standard compliant, and thus more compatible with other databases like PostgreSQL and Oracle Database.

How to repeat:
See description.

[8 Dec 2017 14:00] Daniël van Eeden

Added 8.0

[8 Feb 2018 14:43] MySQL Verification Team

Hello Daniël,

Thank you for the feature request!

Thanks,
Umesh