HyperDB icon indicating copy to clipboard operation
HyperDB copied to clipboard

Support `SELECT DISTINCT SQL_CALC_FOUND_ROWS`

Open dd32 opened this issue 2 years ago • 0 comments

Fixes #136

The MariaDB SELECT format is...

SELECT
    [ALL | DISTINCT | DISTINCTROW]
    [HIGH_PRIORITY]
    [STRAIGHT_JOIN]
    [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
    [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
    select_expr [, select_expr ...]
    [ FROM [table_references](https://mariadb.com/kb/en/join-syntax/)

The current regular expression therefor doesn't match any of the other query modifiers either, but DISTINCT is AFAIK the only one that WordPress would be using.

dd32 avatar Jun 26 '23 01:06 dd32