Robert Chipperfield

FIND_IN_SET to PATINDEX translation missing %s

2

At the moment, the `FIND_IN_SET` translation (used by bbPress's topic subscription notifications) turns into `PATINDEX`: https://github.com/ProjectNami/projectnami/blob/master/wp-includes/translations.php#L1151 However, the `pattern` argument isn't surrounded by `%`s, which https://docs.microsoft.com/en-us/sql/t-sql/functions/patindex-transact-sql suggests it must be,...

WP_Query row counts can be incorrect if query is filtered (seen in bbPress)

1

Currently, https://github.com/ProjectNami/projectnami/blob/72b69a2e2f5840b2cb77c83e7316fdb6efa9e570/wp-includes/class-wp-query.php#L2854 performs a COUNT() query to find the number of rows that would be returned if $limits did not apply. However, if the `posts_request` filter causes the query to...

A proposed solution to #341, by performing the row count after any query filters have been run. - If any filters don't change the query, then it should have the...

Addresses #339 by adding the wildcards around the `PATINDEX` pattern. Also permits some optional whitespace after FIND_IN_SET.

bbPress uses a MySQL query hint in its WHERE clause filter: https://bbpress.trac.wordpress.org/browser/trunk/src/includes/replies/functions.php#L2042 This generates a query like `SELECT col FROM foo FORCE INDEX (PRIMARY, col) WHERE...`, which is invalid T-SQL....

GPIO BCM14/15 do not have GP capability even when UART disabled

1

**Describe the bug** GPIO BCM 14 and 15 only have the [UARTTXD ](https://github.com/unosquare/wiringpi-dotnet/blob/master/src/Unosquare.WiringPi/GpioPin.Factory.cs#L94)/ UARTRXD capabilities, even when the UART is disabled with `enable_uart=0` in `config.txt`. This prevents use as regular...

Null (`\0`) bytes in strings cause truncation in MSSQL driver

2

A bit of an edge case, but I promise we hit it in real life! Feel free to close as too far-fetched. If any user input includes a null byte...

When SQL_Translations::on_update_to_merge() is called, we've already re-inserted the quoted string values that had been stripped out before other translations had taken place. This means that the regexps in on_update_to_merge() can...

Self-host Sen font instead of using Google Fonts

3

### Describe the feature request Currently, the Unleash front-end loads the Sen font via Google Fonts (https://github.com/Unleash/unleash/blob/main/frontend/index.html#L17). This happens on all pages, including the login page. As a result, public...