Its

pubkey LIKE '%abc’

Instead of

pubkey = ‘full-64-char-long-author-pubkey’

According to NIP-01

(And of course searching by prefixes is more expensive)

I can see some implementations don’t support it and some act inconsistently

For example at nos.lol the dollowing works:

["REQ", "test", {"authors": ["000000000332c7831d9c5a99f183afc2813a6f69a16edda7f6fc0ed8110566e6"]}]

As well as

["REQ", "test", {"authors": ["000000000332c7831d9c5a99f183afc2813a6f69a1"]}]

But next

["REQ", "test", {"authors": ["000000000332c7831d9c5a99f183afc2813a6f6"]}]

Produces error:

["NOTICE","ERROR: bad req: uneven size input to from_hex"]